Hibernate Expression 模糊查询实例 带有关联的模糊查询实例

实例一：

package com.zonecens.criter.tests;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Expression;

import com.zonecens.hibernate.SessionFactory;
import com.zonecens.tables.Computer;
import com.zonecens.tables.Person;

public class ExpressionLike {

public static void main(String[] args) {
   Session s = SessionFactory.getSession();
   Transaction tx=s.beginTransaction();
  
   Criteria cr=s.createCriteria(Computer.class);
   cr.add(Expression.like("cpu","AMD%"));        //查询cpu like AMD%的
  
   List ps=cr.list();
  
   for(Iterator it=ps.iterator();it.hasNext();){
    System.out.println(((Computer)it.next()).getCpu());
   }
}

}
实例二：带有关联的模糊查询

package com.zonecens.criter.tests;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;

import com.zonecens.hibernate.SessionFactory;
import com.zonecens.tables.Person;

public class RelationShip {
public static void main(String[] args) {
   Session s = SessionFactory.getSession();
   Transaction tx=s.beginTransaction();
  
   Criteria cr=s.createCriteria(Person.class);
   cr.add(Expression.between("personID",1,5));
   cr.addOrder(Order.asc("name"));
   cr.createCriteria("computers").add(Expression.like("cpu","AMD%"));
   List ps=cr.list();
  
   for(Iterator it=ps.iterator();it.hasNext();){
    System.out.println(((Person)it.next()).getName());
   }
}

}