String userName="root";
String password="123";
String url ="jdbc:mysql://192.168.0.107:3306/enterprise";
String sql_1="delete from emp where deptno=20";
String sql_2="delete from dept where deptno=20";
Connection con = null;
PreparedStatement car1,car2;
//创建连接通道
con = DriverManager.getConnection(url,userName,password);
//由连接通道向mysql服务器发送"start transaction"
//由连接通道向mysql服务器发送“start transaction”(默认值为ture 即每条statement都是直接提交没有将管道中所有的statement划分为一条事务)
con.setAutoCommit(false);
car1 = con.prepareStatement(sql_1);
car2 = con.prepareStatement(sql_2);
try {
car1.executeUpdate();
car2.executeUpdate();
con.commit();//提交事务
}catch (SQLException EX){
//由连接通道对象向mysql服务器发送"rollback" 若捕获异常则回滚
con.rollback();
}finally{//依次关闭小通道,总通道
if(car1!=null){
car1.close();
}
if(car2!=null){
car2.close();
}
if(con!=null){
con.close();
}
}
02-28
493
01-19
2693