java中criteria类_hibernate----(Hql)另一种查询---利用Criteria类

package com.etc.test;

import java.util.List;

import org.hibernate.Criteria;

import org.hibernate.Session;

import org.hibernate.criterion.DetachedCriteria;

import org.hibernate.criterion.Restrictions;

import com.etc.dao.HibernateSessionFactory;

import com.etc.entity.Person;

import com.etc.entity.Sex;

public class cri查询

{

static void 基础的cri查询()

{

//1 获取session连接

Session s = HibernateSessionFactory.getSession();

//2 获取Criteria对象(查询标准)

Criteria cri = s.createCriteria(Person.class);

//3 配置各种查询约束条件

//添加约束：pid等于1

cri.add(Restrictions.ge("pid", 2))

.add(Restrictions.like("pname", "老%"));

/*

Criteria cri2 = s.createCriteria(Sex.class);

cri2.add(Restrictions.sizeEq("persons", 3));

*/

//cri.add(Restrictions.or(Restrictions.ge("pid", 2), Restrictions.like("pname", "老%")));

//4 查询结果

/*

List list = cri2.list();

for(Sex sex:list)

{

System.out.println(sex);

}

*/

List list = cri.list();

for(Person p:list)

{

System.out.println(p);

}

//5 关闭

HibernateSessionFactory.closeSession();

}

static void cri关联条件查询()

{

//例子：找出性别含有”未知“关键字的所有人

//1 获取session连接

Session s = HibernateSessionFactory.getSession();

//2 获取Criteria对象(查询标准)

Criteria cri1 = s.createCriteria(Person.class);

//3 创建关联对象的查询cri对象

Criteria cri2 = cri1.createCriteria("sex");

cri2.add(Restrictions.like("sexname", "%未知%"));

List list = cri1.list();

for(Person p:list)

{

System.out.println(p);

}

}

static void 离线查询()

{

//1 在未进行数据库连接时，创建离线查询的对象

DetachedCriteria dri = DetachedCriteria.forClass(Person.class);

dri.add(Restrictions.eq("pid", 2));

//2 一旦发现处于连接状态，则可将离线查询转出在线查询

Session s = HibernateSessionFactory.getSession();

Criteria cri = dri.getExecutableCriteria(s);

//3 执行查询

List list = cri.list();

for(Person p:list)

{

System.out.println(p);

}

}

public static void main(String[] args)

{

//基础的cri查询();

//cri关联条件查询();

离线查询();

}

}