分页的sql语句之一写法与代码写法

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (
SELECT T.CONTENT ,
  E.EMP_NAME AS BLESSER,
  O.NAME as blesserDepartment
FROM T_ECM_BIRTH_BLESS T
LEFT JOIN M_EMPLOYEE E
ON E.USER_ID=T.TO_USER
LEFT JOIN M_ORGANIZATION O
ON O.ORG_ID    =E.DEPT_ID
WHERE T.TO_USER=926

) A WHERE ROWNUM <= 1 ) EMP  WHERE RN > 0

将查询结果封装成bean：      

String sql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( SELECT T.CONTENT as content,E.EMP_NAME AS blesser,O.NAME as blesserDepartment FROM T_ECM_BIRTH_BLESS T " +  "LEFT JOIN M_EMPLOYEE E ON E.USER_ID=T.TO_USER LEFT JOIN M_ORGANIZATION O ON O.ORG_ID=E.DEPT_ID WHERE T.TO_USER=? ) A WHERE ROWNUM <= ? ) EMP  WHERE RN > ?";    

   Integer firstPage = pageNo * pageSize - pageSize;     

  Integer endPage = firstPage + pageSize;     

  List<BirthBlessBean> list=commonDao.getListBySpringJDBC(sql, BirthBlessBean.class, toUser,endPage,firstPage);     

  return list;  

    封装pagedata：

int totalCount = birthBlessService.getTotalNums(birthBlessBean.getBirthEmp());   

     PgInfo pageInfo = new PgInfo();  

    pageInfo.setPageNo(totalCount == 0 ? 0 : currentPage);     

pageInfo.setPageSize(pageSize)；    

   pageInfo.setTotalCount(totalCount);      

pageInfo.setSumPage(totalCount % pageSize == 0 ? totalCount / pageSize   : (totalCount / pageSize + 1));      

pageData = new TbData();   

    pageData.setList(birthBlessList);   

    pageData.setPageInfo(pageInfo);     

  pageData = pageData.fillTbData("showBirthBless.action", birthBlessBean,"birthBlessBean");    

   request.setAttribute("tbData", pageData);