请问在jsp分页时实现显示4行4列信息,怎么实现!
最好给些代码,谢谢!

解决方案 »

  1.   

    供参考:
    CODE:
    -----------------------------------------------------------------------
    <table id="t" width="602" border="1" cellpadding="0" cellspacing="0" bordercolorlight=#333333 bordercolordark=#efefef >
    <% 
       Connection connect = null;
       connect = dbcommand.dbConnect("","","");
       int i=0;        //记录当前的记录的行号
       int count=0;    //总记录条数,为计算页码所用
       int ipage = 1;   //超链接传递过来的页码数
       int pages = 0;  //总页码数,通过计算得来
       String ipages = request.getParameter("ipage");
       if (ipages!=null) { ipage = Integer.parseInt(ipages); }
       Statement stmt = null;
       ResultSet rs =null;
       String sSql;   //获取记录总条数,计算总页数 .start
       sSql = "SELECT...........";
       stmt = connect.createStatement();
       rs = stmt.executeQuery(sSql);
       while(rs.next())  { count = rs.getInt(1); }
       pages =  count%4 == 0 ?(count/4):(count/4+1);
       pages = pages > 10 ? 10:pages; 
       rs.close();
       stmt.close();
       rs = null;
       stmt = null;
       // 获取记录总条数,计算总页数  .end
     
       sSql = "select.........."
       sSql += " from ";
       stmt = connect.createStatement();
       rs = stmt.executeQuery(sSql); 
       while(rs.next())
       {
          i = rs.getRow();
          if( i > (ipage-1)*4 && i <= ipage*4 )
          {
             int num = i - 4*(ipage-1);
             out.println("<tr height='18' onclick='setPoint(this)'>");
             out.println("<td width='100'><div align='left'><span class='STYLE1'>"+ rs.getString(1) +"</span></div></td>");
             out.println("<td width='216'><div align='left'><span class='STYLE1'>"+ rs.getString(2) +"</span></div></td>");
             out.println("<td width='111'><div align='left'><span class='STYLE1'>"+ rs.getDouble(3) +"</span></div></td>");
             out.println("<td width='123'><div align='left'><span class='STYLE1'>"+ rs.getString(4) +"</span></div></td>");
             out.println("</tr>"); 
          }
       }
       out.println("</table><hr style='border:thin;'/>");
       rs.close();  stmt.close();  connect.close();
       rs = null; stmt = null; connect = null;
      

  2.   

    上面再加个TABLE就差不多了,自己整合一下啦................
    <body >
    <table width="602" border="1" cellpadding="0" cellspacing="0" bordercolorlight=#333333 bordercolordark=#efefef bgcolor="#33CCCC">
      <tr height="20">
        <td width="100"><div align="center" class="STYLE1">学号</div></td>
        <td width="100"><div align="center" class="STYLE1">姓名</div></td>
        <td width="50"><div align="center" class="STYLE1">年龄</div></td>
        <td width="50"><div align="center" class="STYLE1">性别</div></td>
      </tr>
    </table>
      

  3.   


    <table align="center">
    <tr>
    <th class="msg" colspan="4">新闻管理</th>
    </tr>
    <tr class="top_title">
    <td width="5%">ID</td>
    <td width="60%">新闻标题</td>
    <td width="20%">发布时间</td>
    <td>操作</td>
    </tr>
    <c:if test="${requestScope['newslist']==null}" var="flag">
    <tr height="25px">
    <td colspan="4">暂无任何新闻</td>
    </tr>
    </c:if>
    <c:if test="${flag==false}">
    <c:set var="list" value="${requestScope['newslist']}"></c:set>
    <c:forEach items="${requestScope['newslist']['page']}" var="news">
    <tr class="outline" onmouseover="this.className='online'" onmouseout="this.className='outline'">
    <td>${news.id}</td>
    <td>${news.title}</td>
    <td>${news.greatdate}</td>
    <td><input type="button" value="修改" onclick="javascript:window.location.href='NewsServlet?do=edit&id=${news.id}'" />
    &nbsp;<input type="button" value="删除" onclick="javascript:window.location.href='NewsDoServlet?do=del&id=${news.id}'"/></td>
    </tr>
    </c:forEach>
    <tr>
    <td colspan="4">
    <table align="right">
    <tr>
    <td>当前是第${param["page"]}页</td>
    <td width="20px">|</td>
    <td>共${list["maxpage"]}页</td>
    <td width="20px">|</td>
    <td>每页${list.perpage}条</td>
    <td width="20px">|</td>
    <td>
    <c:if test="${list['maxpage']==1}">
    </c:if>
    <c:if test="${param['page']==1&&param['page']<list['maxpage']}">
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${param['page']+1}">下一页</a>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${list['maxpage']}">尾页</a>
    </c:if>
    <c:if test="${param['page']!=1&&param['page']==list['maxpage']}">
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=1">首页</a>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${param['page']-1}">上一页</a>
    </c:if>
    <c:if test="${param['page']!=1&&param['page']!=list['maxpage']}">
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=1">首页</a>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${param['page']-1}">上一页</a>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${param['page']+1}">下一页</a>
    &nbsp;&nbsp;&nbsp;&nbsp;<a href="NewsServlet?page=${list['maxpage']}">尾页</a>
    </c:if>
    </td>
    <td width="20px">|</td>
    <td>
    转到第<select onchange="javascript:window.location.href=this.options[this.selectedIndex].value;">
    <%
    Page p = (Page)request.getAttribute("newslist");
    for (int i = 1; i <= p.getMaxpage(); i++) {
    if(i==Integer.parseInt(request.getParameter("page"))){%>
    <option value="NewsServlet?page=${param['page']}" selected="selected">${param['page']}</option>
    <%}else{%>
    <option value="NewsServlet?page=<%=i%>"><%=i%></option>
    <%}
    }
    %></select>页
    </td>
    </tr>
    </table>
    </td>
    </tr>
    </c:if>
    </table>
      

  4.   

    可以参考我们例子中的分页代码:
    http://www.family168.com/tutorial/jsp/html/jsp-ch-15.html