目录
HibernateDaoSupport类
1、 继承了HibernateDaoSupport类的类获取session时,已不可用SessionFactory.OpenSessioon的形式来获 取Session了,由于HibernateDaoSupport本身已有获取session的方法getSession(),所以直接用Session se=this.getSession();来获取,
2、 在依据hql获取用户信息时,继承了HibernateDaoSupport类的类中不能在使用Query类了,而是用List<Ssh> list = this.getHibernateTemplate().find(hql);形式来获取实体类集合
createQuery与createSQLQuery方法
createQuery:用的hql语句进行查询//以hibernate生成的Bean为对象装入list返回
createSQLQuery:可以用sql语句查询//是以对象数组进行存储
public List<ProcessEntity> findProcess(boolean isAdmin, ProcessEntity processEntity, int begin, int pageSize) {
criteria = DetachedCriteria.forClass(ProcessEntity.class);
if(!isAdmin) {// 非超管
//按负责人工号查询
if (processEntity.getManagerNum() != null && !processEntity.getManagerNum().isEmpty()) {
criteria.add(Restrictions.like("managerNum", processEntity.getManagerNum()));
}
}
List<ProcessEntity> processEntityList = (List<ProcessEntity>) this.getHibernateTemplate().findByCriteria(criteria,begin,pageSize);
return processEntityList;
}
@Override
public int findProjectCount(boolean isAdmin, Integer managerNum) {
String hql = "SELECT COUNT(*) from com.xmgc.models.pojo.ProjectEntity ";
Query query = null;
if (isAdmin) {
query = currentSession().createQuery(hql);
}else{
if(managerNum == null){
return 0;
}
hql += " where ManagerNum=? ";
query = currentSession().createQuery(hql);
query.setInteger(0, managerNum);
}
List<Long> list = query.list();
if(list.size()>0){
return list.get(0).intValue();
}
return 0;
}
uniqueResult()方法
ManagerEntity managerEntity = (ManagerEntity) query.uniqueResult();
//当确定返回的实例只有一个或者null时 用uniqueResult()方法