Understanding SQL and Java Together

Understanding SQL and Java Together examines all the standards for
combining SQL and Java. It shows you exactly how to use their
features to write efficient and effective code supporting Java access to
SQL data in a variety of ways. You'll gain a thorough understanding of
the relationship between SQL and Java, which will allow you to write
static and dynamic SQL programs in Java, merge Java code with SQL
databases and SQL code, and use other data management techniques
wherever appropriate.

Features:

• Covers all the technologies for using SQL and Java together, including JDBC, Java Blend, and SQLJ Parts 0, 1, and 2
  
• Explains how to embed SQL code in Java and take advantage of Java's ability to compile that code for a specific DBMS
  
• Explains how to store and invoke Java routines in an SQL database-and how to store Java objects in an SQL database for seamless interchange among application layers
  
• Covers dynamic SQL access techniques using JDBC and advantageous ways to combine static and dynamic SQL
  
• Comes with a CD-ROM containing Oracle's JDeveloper, Sybase's Adaptive Server Anywhere, Informix's Cloudscape, the complete database schema, and the complete text of most of the examples
  

Table of contents

Introduction

Chapter 1: Java for the SQL Programmer

Chapter 2: SQL for the Java Programmer

Chapter 3: JDBC 1.0 API

Chapter 4: SQLJ Part 0

Chapter 5: SQLJ Part 1

Chapter 6: SQL User-Defined Types

Chapter 7: SQLJ Part 2

Chapter 8: JDBC 2.0 API

Chapter 9: Java Blend

Chapter 10: CUI Java Application Builders

Chapter 11: Future Developments and Standards Processing