java hql模糊查询,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());

}

}

}