code 39 font crystal reports RESULT SETS EXPLORED in Font

Creator Code 3 of 9 in Font RESULT SETS EXPLORED

} finally { // release the JDBC resources in the finally clause. JDBCUtil.close( rset ); JDBCUtil.close( pstmt ); } } } // end of program The printRsetTypeAndConcurrencyType() method in the JDBCUtil class based on the Statement interface is as follows: public static void printRsetTypeAndConcurrencyType( Statement stmt ) throws SQLException { System.out.print( "\tResult set category (using Statement API): " ); int resultSetType = stmt.getResultSetType(); switch( resultSetType ) { case ResultSet.TYPE_FORWARD_ONLY: System.out.print( "Forward only" ); break; case ResultSet.TYPE_SCROLL_INSENSITIVE: System.out.print( "Scroll insensitive" ); break; case ResultSet.TYPE_SCROLL_SENSITIVE: System.out.print( "Scroll sensitive" ); break; } int resultSetConcurrency = stmt.getResultSetConcurrency(); switch( resultSetConcurrency ) { case ResultSet.CONCUR_READ_ONLY: System.out.println( ", Read only" ); break; case ResultSet.CONCUR_UPDATABLE: System.out.println( ", Updatable" ); break; } } The printRsetTypeAndConcurrencyType() method in the JDBCUtil class based on the ResultSet interface is as follows: public static void printRsetTypeAndConcurrencyType( ResultSet rset) throws SQLException {

int resultSetType = rset.getType(); System.out.print( "\tResult set category (using ResultSet API): " ); switch( resultSetType ) { case ResultSet.TYPE_FORWARD_ONLY: System.out.print( "Forward only" ); break; case ResultSet.TYPE_SCROLL_INSENSITIVE: System.out.print( "Scroll insensitive" ); break; case ResultSet.TYPE_SCROLL_SENSITIVE: System.out.print( "Scroll sensitive" ); break; } int resultSetConcurrency = rset.getConcurrency(); switch( resultSetConcurrency ) { case ResultSet.CONCUR_READ_ONLY: System.out.println( ", Read only" ); break; case ResultSet.CONCUR_UPDATABLE: System.out.println( ", Updatable" ); break; } } This is the output of the program DemoPositioning: java DemoPositioning URL:jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521) (HOST=rmenon-lap))(CONNECT_DATA=(SID=ora10g))) Result set category (using Statement API): Scroll insensitive, Read only Result set category (using ResultSet API): Scroll insensitive, Read only current position: 30 Is it the first row : true current position: 4 current position: 7 current position: 5 current position: 1 current position: 30

Assuming that you have a result set with a concurrency type of ResultSet.CONCUR_UPDATABLE, you can directly update rows in the result set, insert rows into the result set, or delete rows from the result set.

After an update or insert operation in a result set, you propagate the changes to the database in a separate step that you can skip if you want to cancel the changes. A delete operation in a result set, however, is immediately executed (but not necessarily committed) in the database. Let s look at each of these, starting with the delete operation.

To delete the current row, you can invoke the method deleteRow() on the result set: void deleteRow() throws SQLException;

To update one or more columns of the current row, you can call the appropriate updateXXX() method for each column, based on the type of the column you want to update. A ResultSet object has an updateXXX() method for each data type. Each of these methods takes an int for the column number or a string for the column name, along with an item of the appropriate data type to set the new value. For example, if you want to update a column of type double in the current row, you can use one of the following methods: public void updateDouble(int columnIndex, double x) throws SQLException; public void updateDouble( String columnName, double x) throws SQLException;

To insert a row, perform the following steps: 1. Move to a blank row by invoking the moveToInsertRow() method: public void moveToInsertRow() throws SQLException 2. Update all the columns of the row using the updateXXX() methods discussed earlier in the context of the update operation. Note that you have to update all non-nullable columns to non-null values. The nullable columns, if left untouched, retain a null value after the insert is complete, unless a trigger or a default column value kicks in. 3. Propagate the changes to the database by invoking the method insertRow(): public void insertRow() throws SQLException

The class DemoUpdatability illustrates how to update, insert, and delete rows from a table by performing these operations on the rows of the result set. Before running the program, re-create the table and populate it with numbers 1 to 30 in column x: scott@ORA10G> drop table t1; Table dropped.