日期:2014-05-17  浏览次数:20709 次

一条oracle语句的书写
将语句rs=sm.executeQuery("select top "+pageSize+" * from users where userId not in (select top"+pageSize*(pageNow-1)+" userId from users)");转为oracle语句

------解决方案--------------------
试试:
rs=sm.executeQuery("select * from users where userId not in (select userId from users where ROWNUM <= "+pageSize*(pageNow-1)+" ) where ROWNUM <= pageSize");