Hibernate Transaction Criteria

Hibernate.zip下载地址
１．配置Hibernate
hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
	<!-- 配置连接信息 -->
	<!-- 
		#hibernate.dialect org.hibernate.dialect.MySQLDialect
		#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
		#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
		#hibernate.connection.driver_class com.mysql.jdbc.Driver
		#hibernate.connection.url jdbc:mysql:///test
		#hibernate.connection.username gavin
		#hibernate.connection.password
	
	 -->
	<session-factory>
		<!-- 必选的配置 -->
		<property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql:///hibernate01?serverTimezone=UTC</property>
		<property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">123456</property>
		<!-- 数据库方言  使用的数据库类型-->
		<property name="hibernate.dialect org.hibernate.dialect.MySQLDialect"></property>
		<!-- 可选的配置 -->
		<!-- 显示sql -->
		<property name="hibernate.show_sql">true</property>
		<!-- 格式化sql -->
		<property name="hibernate.format_sql">true</property>
		
		<!-- 使用数据库连接池 -->
		<!-- 不加不影响运行，加上可避免出现Hibernate :Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException -->
    
		<!-- C3p0 提供商 -->
		<property name="hibernate.connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider</property>
		<!-- 最小的连接 -->
		<property name="hibernate.c3p0.min_size">5</property>
		<!-- 最大的连接 -->
		<property name="hibernate.c3p0.max_size">10</property>
		<!-- 每120秒检查空闲的连接 -->
		<property name="hibernate.c3p0.timeout">120</property>
		
		<!-- 自动见表
		 hibernate.hbm2ddl.auto
			            create-drop 测试: 创建然后删除当前的数据库中的表
						create 测试创建 ,如果没有表会创建    
						update 测试更新 如果没有表会创建表,如果字段改变会更新操作.(常用)
						validate 测试验证 如果JavaBean 与数据表不一致那么会报错
		-->
		<property name="hibernate.hbm2ddl.auto">update</property>		
				
				
		<!-- 映射文件 -->
		
		<mapping resource="com/igeek/domain/Person.hbm.xml"/>
		
		
	</session-factory>
	


</hibernate-configuration>

javaBean 实体类

/**
 * 
 */
package com.igeek.domian;

/**
 * @author Administrator
 *
 */
public class Person {

	private int age;
	private int id;
	private String name;
	private String uuid;
	
	
	
	public String getUuid() {
		return uuid;
	}
	public void setUuid(String uuid) {
		this.uuid = uuid;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Override
	public String toString() {
		return "Person [age=" + age + ", id=" + id + ", name=" + name + "]";
	}
	
	
}

持久化类

<?xml version="1.0" encoding="UTF-8"?>
<!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.igeek.domian.Person" table="Person">
		<id name="id" column="id">
		<!-- Hibernate 框架
			 主键生成策略
 		    increment 在多线程情况下不能使用这种方式
			identity 主键由数据库产生，适用于mysql
			oracle 主键由数据库产生，适用于oracle
			uuid 产生32位随机数，String 类型，可以 在多线程情况下使用　自增长　id　uuid   column uuid
			assigned 唯一的自然主键生成方式,需要手动设置主键
			native  identity + sequence 根据不同的数据库产生不同主键
		 -->
		 
			<generator class="native"></generator>
		</id>
		<property name="uuid" column="uuid">
		</property>
		<property name="age" column="age"></property>
		<property name="name" column="name"></property>
		
	</class>
	


</hibernate-mapping>

工具类

/**
 * 
 */
package com.igeek.util;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;



/**
 * @author Administrator
 *
 */
public class HibernateUtils {

	//使用静态块创建SessionFactory
	private static  Configuration CONFIG;
	private static  SessionFactory FACTORY;
	
	static {
		CONFIG = new Configuration().configure();
		FACTORY = CONFIG.buildSessionFactory();
	}
	
	/***
	 * 从连接池中获取连接
	 * @return
	 */
	public static Session openSession()
	{
		return FACTORY.openSession();
	}
}

测试类

/**
 * 
 */
package com.igeek.test;

import java.util.UUID;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.igeek.domian.Person;
import com.igeek.util.HibernateUtils;

/**
 * @author Administrator
 *
 */
public class TestPerson {

	private Session session;
	private Transaction transation;
	
	@Before
	public void init()
	{
		session = HibernateUtils.openSession();
		transation = session.beginTransaction();
	}

	@Test
	public void save()
	{
		Person p = new Person();
		p.setName("王晓涵");
		p.setAge(21);
		//手动设置ID
		p.setUuid(UUID.randomUUID().toString());
		session.save(p);
		transation.commit();
	}
	
	
	@After
	public void destory()
	{
		session.close();
		
	}
	
}

使用事务操作数据

１.在hibernate.cfg.xml 中添加下面配置

	．．．．．
	<property name="hibernate.hbm2ddl.auto">update</property>
		<!-- 将session绑定到当前线程，使用getCurrentSession 获取当前线程 -->		
		<property name="hibernate.current_session_context_class">thread</property>		
		<!-- 映射文件 -->			
	 	<mapping resource="com/igeek/domian/Person.hbm.xml"/>
	 	<mapping resource="com/igeek/domian/User.hbm.xml"/>
	 ．．．．．

工具类添加下面代码（HibernateUtils.java ）

	
	public static Session getCurrentSession()
	{
		return FACTORY.getCurrentSession();
	}

实体类

/**
 * 
 */
package com.igeek.domian;

import java.io.Serializable;

/**
 * @author Administrator
 *
 */
@SuppressWarnings("serial")
public class User implements Serializable{

	//唯一标识OID
	private Integer id;
	private String name;
	//类型尽量使用封装类
	private Integer age;
	
	//提供getter 和setter 方法 
	
	
	/***
	 * 空的构造方法用于反射生成对象
	 */
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}

	public Integer getId() {
		return id;
	}

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

	public String getName() {
		return name;
	}

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

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	
	
}

持久化类

<?xml version="1.0" encoding="UTF-8"?>
<!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.igeek.domian.User" table="User">
		<id name="id" column="id">
			<generator class="native"></generator>
		</id>
	
	<property name="name" column="name"></property>
	<property name="age" column="age"></property>
	
	
	</class>

</hibernate-mapping>

数据层

/**
 * 
 */
package com.igeek.dao;

import org.hibernate.Session;

import com.igeek.domian.User;
import com.igeek.util.HibernateUtils;

/**
 * @author Administrator
 *
 */
public class UserDao {

	public void save(User u)
	{
		Session session = HibernateUtils.getCurrentSession();
		session.save(u);
		//不需要开启事务，事务在service层开启
	}
	
	public void saves(User u)
	{
		Session session = HibernateUtils.getCurrentSession();
		session.save(u);
		//不需要开启事务，事务在service层开启
	}
	
	
}

service层

/**
 * 
 */
package com.igeek.service;

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

import com.igeek.dao.UserDao;
import com.igeek.domian.User;
import com.igeek.util.HibernateUtils;

/**
 * @author Administrator
 *
 */
public class UserService {

	
	public void save(User u1,User u2)
	{
		//开启事务
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		try {
			UserDao dao = new UserDao();
			dao.save(u1);
			dao.saves(u2);
			//提交操作
			transaction.commit();
		}catch(Exception e)
		{
			e.printStackTrace();
			transaction.rollback();
		}
		finally {
			//强调，当前代码完成后，不需要手动关闭，当前线程结束，session会自动关闭
			//不需要手动关闭
			
		}
		
	}
	
}

测试类

/**
 * 
 */
package com.igeek.test;

import org.junit.Test;

import com.igeek.domian.User;
import com.igeek.service.UserService;

/**
 * @author Administrator
 *
 */
public class UserTest {

	@Test
	public void testUser()
	{
		User u1 = new User();
		User u2 = new User();
		u1.setName("张文");
		u2.setName("王蒙");
		UserService service = new UserService();
		service.save(u1, u2);
	}
	
}

Criteria 数据查询

相关代码如下：

/**
 * 
 */
package com.igeek.test;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;

import com.igeek.domian.User;
import com.igeek.service.UserService;
import com.igeek.util.HibernateUtils;

/**
 * @author Administrator
 *
 */
public class UserTest {

	@Test
	public void testUser()
	{
		User u1 = new User();
		User u2 = new User();
		u1.setName("张文");
		u2.setName("王蒙");
		UserService service = new UserService();
		service.save(u1, u2);
	}
	
	/***
	 * Criteria 查询
	 */
	@Test
	public void test01()
	{
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		Criteria c = session.createCriteria(User.class); // 创建Criteria 对象
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		transaction.commit();
		//session 不用关闭
	}
	
	/***
	 * Criteria 设置模糊查询
	 */
	@Test
	public void test02()
	{
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		//创建Criteria 对象
		Criteria c = session.createCriteria(User.class);
		//设置条件
		c.add(Restrictions.ilike("name", "%王%"));
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		transaction.commit();
		//session 不用关闭
	}
	
	
	/***
	 * and 多条件查询
	 */
	@Test
	public void test03()
	{
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		Criteria c = session.createCriteria(User.class);
		c.add(Restrictions.ilike("name", "%王%"));
		//当前的条件判断 大于GT  小于LT  等于EQ 
		c.add(Restrictions.gt("age", 18));
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		transaction.commit();
		//session不用关闭
	}
	
	
	/***
	 * or 多条件查询
	 *
	 */
	@Test
	public void test04()
	{
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		Criteria c = session.createCriteria(User.class);
		c.add(Restrictions.or(Restrictions.ilike("name", "%王%"),
				Restrictions.gt("age", 18)));;
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		transaction.commit();
		//session 不用关闭
	}
	
	/***
	 * between ... and 多条件查询
	 */
	@Test
	public void test05()
	{
		Session session = HibernateUtils.getCurrentSession();
		Transaction transaction = session.beginTransaction();
		Criteria c = session.createCriteria(User.class);
		//设置条件 年龄在20 ~ 30 之间
		c.add(Restrictions.between("age", 20, 30));
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		transaction.commit();
		
	}
	
	/***
	 * 分页查询
	 */
	@Test
	public void test06()
	{
		//创建Criteria
		Session session = HibernateUtils.getCurrentSession();
		Transaction transactin = session.beginTransaction();
		Criteria c = session.createCriteria(User.class);
		//参考mysql的分页 limit index size
		//index 从那一条记录开始
		//size 每页数据的条数
		c.setFirstResult(2);// 第三条索引
		c.setMaxResults(2);// 每页的数据
		List<User> users = c.list();
		for (User user : users) {
			System.out.println(user);
		}
		
		transactin.commit();
	}
	
	
}