sybase分页查询优化支持排序 - JAVA

actory 字段加的索引名叫province_index_1
* 如果就一个主键那写null就可以。如果几个索引那用哪个索引写哪个索引的名字
*/
Page page = service.findPageBySql(sql, ProvinceSpareInfoAll.class, "keyId", startNum, pageSize,"province_index_1");//province_pk_1
List list = page.getData();
System.out.println(page.getTotalCount());

for (Object object : list) {
ProvinceSpareInfoAll p = (ProvinceSpareInfoAll)object;
System.out.print(p.getKeyId()+" ");
}
System.out.println();
}

sybase分页查询优化支持排序 (二)