Lesson: JDBC Introduction

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.

A Relational Database Overview

In simplest terms, a relational database is one that presents information in tables with rows and columns.

Integrity Rules

1. duplicate rows are not allowed
2. column values must not be repeating groups or arrays.
3. a null value is missing.
4. primary key cannot be null.

Common SQL Commands

DML data manipulation language

• select
• insert
• delete
• update
  DDL data definition language
• create table
• drop table
• alter table