This book provides complete and working solutions for performing database tasks using JDBC. You can cut and paste solutions from this book to build your own JDBC database applications. All the solutions have been compiled and tested against two leading databases: MySQL and Oracle. This book is ideal for anyone who knows some Java (can read/write basic Java programs) and a little JDBC (can read/write basic queries using JDBC and SQL) and wants to learn more about JDBC. Each section of this book is a complete recipe (including the database setup, the solution, and the MySQL and Oracle solutions), so you can use the code directly in your projects (although sometimes you may need to cut and paste the sections you need).
This book provides solid guidelines for using JDBC to solve tough problems, such as how to load your pictures (binary data) into an Oracle/MySQL database and how to retrieve your pictures from the database as a URL. Most of the solutions presented in this book have been used and tested in realworld database applications. In fact, I have designed and developed all the JDBC code for MyJeeves (http://myjeeves.ask.com) using the same philosophies as in this book. You can cut and paste the provided solutions and tailor them to your own JDBC applications.
