Struts 分页经典代码

package dao3; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import po.user; import poinformation.informationPo; public class informationDao { private Connection conn=null; public ArrayList queryInformation(){ ArrayList ips =new ArrayList(); String sql="select infID,CID,renshu ,zhiwei,yaoqiu from information"; try{ this.initConnection(); ResultSet rs=conn.createStatement().executeQuery(sql); while(rs.next()){ System.out.print(rs.getInt("infID")); informationPo ip= new informationPo(); ip.setInfID(rs.getInt("infID")); ip.setCID(rs.getInt("CID")); ip.setRenshu(rs.getString("renshu")); ip.setZhiwei(rs.getString("zhiwei")); ip.setYaoqiu(rs.getString("yaoqiu")); ips.add(ip); } }catch (Exception ex){ex.printStackTrace();} finally{ this.closeConnection(); } return ips; } public ArrayList querybyCID(int CID){ ArrayList ips =new ArrayList(); String sql="select infID,CID,renshu ,zhiwei,yaoqiu from information where CID=?"; try{ this.initConnection(); PreparedStatement ps= conn.prepareStatement(sql); ps.setInt(1, CID); ResultSet rs=ps.executeQuery(); while(rs.next()){ informationPo ip= new informationPo(); ip.setInfID(rs.getInt("infID")); ip.setCID(rs.getInt("CID")); ip.setRenshu(rs.getString("renshu")); ip.setZhiwei(rs.getString("zhiwei")); ip.setYaoqiu(rs.getString("yaoqiu")); ips.add(ip); } }catch (Exception ex){ex.printStackTrace();} finally{ this.closeConnection(); } return ips; } public boolean insertInformation(informationPo ip){ String sql="insert into information (CID,renshu,yaoqiu,zhiwei) values(?,?,?,?)"; try{ this.initConnection(); PreparedStatement ps=conn.prepareStatement(sql); ps.setInt(1, ip.getCID()); ps.setString(2, ip.getRenshu()); ps.setString(3, ip.getYaoqiu()); ps.setString(4, ip.getZhiwei()); ps.executeUpdate(); return true; }catch(Exception ex){ex.printStackTrace();} finally { this.closeConnection(); } return false; } public void initConnection() { try{ Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp","root","123456"); }catch(Exception ex){ex.printStackTrace();} } public void closeConnection() { try{ if(conn!=null){ conn.close(); conn=null; } }catch(Exception ex){ex.printStackTrace();} } }