使用dao处理事务

String sql1 = "DELETE FROM easybuy_order where eo_id = "+eoId;
String sql2 = "DELETE FROM easybuy_order_detail where eo_id = "+eoId;
int result = 0;
Connection con = DBUtil.getConnection();
Statement ps = null;
try{
//关闭自动事务提交
con.setAutoCommit(false);
//创建statement对象用来执行SQL语句
ps = con.createStatement();
//准备批量执行SQL语句
ps.addBatch(sql1);
ps.addBatch(sql2);
//执行SQL语句
ps.executeBatch();
//提交事务
con.commit();
result = 1;
}catch (SQLException e){
e.printStackTrace();
try{
con.rollback();
}catch(SQLException e1){
e1.printStackTrace();
}
}finally{
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return result;