Bible. This book is for readers who are already
Java, and who want to know more about working with databases. The JDBC
Programming Interface has made
programming an important
Java development, particularly where Web applications are concerned.
The ease with which
Java enables you to develop
database applications is one of the
main reasons for
Java's success as a server-side development language.
programming is perhaps the key element in developing server-side applications, as it
enables such diverse applications as auction sites, XML-based Web services,
shipment-tracking systems, and search engines.
What this Book Aims to Do
The aims of this book are to give you a good understanding of what a relational
is, how to design a relational
database, how to create and query a relational
using SQL, and how to write
database-centric applications in
Java. There are many
books that cover individual aspects of the aforementioned topics, such as SQL or JDBC.
The intention of this book is to provide a single source of information and application
examples covering the entire subject of relational databases.
When I first started to develop
database-driven applications in
Java, I was working with a
database administrator who was responsible for the
database side of the project. This is a
fairly common approach to managing larger
database-driven applications, since it places
responsibility for the
database in the hands of a
database expert and allows the
programmer to concentrate on his or her own area of expertise. The disadvantages of this
approach only became apparent when some of my code proved to be unacceptably slow
database design considerations that failed to take into account the needs of
the business logic.
Working on subsequent smaller projects enabled me to manage my own databases and
develop an understanding of how to design databases that work with the business logic. I
also learned about the tradeoffs involved in using indexes and the importance of
normalization in designing a
database. Perhaps the most important thing I learned was
that, thanks to the design of the JDBC API and the universality of the SQL language,
much of what you learn from working with one
database-management system is directly
applicable to another