Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.tutorialspoint.com/javaexamples/jdbc_row_methods.htm below:

How to use different row methods to get no of rows in a table, update table etc in Java

How to use different row methods to get no of rows in a table, update table etc?

Following example uses first, last, deletRow, getRow, insertRow methods of ResultSet to delete or insert a Row & move pointer of ResultSet to first or last Record.

import java.sql.*;

public class jdbcConn {
   public static void main(String[] args) throws Exception { 
      Class.forName("org.apache.derby.jdbc.ClientDriver");
      Connection con = DriverManager.getConnection(
         "jdbc:derby://localhost:1527/testDb","name","pass");
      
      Statement stmt = con.createStatement(
         ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
      
      String query = "select * from emp";
      ResultSet rs = stmt.executeQuery(query);
      rs.last();
      System.out.println("No of rows in table = "+rs.getRow());
      
      rs.moveToInsertRow();
      rs.updateInt("id", 9);
      rs.updateString("name","sujay");
      rs.updateString("job", "trainee");
      rs.insertRow();
      
      System.out.println("Row added");
      rs.first();
      rs.deleteRow();
      System.out.println("first row deleted");
   }
}

The above code sample will produce the following result. For this code to compile your database has to be updatable. The result may vary.

No of rows in table = 5
Row added
first row deleted

java_jdbc.htm

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4