package erchou;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Demo1 {
public static void main(String[] args) {
Connection connection = null;
PreparedStatement statement = null;
try{
connection = JdbcUtil.getConnection();
connection.setAutoCommit(false);
String sql1 = "UPDATE account SET money=money-1000 WHERE acountName = '张三'";
String sql2 = "UPDATE account SET money=money+1000 WHERE acountName = '李四'";
statement = connection.prepareStatement(sql1);
statement.executeUpdate();
statement = connection.prepareStatement(sql2);
statement.executeUpdate();
}catch(Exception e){
try {
connection.rollback();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
connection.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JdbcUtil.close(connection, statement);
}
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Demo1 {
public static void main(String[] args) {
Connection connection = null;
PreparedStatement statement = null;
try{
connection = JdbcUtil.getConnection();
connection.setAutoCommit(false);
String sql1 = "UPDATE account SET money=money-1000 WHERE acountName = '张三'";
String sql2 = "UPDATE account SET money=money+1000 WHERE acountName = '李四'";
statement = connection.prepareStatement(sql1);
statement.executeUpdate();
statement = connection.prepareStatement(sql2);
statement.executeUpdate();
}catch(Exception e){
try {
connection.rollback();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
connection.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JdbcUtil.close(connection, statement);
}
}
}