JDBC Recipes

1. Front Matter

   Pages i-xxvii

   PDF

2. Introducing JDBC

   Pages 1-44

3. Exploring JDBC’s Novel Feature

   Pages 45-86

4. Making Database Connections

   Pages 87-151

5. Making Database Connections Using DataSource

   Pages 153-168

6. Exploring the ResultSet Interface

   Pages 169-208

7. Working with Scrollable and Updatable ResultSet Objects

   Pages 209-229

8. Reading and Writing BLOBs

   Pages 231-256

9. Reading and Writing CLOBs

   Pages 257-305

10. Working with Date, Time, and Timestamp in JDBC

    Pages 307-340

11. Handling Exceptions in JDBC

    Pages 341-380

12. Exploring the Statement

    Pages 381-430

13. Working with the PreparedStatement

    Pages 431-492

14. Passing Input Parameters to PreparedStatement

    Pages 493-567

15. Exploring JDBC Utilities

    Pages 569-613

16. Back Matter

    Pages 615-635

    PDF

JDBC Recipes provides easy-to-implement, usable solutions to problems in relational databases that use JDBC. You will be able to integrate these solutions into your web-based applications, such as Java servlets, JavaServer Pages, and Java server-side frameworks. This handy book allows you to cut and paste the solutions without any code changes.

This book focuses on topics that have been ignored in most other JDBC books, such as database and result set metadata. It will help you develop database solutions, like adapters, connectors, and frameworks using Java/JDBC. The insightful solutions will enable you to handle all data types, including large binary objects. A unique feature of the book is that it presents JDBC solutions (result sets) in XML.

• Exception
• Factor
• Framework
• Java
• JavaServer Pages
• MySQL
• Prepared Statement
• SQL
• Servlet
• Servlets
• XML
• stored procedure

Mahmoud Parsian, Ph.D. is a Sun Certified Java Programmer and senior lead software engineer for AskJeeves.com, and he has expertise in Java database programming and development. His honors include the following: Ask Jeeves Bright Star Award, Octopus Award for successive release of the Octopus software, Cisco Systems Leadership Award, Individual Achievement Award, and four Specialist of the Quarter awards. Parsian has also received numerous commendation letters from customers regarding his outstanding performance and leadership on customer projects.

Policies and ethics