session_flush

session flush测试：

session flush方法主要做了两件事：
* 清理缓存
* 执行sql

session在什么情况下执行flush
* 默认在事务提交时
* 显示的调用flush
* 在执行查询前，如：iterate

hibernate按照save(insert),update、delete顺序提交相关操作

import java.util.Date;

public class User1 {

	private String id;

	private String name;

	private String password;

	private Date createTime;

	private Date expireTime;

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public Date getExpireTime() {
		return expireTime;
	}

	public void setExpireTime(Date expireTime) {
		this.expireTime = expireTime;
	}
}


import java.util.Date;

public class User2 {

	private int id;

	private String name;

	private String password;

	private Date createTime;

	private Date expireTime;

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public Date getExpireTime() {
		return expireTime;
	}

	public void setExpireTime(Date expireTime) {
		this.expireTime = expireTime;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}
}


import java.util.Date;

public class User3 {

	private String id;

	private String name;

	private String password;

	private Date createTime;

	private Date expireTime;

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public Date getExpireTime() {
		return expireTime;
	}

	public void setExpireTime(Date expireTime) {
		this.expireTime = expireTime;
	}
}

//User1.hbm.xml
<hibernate-mapping package="com.bjsxt.hibernate">
	<class name="User1" table="t_user1">
		<id name="id" column="user_id" length="32">
			<generator class="uuid"/>
		</id>
		<property name="name" unique="true" not-null="true" length="10"/>
		<property name="password" not-null="true" length="10"/>
		<property name="createTime" column="create_time"/>
		<property name="expireTime" column="expire_time"/>
	</class>
</hibernate-mapping>


//User2.hbm.xml
<hibernate-mapping package="com.bjsxt.hibernate">
	<class name="User2" table="t_user2">
		<id name="id" column="user_id">
			<generator class="native"/>
		</id>
		<property name="name" unique="true" not-null="true" length="20"/>
		<property name="password" not-null="true" length="10"/>
		<property name="createTime" column="createtime"/>
		<property name="expireTime" column="expiretime"/>
	</class>
</hibernate-mapping>


//User3.hbm.xml
<hibernate-mapping package="com.bjsxt.hibernate">
	<class name="User3" table="t_user3">
		<id name="id" column="user_id" length="10">
			<generator class="assigned"/>
		</id>
		<property name="name" length="10"/>
		<property name="password" length="10"/>
		<property name="createTime" column="create_time"/>
		<property name="expireTime" column="expire_time"/>
	</class>
</hibernate-mapping>

import java.util.Date;

import org.hibernate.Session;
import org.hibernate.Transaction;

import junit.framework.TestCase;

public class SessionFlushTest extends TestCase {

	/**
	 * 测试uuid主键生成策略
	 */
	public void testSave1() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User1 user = new User1();
			user.setName("李四");
			user.setPassword("123");
			user.setCreateTime(new Date());
			user.setExpireTime(new Date());

			//因为user的主键生成侧路采用的是uuid，所以调用完成save后，只是将user纳入到了session的管理
			//不会发出insert语句，但是id已经生成，session中existsInDatebase状态为false
			session.save(user);

			//幻读——第一次查10-20岁的记录为10，然后再查一次为20
			//调用flush，hibernate会清理缓存，执行sql
			//如果数据库的隔离级别(未提交读、提交读、重复读、序列化)设置为为提交读，那么我们可以看到flush过的数据
			//并且session中existsInDatebase状态为true
			session.flush();  //flush在commit时默认隐含调用

			//提交事务
			//默认情况下commit操作会先执行flush清理缓存，所以不用显示的调用flush
			//commit后数据是无法回滚的
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 测试native主键生成策略
	 */
	public void testSave2() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User2 user = new User2();
			user.setName("张三1");
			user.setPassword("123");
			user.setCreateTime(new Date());
			user.setExpireTime(new Date());

			//因为user的主键生成策略为native,所以调用session.save后，将执行insert语句，返回有数据库生成的id
			//纳入了session的管理，修改了session中existsInDatebase状态为true
			//如果数据库的隔离级别设置为为提交读，那么我们可以看到save过的数据
			session.save(user);
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}


	/**
	 * 测试uuid主键生成策略
	 */
	public void testSave3() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User1 user = new User1();
			user.setName("王五");
			user.setPassword("123");
			user.setCreateTime(new Date());
			user.setExpireTime(new Date());

			//因为user的主键生成侧路采用的是uuid，所以调用完成save后，只是将user纳入到了session的管理
			//不会发出insert语句，但是id已经生成，session中existsInDatebase状态为false
			session.save(user);

			//将user对象从session中逐出，即session的EntityEntries属性中逐出
			session.evict(user);

			//无法成功提交，因为hibernate在清理缓存时，在session的insertions集合中取出user对象进行insert操作后
			//需要更新entityEntries属性中的existsInDatabase为true，而我们采用evict已经将user从session的entityEntries
			//中逐出了，所以找不到相关数据，无法更新，抛出异常
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 测试uuid主键生成策略
	 */
	public void testSave4() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User1 user = new User1();
			user.setName("王五");
			user.setPassword("123");
			user.setCreateTime(new Date());
			user.setExpireTime(new Date());

			//因为user的主键生成侧路采用的是uuid，所以调用完成save后，只是将user纳入到了session的管理
			//不会发出insert语句，但是id已经生成，session中existsInDatebase状态为false
			session.save(user);

			//flush后hibernate会清理缓存，会将user对象保存到数据库中，将session中的insertions(临时集合)中的user对象
			//清除，并且设置session中existsInDatebase的状态为true
			session.flush();

			//将user对象从session中逐出，即session的EntityEntries属性中逐出
			session.evict(user);

			//可以成功提交，因为hibernate在清理缓存时，在session的insertions集合中无法找到user对象
			//所以就不会发出insert语句，也不会更新session中的existsInDatabase的状态
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 测试native主键生成策略
	 */
	public void testSave5() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User2 user = new User2();
			user.setName("张三11");
			user.setPassword("123");
			user.setCreateTime(new Date());
			user.setExpireTime(new Date());

			//因为user的主键生成策略为native,所以调用session.save后，将执行insert语句，返回有数据库生成的id
			//纳入了session的管理，修改了session中existsInDatebase状态为true
			//如果数据库的隔离级别设置为为提交读，那么我们可以看到save过的数据
			session.save(user);

			//flush后hibernate会清理缓存，会将user对象保存到数据库中，将session中的insertions(临时集合)中的user对象
			//清除，并且设置session中existsInDatebase的状态为true
			session.flush();

			//将user对象从session中逐出，即session的EntityEntries属性中逐出
			session.evict(user);

			//可以成功提交，因为hibernate在清理缓存时，在session的insertions集合中无法找到user对象
			//所以就不会发出insert语句，也不会更新session中的existsInDatabase的状态
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}

	/**
	 * 测试assigned主键生成策略
	 * 
	 */
	public void testSave6() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User3 user = new User3();
			user.setId("001");
			user.setName("张三");

			session.save(user);

			user.setName("王五");
			session.update(user);

			User3 user3 = new User3();
			user3.setId("002");
			user3.setName("李四");
			session.save(user3);

			//Hibernate: insert into t_user3 (name, password, create_time, expire_time, user_id) values (?, ?, ?, ?, ?)
			//Hibernate: insert into t_user3 (name, password, create_time, expire_time, user_id) values (?, ?, ?, ?, ?)
			//Hibernate: update t_user3 set name=?, password=?, create_time=?, expire_time=? where user_id=?
			//hibernate按照save(insert),update、delete顺序提交相关操作
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}	

	/**
	 * 测试assigned主键生成策略
	 * 
	 */
	public void testSave7() {
		Session session = null;
		Transaction tx = null;
		try {
			session = HibernateUtils.getSession();
			tx = session.beginTransaction();

			User3 user = new User3();
			user.setId("003");
			user.setName("张三");

			session.save(user);

			user.setName("王五");
			session.update(user);

			//flush后hibernate会清理缓存，会将user对象保存到数据库中，将session中的insertions(临时集合)中的user对象
			//清除，并且设置session中existsInDatebase的状态为true
			session.flush();

			User3 user3 = new User3();
			user3.setId("004");
			user3.setName("李四");
			session.save(user3);

			//Hibernate: insert into t_user3 (name, password, create_time, expire_time, user_id) values (?, ?, ?, ?, ?)
			//Hibernate: update t_user3 set name=?, password=?, create_time=?, expire_time=? where user_id=?
			//Hibernate: insert into t_user3 (name, password, create_time, expire_time, user_id) values (?, ?, ?, ?, ?)
			//因为我们在session.udpate(user)后执行了flush，所以在清理缓存时执行flush前的sql不会生成
			//sql会按照我们的意愿执行
			tx.commit();
		}catch(Exception e) {
			e.printStackTrace();
			tx.rollback();
		}finally {
			HibernateUtils.closeSession(session);
		}
	}		
}