数据库事务

最新推荐文章于 2016-11-09 23:29:47 发布

yjz764297625

最新推荐文章于 2016-11-09 23:29:47 发布

阅读量49

点赞数

分类专栏： java MySQL 文章标签：数据库 java

本文链接：https://blog.csdn.net/yjz764297625/article/details/88347692

版权

java 同时被 2 个专栏收录

155 篇文章 0 订阅

订阅专栏

MySQL

32 篇文章 0 订阅

订阅专栏


package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Savepoint;
import java.sql.Statement;

public class TestTransaction {

	public static void main(String[] args) throws SQLException {

		Connection conn = null;
		Statement stmt = null;
		Savepoint sp = null;
		try{
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/for117", "root", "admin");
			conn.setAutoCommit(false);
			stmt = conn.createStatement();
			stmt.executeUpdate("update  tb_test set number = number*2 where id = 1");
			sp =  conn.setSavepoint();
			stmt.executeUpdate("update  tb_test set number = number*2 where id = 2");
			int i = 34;
			int b = i*2;
			if(b>3){
				throw new Exception();
			}
			stmt.executeUpdate("update  tb_test set number = number*2 where id = 3");
			conn.commit();
		}catch (Exception e) {
		  conn.rollback(sp);
		  conn.commit();
		}
	}
}