- Home
- Products
- Integration
- Tutorial
- Barcode FAQ
- Purchase
- Company
code 39 font crystal reports RESULT SETS EXPLORED in Font
CHAPTER 7 RESULT SETS EXPLORED Drawing USS Code 39 In None Using Barcode maker for Font Control to generate, create Code 39 image in Font applications. www.OnBarcode.comQR Code Creation In None Using Barcode creator for Font Control to generate, create Denso QR Bar Code image in Font applications. www.OnBarcode.com} 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 { UCC - 12 Generator In None Using Barcode creator for Font Control to generate, create UPCA image in Font applications. www.OnBarcode.comDraw ECC200 In None Using Barcode encoder for Font Control to generate, create Data Matrix image in Font applications. www.OnBarcode.comCHAPTER 7 RESULT SETS EXPLORED
Make EAN / UCC - 13 In None Using Barcode printer for Font Control to generate, create European Article Number 13 image in Font applications. www.OnBarcode.comCode39 Printer In None Using Barcode creation for Font Control to generate, create ANSI/AIM Code 39 image in Font applications. www.OnBarcode.comint 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 Paint EAN / UCC - 13 In None Using Barcode drawer for Font Control to generate, create GTIN - 128 image in Font applications. www.OnBarcode.comEAN8 Creation In None Using Barcode drawer for Font Control to generate, create GTIN - 8 image in Font applications. www.OnBarcode.comUpdating, Inserting, and Deleting Result Set Rows
Scan Code 39 In Visual C#.NET Using Barcode reader for .NET Control to read, scan read, scan image in .NET applications. www.OnBarcode.comPrinting Code 39 Extended In None Using Barcode creator for Word Control to generate, create Code 3/9 image in Office Word applications. www.OnBarcode.comAssuming 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. Print Barcode In .NET Framework Using Barcode printer for ASP.NET Control to generate, create Barcode image in ASP.NET applications. www.OnBarcode.comUCC.EAN - 128 Drawer In None Using Barcode generation for Office Word Control to generate, create EAN / UCC - 13 image in Word applications. www.OnBarcode.comCHAPTER 7 RESULT SETS EXPLORED
Creating UCC - 12 In VB.NET Using Barcode creator for VS .NET Control to generate, create EAN 128 image in .NET applications. www.OnBarcode.comDecode Barcode In Java Using Barcode reader for Java Control to read, scan read, scan image in Java applications. www.OnBarcode.comAfter 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. UPC A Generator In Visual C#.NET Using Barcode creation for Visual Studio .NET Control to generate, create UPC Code image in VS .NET applications. www.OnBarcode.comQR Code 2d Barcode Generator In Visual Studio .NET Using Barcode encoder for Reporting Service Control to generate, create Quick Response Code image in Reporting Service applications. www.OnBarcode.comDeleting a Row
EAN 13 Creator In .NET Using Barcode maker for VS .NET Control to generate, create European Article Number 13 image in .NET applications. www.OnBarcode.comRecognizing Data Matrix ECC200 In VB.NET Using Barcode recognizer for VS .NET Control to read, scan read, scan image in VS .NET applications. www.OnBarcode.comTo delete the current row, you can invoke the method deleteRow() on the result set: void deleteRow() throws SQLException; Reading UCC-128 In VB.NET Using Barcode recognizer for VS .NET Control to read, scan read, scan image in .NET applications. www.OnBarcode.comData Matrix 2d Barcode Generation In None Using Barcode creator for Online Control to generate, create DataMatrix image in Online applications. www.OnBarcode.comUpdating a Row
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; Inserting a Row
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 Example of Updatability
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.
|
|