/**
* 组装分页SQL的方法
* @param sqlsss 具体的业务SQL
* @param page 第几页
* @param rows 多少行
* @return
*/
public String getPageSql(String sqlsss,Integer page,Integer rows){
String sql = "select * from (select rownum as rn, t.* from ( "+sqlsss+" ) t ) where 1=1 ";
String fy_sql = "";
if (page == 0){
page = 1;
}
if(page>0&&rows>0){
int a = page;
int size = rows;
fy_sql=" and rn >"+(a-1)*size+" and rn <= "+a*size+" ";
}
sql = sql + fy_sql;
return sql;
}
/**
* 组装查询总量的方法
* @param sqlsss
* @return
*/
public String getCountSql(String sqlsss){
String sql = "select count(1) from ( "+sqlsss+" ) ";
return sql;
}
记得还需要查总量返回给前台。