VIP31/JDBC/src/main/java/com/lc/jdbc/TestJdbc2.java

package com.lc.jdbc;

import org.junit.Test;

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

/**
 * ClassName: TestJdbc
 *
 * @Author 爱扣钉-陈晨
 * @Create 2024/1/25 10:27
 * @Version 1.0
 */
public class TestJdbc2 {

     @Test
     public void test01() throws Exception {
         //加载驱动
         Class.forName("com.mysql.cj.jdbc.Driver");
         //建立连接
         String user = "root";
         String pass = "123456";
         String url = "jdbc:mysql://127.0.0.1:3306/db2?useSSL=false";
         //连接
         Connection connection = DriverManager.getConnection(url, user, pass);

         //sql预编译执行对象。
         //connection.prepareStatement()

         //开启事务
         //connection.setAutoCommit(false);
         //提交
         //connection.commit();
         //回滚
         //connection.rollback();

         Statement statement = connection.createStatement();


         ResultSet resultSet = statement.executeQuery("");


         boolean next = resultSet.next();




     }
}