官术网_书友最值得收藏!

Chapter 1. JDBC 4.0

The Java Database Connectivity API is used to access a SQL database from a Java application. JDBC also supports tabular data sources, such as a spreadsheet. We will constrain our discussion to SQL relational databases. Using JDBC API, SQL statements can be run in a database. JDBC started as JDBC 1.0 API; JDBC 1.0 covered the basics of establishing a connection with a database, running SQL statements, retrieving values from result sets, and using transactions. JDBC 2.0 introduced scrollable result sets, JDBC methods to update a result set or a database table, batch updates, and SQL3 data types such as, BLOB, CLOB, Array, Ref, and Struct. JDBC 3.0 introduced savepoints, connection pooling of prepared statements, multiple open ResultSet objects, BOOLEAN data type, and an interface for parameter metadata and for retrieving database metadata. JDBC 4.0 specifications added some new features, which we will discuss in this chapter.

The JDBC API provides various interfaces and classes for accessing a database; creating tables in the database; and adding, updating, deleting data, in the database tables. In the following sections, we will discuss some of the JDBC classes and interfaces. We will also discuss the new methods added to these classes or interfaces, in JDBC 4.0 specifications. To run a JDBC 4.0 application, install a RDBMS database such as the open-source MySQL database or the commercial Oracle database. A JDBC driver class is required to establish a connection with the database. JDBC drivers are vendor-specific. A JDBC driver class implements the java.sql.Driver interface.

主站蜘蛛池模板: 浮山县| 朝阳区| 赤城县| 龙口市| 霞浦县| 娱乐| 嵩明县| 巩义市| 荔浦县| 秀山| 金山区| 吉林省| 巢湖市| 泾阳县| 阿坝| 铜川市| 广昌县| 双城市| 青田县| 桃源县| 大同市| 桓台县| 阳曲县| 深水埗区| 财经| 惠安县| 红河县| 瑞安市| 康定县| 朝阳市| 石渠县| 大化| 新民市| 荣成市| 天气| 克拉玛依市| 江永县| 璧山县| 绥化市| 盐津县| 罗定市|