// 加載JDBC驅(qū)動程序：反射，這樣調(diào)用初始化com.mysql.jdbc.Driver類，即將該類加載到JVM方法
區(qū)，并執(zhí)行該類的靜態(tài)方法塊、靜態(tài)屬性。
Class.forName("com.mysql.jdbc.Driver");

// 創(chuàng)建數(shù)據(jù)庫連接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?
user=root&password=root&useUnicode=true&characterEncoding=UTF-8");

//3.構(gòu)造一個Sql
 String sql =" insert into stu(id,name,age) values(1,zhang,3)";

//需要把 Sql語句轉(zhuǎn)化為對象
 PreparedStatement statement = connection.prepareStatement(sql);

// 查詢操作
preparedStatement.executeQuery();

// 新增、修改、刪除操作
preparedStatement.executeUpdate();

    //接受結(jié)果集合         
     ResultSet resultSet = statement.executeQuery();
        //結(jié)果集遍歷
        while (resultSet.next()){
            //移動光標(biāo)
            int id = resultSet.getInt("id");
            String name = resultSet.getString("name");
            int age = resultSet.getInt("age");
            System.out.println(id+" "+name+" "+age+" ");
        }

try {
    if(resultSet != null){
        resultSet.close();
   }
    if(preparedStatement != null){
        preparedStatement.close();
   }
    if(connection != null){
        connection.close();
   }
} catch (SQLException e) {
    e.printStackTrace();
    throw new RuntimeException("數(shù)據(jù)庫錯誤");
}

    // 加載JDBC驅(qū)動程序
Class.forName("com.mysql.jdbc.Driver");
// 創(chuàng)建數(shù)據(jù)庫連接
Connection connection = DriverManager.getConnection(url);

 DataSource dataSource = new MysqlDataSource();
        ((MysqlDataSource)dataSource).setUrl("jdbc:mysql://localhost:3306/db1?serverTimezone=UTC");
        ((MysqlDataSource)dataSource).setUser("root");
        ((MysqlDataSource)dataSource).setPassword("123456");

import com.mysql.cj.jdbc.MysqlDataSource;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class TestJDBC {
    public static void main(String[] args) throws SQLException {
        // MysqlDataSource dataSource = new MysqlDataSource();
        //dataSource.setUrl();
        //1. 創(chuàng)建數(shù)據(jù)源，即獲取數(shù)據(jù)庫的位置
        DataSource dataSource = new MysqlDataSource();
        ((MysqlDataSource) dataSource).setUrl("jdbc:mysql://localhost:3306/db1?serverTimezone=UTC");
        ((MysqlDataSource)dataSource).setUser("root");
        ((MysqlDataSource)dataSource).setPassword("123456");

        // 2 .和數(shù)據(jù)庫服務(wù)器建立連接
        Connection connection = dataSource.getConnection();

        //3.構(gòu)造一個Sql
        String sql =" insert into stu(id,name,age) values(?,?,?)";
      //  String sql =" insert into stu(id,name,age) values(1,zhang,3)";
        //需要把 Sql語句轉(zhuǎn)化為對象
        PreparedStatement statement = connection.prepareStatement(sql);

        statement.setInt(1,66);
        statement.setString(2,"a");
        statement.setInt(3,7);
        //4.構(gòu)造好的sql 發(fā)送給服務(wù)器;
       int n = statement.executeUpdate();
        System.out.println("n:"+ n);

        //5.最后一步 釋放資源
        statement.close();
        connection.close();
    }
}