@Override public PageModel queryForPager(int pageNumber, int pageSize, Class entityClass, String condition, String sort,HttpServletRequest request, Object... params) { EntityManager entityManager = getEntityManager(request,1); String schemaName = entityManager.getProperties().get("id")+""; PageModel page = new PageModel(); String sqllist = SqlHelper.generateSelectSqlForPager(pageNumber, pageSize, entityClass, condition, sort,schemaName); String sqlcount = SqlHelper.generateSelectSqlForCount(entityClass, condition); if(params instanceof Object[]){ sqllist = formatSql(sqllist,params); sqlcount = formatSql(sqlcount,params); } Query createNativeQuery = entityManager.createNativeQuery(SqlParserUtil.sqlParserForSelect(sqllist, schemaName)); List resultList = createNativeQuery.getResultList();
JPA entityManager 实现 分页查询
最新推荐文章于 2024-04-24 11:46:11 发布