JDBC Developer's Resource (Bk/CD)

84235-1 Write JavaaA A code that leverages all your corporate data resources-with JDBC and The JDBC Developer's Resource. If you need to build Java applications that use existing corporate data, you deserve the best JDBC tutorial and reference available: The JDBC Developer's Resource. For programmers familiar with Java, this book/CD-ROM package offers comprehensive coverage of Sun's Java Database Connectivity (JDBC) API-and provides complete tools for making the most of JDBC. Learn all the fundamentals you need to know, including JDBC's interface, methods, and relationship to ODBC. Then, using extensive code examples, discover how to use JDBC in a wide range of applications, in both two-tiered and three-tiered environments. An extensive tutorial walks you through every step of developing numerous sample applications, demonstrating virtually all the techniques you need to know to program JDBC applications. Examples range from the development of simple JDBC applications to connect to a database and retrieve data, to the creation of a three-tiered RMI program with an applet that makes remote calls to object methods on a server using Java's RMI interface.As you become familiar with JDBC, you'll depend on The JDBC Developer's Resource even more. Its exclusive "Quick Reference" describes all JDBC methods, the classes they belong to, and the parameters passed to them. A more detailed reference presents every class, its methods and variables, with code samples. The accompanying CD-ROM contains indispensable tools for JDBC and Java software development, including: *A trial version of the exciting new Mojo Java applet development environment. *The complete Java RMI and JDBC API. *Intersolv's DataDirect ODBC Pack for Microsoft WindowsA (R) 95. *Sun's complete Java Developer's Kit 1.02. *Complete source code for all the books applets and applications. With The JDBC Developer's Resource, you've got everything you need to combine Java's unprecedented capabilities with your organization's massive data resources. Now that's power.

Table of Contents:
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.