package day20151026page;
public class Test {
public static void main(String[] args) {
System.out.println(tester(2,5));
}
public static String tester(int page,int pagesize){
int start = (page-1)*pagesize + 1;
int end = page * pagesize;
String sql = "select * from "+
"(select rownum rn, e.* from "+
"(select empno,ename,sal from emp) e)"+
"where rn between "+start+ " and " + end+";";
return sql;
}
}
sql 分页
最新推荐文章于 2024-07-24 20:31:18 发布