public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }
public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }
public PaginationRsp<JobPo> pageSelect(JobQueueReq request) { PaginationRsp<JobPo> response = new PaginationRsp<JobPo>(); WhereSql whereSql = buildWhereSql(request); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName(request)) .whereSql(whereSql) .single(); response.setResults(results.intValue()); if (results > 0) { List<JobPo> jobPos = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName(request)) .whereSql(whereSql) .orderBy() .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection())) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_PO_LIST_RSH); response.setRows(jobPos); } return response; }