无废话,看代码:
@Overridepublic List<Sites> queryAllSites(Pager pager) {String sql = "select * from sakai_site order by SITE_ID limit ?,?";Object[] obj = new Object[]{pager.getStart(),pager.getLimit()};List<Sites> list = jdbcTemplate.query(sql,obj, new siteMapper());return list;}