Struts带分页有查询

package com.accp.common; import java.lang.reflect.Field; import java.lang.reflect.Method; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import org.apache.commons.beanutils.ConvertUtils; public class BaseDb { public void executeUpdate(String sql) { BaseDao db = new BaseDao(); try { db.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { db.close(); } } public List executeQuery(String sql,Class cls) { List<Object> list = new ArrayList<Object>(); BaseDao db = new BaseDao(); ResultSet rs; try { rs = db.executeQuery(sql); String[] columnName = new String[rs.getMetaData().getColumnCount()]; String[] columnType = new String[rs.getMetaData().getColumnCount()]; for (int i = 0; i < columnName.length; i++) { columnName[i] = rs.getMetaData().getColumnName(i + 1); } for (int i = 0; i < columnType.length; i++) { columnType[i] = rs.getMetaData().getColumnTypeName(i + 1); } while (rs.next()) { Object obj = cls.newInstance(); for (String fieldName : columnName) { Field field = cls.getDeclaredField(fieldName); Method method = cls.getDeclaredMethod("set" + fieldName.substring(0, 1).toUpperCase() + fieldName.substring(1), new Class[] { field .getType() }); String value = rs.getString(fieldName); if(value==null) continue; method.invoke(obj,ConvertUtils.convert(value, field.getType()) ); } list.add(obj); } } catch (Exception e) { System.out.println("executeQuery 出错!"); throw new RuntimeException(e.toString()); } finally { db.close(); } return list; } public int getPageCount(String sql) { return (getCount(sql)+InitResource.pageSize-1)/InitResource.pageSize; } public int getCount(String sql) { int count = 0; BaseDao dao = new BaseDao(); ResultSet rs; try { rs = dao.executeQuery(sql); if(rs.next()) count = rs.getInt(1); return count; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { dao.close(); } return count; } public List executeQuery(String sql) { return this.executeQuery(sql,1,999999); } public List executeQuery(String sql,int pageNow) { return this.executeQuery(sql,pageNow,InitResource.pageSize); } public List executeQuery(String sql,int pageNow,int pageSize) { List list = new ArrayList(); BaseDao db = new BaseDao(); ResultSet rs; try { rs=db.executeQuery(sql); String[] columnName = new String[rs.getMetaData().getColumnCount()]; for (int i = 0; i < columnName.length; i++) { columnName[i] = rs.getMetaData().getColumnName(i + 1); } rs.absolute((pageNow-1)*pageSize+1); for(int t=0;t<pageSize;t++) { HashMap hs = new HashMap(); for (int i = 0; i < columnName.length; i++) { String value = rs.getString(columnName[i]); if(value==null) continue; hs.put(columnName[i], value); } list.add(hs); if(!rs.next()) break; }} catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { db.close(); } return list; } }