Understanding SQL and Java Together
A Guide to SQLJ, JDBC, and Related Technologies
Published on 23. May 2000
Book
Paperback/Softback
514 pages
978-1-55860-562-6 (ISBN)
Description
With the growth of Java and the rise of database-powered Web applications, the need to use Java with SQL is clear. Until now, authoritative coverage of the techniques available to meet these challenges and reap their benefits-both programming and career benefits-didn't exist.
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.
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.
More details
Series
Language
English
Place of publication
San Francisco
United States
Publishing group
Elsevier Science & Technology
Target group
Professional and scholarly
Dimensions
Height: 235 mm
Width: 187 mm
Weight
900 gr
ISBN-13
978-1-55860-562-6 (9781558605626)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books. Andrew Eisenberg is Manager of Standards and Consortia at Progress Software Corporation. He represents his company on the ANSI NCITS Technical Committee H2 for Database, the W3C XML Query Work Group, and the Transaction Processing Performance Council. He has represented prior companies on the OMG and the SQLJ informal group.
Content
1. Chapter 1 - Introduction
2. Chapter 2 - Java for the SQL Programmer
3. Chapter 3 - SQL for the Java Programmer
4. Chapter 4 - JDBC 1.0 API
5. Chapter 5 - SQLJ Part 0 (Embedding SQL in Java)
6. Chapter 6 - SQLJ Part 1 (SQL Routines Using the Java(tm) Programming Language)
7. Chapter 7 - SQL User-Defined Types
8. Chapter 8 - SQLJ Part 2 (SQL Types Using the Java(tm) Programming Language)
9. Chapter 9 - JDBC 2.0 API
10. Chapter 10 - Java Blend
11. Chapter 11 - GUI Java Application Builders
12. Chapter 12 - Future Developments and Standards Processing
13. Appendix A - Relevant Standards Bodies
14. Appendix B - Database Schema Used in Our Example
15. Appendix C - Movie and Vote Classes
16. Appendix D - SQL/PSM Syntax
17. Appendix E - SQLJ Part 0 Syntax
18. Appendix F - SQLJ Part 1 Syntax
19. Appendix G - SQL UDT Syntax
20. Appendix H - SQLJ Part 2 Syntax
21. Appendix I - The PlayingCard Classes
2. Chapter 2 - Java for the SQL Programmer
3. Chapter 3 - SQL for the Java Programmer
4. Chapter 4 - JDBC 1.0 API
5. Chapter 5 - SQLJ Part 0 (Embedding SQL in Java)
6. Chapter 6 - SQLJ Part 1 (SQL Routines Using the Java(tm) Programming Language)
7. Chapter 7 - SQL User-Defined Types
8. Chapter 8 - SQLJ Part 2 (SQL Types Using the Java(tm) Programming Language)
9. Chapter 9 - JDBC 2.0 API
10. Chapter 10 - Java Blend
11. Chapter 11 - GUI Java Application Builders
12. Chapter 12 - Future Developments and Standards Processing
13. Appendix A - Relevant Standards Bodies
14. Appendix B - Database Schema Used in Our Example
15. Appendix C - Movie and Vote Classes
16. Appendix D - SQL/PSM Syntax
17. Appendix E - SQLJ Part 0 Syntax
18. Appendix F - SQLJ Part 1 Syntax
19. Appendix G - SQL UDT Syntax
20. Appendix H - SQLJ Part 2 Syntax
21. Appendix I - The PlayingCard Classes