Java APIs, Extensions and Libraries: With JavaFX, JDBC, jmod, jlink, Networking, and the Process API

© Kishori Sharan 2018

Kishori SharanJava APIs, Extensions and Librarieshttps://doi.org/10.1007/978-1-4842-3546-1_5

5. JDBC API

Kishori Sharan¹ 

(1)

Montgomery, Alabama, USA

 

In this chapter, you will learn:

• What JDBC API is

• The types of JDBC drivers

• A brief overview of Apache Derby database

• How to connect to a database using a JDBC driver

• What transaction isolation levels are

• JDBC-data-types-to-Java-data-types mapping

• How to execute SQL statements in Java programs and process the results

• How to use rowsets, batch updates, and large objects (LOBs)

• How to retrieve SQL warnings and enable JDBC tracing

All example programs in this chapter are members of a jdojo.jdbc module, as declared in Listing 5-1.

// module-info.java

module jdojo.jdbc {

    requires java.sql.rowset; ...