public static int update(Connection conn,String sql,Object...args){
PreparedStatement ps=null;
try {
ps=conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i + 1, args[i]);
}
return ps.executeUpdate();
}catch (Exception e){
e.printStackTrace();
}finally {
JDBCUtils.closeResource(null,ps,null);
}
return 0;
}
public void test13(){
Connection conn=null;
try{
conn=JDBCUtils.getConnection();
conn.setAutoCommit(false);
String sql_1="update user_table set balance=balance-100 where user=?";
SQLTools.update(conn,sql_1,"zhang2");
String sql_2="update user_table set balance=balance+100 where user=?";
SQLTools.update(conn,sql_2,"zhang1");
System.out.print("转账成功!");
conn.commit();
}catch (Exception e){
System.out.println("转账失败。。。");
try{
}catch (Exception e1){
e1.printStackTrace();
}
}finally {
JDBCUtils.closeResource(conn,null,null);
}
}