JDBC: Database Programming with J2ee

The in-depth programmer's guide to database access with JDBC 3.0.

• The definitive JDBC tutorial and reference
• Covers the JDBC 3.0 API Java design patterns for JDBC and best-practice programming techniques
• JSP Web database development with JSPs and servlets, RMI multi-tier development, and EJB-based database integration

JDBC gives Java developers the power to database-enable virtually any application, on virtually any platform, using virtually any database. In this book, leading JDBC expert Art Taylor combines an expert JDBC tutorial and a definitive API reference that provides thorough and detailed coverage of the new JDBC 3.0 standard. Taylor brings together code examples, design patterns, and expert programming techniques for J2EE programming. Code examples include Web development, GUI programming with Swing, servlets, JSPs, EJBs, and RMI. Coverage includes:

• Web database development capabilities leveraging JavaServer Pages(tm) and servlets
• Database access using Enterprise JavaBeans(tm) components
• Creating a GUI-based database browser using Swing
• JDBC 3.0 support for scrollable cursors, batch updates, and connection pooling
• DataSource lookup using JNDI
• Using Blobs with JDBC
• Dynamic SQL using JDBC database metadata

If you write database applications with Java(tm), one book delivers all the expertise and insight you need to maximize their power and performance: JDBC: Database Programming with J2EE.

Table of Contents

Preface.
1. JDBC Today.
2. The Relational Database and SQL.
3. The JDBC API Explained.
4. Getting Connected.
5. Using the Connection.
6. Retrieving and Manipulating Data: The Statement Class and JDBC Exceptions.
7. The PreparedStatement and CallableStatement Classes.
8. The ResultSet Class.
9. Transactions in JDBC.
10. JDBC and Dynamic Queries.
11. The DatabaseMetaData Interface.
12. DatabaseMetaData Methods.
13. Advanced Topics JDBC in Action: Introduction to JDBC Design Patterns.
14. Table Browser Application.
15. Persisting Data Objects with JDBC.
16. JDBC Design Patterns: Data Access Objects and Value Objects.
17. JSP Basics.
18. JSP and JDBC in Development: A Discussion Group System.
19. JSP and JDBC in Development: Coding the Discussion Group System.
20. Transforming JDBC Data to XML.
21. JDBC and BLOBs.
22. Enterprise JavaBeans Architecture.
23. JDBC and Enterprise JavaBeans.
Appendix A. JDBC 3.0.
Appendix B. Java Servlets.
Appendix C. XML Basics and Processing with JAXP.
Appendix D. Math Functions.
Index.