[Book Cover]

JDBC Developer's Resource, 2/e

Art Taylor

Published December, 1998 by Prentice Hall PTR (ECS Professional)

Copyright 1999, 600 pp.
Paper
ISBN 0-13-901661-9


Sign up for future
mailings on this subject.

See other books about:
    Database Management and Design-Computer Science


Summary



Features




Table of Contents
I. JAVA TUTORIAL.

    1. A Java Language Primer.

      History of Java. Features. Design. C++ and Java. Emerging Java Technologies. Java Beans. Java Database Access Standard (JDBC). JDBC Driver Types. The Java Base System. 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. Multiple Inheritance. 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. 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. Load Driver and Create Connection. Create Query String with Parameters and Create PreparedStatement 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. 'Get Date' Button Click. '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 Programming with JDBC.

      RMI Example: The Client. The Middle Tier. The Back End. Three-Tiered and Multitiered Programming with Java RMI. Using JDBC and RMI. Three-tiered RMI Example. The RMI/ JDBC Example. The RMI Client Code. RMI Remote Method Programming (Server). Remote Method Implementation: Main Program Block.

    7. JDBC 2.0 Revisions and Extensions.

      JDBC 2.0 Enhancements and Changes. Result Set Enhancements. Batch Updates. Advanced Data Types. Rowsets. JNDI Database Naming. Connection Pooling. Distributed Transaction Support. Other Additions. Result Set Enhancements. ResultSet Scrolling. Using a ResultSet. Updating with ResultSets. Inserting with ResultSets. Visibility of Database Changes. Determining Cursor Capabilities. Batch Updates with JDBC. Object Persistence: Storing Java Objects in the Database. New SQL Data Types. Distinct and Structured Data Types. Retrieving and Storing Large Objects: Blobs and Clobs. Retrieving Arrays. Retrieving and Storing "refs". Retrieving and Storing Distinct Data Types. Retrieving and Storing Structured Types. Using Stream I/O to Manipulate Structured Data Types. Conclusion.

II. JDBC REFERENCE.
    8. JDBC Quick Reference.

      JDBC Methods Summary. All JDBC Methods. Class Variables.

    9. JDBC Reference.

      Interface BigDecimal. Instance Variables. BigDecimal Methods. Interface BigInteger. Instance Variables. BigInteger Methods. Interface java.sql.CallableStatement. CallableStatement Methods. Interface java.sql.Connection. Instance Variables. Connection Methods. The java.sql.DatabaseMetaData Interface. Instance Variables. DatabaseMetaData Methods. Class java.sql.DataTruncation. DataTruncation Methods. Interface java.sql.Date. Interface java.sql.Driver. Driver Methods. GetPropertyInfo. Interface java.sql.DriverManager. DriverManager Methods. Interface java.sql.DriverPropertyInfo. Variables. Constructor. Class java.sql.NullData. Variables. Constructor. Interface java.sql.PreparedStatement. PreparedStatement Methods. 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. Interface java.sql.Time. Time Constructors. Methods. Class java.sql.Timestamp. Timestamp Constructors. Timestamp Methods. Class java.sql.Types.

    Appendix A: Functions.
    Appendix B: Applet Code Example (Chapter 5).
    Appendix C: RMI Code Example (Chapter 6).
    Index.

[Help]

© Prentice-Hall, Inc. A Simon & Schuster Company
Comments To webmaster@prenhall.com