Refresh Row JDBC One of the new features of JDBC 2.0 is the introduction of updateXXX() methods in ResultSet interface. With these methods, without using SQL commands, a record in the table can be updated, inserted, deleted and now let us see updating a record with refreshRow() method. In the following code, a record’s old …
ResultSet methods JDBC JDBC 2.0 ResultSet enhancement operations include the methods to update, insert or delete a record without writing the SQL commands. That is, SQL commands need not be known, of course for CRUD operations. This is the greatness of ResultSet methods JDBC. Example on ResultSet methods JDBC import java.sql.*; public class Updates { …
JDBC ResultSet Enhancement Update Methods Example Read More »
Scrollable ResultSet: JDBC 2.0 API ResultSet methods are used where the records are read in the reverse order and also reading the data of a specific record. Note: It is advised to go through the postings Scrollable ResultSet and ResultSet Types and Concurrency as they are used in this code. Just for a change, thin …
ResultSet Types Concurrency JDBC Overloaded createStatement() Method (knowledge required for ResultSet Types Concurrency JDBC). Before going into programming it is required to know more about createStatement() method of Connection interface. This method can have parameters. You know the following Statement object creation earlier. Statement stmt = con.createStatement(); The createStatement() method of Connection interface returns an …
You retrieved records from database earlier in Select Records Example by iterating the records with the ResultSet object as follows. In the same example, you also have seen the ResultSet cursor movement in while loop. while(res.next()) { System.out.println(res.getInt(1) + “\t” + res.getString(2) + “\t” + res.getDouble(3)); } The above loop prints the records from top …
JDBC 2.0 New Features : JDBC 2.0 API: The java.sql package shipped with with JDK 2.0 is known as JDBC 2.0 API. It adds mainly four new features to JDBC 1.0 (shipped with JDK 1.0). All the earlier programs are illustrated with JDBC 1.0 style. Let us repeat the above programs with JDBC 2.0 and …
Batch Update JDBC If 10 records of Employee are to be inserted, writing 10 times insert command is very slow in performance as 10 times the JDBC program should hit the database. To improve the performance, all the 10 insert statements can be converted into a batch and executed at a time. In this case, …
