Hibernate基于timestamp的乐观锁

比眉伴天荒 2022-05-23 00:47 150阅读 0赞

##### 数据表 #####

![20180530091601784][]

##### 创建实体类 #####

package com.dwx.models;
    import java.util.Date;
    public class Accounts {
    	private int id;
    	private String username;
    	private double money;
    	private Date lastUpdate;
    	public Date getLastUpdate() {
    		return lastUpdate;
    	}
    	public void setLastUpdate(Date lastUpdate) {
    		this.lastUpdate = lastUpdate;
    	}
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public String getUsername() {
    		return username;
    	}
    	public void setUsername(String username) {
    		this.username = username;
    	}
    	public double getMoney() {
    		return money;
    	}
    	public void setMoney(double money) {
    		this.money = money;
    	}
    }

##### 配置映射 #####

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    <hibernate-mapping>
    	<class name="com.dwx.models.Accounts" table="accounts">
    		<id name="id">
    			<generator class="native"></generator>
    		</id>
    		<timestamp name="lastUpdate" column="last_update"></timestamp>
    		<property name="username"></property>	
    		<property name="money"></property>		
    	</class>
    </hibernate-mapping>

##### 添加记录 #####

session=HibernateSessionFactory.getSession();
    			tx=session.beginTransaction();
    			Accounts a=new Accounts();
    			a.setUsername("白雪");
    			a.setMoney(100);
    			session.save(a);
    			tx.commit();

##### 查看数据表 #####

![20180530092125904][]

##### 修改记录 #####

session=HibernateSessionFactory.getSession();
    			tx=session.beginTransaction();
    			Accounts a=(Accounts)session.load(Accounts.class, 3);
    			a.setMoney(500);
    			session.update(a);
    			tx.commit();

##### 再次查看数据表 #####

![20180530092233342][]

[20180530091601784]: /images/20220523/4c452ba558394f909bde197d14b1b8a3.png
[20180530092125904]: /images/20220523/08e61e717d164d0b8cdf0ddbc92193d0.png
[20180530092233342]: /images/20220523/af08d4e2e16c47cd80f2066af7a26c2d.png