JDBC learning notes

I. overview of JDBC

1.JDBC:SUN provides a set of operating database specifications

The relationship between 2.JDBC and database: the relation between interface and implementation class

3.JDBC specification: (four core objects)

ADriverManager: for registration drivers

Connection: indicates a link to the database creation

Statement: the object that operates the database executing the SQL statement

Listing ResultSet: a result set or a virtual table

Two, JDBC entry procedures

1. create Java project, boot package

2. create a test database in MySQL and insert data

3. code implementation

4.results of enforcement