帮忙改成MYSQL语句行吗?
String sql = "select top " + pagesvo.getPageSize()
+ " * from tb_chengguo where id not in(select top "
+ pagesvo.getPageSize() * (pagesvo.getPageNow() - 1)
+ " id from tb_chengguo where firstname='" + username
+ "') and firstname='" + username + "'";
String sql = "select top " + pagesvo.getPageSize()
+ " * from tb_chengguo where id not in(select top "
+ pagesvo.getPageSize() * (pagesvo.getPageNow() - 1)
+ " id from tb_chengguo where spzt=3) and spzt=3";