bbossgroups中提供的分页查询方法,非常简单,也非常的高效。 PreparedDBUtil dbUtil = new PreparedDBUtil();try {dbUtil.preparedSelect("select * from testnewface where object_id < ?",0,10);//分页查询方法dbUtil.setInt(1, 100);List list = dbUtil.executePreparedForList(TestNewface.class,new RowHandler<TestNewface>(){public void handleRow(TestNewface t, Record record) {try {t.setCREATED(record.getDate("created"));t.setDATA_OBJECT_ID(record.getInt("DATA_OBJECT_ID"));//........设置其他的属性} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}System.out.println("row handler:"+t);}});int totalsize = dbUtil.getTotalSize();//获得总记录数for(int i = 0; i < list.size()/*list.size()当页记录数*/; i ++)//遍历当页记录{TestNewface testNewface = (TestNewface)list.get(i);... ...}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}PreparedD 你的当前访问异常,请进行认证后继续阅读剩余内容。 提交