sqlserver里的转成Mysql的String sql="select top "+recordsInOnePage+" * from Goods where GoodsType='"+type+"' and goodsID not in(select top "+recordsInOnePage*currentPage+" goodsID from Goods where GoodsType='"+type+"' order by goodsID)";
调试欢乐多
select top 10 * from tb换成select * from tb limit 10