Read more
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.
This edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. It also explains the relationship between JDBC and Enterprise JavaBeans.
List of contents
Preface
The JDBC API
Chapter 1: Java in the Enterprise
Chapter 2: Relational Databases and SQL
Chapter 3: Introduction to JDBC
Chapter 4: Advanced JDBC
Chapter 5: The JDBC Optional Package
Applied JDBC
Chapter 6: Other Enterprise APIs
Chapter 7: Distributed Application Architecture
Chapter 8: Distributed Component Models
Chapter 9: Persistence
Chapter 10: The User Interface
Reference
Chapter 11: JDBC Reference
Chapter 12: The JDBC Optional Package Reference
Colophon
About the author
George Reese is the founder of two Minneapolis-based companies, enStratus Networks LLC (maker of high-end cloud infrastructure management tools) and Valtira LLC (maker of the Valtira Online Marketing Platform). Over the past 15 years, George has authored a number of technology books, including MySQL Pocket Reference, Database Programming with JDBC and Java, Java Database Best Practices, and the upcoming Web Architecture and Programming in the Cloud.Throughout the Internet era, George has spent his career building enterprise tools for developers and delivering solutions to the marketing domain. He was an influential force in the evolution of online gaming through the creation of a number of Open Source MUD libraries and he created the first JDBC driver in 1996--the Open Source mSQL-JDBC. Most recently, George has been involved in the development of systems to support the deployment of transactional web applications in the cloud.George holds a BA in Philosophy from Bates College in Lewiston, Maine and an MBA from the Kellogg School of Management in Evanston, Illinois. He currently lives in Minnesota with his wife Monique and his daughters Kyra and Lindsey.
Summary
This text 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.
