jsp之javaBean分页查询

来源：互联网发布：薛之谦的淘宝女装店编辑：程序博客网时间：2024/05/21 18:33

图片：

定义每页的记录数：

public class User {  public static final int PAGESIZE=10;}

find类：作用是查询总记录数和分页信息

public class Find { //查询总记录数        public int SelectCount(){        int count=0;        ResultSet rs=null;        UserCoon coon=new UserCoon();        Connection coona=coon.getCoon();        String sql_Counts="select count(*) from user_table";        try {PreparedStatement pst=coona.prepareStatement(sql_Counts);rs=pst.executeQuery();if(rs.next()){ count=rs.getInt(1);}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}                return count;        }      //分页查询        public List<User> Selectcontent(int page){            List<User> list=new ArrayList<User>();        UserCoon coon=new UserCoon();        Connection coona=coon.getCoon();        String sql_Count="select * from user_table limit ?,?";        try {PreparedStatement pst=coona.prepareStatement(sql_Count);pst.setInt(1,(page-1)*User.PAGESIZE);pst.setInt(2,User.PAGESIZE);    ResultSet rs=pst.executeQuery();while(rs.next()){User usera=new User();usera.setId(rs.getString("id"));usera.setUsername(rs.getString("username"));usera.setpassword(rs.getString("password"));usera.setType(rs.getString("type"));list.add(usera);}           } catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}        return list;        }       }

showPage.jsp

<table align="center" width="800" border="1"><tr>   <td align="center" colspan="3">    <h2>所有用户信息</h2>   </td></tr><tr align="center">     <td><b>用户名</b></td>     <td><b>密码</b></td>     <td><b>用户类型</b></td></tr>    <%      int currpage=1;//定义当前页码      if(request.getParameter("page")!=null){         currpage=Integer.parseInt(request.getParameter("page"));      }      Find find=new Find();      List<User> listall=new ArrayList<User>();      listall=find.Selectcontent(currpage);      Iterator<User> it=listall.iterator();      while(it.hasNext()){      User usera=it.next();     %><tr align="center">  <td><%=usera.getUsername()%></td>  <td><%=usera.getPassword()%></td>  <td><%=usera.getType()%></td></tr> <%} %> <tr>  <td align="center" colspan="3">     <jsp:include page="Bar.jsp"/>      </tr></table>

Bar.jsp

<%       int pages;//定义总页数       int currpage=1;//定义当前页码       if(request.getParameter("page")!=null){            currpage=Integer.parseInt(request.getParameter("page"));         }       Find fd=new Find();       int count=fd.SelectCount();       if(count%User.PAGESIZE==0){                 pages=count/User.PAGESIZE;          }else{                pages=count/User.PAGESIZE+1;          }         StringBuffer sb=new StringBuffer();       for(int i=1;i<=pages;i++){             if(i==currpage){               sb.append("["+i+"]");         }else{                sb.append("<a href='showPage.jsp?page="+i+"'>"+i+"</a>"); //构建分页条          }                 sb.append("  ");           }             out.println(sb);            request.setAttribute("bar", sb.toString());          %>

0 0