java 数据库操作,事务回滚
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*java 事务回滚操作
*
**/
public class TestTransaction {
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
PreparedStatement ps = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mydb", "root", "root");
System.out.println("数据库已连接!");
stmt = con.createStatement();
修改默认的自动提交数据,执行多条数据
con.setAutoCommit(false);
stmt.addBatch