JDBC API Tutorial and Reference Manual

Author: (USA) Fisher, M, (USA) Ellis, J, (USA) Bruce, J, Translated by Li Hua et al.
Publisher:
Publish Date: 2004-10-01
Features: This book provides an authoritative tutorial and reference for the JDBCTM API. The JDBCAPI technology supports universal data access using the JavaTM programming language. This version has been updated and expanded to cover the entire JDBCTM 3.0 API, including the java.sql package and the javax.sql package, which facilitates the development of server-side applications. In addition to introducing the JDBCTM 3.0 API specification, this book also includes in-depth explanations—from a step-by-step tutorial to a comprehensive reference for every class and interface. For beginners learning the Java technology, this book also introduces the basics of Java programming and SQL. Starting from this foundation, you will learn how to create databases, establish connections, retrieve values from result sets, and use prepared statements to create complete JDBC applications. Additionally, this book provides numerous examples and illustrates methods for performing common tasks. Then, the book shifts to more advanced topics, focusing on advanced features of the JDBCTM 3.0 API, such as scrollable and updatable result sets, batch updates, SQL99 data types, custom mapping, savepoints, statement pooling, and auto-generated keys. Beyond providing an in-depth introduction to the JDBC metadata API, this book also offers new insights into row sets. Row set technology supports handling datasets using JavaBeansTM components. Furthermore, this book introduces the standard implementations of JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet, and FilteredRowSet objects. This book provides concise yet comprehensive information for every class and interface in the JDBCAPI (from Array to XADataSource). Each class includes an overview of use cases, as well as detailed explanations of methods and fields. The chapters on the mapping between SQL types and types in the Java programming language, Appendix A, a summary of new features in the JDBC 2.0 and 3.0 APIs, and the glossary are essential resources for all database programmers.