Home Tutorial Java Jdbc Jdbcresultset JDBC ResultSet Delete Row Example

 
 

Share on Google+Share on Google+
JDBC ResultSet Delete Row Example
Posted on: October 23, 2010 at 12:00 AM
Advertisement
Learn how to delete row using ResultSet. We are also used ResultSet object with update capability for delete rows from database tables.

JDBC ResultSet Delete Row Example:

Learn how to delete row using ResultSet. We are also used ResultSet object with update capability for delete rows from database tables. The following step are use:

1. Create a database connection object.

2. Create a statement object with ResultSet.CONCUR_UPDATABLE concurrency type.

3. Create a SQL select query.

4. Execute query using executeQuery() method on the created statement object to return ResultSet object on the table.

5. Call ResultSet methods like next(), absolute(), last() etc for cursor move.

6. Finally call deleteRow() ResultSet method for delete the current row form the table of the ResultSet object.

Example:

package ResultSet;
import java.sql.*;

public class ResultSetDeleteRow {

  public static void main(String[] args) {
    
        Connection connection = null;
        String url = "jdbc:mysql://localhost:3306/";
        String dbName = "roseindia_jdbc_tutorials";
        String driverName = "com.mysql.jdbc.Driver";
        String userName = "root";
        String password = "root";

        try {
          Class.forName(driverName).newInstance();
          connection = DriverManager.getConnection(url+dbName, userName, password);
         
          Statement stmt = connection.createStatement(
              ResultSet.TYPE_SCROLL_SENSITIVE,
              ResultSet.CONCUR_UPDATABLE);
          
            ResultSet rs = stmt.executeQuery("SELECT * from user");
            while(rs.next()){
              if(rs.getInt(1)==1){
                rs.deleteRow();
                System.out.println("Deleted user_id :" + rs.getInt(1));
              }
              else{
                System.out.println("user_id :" + rs.getInt(1));
              }
            }                  
            rs.close();
            stmt.close();
            connection.close();
        catch (Exception e) {
          System.err.println(e);
        }  
   }
}
 

In this example we are deleting row that have user_id == 1.

Now we will run this example with the help of eclipse IDE and see the output.

Program output:

The database table output before run the example is:

The eclipse console output is:

The database table output after run example is:

Download source code

Advertisement

Related Tags for JDBC ResultSet Delete Row Example:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 23, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com