打印本文 打印本文 关闭窗口 关闭窗口
Oracle & JSP 开发的小型信息管理系统 (七) 源代码5
作者:武汉SEO闵涛  文章来源:敏韬网  点击数1873  更新时间:2009/4/22 22:03:04  文章录入:mintao  责任编辑:mintao
sp;                 </tr>
                          <%if(intRowCount==0){%>
    對不起,還沒有資料!
    <%}else{%>
  <%-- 顯示每頁的資料 (根據i的值判斷每頁的5條記錄) --%>
 <%
  i=0;
  while(i<intPageSize && rs.next()){
 %>
                        <tr>
                          <td width="15%" height="23" bgcolor="#FFFFFF">
                            <p align="center"><%=rs.getString("article_id")%>
                          </td>
                          <td width="45%" bgcolor="#FFFFFF">
                             <a href="javascript:openwin(<%=rs.getString("article_id")%>)" title="<%=rs.getString("title")%>"><%=rs.getString("title")%></a>
                                               
                          </td>
                          <td width="26%" bgcolor="#FFFFFF">
                            <div align="center"><%=rs.getString("date_and_time")%></div>
                          </td>
                          <td width="15%" bgcolor="#FFFFFF">
                            <p align="center"><%=rs.getString("hits")%>
                          </td>
                        </tr>
          <%
   i++;//通過I迴圈設置每頁的頁數
    }
 %>
  
   
  <%}%>
                      </table>
                    </center>
                  </div>
               <FORM action=index.jsp method=POST>
<p align=''''center'''' vAlign=''''bottom''''>
    第<%=intPage%>頁 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>頁&nbsp;&nbsp;&nbsp;
   
    <%if(intPage>1){%>
    <a href="index.jsp?page=<%=intPage-1%>&types=<%=types%>">上一頁</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <%}%>
        <%if(intPage<intPageCount){%>
    <a href="index.jsp?page=<%=intPage+1%>&types=<%=types%>">下一頁</a>&nbsp;&nbsp;&nbsp;
    <%}%>
        <br>到第<input type="text" name="page" size="5" value="1"/>頁
        <input type="submit" value="確定" class="buttonface">
     </form>
         <%
     
         String userName=(String)session.getAttribute("admin");
         if(userName==null){userName="";}
         if(userName.equals("admin")){
        
         %>
         &nbsp; &nbsp;<a href="manage.jsp">系統管理</a><%}
         else{%>
         &nbsp; &nbsp;<a href="login.jsp">登錄系統管理</a><%}%>
        
                </div>
              </div>
            </div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<%rs.close();

conn.close();
%>
<p align="center">Copyright &copy;moonsoft 2004</p>
</body>
</html>

上一页  [1] [2] 

打印本文 打印本文 关闭窗口 关闭窗口