数据库编程 东海陈光剑 桃花源大仙 20120807.docx

数据库编程东海陈光剑 桃花源大仙igure 2.1 Java App 与数据库通信过程16Figure 3.1 the Books table.17Figure 3.2 shows the most common SQL data types.20Figure 3.3 SQL Data Types and Their Corresponding Java Types21数据库编程Database ProgrammingJDBC设计架构The Design of JDBCSQL结构化查询语言The Structured Query Language安装JDBCJDBC InstallationJDBC编程基本概念Basic JDBC Programming Concepts查询Query Execution滚动更新数据Scrollable and Updatable Result Sets元数据Metadata行Row Sets事物Transactions高级连接Advanced Connection ManagementLDAP简介Introduction to LDAPIn the summer of 1996, Sun released the first version of the Java Database Connectivity (JDBC) API. This API lets programmers connect to a database and then query or update it, using the Structured Query Language or SQL. (SQL, usually pronounced like sequel, is an industry standard for relational database access.)Java and JDBC have an essential advantage over other database programming environments: Programs developed with Java and JDBC are platform independent and vendor independent.The same database program written in Java can run on an NT box, a Solaris server, or a database appliance powered by the Java platform. You can move your data from one database to another, for example, from Microsoft SQL Server to Oracle, or even to a tiny database embedded in a device, and the same program can still read your data. This capability is in sharp contrast to traditional database programming. Too often, developers write database applications in a proprietary database language, using a database management system that is available only from a single vendor.JDBC has been updated several times. As part of the release of JDK 1.2 in 1998, a second version of JDBC was issued. As this book is published, JDBC 3 is the most current version, with JDBC 4 under development. JDBC 3 is included with JDK 1.4 and 5.0.We must caution you that the JDK offers no tools for visual database program development. For form designers, query builders, and report generators, you need to turn to third-party to