说明

增加 连接数据库方法 connect，比原方法多一个参数：是否自动提交

注意：不在原方法增加参数，而是增加方法的原因是：不影响旧程序运行。

package top.malaoshi.jdbc;

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

public class ConnectionFactory {

    //连接数据库
    public static Connection connect(String driver,String url,String username,String password) throws ClassNotFoundException, SQLException {
        Class.forName(driver);
        Connection connection = DriverManager.getConnection(url, username, password);

        return connection;
    }


    //连接数据库，可以指定是否自动提交
    public static Connection connect(String driver,String url,String username,String password,boolean autoCommit) throws ClassNotFoundException, SQLException{
        Connection connection = connect(driver, url, username, password);
        //设置是否自动提交
        connection.setAutoCommit(autoCommit);
        return connection;
    }

}

测试

//===关键，设置不自动提交==============
Connection conn = ConnectionFactory.connect("com.mysql.jdbc.Driver" 
                , "jdbc:mysql://127.0.0.1:3308/scott?useSSL=false&useUnicode=true&characterEncoding=utf-8"
                ,"root"
                ,""
                ,false)

原文出处：/show_1IX6xhiHkZQw.html