QBC:
@Test
public void HQ_1() {
Session session=sf.getCurrentSession();
session.beginTransaction();
//Criteria:标准、准则、约束
Criteria c=session.createCriteria(Topic.class)//from Topic
.add(Restrictions.gt("id", 2))//id>2
.add(Restrictions.lt("id", 8))//id<8
.add(Restrictions.like("name", "t_"))
.createCriteria("category")//相当于连接
.add(Restrictions.between("id", 3,5));//category.id>=3 and category.id<=5
List<Topic> topics=(List<Topic>)c.list();
for(Topic t:topics){
System.out.println(t.getName());
}
session.getTransaction().commit();
}
QBE:
@Test
public void HQ_1() {
Session session=sf.getCurrentSession();
session.beginTransaction();
Topic tExample=new Topic();
tExample.setName("T_");
Example e=Example.create(tExample).ignoreCase().enableLike();
Criteria c=session.createCriteria(Topic.class)//from Topic
.add(Restrictions.gt("id", 2))//id>2
.add(Restrictions.lt("id", 8))//id<8
.add(e);
List<Topic> topics=(List<Topic>)c.list();
for(Topic t:topics){
System.out.println(t.getName());
}
session.getTransaction().commit();
}