public class JdbcTest3 {
public static void main(String[] args) {
String url = "jdbc:mysql://47.105.167.226:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username = "root";
String password = "Wjj811971...";
Connection connection = null;
// 加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
// 连接数据库
connection = DriverManager.getConnection(url, username, password);
// 通知数据库开启事务
connection.setAutoCommit(false);
String sql1 = "update account set money = money + 100 where name ='王进京';";
connection.prepareStatement(sql1).executeUpdate();
String sql2 = "update account set money = money + 100 where name ='王进京';";
connection.prepareStatement(sql2).executeUpdate();
// 以上两条sql都执行成功了,才提交事务
connection.commit();
System.out.println("执行成功...");
} catch (Exception e) {
try {
// 如果出现异常,就通知数据库回滚事务
connection.rollback();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
e.printStackTrace();
} finally {
// 关闭连接
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
Jdbc事务的简单使用
最新推荐文章于 2021-01-01 22:24:49 发布