在SQL server 2005数据库中实现分页查询,语句是这样写吗?(在线等)
sql = " SELECT * "+
" FROM (SELECT Row_Number() OVER (ORDER BY empno) AS RowId, * "+
" FROM emp) U " +
" WHERE U.RowId BETWEEN ? AND ? ";
ps = conn.prepareStatement(sql);
ps.setInt(1,currentPage*lineSize);
ps.setInt(2,(currentPage-1)*lineSize);
//ps.setInt(2,currentPage*lineSize);
rs = ps.executeQuery();