【分页查询】页面传入动态参数，DAO层多表查询实例

最新推荐文章于 2024-07-20 08:59:24 发布

DawidZhu

最新推荐文章于 2024-07-20 08:59:24 发布

阅读量3.1k

点赞数

文章标签： dao string null session list

本文链接：https://blog.csdn.net/zdwzzu2006/article/details/6278893

版权

public List getAuthority(TRoleStepDoc bussDoc, PageInfo pageInfo)
   throws RuntimeException {

  Session session = getHibernateTemplate().getSessionFactory()
    .getCurrentSession();
  StringBuffer hql = new StringBuffer();

  hql
    .append("select tc,tr,tb, t from TRolebussdoc t,TBussstep tb,TRole tr ,TCaseType tc ");
  hql
    .append("where t.roleId=tr.roleId and t.bussId =tb.bussId and t.docType=tc.caseTypeCode ");
  if (bussDoc != null) {

   String roleId = bussDoc.getRoleId();
   if (roleId != null && !"".equals(roleId)) {
    hql.append("and t.roleId= '" + roleId + "' ");
   }

String busiId = bussDoc.getBussId();
if (busiId != null && !"".equals(busiId)) {

hql.append("and t.bussId= '" + busiId + "' ");
}

String docType = bussDoc.getDocType();
if (docType != null && !"".equals(docType)) {

    hql.append("and t.docType= '" + docType + "' ");
   }
   hql.append("order by tr.roleName,tb.bussName");
  }

  int pageCount = session.createQuery(hql.toString()).list().size();
  pageInfo.setPageCount(String.valueOf(pageCount));

  return session.createQuery(hql.toString()).setFirstResult(
    Integer.parseInt(pageInfo.getPageBegin())).setMaxResults(
    Integer.parseInt(pageInfo.getPageLen())).list();
}