急,设置了conn.createStatement后查询出错,100分求解
方式1:Statement stmt = conn.createStatement();
方式2:Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
使用方式1时,select hjx,bkkl,count(bkkl) as c from ks group by hjx,bkkl order by hjx,count(bkkl) desc返回结果正常
为了实现分页,改用方式2,查询结果就出现数据不完整
求解决的方法?谢谢!