DetachedCriteria离线查询

//在Action中 拼查询条件
public ActionForward Action (....)
{
DetachedCriteria dc = DetachedCriteria.forClass(User.class);
String name = request.getParameter("name");

//拼查询条件
if (name != null)
dc.add(Restrictions.eq("name", name));
int age = request.getParameter("age");
if(age > 0)
dc.add(Restrictions.eq("age", age));
List users = query(dc);
}

//在DAO层 查询
static List query(DetachedCriteria dc)
{
Session s = HibernateUtil.getSession();
Criteria c = dc.getExecutableCriteria(s);  //这时须要一个session
List rs = c.list();
s.close();
return rs;
}