java 乐观锁 悲观所_JDBC悲观锁与乐观锁基础教程

import org.junit.Before;

import org.junit.Test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

/**

* @author Marco Behler

*/

public class OptimisticLockingExercise {

@Before

public void setUp() {

try (Connection connection = getConnection()) {

createTables(connection);

} catch (SQLException e) {

e.printStackTrace();

}

}

@Test(expected = OptimisticLockingException.class)

public void optimistic_locking_exercise() throws SQLException {

try (Connection connectionFromJackBauer = getConnection()) {

connectionFromJackBauer.setAutoCommit(false);

connectionFromJackBauer.createStatement().execute(

"insert into items " +

"(name, release_date, version) values " +

"('CTU Field Agent " +

"Report', current_date() - 100, 0)");

// 上面刚刚插入了错误的release_date. 让我们快速在更新一下

//release_date ，并增加版本号version number

int updatedRows = connectionFromJackBauer.createStatement()

.executeUpdate(

"update items set release_date = current_date(), " +

" version = version + 1 " +

"where name = 'CTU Field Agent Report'" +

" and version = 0");

System.out.println("Rows updated by Jack Bauer: " +

updatedRows);

connectionFromJackBauer.commit();

}

// 同时, habib marwin试图设置release_date为今天+10，但是他试图使用版本为0

//的记录进行这种更新

try (Connection connectionFromHabibMarwan = getConnection()) {

connectionFromHabibMarwan.setAutoCommit(false);

int updatedRows = connectionFromHabibMarwan.createStatement()

.executeUpdate(

"update items set release_date = current_date() + 10," +

"  version = version + 1" +

"where name = 'CTU Field Agent Report'" +

" and version = 0");

System.out.println("Rows updated by Habib Marwan: " +

updatedRows);

//这一行是很多Java框架进行乐观锁检测的方法，检测真正更新的记录数。

if (updatedRows == 0) throw new OptimisticLockingException();

}

}

// self made. check out the one from hibernate or spring

public static class OptimisticLockingException extends

RuntimeException {}

private Connection getConnection() throws SQLException {

return DriverManager.getConnection("jdbc:h2:mem:exercise_db;" +

"DB_CLOSE_DELAY=-1");

}

private void createTables(Connection conn) {

try {

conn.createStatement().execute("create table bids (id " +

"identity, user VARCHAR, time TIMESTAMP ," +

" amount NUMBER, currency VARCHAR) ");

conn.createStatement().execute("create table items (id " +

"identity, name VARCHAR, release_date date," +

" version NUMBER default " +

"0)");

} catch (SQLException e) {

e.printStackTrace();

}

}

}