Beginning Java Databases

What does this book cover?

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

Book overview

Java has evolved into a robust, high performance programming language that is well suited to a range of different environments, be it on a middle tier Application Server or a client browser. Regardless of the architecture of your application you are using, it will almost certainly need to make use of data that is stored in some form of database. Relational databases are the data store of choice in the vast majority of businesses, and have also evolved enormously over the recent years, into powerful and feature-rich data management systems.

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.

Who is this book for?

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++.

Summary of Contents

Introduction 1

Setting Up Your Java Environment 9

Chapter 1: Relational Databases and Java 15

Chapter 2: Basic JDBC Techniques 35

Chapter 3: SQL Queries and Data Manipulation 73

Chapter 4: Creating Tables and Modifying Data with SQL 131

Chapter 5: Relational Database Design Concepts 149

Chapter 6: Case Study: Designing the Music Store Database 187

Chapter 7: Overview of JDBC Application Development 223

Chapter 8: Connecting to a Database 259

Chapter 9: Using Statements and ResultSets 295

Chapter 10: Using Meta Data 333

Chapter 11: Using Rowsets 353

Chapter 12: Prepared Statements 377

Chapter 13: Callable Statements and Stored Procedures 419

Chapter 14: Transactions 449

Chapter 15: Object-Relational Mapping Concepts 489

Chapter 16: Using an Object-Relational Mapping Framework 517

Chapter 17: Debugging and Logging 591

Chapter 18: JDBC DataSources 631

Chapter 19: J2EE and Java Database Applications 665

Chapter 20: Exporting Relational Data to XML 719

Chapter 21: Using XSLT 759

Chapter 22: The Model-View-Controller Framework 801

Appendix A: Connecting to the Music Store Database 875

Appendix B: Installing the JBoss Application Server and Tomcat Web Container 897

Appendix C: XML Primer 913

Appendix D: Support, Errata, and p2p.wrox.com 957

Index 963

Applet Index
(sorted alphabetically)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z #s

The Java Source
(applets w/source code)
A B C D E F G H I J K
L M N O P Q R S T U
V W X Y Z

How to Add Java Applets to Your Site

New on the Java Boutique:

New Tutorial:

SAMS: Java's API For Mobile Services
This new Java API provides SMS and MMS functionality while eliminating portability hassles. Find out how SAMS helps bring mobile development one step closer to "write once, deploy anywhere".

New Applet:

Java Redirector
Place Java Redirector applet on a Web page to open another Web page in the browser window. You can have it open another Web page in the same window or in another browser window. You can set the size, background color, text color, font, font size, and display an images and text. The options are set in the applet tag.