JDBC事务,开发中掌握四个特性:原子性、一致性、隔离性、持久性。下面讲解一个简单的转账实例。
张三给李四转账500元,正常来说,张三剩下500元,李四1500元。简单的代码如下:
package com.lxz.operation_shiwu;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.lxz.utils.DbUtils;
public class Test_shiwu {
private static DbUtils dbUtil=new DbUtils();
/**
* 转出
* @param con
* @param accountName
* @param account
* @throws Exception
*/
private static void outCount(Connection con,String accountName,int account)throws Exception{
String sql="update t_account set accountBalance=accountBalance-? where accountName=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setInt(1, account);
pstmt.setString(2, accountName);
pstmt.executeUpdate();
}
/**
* 转入
* @param con
* @param accountName
* @param account
* @throws Exception
*/
private static void inCount(Connection con,String accountName,int account)throws Exception{
String sql="update t_account set account=accountBalance+? where accountName=?"; //异常sql
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setInt(1, account);
pstmt.setString(2, accountName);
pstmt.executeUpdate();
}
public static void main(String[] args) {
Connection con=null;
try {
con=dbUtil.getConnetction();
con.setAutoCommit(false); // 取消自动提交
System.out.println("张三开始向李四转账!");
int account=500;
outCount(con, "张三", account);
inCount(con, "李四", account);
System.out.println("转账成功!");
} catch (Exception e) {
try {
con.rollback(); // 回滚
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
con.commit(); // 提交事务
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
jdbc中添加事务,做下面几个操作:
①取消自动提交
②出现异常,事务回滚
③提交事务