jdbc打开mysql 批处理_JDBC批处理与事务处理

利用事务处理批量提交：

package com.gwolf.crud.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.util.Arrays;

public class TestJDBC {

public static void main(String[] args) throws Exception{

Class.forName("com.mysql.jdbc.Driver");

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/ssm_crud", "root", "root");

Statement stmt = connection.createStatement();

connection.setAutoCommit(false);

try {

stmt.addBatch("insert into tbl_emp(emp_name) values('测试1')");

stmt.addBatch("insert into tbl_emp(emp_name) values('测试2')");

stmt.addBatch("insert into tbl_emp(emp_name) values('测试3')");

int result[] = stmt.executeBatch();

System.out.println(Arrays.toString(result));

connection.commit();

}catch(Exception e) {

e.printStackTrace();

connection.rollback();

}

connection.close();

}

}