JavaWeb——03JDBC

 JDBC架构：

JDBC访问数据库的步骤：

1、导入驱动，加载具体的驱动类

2、与数据库建立连接

3、发送SQL语句，执行

Statement执行增删改查

package JDBC_DEMO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class demo1 {
	private static String url="jdbc:mysql://localhost:3306/demodatabase?serverTimezone=UTC";
	public static void update() throws ClassNotFoundException, SQLException {
//1、加载具体的驱动类
		Class.forName("com.mysql.cj.jdbc.Driver");
//与数据库建立连接
		Connection connection = DriverManager.getConnection(url,"root","123456");
//发送SQL
		Statement stmt = connection.createStatement();
		String sql = "select * from person";
		//stmt.executeUpdate("insert into person values(1,xz,23)");
//查询操作	
		ResultSet rs = stmt.executeQuery(sql);
		while(rs.next()) {
			String name = rs.getString("name");
			int id = rs.getInt("id");
			int age = rs.getInt("age");
			System.out.println(id+name+age);
		}
		
		
	}
	
	
	
	public static void main(String[] args) {
		try {
			update();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

 Connection产生操作数据库的对象：

Connection产生Statement对象：createStatement();

Connection产生PreparedStatement对象：prepareStatement();

Connection产生CallableStatement对象：prepareCall();