NOT IN ????????????????
rs = op.query( "SELECT top " + pageSize + " * FROM 类别表 where 父类编号= "+pid+ " AND 类别编号 NOT IN (SELECT TOP " + ((currPage - 1) * pageSize)+ " 类别编号 from 类别表 WHERE 父类编号= "+pid+ " ORDER BY 类别编号 DESC) ORDER BY 类别编号 DESC ");

用jsp在mysql中应该怎样实现

[解决办法]
select aaaaaaaaa from vvvvv where aaaaaaaaa
以上的都一样

分页采用

limit 100,20