Question

[Microsoft][ODBC Microsoft Access 驱动程序] 语法错误 (操作符丢失)

PS：提示错误 在查询表达式 'not in (select top 1 userId from userInfo)' 中
要实现分页操作贴上部分程序
ResultSet rs=sm.executeQuery("select count(*) from (select distinct * from userInfo) ");
if(rs.next()){rowcount=rs.getInt(1);}//查询结果为一行一列
//计算pagecount
if(rowcount%pagesize==0){
pagecount=rowcount/pagesize;}
else{
pagecount=rowcount/pagesize+1;}
//查出需显示的记录
n=pagesize*(pagenow-1)+1;
rs=sm.executeQuery("select top "+pagesize+" * from userInfo where not in (select top "+n+" userId from userInfo) ");

Answer 1

in 或 not in 是一个双目运算符

其左侧的量与右侧的量必须在类型上是相应的，只是左侧为列变量，而右侧为集合。
你的最后一行应该写成：
rs=sm.executeQuery("select top "+pagesize+" * from userInfo where USERID not in (select top "+n+" userId from userInfo) ");