Ships from: Chatham, NJ
Usually ships in 1-2 business days
| Preface | ||
| Ch. 1 | JDBC Today | 1 |
| Ch. 2 | The Relational Database and SQL | 13 |
| Ch. 3 | The JDBC API Explained | 37 |
| Ch. 4 | Getting Connected | 53 |
| Ch. 5 | Using the Connection | 77 |
| Ch. 6 | Retrieving and Manipulating Data: The Statement Class and JDBC Exceptions | 103 |
| Ch. 7 | The PreparedStatement and CallableStatement Classes | 133 |
| Ch. 8 | The ResultSet Class | 165 |
| Ch. 9 | Transactions in JDBC | 203 |
| Ch. 10 | JDBC and Dynamic Queries | 217 |
| Ch. 11 | The DatabaseMetaData Interface | 245 |
| Ch. 12 | DatabaseMetaData Methods | 267 |
| Ch. 13 | Advanced Topics JDBC in Action: Introduction to JDBC Design Patterns | 299 |
| Ch. 14 | Table Browser Application | 339 |
| Ch. 15 | Persisting Data Objects with JDBC | 365 |
| Ch. 16 | JDBC Design Patterns: Data Access Objects and Value Objects | 379 |
| Ch. 17 | JSP Basics | 427 |
| Ch. 18 | JSP and JDBC in Development: A Discussion Group System | 457 |
| Ch. 19 | JSP and JDBC in Development: Coding the Discussion Group System | 481 |
| Ch. 20 | Transforming JDBC Data to XML | 545 |
| Ch. 21 | JDBC and BLOBs | 565 |
| Ch. 22 | Enterprise JavaBeans Architecture | 583 |
| Ch. 23 | JDBC and Enterprise JavaBeans | 601 |
| App. A | JDBC 3.0 | 631 |
| App. B | Java Servlets | 637 |
| App. C | XML Basics and Processing with JAXP | 667 |
| App. D | Math Functions | 697 |
| Index | 701 |
This book was written with two major goals: cover the JDBC specification in detail and provide a series of examples that demonstrate how JDBC would be used in real world using J2EE.
These goals create two targets: one which is clear and focused and the other which is open-ended and vague. Writing about the JDBC API is fairly straightforward; take the classes, describe the methods and show examples that use the methods in the class. But writing about any possible Java database application is open-ended. A database application can be a text-based application reading from a file and updating a database. It can be an applet written using AWT, a GUI client written in Swing, or it can be a servlet or JSP page running in a Web server. It can be a distributed component written as an EJB.
So showing every possible Java database application was not an option. What was chosen were a set of examples that cover some common and some interesting approaches to Java database programming with J2EE. The result was a set of applications that included text-based applications, RMI, Java file i/o, the Swing GUI, Java Server Pages, Java servlets, JavaBeans and Enterprise JavaBeans.
With that in mind, this book is designed to accommodate the introductory developer, the Java developer who has just started working with Java, up to the intermediate and even advanced Java developer. The book begins by assuming some knowledge of Java and relational databases and presents a series of short examples and a few code snippets. The initial examples are not meant to be representative of how JDBC would be used in a complete application, but are meant to show specific JDBC APIfeatures and methods. By using short examples with most of the work being done within the main program block, the focus in these early chapters remains on the JDBC API and is not lost in a complex application.
Examples begin to progress in complexity with the later chapters. This is obviously based on the assumption that the reader is now more familiar with JDBC and database programming with Java and is ready to see JDBC in more complex, real-world examples. As mentioned previously, these later examples use Swing, RMI, JSPs, JavaBeans, servlets and EJBs and apply various Java design patterns to provide additional structure to the code.
This book covers the majority of the JDBC 3.0 specification. Examples were compiled and tested using JDK 1.4 using JDBC drivers based on the JDBC 2.1 specification.
The code examples in the book are available on the companion web site in addition to other code examples and content. Be sure to check the web site to keep up to date on any corrections, changes or additional content.
The individual who should read this book should be familiar with the Java language but there is no requirement to be a Java guru. Instead, some knowledge of the language basics, familiarity with the syntax, understanding of object-oriented programming, Java exception handling, and class file layout should be sufficient.
The individual reading this book should also have some understanding of relational databases. Since the assumption is that the potential reader will most likely be a Java programmer who has had a JDBC project thrust upon them (or has wisely pursued such a project), the book will devote some coverage to relational databases in Chapter 2. The SQL language will be covered, including the basic syntax of Data Manipulation Language (DML) and some of the more advanced SQL features such as unions and complex joins.
Overview