Understanding SQL and Java Together

Meer over het boek

With the growth of Java and the rise of database-powered Web applications, the need for integrating Java with SQL has become essential. This resource offers comprehensive coverage of the techniques necessary to effectively combine these two technologies, providing both programming and career benefits. It thoroughly examines standards for integrating SQL and Java, demonstrating how to leverage their features to write efficient code that supports Java access to SQL data in various ways. Readers will gain a deep understanding of the relationship between SQL and Java, enabling them to write both static and dynamic SQL programs, merge Java code with SQL databases, and employ other data management techniques as needed. Key topics include the technologies for using SQL and Java together, such as JDBC, Java Blend, and SQLJ, as well as how to embed SQL code in Java and utilize Java's capabilities to compile code for specific DBMS. Additionally, it explains storing and invoking Java routines in an SQL database and how to store Java objects for seamless interchange among application layers. Dynamic SQL access techniques using JDBC and effective combinations of static and dynamic SQL are also covered. A CD-ROM is included, featuring Oracle's JDeveloper, Sybase's Adaptive Server Anywhere, Informix's Cloudscape, the complete database schema, and the full text of most examples.