Java Database Programming Bible

• Master the ins and outs of RDBMS technology, SQL, and JDBC
• Create two-tier and multi-tier database applications
• Harness JSP, servlets, EJB, JDO, XML, and related technologies

If Java can do it, you can do it too . . .

Java delivers powerful tools for creating today's multi-tier database applications. Packed with lucid explanations and lots of real-world examples, this comprehensive guide gives you everything you need to master Java database programming techniques. Starting with an insightful look into RDBMS, SQL, and JDBC fundamentals, veteran developer John O'Donahue walks you through the development process for both two-tier and three-tier applications, providing detailed coverage of Java database applications, using Swing components, servlets, JSP, XML, and EJB persistence.

Inside, you'll find complete coverage of Java database programming

• Get a comprehensive overview of relational database design, SQL, and JDBC
• Create a complete two-tier application using Swing components to update, retrieve, summarize, and group data
• Build a three-tier Web application using servlets, JSP, HTML forms, XSL transforms, and JavaMail
• Use servlets to upload images and documents, store them as blobs or clobs, and retrieve and display them using JSP
• Harness JDBC, SQL, JDO, and other technologies to work with XML documents and Web services
• Delve into bean-managed persistence, container-managed persistence, and JDO-managed transparent persistence
• Set up users and schemas, establish security, and tune database performance

Part I: Introduction to Databases, SQL, and JDBC

• Chapter 1: Relational Databases
• Chapter 2: Designing a Database
• Chapter 3: SQL Basics
• Chapter 4: Introduction to JDBC

Part II: Using JDBC and SQL in a Two-Tier Client/Server Application

• Chapter 5: Creating a Table with JDBC and SQL
• Chapter 6: Inserting, Updating, and Deleting Data
• Chapter 7: Retrieving Data with SQL Queries
• Chapter 8: Organizing Search Results and Using Indexes
• Chapter 9: Joins and Compound Queries
• Chapter 10: Building a Client/Server Application

Part III: A Three-Tier Web Site with JDBC

• Chapter 11: Building a Membership Web Site
• Chapter 12: Using JDBC DataSources with Servlets and Java Server Pages
• Chapter 13: Using PreparedStatements and CallableStatements
• Chapter 14: Using Blobs and Clobs to Manage Images and Documents
• Chapter 15: Using JSPs, XSL, and Scrollable ResultSets to Display Data
• Chapter 16: Using the JavaMail API with JDBC

Part IV: Using Databases, JDBC, and XML

• Chapter 17: The XML Document Object Model and JDBC
• Chapter 18: Using Rowsets to Display Data
• Chapter 19: Accessing XML Documents Using SQL

Part V: EJBs, Databases, and Persistence

• Chapter 20: Enterprise JavaBeans
• Chapter 21: Bean-Managed Persistence
• Chapter 22: Container-Managed Persistence
• Chapter 23: Java Data Objects and Transparent Persistence

Part VI: Database Administration

• Chapter 24: User Management and Database Security
• Chapter 25: Tuning for Performance
• Appendix A: A Brief Guide to SQLSyntax
• Appendix B: Installing Apache and Tomcat