public class BaseDao {
Connection con ;
PreparedStatement pt ;
public void transfer(int eid1,int eid2, double amount){
int result1 = 0;
int result2 = 0;
String sql1 = "update employee set money = money - ? where eid = ?";
String sql2 = "update employee set money = money + ? where eid = ?";
try {
con = MyConnection.getCon();
con.setAutoCommit(false);
pt = con.prepareStatement(sql1);
pt.setDouble(1, amount);
pt.setInt(2, eid1);
result1 = pt.executeUpdate();
if(result1 != 1){
con.rollback();
System.err.println("没有"+eid1+"这个id");
return;
}
System.out.println(result1);
pt = con.prepareStatement(sql2);
pt.setDouble(1, amount);
pt.setInt(2, eid2);
System.out.println(result2);
result2 = pt.executeUpdate();
if(result2 != 1){
con.rollback();
System.err.println("没有"+eid2+"这个id");
return;
}
con.commit();
} catch (Exception e) {
try {
con.rollback();
} catch (SQLException e1) {
System.out.println("回滚事务异常!");
throw new RuntimeException(e);
}
System.out.println("数据库访问异常!");
throw new RuntimeException(e);
}finally{
try {
if(pt!=null){
pt.close();
}
if(con!=null){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}