- JDBC 4.0 and Oracle JDeveloper for J2EE Development
- Deepak Vohra
- 256字
- 2021-08-25 18:08:43
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.
- Learning SQL Server 2008 Reporting Services
- WordPress 2.7 Cookbook
- 數據、模型與決策:基于Excel的建模和商務應用
- Moodle 1.9 for Teaching 7/14 Year Olds: Beginner's Guide
- Excel 2013使用詳解(修訂版)
- Alice 3 Cookbook
- Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
- CMS Design Using PHP and jQuery
- Django 1.0 Template Development
- 抖音+剪映+Premiere短視頻制作從新手到高手(第2版)
- 中文版3ds Max 2022基礎教程
- Photoshop CC入門與提高
- 中文版Premiere Pro CS6視頻編輯(慕課版)
- Science Teaching with Moodle 2.0
- Mobile Web Development