Hibernate OID、导航图、HQL、SQL、QBC查询方式示例

Hibernate OID、导航图、HQL、SQL、QBC查询方法示例

本案例使用的hibernate版本为  hibernate-release-5.2.10.Final 

为了测试，本案例在mysql数据库中创建了一个db数据库。

示例描述一个案例，在网上购物系统中一个用户可以有多个订单，所以用户和订单属于一对多关系，在cn.sz.pojo包下面是他们的实体并用注解进行了映射配置。cn.sz.pojo包下面的User.java和User.hbm.xml用于HQL查询时利用查询名称实现查询时使用。

创建一个java项目：项目的结构如下：（lib文件夹用于存放jar包）

lib目录下则是hibernate5需要的jar包（注需要将jar加载到项目中：选中jar包右键 --》BuildPath--》Add to Build Path）

log4j.properties为日志配置文件（需要加载配置junit），此项目可以不需要日志，使用日志只是为了观察方便。
注：junit配置可以参考 http://blog.csdn.net/benxiaohai888/article/details/78231911

由于在主配置文件配置了字段创建数据表的配置，所以第一次加载时就会自动创建数据表

配置的代码：

<!-- 自动生成数据表（数据表的生成方式） -->
<property name="hbm2ddl.auto">update</property>

接下来是示例代码：

1、主配置文件 hibernate.cfg.xml copy

<?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><session-factory><!--配置一：数据库连接信息 --><!-- 数据库驱动 --><property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property><!-- 数据库URL --><property name="hibernate.connection.url">jdbc:mysql://localhost:3306/db?characterEncoding=utf8</property><!--数据库用户名， --><property name="hibernate.connection.username">root</property><!--数据库密码 --><property name="hibernate.connection.password"></property><!--配置二:数据库方言配置，配置数据库方言的作用是屏蔽数据库的差异，换句话说是使hibernate框架知道 要与哪种数据库取得联系 --><property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property><!-- <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> --><!--配置三：其它配置 （这些配置可选） --><!-- 是否在控制台显示sql语句 --><property name="hibernate.show_sql">true</property><!--是否格式化删除sql语句 --><property name="hibernate.format_sql">true</property><!-- 自动生成数据表（数据表的生成方式） --><property name="hbm2ddl.auto">update</property><!-- 将session绑定到当前线程 --><property name="hibernate.current_session_context_class">thread</property><!-- 设置事务的隔离级别 --><property name="hibernate.connection.isolation">4</property><!-- 配置四：映射配置 --><!-- 基于注解的配置方式 --><mapping class="cn.sz.pojo.User" /><mapping class="cn.sz.pojo.Orders" /><!--<mapping resource="cn/sz/vo/User.hbm.xml" />--></session-factory></hibernate-configuration>

2、工具类（获取Session）HibernateUtil.java

[java] view plain copy

1. package cn.sz.utils;  
2.   
3. import org.hibernate.Session;  
4. import org.hibernate.SessionFactory;  
5. import org.hibernate.cfg.Configuration;  
6.   
7. public class HibernateUtil {  
8.     public static Session getSession() {  
9.         Session session = null;  
10.         // 创建一个读取主配置文件的对象  
11.         Configuration cfg = new Configuration();  
12.         // 读取主配置文件  
13.         cfg.configure();  
14.         // 创建Session工厂  
15.         SessionFactory factory = cfg.buildSessionFactory();  
16.         // 打开Session  
17.         // session = factory.openSession();  
18.         // 如果在主配置文件将session绑定到线程中，所以可以从线程中取出session  
19.         session = factory.getCurrentSession();  
20.         return session;  
21.     }  
22. }  

3、日志文件 log4j.properties

[plain] view plain copy

1. log4j.rootLogger=DEBUG,console,FILE  
2. log4j.appender.console=org.apache.log4j.ConsoleAppender  
3. log4j.appender.console.threshold=INFO  
4. log4j.appender.console.layout=org.apache.log4j.PatternLayout  
5. log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} [%5p] - %c -%F(%L) -%m%n  
6. log4j.appender.FILE=org.apache.log4j.RollingFileAppender  
7. log4j.appender.FILE.maxBackupIndex=100  
8. ##log4j.appender.FILE=org.apache.log4j.DailyRollingFileAppender   
9. log4j.appender.FILE.Append=true  
10. log4j.appender.FILE.File=c:/error1.log  
11. log4j.appender.FILE.Threshold=INFO  
12. log4j.appender.FILE.layout=org.apache.log4j.PatternLayout  
13. log4j.appender.FILE.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} [%5p] - %c -%F(%L) -%m%n  
14. log4j.appender.FILE.MaxFileSize=1MB  

4、实体类User.java(sn.sz.pojo包下面)

package cn.sz.pojo;import java.util.Date;import java.util.Set;import javax.persistence.CascadeType;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.OneToMany;import javax.persistence.Table;@Entity@Table(name = "h_user")public class User {// 基于外键的方式时，使用的配置(一对一关系)@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Integer userId;private String userName;private Date birthday;// 一对多关系(用户和订单),添加cascade配置并不能实现一的一方维护关系@OneToMany(targetEntity = Orders.class, mappedBy = "user", cascade = CascadeType.ALL)private Set<Orders> orderss;public User() {}public User(String userName, Date birthday) {this.userName = userName;this.birthday = birthday;}public Integer getUserId() {return userId;}public void setUserId(Integer userId) {this.userId = userId;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public Set<Orders> getOrderss() {return orderss;}public void setOrderss(Set<Orders> orderss) {this.orderss = orderss;}@Overridepublic String toString() {return "User [userId=" + userId + ", userName=" + userName + ", birthday=" + birthday + "]";}}

5、实体类 Orders.java

package cn.sz.pojo;import javax.persistence.Basic;import javax.persistence.CascadeType;import javax.persistence.Entity;import javax.persistence.FetchType;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.JoinColumn;import javax.persistence.ManyToOne;import javax.persistence.Table;@Entity@Table(name = "h_orders")public class Orders {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Integer ordersId;private String ordersName;// 一对多关系(用户和订单)@ManyToOne(cascade = CascadeType.ALL)@JoinColumn(name = "userId")@Basic(fetch = FetchType.LAZY) //// 添加此项配置并不能实现一的一方维护关系private User user;public Integer getOrdersId() {return ordersId;}public void setOrdersId(Integer ordersId) {this.ordersId = ordersId;}public String getOrdersName() {return ordersName;}public void setOrdersName(String ordersName) {this.ordersName = ordersName;}public User getUser() {return user;}public void setUser(User user) {this.user = user;}@Overridepublic String toString() {return "Orders [ordersId=" + ordersId + ", ordersName=" + ordersName + "]";}}

6、实体类User.java(sn.sz.vo下面)

package cn.sz.vo;import java.util.Date;public class User {private Integer userId;private String userName;private Date birthday;public Integer getUserId() {return userId;}public void setUserId(Integer userId) {this.userId = userId;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}}

7、映射文件 User.hbm.xml

<?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"><!-- package为实体类所在的包 --><hibernate-mapping package="cn.sz.vo"><!-- 实体类和哪个表对应 ;table用于配置实体类和表的对应；name用于配置哪个实体类和表对应 --><class table="h_user" name="User"><!-- id用于配置主属性和主键字段对应；id的name用于配置属性名 ，column为对应字段名 --><id name="userId"><!-- 主键生成策略 --><generator class="native"></generator></id><!-- property用于配置普通属性和字段的对应 --><property name="userName" type="string" length="30"></property><property name="birthday" type="date"></property></class><query name="queryUser"><![CDATA[select u.userId,u.userName from User u where u.userId<2]]></query><query name="queryUser2"><![CDATA[select u.userId,u.userName from User u where u.userName like '%李%']]></query></hibernate-mapping>

测试类：

OID查询、导航图查询、HQL、测试类：

package cn.sz.test;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Arrays;import java.util.Date;import java.util.List;import java.util.Set;import org.hibernate.Session;import org.hibernate.query.Query;import org.junit.Test;import com.mysql.fabric.xmlrpc.base.Array;import cn.sz.pojo.Orders;import cn.sz.pojo.User;import cn.sz.utils.HibernateUtil;public class QueryTest {@Test// 添加测试数据public void testSave() {Session session = HibernateUtil.getSession();session.beginTransaction();// 创建一个用户User u = new User();u.setUserName("张三");u.setBirthday(new Date());Orders orders1 = new Orders();orders1.setOrdersName("衣服");orders1.setUser(u);Orders orders2 = new Orders();orders2.setOrdersName("武器");orders2.setUser(u);// 继续创建一个用户User u2 = new User();u2.setUserName("李四");u2.setBirthday(new Date());Orders orders3 = new Orders();orders3.setOrdersName("水果");orders3.setUser(u2);Orders orders4 = new Orders();orders4.setOrdersName("鞋子");orders4.setUser(u2);// 继续创建一个用户User u3 = new User();u3.setUserName("王五");u3.setBirthday(new Date());Orders orders5 = new Orders();orders5.setOrdersName("水果");orders5.setUser(u3);session.save(orders1);session.save(orders2);session.save(orders3);session.save(orders4);session.save(orders5);session.save(u);session.save(u2);session.save(u3);session.getTransaction().commit();session.close();}@Test// OID查询方式 get()方法和load() 方法public void testOIDQuery() {Session session = HibernateUtil.getSession();session.beginTransaction();User u1 = session.get(User.class, 1);System.out.println(u1.toString());User u2 = session.load(User.class, 1);System.out.println(u2.toString());Set<Orders> orderss = u2.getOrderss();// 导航图查询方式for (Orders orders : orderss) {System.out.println(orders.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery1() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL 查询user表的所有记录String hql = "FROM User u";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery2() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL 查询user表的编号大于1的记录String hql = "FROM User u WHERE u.userId > 1";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery3() {Session session = HibernateUtil.getSession();session.beginTransaction();String c = "李";// HQL 查询user表的姓名中有李记录String hql = "FROM User u WHERE u.userName like '%" + c + "%'";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery4() {Session session = HibernateUtil.getSession();session.beginTransaction();String c = "李";// HQL 查询user表的id为1的记录（只有一个）String hql = "FROM User u WHERE u.userId=1";Query query = session.createQuery(hql);Object result = query.uniqueResult();System.out.println(result);session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery5() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL 查询user表的id为1在1-2范围，姓名为李四的记录String hql = "FROM User u WHERE u.userId in(1,2) AND u.userName='李四'";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery6() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL 查询user表的所有记录，按姓名降序排序String hql = "FROM User u ORDER BY u.userName DESC";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery7() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL 统计user表的记录总数String hql = "SELECT COUNT(*) FROM User u";Query query = session.createQuery(hql);Object result = query.uniqueResult();System.out.println(result.toString());session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery8() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询不同用户的订单数目String hql = "SELECT COUNT(*) FROM Orders o GROUP BY o.user";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery9() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--查询user的姓名String hql = "SELECT u.userName FROM User u";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o.toString());}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery10() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--查询user的姓名和生日String hql = "SELECT u.userName,u.birthday FROM User u";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery11() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--查询user的姓名和生日String hql = "SELECT new User(u.userName,u.birthday) FROM User u";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {System.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery12() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--查询user的姓名和生日,实现分页String hql = "SELECT new User(u.userName,u.birthday) FROM User u";Query query = session.createQuery(hql);// 设置分页query.setFirstResult(0);query.setMaxResults(2);List list = query.list();for (Object o : list) {System.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery13() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用占位符的方案(占位符从0开始)String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userName=?";Query query = session.createQuery(hql);query.setParameter(0, "李四");List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery14() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用占位符的方案(占位符从0开始)String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userName like ?";Query query = session.createQuery(hql);// query.setParameter(0, "%李%");String c = "李";query.setParameter(0, "%" + c + "%");List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery15() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用占位符的方案(占位符从0开始)String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userId IN(?,?)";Query query = session.createQuery(hql);query.setParameter(0, 1);query.setParameter(1, 2);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery16() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用查询变量方案String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userName=:name";Query query = session.createQuery(hql);query.setParameter("name", "王五");List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery17() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用查询变量方案String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userId BETWEEN :start AND :end";Query query = session.createQuery(hql);query.setParameter("start", 1);query.setParameter("end", 3);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery18() {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用查询变量方案String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userId BETWEEN :start AND :end";Query query = session.createQuery(hql);query.setParameter("start", 1);query.setParameter("end", 3);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery19() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用查询变量方案String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.birthday BETWEEN :start AND :end";Query query = session.createQuery(hql);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");Date d1 = sdf.parse("2017-10-23 0:0:0");Date d2 = sdf.parse("2017-10-25 0:0:0");query.setParameter("start", d1);query.setParameter("end", d2);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery20() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--设置查询条件，采用查询变量方案/* * 在HQL中，占位符的个数不能确定，换句话说假设从页面传入的同一个条件值， 在不同请求时所传值的个数不同，导致占位符的个数不能确定 */String hql = "SELECT u.userName,u.birthday FROM User u WHERE u.userId in(:ids)";Query query = session.createQuery(hql);query.setParameterList("ids", new Object[] { 1, 2 });List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式(连接查询)public void testHQlQuery21() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--连接查询String hql = "SELECT u.userName,u.birthday FROM User u,Orders o WHERE u.userId =o.user";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery22() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// HQL查询--连接查询// String hql = "SELECT u.userName,u.birthday,o.ordersId,o.ordersName// FROM User u JOIN Orders o// ON u.userId =o.user";// String hql = "SELECT u.userName,u.birthday,o.ordersId,o.ordersName// FROM Orders o JOIN o.user// u";String hql = "SELECT o.user.userName,o.user.birthday,o.ordersId,o.ordersName FROM Orders o";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery23() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// 连接查询---内连接查询，迫切内连接查询，fetch作用是实现迫切连接查询// 迫切查询和非迫切查询区别是非迫切的查询结果是数组形式，迫切查询结果是对象形式// String hql = "SELECT u.userId,u.userName,o.ordersId,o.ordersName FROM// User u INNER JOIN FETCH Orders o ON u.userId=o.user";String hql = "select u.userId,u.username,o.ordersId,o.ordersName from Orders o join fetch o.user u";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Test// HQL查询方式public void testHQlQuery24() throws ParseException {Session session = HibernateUtil.getSession();session.beginTransaction();// 连接查询---内连接查询，迫切内连接查询，fetch作用是实现迫切连接查询// 迫切查询和非迫切查询区别是非迫切的查询结果是数组形式，迫切查询结果是对象形式// 迫切查询只有迫切内连接查询和迫切左外连接查询// String hql = "SELECT u.userId,u.userName,o.ordersId,o.ordersName FROM// User u left fetch Orders o ON u.userId=o.user";String hql = "SELECT u.userId,u.username,o.ordersId,o.ordersName FROM User u right join Orders o on u.userId=o.user";Query query = session.createQuery(hql);List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Testpublic void test25() {Session session = HibernateUtil.getSession();session.beginTransaction();// 利用查询名称实现查询Query query = session.createNamedQuery("queryUser");List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}@Testpublic void test26() {Session session = HibernateUtil.getSession();session.beginTransaction();// 利用查询名称实现查询Query query = session.createNamedQuery("queryUser2");List list = query.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}}

QBC查询测试类：

package cn.sz.test;import java.util.Arrays;import java.util.List;import org.hibernate.Criteria;import org.hibernate.Session;import org.hibernate.criterion.DetachedCriteria;import org.hibernate.criterion.Restrictions;import org.junit.Test;import cn.sz.pojo.User;import cn.sz.utils.HibernateUtil;public class CriteriaTest {@Testpublic void test1() {Session session = HibernateUtil.getSession();session.beginTransaction();// 认识QBC查询Criteria criteria = session.createCriteria(User.class);List list = criteria.list();for (Object object : list) {System.out.println(object);}session.getTransaction().commit();session.close();}@Testpublic void test2() {Session session = HibernateUtil.getSession();session.beginTransaction();// 认识QBC查询--查询一个结果Criteria criteria = session.createCriteria(User.class);criteria.add(Restrictions.eqOrIsNull("userId", 1));Object o = criteria.uniqueResult();System.out.println(o);session.getTransaction().commit();session.close();}@Testpublic void test3() {Session session = HibernateUtil.getSession();session.beginTransaction();// 认识QBC查询--查询一个结果Criteria criteria = session.createCriteria(User.class);// 分页操作criteria.setFirstResult(0);criteria.setMaxResults(2);List list = criteria.list();for (Object object : list) {if (object.getClass().isArray())System.out.println(Arrays.toString((Object[]) object));elseSystem.out.println(object);}session.getTransaction().commit();session.close();}@Testpublic void test4() {Session session = HibernateUtil.getSession();session.beginTransaction();// 离线查询--创建一个离线查询对象DetachedCriteria dCriteria = DetachedCriteria.forClass(User.class);Criteria criteria = dCriteria.getExecutableCriteria(session);criteria.add(Restrictions.in("userId", 1, 2, 3));List list = criteria.list();for (Object object : list) {if (object.getClass().isArray())System.out.println(Arrays.toString((Object[]) object));elseSystem.out.println(object);}session.getTransaction().commit();session.close();}}

SQL查询测试类：

package cn.sz.test;import java.util.Arrays;import java.util.List;import org.hibernate.SQLQuery;import org.hibernate.Session;import org.hibernate.query.NativeQuery;import org.junit.Test;import cn.sz.utils.HibernateUtil;public class SQLTest {@Test@SuppressWarnings("rawtypes") // 去除警告提示public void test1() {Session session = HibernateUtil.getSession();session.beginTransaction();// 查询所有的用户String sql = "select * from h_user";SQLQuery query = session.createSQLQuery(sql);List list = query.list();for (Object o : list) {// 如果是数组则转换为字符串打印输出if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));else// 否则调用对象的toString() 方法打印输出System.out.println(o);}session.getTransaction().commit();session.close();}@Test@SuppressWarnings("rawtypes")public void test2() {Session session = HibernateUtil.getSession();session.beginTransaction();// 查询id为1的用户String sql = "select * from h_user where userid=1";SQLQuery sqlQuery = session.createSQLQuery(sql);// 结果为唯一值Object o = sqlQuery.uniqueResult();if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);session.getTransaction().commit();session.close();}@Test@SuppressWarnings("rawtypes")public void test3() {Session session = HibernateUtil.getSession();session.beginTransaction();// 分页查询String sql = "select * from h_user";SQLQuery sqlQuery = session.createSQLQuery(sql);// 设置查询起始位置sqlQuery.setFirstResult(0);// 设置查询记录数sqlQuery.setMaxResults(3);List<Object> list = sqlQuery.list();for (Object o : list) {if (o.getClass().isArray())System.out.println(Arrays.toString((Object[]) o));elseSystem.out.println(o);}session.getTransaction().commit();session.close();}}

注：我们在利用查询名称实现查询的时候需要使用cn.sz.vo下面的User实体类和User.hbmxml映射文件,还需要注释主配置中的下面代码，

<mapping class="cn.sz.pojo.User" />
<mapping class="cn.sz.pojo.Orders" /> 

并打开

<mapping resource="cn/sz/vo/User.hbm.xml" />