Criter涉及到的查询
来源:互联网 发布:西安程序麻将机软件 编辑:程序博客网 时间:2024/05/22 07:45
package com.etc.testCriteria;
import java.util.Calendar;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;
import com.etc.entity.Student;
public class testCriteriademo {
@Test
public void find() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println(
"id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void findbycond() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
// 查询年龄大于11岁且小于14岁的的学生
cr.add(Restrictions.gt("age", 11));
cr.add(Restrictions.lt("age", 14));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void findorcond() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
// 查询年龄大于11岁且小于14岁的的学生
cr.add(Restrictions.or(Restrictions.lt("age", 12), Restrictions.gt("age", 13)));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void orderfind() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.addOrder(Order.desc("age"));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid() +"班级:"+s.getCid()+ "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void countfind() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.setProjection(Projections.avg("age"));
System.out.println("学生平均年龄是:"+cr.uniqueResult());
/*List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge());
}
*/
}
@Test
public void orderbyage() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.addOrder(Order.desc("age"));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void birthbetween() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
Calendar c1=Calendar.getInstance();
c1.set(Calendar.YEAR, 2014);
c1.set(Calendar.MONTH,0);
c1.set(Calendar.DATE, 1);
Calendar c2=Calendar.getInstance();
c2.set(Calendar.YEAR, 2014);
c2.set(Calendar.MONTH, 11);
c2.set(Calendar.DATE, 1);
Date d1=c1.getTime();
Date d2=c2.getTime();
cr.add(Restrictions.between("birthday", d1, d2));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void groupbyclass() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.setProjection(Projections.groupProperty("cid"));
List list = cr.list();
System.out.println(list.size());
/*Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}*/
}
@Test
public void detchedCriteria() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
//先建立DetchedCriteria对象
DetachedCriteria detachedCriteria=DetachedCriteria.forClass(Student.class);
//加入查询条件
detachedCriteria.add(Restrictions.eq("age", 13));
//绑定session并返回一个Criteria实例
cr=detachedCriteria.getExecutableCriteria(session);
List list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
}
import java.util.Calendar;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;
import com.etc.entity.Student;
public class testCriteriademo {
@Test
public void find() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println(
"id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void findbycond() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
// 查询年龄大于11岁且小于14岁的的学生
cr.add(Restrictions.gt("age", 11));
cr.add(Restrictions.lt("age", 14));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void findorcond() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
// 查询年龄大于11岁且小于14岁的的学生
cr.add(Restrictions.or(Restrictions.lt("age", 12), Restrictions.gt("age", 13)));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void orderfind() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.addOrder(Order.desc("age"));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid() +"班级:"+s.getCid()+ "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void countfind() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.setProjection(Projections.avg("age"));
System.out.println("学生平均年龄是:"+cr.uniqueResult());
/*List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge());
}
*/
}
@Test
public void orderbyage() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.addOrder(Order.desc("age"));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void birthbetween() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
Calendar c1=Calendar.getInstance();
c1.set(Calendar.YEAR, 2014);
c1.set(Calendar.MONTH,0);
c1.set(Calendar.DATE, 1);
Calendar c2=Calendar.getInstance();
c2.set(Calendar.YEAR, 2014);
c2.set(Calendar.MONTH, 11);
c2.set(Calendar.DATE, 1);
Date d1=c1.getTime();
Date d2=c2.getTime();
cr.add(Restrictions.between("birthday", d1, d2));
List<Student> list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
@Test
public void groupbyclass() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
cr.setProjection(Projections.groupProperty("cid"));
List list = cr.list();
System.out.println(list.size());
/*Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}*/
}
@Test
public void detchedCriteria() {
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria cr = session.createCriteria(Student.class);
//先建立DetchedCriteria对象
DetachedCriteria detachedCriteria=DetachedCriteria.forClass(Student.class);
//加入查询条件
detachedCriteria.add(Restrictions.eq("age", 13));
//绑定session并返回一个Criteria实例
cr=detachedCriteria.getExecutableCriteria(session);
List list = cr.list();
Iterator<Student> it = list.iterator();
while (it.hasNext()) {
Student s = it.next();
System.out.println("id号是:" + s.getSid()+"班级:"+s.getCid() + "姓名:" + s.getSname() + "密码:" + s.getPassword() + "年龄:" + s.getAge()+"出生日期"+s.getBirthday());
}
}
}
0 0
- Criter涉及到的查询
- criter查询详细
- 涉及到空值的查询
- 查询表涉及到的存储过程名
- sql涉及到多对多的查询
- oracle 根据表查询涉及到的包、存储过程
- 定位的第一个中实现 ,用 criter类实现 的职位选择
- 单卡涉及到的宏
- 涉及到图片展示的
- 研究生论文涉及到的期刊
- Wifi涉及到的API
- 涉及到的权限
- discuz涉及到的问题
- bind9涉及到的文档
- activiti 涉及到的表
- mysql 涉及到的优化
- 涉及到根目录的三个知识点
- SY_split_KitPO中涉及到的几张表!
- LeetCode OJ 406. Queue Reconstruction by Height
- C语言指针导学(6)——使用指针时的“陷阱”
- 蓝桥杯 ADV-89 算法提高 输出九九乘法表
- TensorFlow 新手入门
- 使用dd命令新增交换分区
- Criter涉及到的查询
- 深入理解HTTP协议、HTTP协议原理分析
- JavaScript 自执行函数(闭包)
- struct accessor实现for c
- 蓝桥杯 ADV-90 算法提高 输出日历
- 快速排序(C语言)
- 蓝桥杯 ADV-91 算法提高 素数判断
- 【前端】js中外链文件优化问题
- stdarg的用法(可变参数的用法)