package com.tudou.hibernates.t1;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;
public class TestGetCriteria {
private static Configuration cfg = new Configuration().configure();
private static SessionFactory fac = cfg.buildSessionFactory();
private static Session son = fac.openSession();
private static Transaction tr = son.beginTransaction();
// Criteria查询
public static void criteriaSelect() {
Criteria cri = son.createCriteria(Card.class);
List<Card> cards = cri.list();
for (Card c : cards) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
}
// Criteria条件查询
public static void criteriaSelectByExpressionEq() {
Criteria cri = son.createCriteria(Card.class);
cri.add(Expression.eq("cardName", "传奇世界"));
List<Card> cards = cri.list();
for (Card c : cards) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
}
// Criteria模糊条件查询
public static void criteriaSelectByExpressionLike() {
Criteria cri = son.createCriteria(Card.class);
cri.add(Expression.like("cardName", "%世界%"));
List<Card> cards = cri.list();
for (Card c : cards) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
}
// Criteria分页查询
public static void criteriaByPage() {
Criteria cri = son.createCriteria(Card.class);
cri.setFirstResult(0);
cri.setMaxResults(3);
List<Card> cards1 = cri.list();
for (Card c : cards1) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
cri.setFirstResult(3);
List<Card> cards2 = cri.list();
for (Card c : cards2) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
}
// Criteria分页排序查询
public static void criteriaByPageOrder() {
Criteria cri = son.createCriteria(Card.class);
cri.setFirstResult(0);
cri.setMaxResults(6);
cri.addOrder(Order.desc("createDate"));
List<Card> cards1 = cri.list();
for (Card c : cards1) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
cri.setMaxResults(3);
cri.addOrder(Order.desc("createDate"));
List<Card> cards = cri.list();
for (Card c : cards) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
cri.setFirstResult(3);
cri.setMaxResults(3);
cri.addOrder(Order.desc("createDate"));
List<Card> cards2 = cri.list();
for (Card c : cards2) {
System.out.println(c.getCardName() + "\t" + c.getCreateDate());
}
}
// 程序入口
public static void main(String[] args) {
// 测试方法
criteriaByPageOrder();
tr.commit();
son.close();
fac.close();
}
}
hibernate中criteria查询
最新推荐文章于 2024-09-15 19:46:31 发布