Beginning java databases

This book aims to teach you how to use these two powerful technologies to build successful Java database applications. You will find out how relational databases work and how you can use them in your Java programs, through the JDBC interface. You will see how to apply your new skills in an enterprise environment and by the end will be building sophisticated web-enabled Java database applications that incorporate other technologies, such as XML.

This book covers:

• Using the JDBC API to build database-driven Java applications
  
• Introduction to new JDBC 3.0 features
  
• SQL and relational database design
  
• Object-relational mapping frameworks and techniques
  
• Debugging your application and logging its activities
  
• Applying Java and JDBC skills in a J2EE environment
  
• Integrating XML into you Java database applications
  

This book is ideal for the programmer who has a reasonable grasp of the fundamentals of the Java language, and is now looking to apply and improve these skills in building database-driven Java applications. If you are relatively new to Java, then the explanations in the text should allow you to grasp all of the fundamental issues discussed, especially if you are migrating from another language such as C or C++.

Author Biography: Since becoming a professional software developer, Kevin Mukhar has programmed a client-server based training system in C and C++. He then worked on a large-scale data management system using an Oracle database to manage terabytes of binary data. The front-end was developed as a web application employing C++ and Java. This was followed by an all Java system for dynamically finding and displaying data from distributed data repositories. His latest job is developing Java intranet web applications using J2EE technologies. The web applications provide customer management for a company with millions of customers.

Todd Lauinger is a freelance instructor, mentor, conference speaker, and published author. He is currently employed as a Software Construction Fellow at Best Buy Co., Inc., working there to establish a common infrastructure for all Java-related software development activities in the enterprise. Todd has his Masters degree in Software Engineering, along with over 10 years of experience developing large, mission-critical software systems for engineering and business organizations.

John Carnell is currently working as a Senior Systems Architect for Workscape, a leading provider of HR and Employee Benefits self-service solutions. John's favorite topic of discussion, much to his wife's chagrin, is component based, N-Tier architectures. John has extensive experience with both the Microsoft, Oracle, and Java N-Tier solutions. John can be reached at john_carnell@yahoo.com.

Table of Contents

• Introduction
• Setting Up Your Java Environment
• Chapter 1: Relational Databases and Java
• Chapter 2: Basic JDBC Techniques
• Chapter 3: SQL Queries and Data Manipulation
• Chapter 4: Creating Tables and Modifying Data with SQL
• Chapter 5: Relational Database Design Concepts
• Chapter 6: Case Study: Designing the Music Store Database
• Chapter 7: Overview of JDBC Application Development
• Chapter 8: Connecting to a Database
• Chapter 9: Using Statements and ResultSets
• Chapter 10: Using Meta Data
• Chapter 11: Using Rowsets
• Chapter 12: Prepared Statements
• Chapter 13: Callable Statements and Stored Procedures
• Chapter 14: Transactions
• Chapter 15: Object-Relational Mapping Concepts
• Chapter 16: Using an Object-Relational Mapping Framework
• Chapter 17: Debugging and Logging
• Chapter 18: JDBC DataSources
• Chapter 19: J2EE and Java Database Applications
• Chapter 20: Exporting Relational Data to XML
• Chapter 21: Using XSLT
• Chapter 22: The Model-View-Controller Framework
• Appendices
• Appendix A: Connecting to the Music Store Database
• Appendix B: Installing the JBoss Application Server and Tomcat Web Container
• Appendix C: XML Primer
• Appendix D: Support, Errata, and p2p.wrox.com
• Index