Java Review of database programming

First, JDBC overview

1. The primary role of JDBC (Java database Connectivity,java connection)

Provides a platform-agnostic standard Java API for executing SQL statements, consisting of a set of classes and interfaces written in the Java language

JDBC Driver Classification:

JDBC-ODBC Bridge Drive

JDBC Local driver

JDBC Network Driver

Native protocol Pure JDBC Driver

2. JDBC's main operating interface

Java.sql.DriverManager

Java.sql.Connection

Java.sql.Statement

Java.sql.PreparedStatement

Java.sql.ResultSet

Java.sql.Date

Java.sql.Timestamp

Java.sql.CallableStatement

Java.sql.DatabaseMetaData

Java.sql.Driver

Java.sql.DataTruncation

Java.sql.DriverPropertyInfo

Java.sql.Time

Java.sql.SQLException

Java.sql.SQLWarning

Java.sql.Types

Second, MySQL database

1. mysql Database

2. mysql Database installation and configuration

3. Basic operation commands in MySQL

III. Fundamentals of SQL syntax

1. SQL Class (structed query Language, Structured Query language)

DML (data manipulation Language, Operation Yu Yang): Used to retrieve or modify data

DDL (data definition Language): A structure used to define data, such as creating, modifying, or deleting database objects

DCL (Data Control Language): Defining Permissions for database users

2. SQL syntax additions, modifications, deletions, simple query statements: DDL

Iv. JDBC Operation steps

1. JDBC Operation steps

2. How to configure the database driver

3. JDBC for Database Connectivity

V. Database UPDATE operations

1. Connection object Get statement instance

2. Statement data increment, modify, delete operation

Executeupdate ()

ExecuteQuery ()

Addbatch ()

Exectuebatch ()

Close ()

Execute ()

Vi.. ResultSet interface

Seven, PreparedStatement interface

1. How the PreparedStatement interface works

2. Using PreparedStatement for database update and query operation

Vii. processing of Big Data objects

Store massive text in CLOB

Storing binary data in BLOBs

Must use PreparedStatement

1. Fundamentals of large object processing

2. CLOB data read and write operations

3. Easy processing of large text data using the Clob class

Use IO stream or Getclob () to complete

4. Read-write operation of BLOB data

5. Blob class for easy processing of binary data

Eight, CallableStatement interface

1. Creation of MySQL stored procedures

2. Three ways to pass stored procedure parameters

3. CallableStatement the operation of the calling stored procedure

Nine, JDBC 2.0

1. Key features provided by JDBC 2.0

2. Actions for scrollable result sets

3. Add, modify, delete operation of result set

4. Batch Operations

X. Handling of Things

1. mysql Transaction operations Command: ACID

2. JDBC Transaction processing steps and implementation

Xi. using the Metadata Analysis database

1. DatabaseMetaData

2. ResultSetMetaData

Java Review of database programming