JSP与DB2连接 实现分页效果

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"%> 
<%@ page import="com.yntk.qjtk.*" %>
<%Connection conn = ConnDB.getDB2Connetion();
Statement stmt = ConnDB.stmt(conn);
String sql="select branch,aracde,agntnum,agntname from mq_agntinfo";
sql=sql+" where branch='60' and dteapp between 20090401 and 20090505" ;  
ResultSet rs = ConnDB.rs(stmt,sql);%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
  
<body>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="200">ha代码</td>
    <td width="200">服务部</td>
    <td width="200">工号</td>
    <td width="200">姓名</td>
    <td width="200">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5">
        
<%while(rs.next()) {%> 
    <table width="1000" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"><%=rs.getString("branch")%></td>
    <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"><%=rs.getString("aracde")%></td>
    <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"><%=rs.getString("agntnum")%></td>
    <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"><%=rs.getString("agntname")%></td>
    <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"><%=rs.getString("branch")%></td>
  </tr>
  <tr>
    <td height="3" colspan="5" align="center" valign="middle"><img src="spacer.gif" width="1" height="1" /></td>
    </tr>
</table>
<%}%>  
<%rs.close();   
stmt.close();   
conn.close();   
%> 
</td>
  </tr>
</table>
  
  
</body>   
</html> 如何才能分页？

解决方案 »

  1.   

    主要就是写分页的sql语句. 
    可以看:
    http://topic.csdn.net/t/20030212/10/1419789.html
    http://www.javaeye.com/wiki/topic/224283
      

  2.   

              <%
         int recordCount;
     int pageCount;
     int pageId;
     int pageSize=4;
         String strPage;
         int i;
         strPage=request.getParameter("pageId");
         if(strPage==null){pageId=1;}
         else{
         pageId=java.lang.Integer.parseInt(strPage);
         if(pageId<1) pageId=1;
         
         }     //分页  
      
        
    <table width="1000" border="0" cellspacing="0" cellpadding="0"> 
      <tr> 
        <td width="200">ha代码 </td> 
        <td width="200">服务部 </td> 
        <td width="200">工号 </td> 
        <td width="200">姓名 </td> 
        <td width="200">&nbsp; </td> 
      </tr> 
      <tr> 
        <td colspan="5"> 
            
    <%while(rs.next()) {%> 
        <table width="1000" border="0" cellspacing="0" cellpadding="0"> 
      <tr> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("branch")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("aracde")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("agntnum")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("agntname")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("branch")%> </td> 
      </tr> 
      <tr> 
        <td height="3" colspan="5" align="center" valign="middle"> <img src="spacer.gif" width="1" height="1" /> </td> 
        </tr> 
    </table> 
    <%}%>  
    <%rs.close();  
    stmt.close();  
    conn.close();  
    %> 
    </td> 
      </tr> 
    </table> 
         [color=#FF0000] <tr>
                <td><div align='center'>
        <TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
                          <TBODY>
                            <TR>
                              <TD align="right" height="29">                    
                            <TR>
                              <TD>
      
      
       <DIV align="right">
                                <div align="right">
                                  <% if (pageCount>1){%>
                                  <%if(pageId>1){%>
                                  <a href="index_list.jsp?pageId=1">首页</a>&nbsp; <a href="index_list.jsp?pageId=<%=pageId-1%>">上一页</a>&nbsp;
                                  <%}
    if (pageId<pageCount){
    %>
                                  <a href="index_list.jsp?pageId=<%=pageId+1%>">下一页</a>&nbsp; <a href="index_list.jsp?pageId=<%=pageCount%>">尾页</a>&nbsp;
                                  <%}
    }
    %>
                                  <%

    if(pageCount>1){
    out.print("共"+pageCount+"页 第"+pageId+"页");

    if(pageCount!=1){%>
                                  <span class="price">转到第</span>
                                  <select name="jump" onChange="window.location.href='index_list.jsp?pageId='+jump.options[jump.selectedIndex].value">
                                    <% for(int ii=1;ii<=pageCount;ii++)  {
         if (ii==pageId){
         %>
                                    <option selected="selected" value="<%=ii%>"><%=ii%></option>
                                    <%}else{%>
                                    <option value="<%=ii%>"><%=ii%></option>
                                    <%}}%>
                                  </select>
                                  <span class="price">页</span>
                                  <%}}%>
       </div>
       </DIV>
       </TD>
                            </TR>
                          </TBODY>
                        </TABLE>
        </div></td>
               </tr>       
      

  3.   

           <% 
        int recordCount; 
    int pageCount; 
    int pageId; 
    int pageSize=4; 
        String strPage; 
        int i; 
        strPage=request.getParameter("pageId"); 
        if(strPage==null){pageId=1;} 
        else{ 
        pageId=java.lang.Integer.parseInt(strPage); 
        if(pageId <1) pageId=1; 
        
        } //分页 
      
        
    <table width="1000" border="0" cellspacing="0" cellpadding="0"> 
      <tr> 
        <td width="200">ha代码 </td> 
        <td width="200">服务部 </td> 
        <td width="200">工号 </td> 
        <td width="200">姓名 </td> 
        <td width="200">&nbsp; </td> 
      </tr> 
      <tr> 
        <td colspan="5"> 
            
    <%while(rs.next()) {%> 
        <table width="1000" border="0" cellspacing="0" cellpadding="0"> 
      <tr> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("branch")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("aracde")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("agntnum")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("agntname")%> </td> 
        <td width="100" height="20" align="center" valign="middle" bgcolor="#ff8000"> <%=rs.getString("branch")%> </td> 
      </tr> 
      <tr> 
        <td height="3" colspan="5" align="center" valign="middle"> <img src="spacer.gif" width="1" height="1" /> </td> 
        </tr> 
    </table> 
    <%}%>  
    <%rs.close();  
    stmt.close();  
    conn.close();  
    %> 
    </td> 
      </tr> 
    </table> 
         [color=#FF0000]<tr> 
                <td> <div align='center'> 
        <TABLE cellSpacing="0" cellPadding="0" width="100%" border="0"> 
                          <TBODY> 
                            <TR> 
                              <TD align="right" height="29">                    
                            <TR> 
                              <TD> 
      
      
      <DIV align="right"> 
                                <div align="right"> 
                                  <% if (pageCount>1){%> 
                                  <%if(pageId>1){%> 
                                  <a href="index_list.jsp?pageId=1">首页 </a>&nbsp; <a href="index_list.jsp?pageId= <%=pageId-1%>">上一页 </a>&nbsp; 
                                  <%} 
    if (pageId <pageCount){ 
    %> 
                                  <a href="index_list.jsp?pageId= <%=pageId+1%>">下一页 </a>&nbsp; <a href="index_list.jsp?pageId= <%=pageCount%>">尾页 </a>&nbsp; 
                                  <%} 
    } 
    %> 
                                  <% if(pageCount>1){ 
    out.print("共"+pageCount+"页 第"+pageId+"页"); if(pageCount!=1){%> 
                                  <span class="price">转到第 </span> 
                                  <select name="jump" onChange="window.location.href='index_list.jsp?pageId='+jump.options[jump.selectedIndex].value"> 
                                    <% for(int ii=1;ii <=pageCount;ii++)  { 
        if (ii==pageId){ 
        %> 
                                    <option selected="selected" value=" <%=ii%>"> <%=ii%> </option> 
                                    <%}else{%> 
                                    <option value=" <%=ii%>"> <%=ii%> </option> 
                                    <%}}%> 
                                  </select> 
                                  <span class="price">页 </span> 
                                  <%}}%> 
      </div> 
      </DIV> 
      </TD> 
                            </TR> 
                          </TBODY> 
                        </TABLE> 
      </div> </td> 
              </tr>       
      

  4.   

    发不好了，哈哈，中间是你的table，开头结尾jsp页面是分页方法，具体你好要改一下