The outstanding features of this book include but are not limited to the following.
1.
A novel writing style is adopted to attract students or beginning programmers who are interested in learning and developing practical database programs, with the hope of avoiding the headaches caused by huge blocks of codes found in traditional database programming books.
2.
A real completed sample database, CSE_DEPT, with three versions (Microsoft Access 2007, SQL Server 2008, and Oracle Database 10 g XE Release 2), is provided and used for the entire book. A step-by-step, detailed description about how to design and build a practical relational database is provided.
3.
Both fundamental and advanced database programming techniques are covered, for the convenience of both beginning students and experienced programmers.
4.
Updated Java database programming techniques, such as Java Persistence API, Java Enterprise Edition 6, JavaServer Pages, JavaServer Faces, and Enterprise Java Beans, are discussed and analyzed with real projects to enable readers to have a clear picture and easy-to-learn path for Java database applications.
5.
More than 30 real sample database programming projects are covered, with detailed illustrations and explanations to help students to understand key techniques and programming technologies.
6.
Three types of popular databases are covered and discussed in detail with practical sample examples: Microsoft Access, SQL Server 2008, and Oracle Database 10 g Express Edition (XE).
7.
The various actual JDBC APIs and JDBC drivers are discussed and presented with real example coding explanations. The working structure and principle of using a JDBC driver to establish a valid database connection, build an SQL statement, and process the query results are introduced in detail with example codes. JDBC RowSet, a useful tool, is also discussed and analyzed with some example codes.
8.
Problems and selected solutions are provided for each chapter to strengthen and improve understanding of the topics.
9.
Power Point teaching slides are also provided to help instructors
