@Override

    public 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;

    }