str :='select * from userinfo where rownum<='+pageSize+' and user_id not in
(select user_id from userinfo where rownum<='+(intPage-1)*pageSize +')';
pl/sql 的连接符 是'||'
java的连接符 是'+'
str :='select * from userinfo where rownum<='||pageSize||' and user_id not in
(select user_id from userinfo where rownum<='||(intPage-1)*pageSize ||')';
(select user_id from userinfo where rownum<='+(intPage-1)*pageSize +')';
pl/sql 的连接符 是'||'
java的连接符 是'+'
str :='select * from userinfo where rownum<='||pageSize||' and user_id not in
(select user_id from userinfo where rownum<='||(intPage-1)*pageSize ||')';