The Java Developers Almanac 1.4
Order this book from
Amazon
.
Home
>
List of Packages
java.sql
Drivers
e232.
Getting JDBC Drivers for a Database
e233.
Loading a JDBC Driver
e234.
Listing All Loaded JDBC Drivers
Connections
e235.
Connecting to an Oracle Database
e236.
Connecting to a MySQL Database
e237.
Connecting to a SQLServer Database
e238.
Listing All Available Parameters for Creating a JDBC Connection
e239.
Determining If a Database Supports Transactions
e240.
Committing and Rolling Back Updates to a Database
e241.
Handling a SQL Exception
e242.
Determining If a SQL Warning Occurred
e243.
Getting the Driver of a Connection
e244.
Setting the Number of Rows to Prefetch When Executing a SQL Query
Tables
e245.
Creating a Database Table
e246.
Deleting a Database Table
e247.
Listing All Table Names in a Database
e248.
Creating a MySQL Table to Store Java Types
e249.
Creating an Oracle Table to Store Java Types
e250.
Creating a SQLServer Table to Store Java Types
Retrieving Data
e251.
Getting Rows from a Database Table
e252.
Getting Data from a Result Set
e253.
Determining If a Fetched Value Is NULL
e254.
Getting the Column Names in a Result Set
e255.
Getting the Number of Rows in a Database Table
e256.
Getting BLOB Data from a Database Table
e257.
Matching with Wildcards in a SQL Statement
Inserting and Updating Data
e258.
Inserting a Row into a Database Table
e259.
Inserting a Row into a Database Table Using a Prepared Statement
e260.
Getting and Inserting Binary Data into an Database Table
e261.
Updating a Row in a Database Table
Deleting Data
e262.
Deleting a Row from a Database Table
e263.
Deleting All Rows from a Database Table
Batching
e264.
Determining If a Database Supports Batching
e265.
Executing a Batch of SQL Statements in a Database
Scrollable Result Sets
e266.
Determining If a Database Supports Scrollable Result Sets
e267.
Creating a Scrollable Result Set
e268.
Determining If a Result Set Is Scrollable
e269.
Moving the Cursor in a Scrollable Result Set
e270.
Getting the Cursor Position in a Scrollable Result Set
e271.
Getting the Number of Rows in a Table Using a Scrollable Result Set
Updatable Result Sets
e272.
Determining If a Database Supports Updatable Result Sets
e273.
Creating an Updatable Result Set
e274.
Determining If a Result Set Is Updatable
e275.
Updating a Row in a Database Table Using an Updatable Result Set
e276.
Cancelling Updates to an Updatable Result Set
e277.
Inserting a Row into a Database Table Using an Updatable Result Set
e278.
Deleting a Row from a Database Table Using an Updatable Result Set
e279.
Refreshing a Row in an Updatable Result Set
Procedures and Functions
e280.
Getting the Stored Procedure Names in a Database
e281.
Calling a Stored Procedure in a Database
e282.
Calling a Function in a Database
e283.
Creating a Stored Procedure or Function in an Oracle Database
Database Meta Data
e284.
Listing All Non-SQL92 Keywords Used by a Database
e285.
Listing the String Functions Supported by a Database
e286.
Listing the Numeric Functions Supported by a Database
e287.
Listing the System Functions Supported by a Database
e288.
Listing the Time and Date Functions Supported by a Database
e289.
Getting the Maximum Table Name Length in a Database
e290.
Listing Available SQL Types Used by a Database
e291.
Getting the Name of a JDBC Type
Importing and Exporting
e292.
Loading a Flat File to a MySQL Table
e293.
Exporting an Oracle Table to a Flat File
e294.
Loading a Flat File to an Oracle Table
e295.
Exporting a MySQL Table to a Flat File
Oracle OBJECTs
e296.
Creating an OBJECT Type in an Oracle Database
e297.
Inserting an OBJECT Value into an Oracle Table
e298.
Inserting an OBJECT Value into an Oracle Table Using a Prepared Statement
e299.
Getting an OBJECT Value from an Oracle Table
e300.
Deleting an OBJECT Type from an Oracle Table
Oracle VARRAYs
e301.
Creating a VARRAY Type in an Oracle Database
e302.
Inserting a VARRAY Value into an Oracle Table
e303.
Inserting a VARRAY Value into an Oracle Table Using a Prepared Statement
e304.
Getting a VARRAY Value from an Oracle Table
© 2002 Addison-Wesley.