//这里不能使用一个sql语句完成分页,需要6步才能完成
String paginatedSql = this.wrapPaginatedSql(sql, firstElement, firstElement + maxElements);
String rowcount = "set rowcount " + (firstElement + maxElements);
stmt.execute(rowcount);
paginatedSql = "select *,id=identity(9) into #test from " + sql;
stmt.execute(rowcount);
stmt.execute("set rowcount " + maxElements);
paginatedSql = "select * from risenet_employee where employee_guid not in (select employee_guid from #test ) order by tabindex";
rs = stmt.executeQuery(paginatedSql);
while (rs.next()) {
lst.add(itemFactory.createObject(rs));
}
stmt.execute("set rowcount 0");
stmt.execute("drop table #test");
sybase 分页
最新推荐文章于 2024-05-09 14:46:38 发布