@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); return response; }
@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); 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; }
.from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name())
.from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name())
@Override public PaginationRsp<JobLogPo> search(JobLoggerRequest request) { PaginationRsp<JobLogPo> response = new PaginationRsp<JobLogPo>(); Long results = new SelectSql(getSqlTemplate()) .select() .columns("count(1)") .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .single(); response.setResults(results.intValue()); if (results == 0) { return response; } // 查询 rows List<JobLogPo> rows = new SelectSql(getSqlTemplate()) .select() .all() .from() .table(getTableName()) .whereSql(buildWhereSql(request)) .orderBy() .column("log_time", OrderByType.DESC) .limit(request.getStart(), request.getLimit()) .list(RshHolder.JOB_LOGGER_LIST_RSH); response.setRows(rows); 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; }
.from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name()) .from() .table(getTableName()) .whereSql( new WhereSql() .andOnNotNull("node_type = ?", request.getNodeType() == null ? null : request.getNodeType().name())