JDBC Developer's Resource (Bk/CD)

Introduction. The Java Language and the JBDBC. About This Book. Target Audience. Resource. Conventions Used in This Book. About the CD. About the Web Site. I. JAVA TUTORIAL. 1. A Java Language Primer. History of Java. Features. Design. C++ and Java. Emerging Java Technologies. Java Beans. Java JDK Version 1.1. Java Database Access Standard (JDBC). Flavors of JDBC. Basic Elements of Java. Numeric Data Types. Arrays. Strings. Labels. Memory Management in Java. Exception Handling. C and C++ Features Not Present in Java. typedefs, defines, and Pre-processor Support. Structures and Unions. Functions. Operator Overloading. Automatic Coercion. Pointers. 2. Relational Database Primer. History of the Relational Database. Relational Database Concepts. Relational Database Terminology. Structured Query Language. Basic SQL Statements. SQL Standards. Call Level Interface. Transactions, Database Logging and Isolation Levels, and Concurrency. SQL Query Optimization. Dynamic SQL Execution. 3. JDBC Application Programmer Interface (API). SQL Statement Execution with JDBC. DriverManager Class. The java.sql.Connection Class. The java.sql.Statement Class. The java.sql.ResultSet class. The java.sql.PreparedStatement Class. JDBC Security. JDBC Usage. Applet. Java for General-Purpose Applications. CGI Application. JDBC Application Design. JDBC Data Type Mapping. Multi-Threading in Java. Transactions. Cursors. SQL Level. 4. JDBC Tutorial. A Simple JDBC Application. Use of the Prepared Statement. Positioned Cursor Update. Transaction Modes. Java Applet. Three-Tiered Remote Method Invocation (RMI) Application. CGI Application. Metadata Usage. ResultSet Array Example. Basic JDBC Programming. Basic JDBC Steps. Load Driver. Create Connection. Create Statement. Execute SQL Statement and Return ResultSet. Iterate ResultSet. A Dynamic SQL Select Program. Load Driver and Get Database Connection. Retrieve Table Name from Command Line Argument. Build Select Statement. Create Statement Object and Execute SQL Statement. Create a ResultSetMetaData Object. Traverse the ResultSet. Prepared Statement. Create Query String with Parameters and Create Prepared Statement Object. Set Parameter Value and Execute Query. Loop for 2000 Iterations. Positioned Cursor Update. Load Database Driver and Create Connection. Create DatabaseMetaData Object and Test for Positioned Update Functionality. Execute Select Query. Get Cursor Name and Execute Update Statement. Review Results. Transaction Modes. Load Driver and Create Connection. Set the Auto-Commit Mode. Create Statement and Execute DDL and DML. Commit Work. Create Prepared Statement and Execute Updates. Rollback Work and Display Results. catch code block. CGI Application. Load Driver Manager and Create Connection. Create Prepared Statement with Parameter. Parse CGI Arguments. Set Parameters and Execute Query. Retrieve Results and Display Formatted Output. Metadata Access. Retrieve Query from the Command Line. Load Driver and Create Connection. Create Statement and Execute the Query. Retrieve the ResultSet and Determine the Number of Columns. Execute Formatting Routine. Iterate Results Displaying Formatted Data. Scrolling ResultSet Array. Declare RSArray Object. Load DriverManager and Connection. Create Statement and Execute. Iterate ResultSet Adding to ResultSetArray Buffer. Display Results. The RSArray Class. Class Definition. 5. JDBC Applet Example. Overview. Insert Data. Get Data. Next Row. Previous Row. Applet Code. Declarations. Display Applet Window. Previous Row Button Click Event Handler. Next Row Button Click Event Handler. Insert Data Button Click Event Handler. Declarations. Display Applet Window. Button Class Declaration. Previous Button Click Handler. Insert Data Button Click Event. NextRow Button Event. Get Data Button Event. 6. Three-Tiered Application Demo. Benefits of Three-Tiered Architecture. The Java Remote Method Invocation (RMI) API. Creating a RMI Application. Three-Tiered Demo Application. Client Applet Overview. Server Application Overview. Client Price Guide Applet. RMI Server. Complete Code Presentation. CompApplet. ClientHandler. ServerHandler. CompPrice. ResultSetCopy. ResultCopier. Database. II. JDBC REFERENCE. 7. JDBC Quick Reference. JDBC Methods Summary. All JDBC Methods. Class Variables. 8. JDBC Reference. Interface java.sql.CallableStatement. CallableStatement Methods. Interface java.sql.Connection. Connection Methods. The java.sql.DatabaseMetaData Interface. Instance Variables. DatabaseMetaData Methods. Class java.sql.DataTruncation. DataTruncation Methods. Class java.sql.Date. Interface java.sql.Driver. Driver Methods. getPropertyInfo. Class java.sql.DriverManager. DriverManager Methods. Class java.sql.DriverPropertyInfo. Variables. Constructor. Class java.sql.NullData. Variables. Constructor. Class java.sql.Numeric. Constructors. Numeric Methods. hashCode. Interface java.sql.PreparedStatement. PreparedStatement Methods. executeQuery. Interface java.sql.ResultSet. ResultSet Methods. Interface java.sql.ResultSetMetaData. ResultSetMetaData Variables. ResultSetMetaData Methods. Class java.sql.SQLException. SQLException Constructor. SQLException Methods. Class java.sql.SQLWarning. SQLWarning Constructor. SQLWarning Methods. Interface java.sql.Statement. Statement Methods. Class java.sql.Time. Methods. Class java.sql.Timestamp. Timestamp Constructors. Timestamp Methods. Class java.sql.Types. APPENDIX A. Functions. Math Functions. String Functions. Date Functions. Database Functions. Index.