多个值的离线查询

/**
* 名称查重
* @param qrybo 查重条件
* @return 如果重复的话，则显示所有重复的记录(为SimpleName中的内容)
* @throws SysException
*/
public List checkDoubleName(NameQueryBO qrybo) throws SysException{
DetachedCriteria criteria = DetachedCriteria.forClass(NameAuthority.class);

criteria.add(
Restrictions.or(Restrictions.like ("name.keyWord",qrybo.getKeyWord()),
Restrictions.or(Restrictions.like("name.keyWord",qrybo.getFirst()),
Restrictions.or(Restrictions.like("name.keyWord",qrybo.getSecond()),
Restrictions.like("name.keyWord",qrybo.getThird())
))));

return (List)nadao.findByCriteria(criteria);
}


/**
* 根据离线查询条件查找名称记录
* @param criteria
* @return
*/
public List findByCriteria(DetachedCriteria criteria){
ConstantDAO ctdao = new ConstantDAO();
Session session = getSession();
Transaction tran = session.beginTransaction();
Criteria cri = criteria.getExecutableCriteria(session);
List list = (List)cri.list();
tran.commit();
return list;
}