一、参数在HQL语句中直接通过模版查询（hibernate3.1.3以上版本汉字参数不乱码）
public List findPerson()
{
String hql =
" from syidt.modules.grp.basegrp.persistence.Person as person where person.personName ='李景涛' order by person.theGroup.groupOID,person.number";
List list = hibernateOperations.find(hql);
return list;
}
二、通过模版查询，通过占位府？查询 groupOID 可以为数组
public String getDutyManOfGroup(String groupOID)
{
String sql = "from syidt.modules.grp.basegrp.persistence.Person as person where person.theGroup.groupOID=?";
List list = hibernateOperations.find(sql, groupOID);
// String[] strtemp = {"1", "2"};
Iterator ite = list.iterator();
String personOID = ( (Person) ite.next()).getPersonOID();
return personOID;
}
三、DetachedCriteria查询
/**
* 部门中最大的序号数
* getGroupMaxSeq
*
* @author chenxs
*
* @param parentGropuOID String
* @return int
*/
public int getGroupMaxSeq(String parentGropuOID)
{
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Group.class);
detachedCriteria.add(Restrictions.eq("theParentGroup.groupOID",
parentGropuOID));
detachedCriteria.setProjection(Projections.projectionList().add(
Projections.max("groupOrder")));
Integer integer = new Integer(0);
integer = (Integer) hibernateOperations.findByCriteria(
detachedCriteria).get(0);
if (integer == null) {
return 0;
}
return integer.intValue();
}
四、hibernate回调查询
/**
* downAllGroup
* 部门序列号批量下移
* =========================
*
