Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store).
The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available.
But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions.
First off, be warned that this book was grossly mis-titled. If you're a beginner hoping to learn about JDBC and Java, look elsewhere. If you're interested in getting an overview on more advanced topics related to database design and other not-so-related topics, then you may want to add one star.
I read this book for final year project hoping to learn more about using JDBC to access databases for my project. The preface claimed that basic knowledge of Java and SQL was enough. Did the book cover JDBC? Yes, in about 3 short chapters from basic to advanced to optional. For someone who don't know JDBC, those three chapters will not give you more than hints of what can be done.
The rest of the book? It touches advanced topics like RMI, JNDI, EJB, a bit on design patterns, distributed architecture, persistence, and even, strangely, Swing; apparently in an attempt to show how JDBC is used in the real world. As a student, reading those chapters is like reading a chemistry book. None of those chapters attempt to explain things in a big picture, but instead dives straight into the advanced topics as if the reader is expected to know the basics.
It's a book that's badly advertised and expects the reader to know very much about the topics being discussed, but doesn't actually say that the reader should.