Trail: JDBC Database Access

Lesson: JDBC Introduction

JDBC manage three programming activities:

1. Connect to a data source, like a database.
2. Send queries and update statements to the database.
3. Retrieve and process the results received from the database in answer to your query.

JDBC Product Components

JDBC includes four components:

1. The JDBC API is divided into two packages: java.sql and javax.sql.
2. JDBC Driver Manager
3. JDBC Test Suite
4. JDBC-ODBC Bridge

主要使用前两个， 测试后面学习 junit5 的时候留意一下

JDBC Architecture

Two-tier and Three-tier Processing Models

In the two-tier model, a java application talks directly to the data source.
In the three-tier model, commands are sent to a “middle tier” of services.