JDBC Developer's Resource
2nd Edition
Published on 12. January 1999
Book
Mixed media product
600 pages
978-0-13-901661-5 (ISBN)
Description
This is simply the most systematic tutorial and reference available for mastering JDBC 2.0. Understand every key element of the JDBC 2.0 standard, and learn how it can be used to database-enable a wide variety of applications. Discover how JDBC provides for enhanced security, through techniques such as trusted applets. An extensive tutorial section walks developers through every step of developing a three-tier client/server application, demonstrating most of the techniques developers will need, including how to implement multithreading support, register drivers, and execute SQL statements. The book also contains listings of every JDBC class method, with real-world usage examples and tips. All code appears on the accompanying CD-ROM.
More details
Edition
2nd edition
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 235 mm
Width: 178 mm
Thickness: 45 mm
Weight
1303 gr
ISBN-13
978-0-13-901661-5 (9780139016615)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition
Art Taylor
JDBC Developer's Resource (Bk/CD)
Book
04/1997
Prentice Hall
€37.21
Article exhausted; check for reprint
Person
Art Taylor is a data consultant and author of two previous books for Prentice Hall PTR, including Informix Database Administrator's Resource Guide.
Content
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.
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.