⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 seperatepage.htm

📁 java开发实例 多个jsp开发实例
💻 HTM
字号:
🔍 
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="KEYWORDS" content="小龙亭工作室之JSP实践之旅">
<title>小龙亭工作室之JSP实践之旅</title>
<link rel="stylesheet" href="../jsp.css" type="text/css">
</head>

<body topmargin="0" leftmargin="0" rightmargin="0">
<div align="center"><!--以下开始小龙亭标题 -->
<script language="javascript" src="../gaptitle.js"></script>
<!--以下开始主题索引td和文章区td -->
<div align="center"><center>

<table width="100%">
  <tr>
    <td colspan="2" height="10"></td>
  </tr>
  <tr>
    <td width="20%" style="border-right: 1px solid red" valign="top" height="227"><script
    language="javascript" src="manualindex.js"></script> </td>
    <td width="80%" valign="top" height="227">　 
      <p align="center"><b><font size="3" color="#FF00FF">在jsp中实现分页</font></b> 
      <p align="center">　<p>（编者按：此文来自网上论坛中〈初学jsp心得〉一文）<p><br>
      page是关键字，不能当变量。<br>
      <p><b>conn.jsp</b><p><br>
      &lt;%<br>
    String sDBDriver = "COM.ibm.db2.jdbc.app.DB2Driver";<br> 
    String sConnStr = "jdbc:db2:faq";<br> 
    Connection conn = null;<br> 
    Statement stmt = null;<br> 
    ResultSet rs=null;<br> 
       try {<br> 
               Class.forName(sDBDriver);&nbsp;<br>
    }<br>
       catch(java.lang.ClassNotFoundException e)     {<br> 
        out.print("faq(): " + e.getMessage());<br> 
    }<br> 
      <br> 
    try{<br> 
       conn = DriverManager.getConnection(sConnStr,"wsdemo","wsdemo1");&nbsp;<br>
       stmt = conn.createStatement();<br> 
    }catch(SQLException e){<br> 
        out.print(e.toString());<br> 
    }<br> 
      %><br> 
      <br> 
      <b>query.jsp<br> 
      </b><br> 
      &lt;%@ page language="java" import="java.sql.*"  %><br> 
      &lt;%@ page contentType="text/html; charset=gb2312" %><br> 
      &lt;%@ include file="conn.jsp" %><br> 
      &lt;%<br> 
      ......<br> 
      int pages=0;<br> 
      int pagesize=10;<br> 
      ResultSet result = null;<br> 
      ResultSet rcount = null;<br> 
      <br> 
      pages = new Integer(request.getParameter("pages")).intValue();<br> 
      <br> 
      if (pages>0)<br> 
      {<br> 
      <br> 
      String sql=" state='我不傻'";<br> 
      int count=0;<br> 
      try {<br> 
      rcount = stmt.executeQuery("SELECT count(id) as id from user where "+sql);<br> 
      catch(SQLException ex) {<br> 
  out.print("aq.executeQuery: " + ex.getMessage());<br> 
  }<br> 
      if(rcount.next())<br> 
  count = rcount.getInt("id");<br> 
      rcount.close();<br> 
      if (count>0)<br> 
      {<br> 
      sql="select * from user where  "+sql;<br> 
      try {<br> 
      result = stmt.executeQuery(sql);<br> 
    }<br> 
      catch(SQLException ex) {<br> 
  out.print("aq.executeQuery: " + ex.getMessage());<br> 
  }<br> 
      int i;<br> 
      String name;<br> 
      //  result.first();<br> 
      //  result.absolute((pages-1)*pagesize);<br> 
      //  此方法jdbc2.0支持。编译通过，但执行不过，不知是不是跟驱动有关，只好用下面的笨办法。<br> 
      for(i=1;i&lt;=(pages-1)*pagesize;i++)<br> 
  result.next();<br> 
      for(i=1;i&lt;=pagesize;i++) {<br> 
  if (result.next()) {<br> 
  name=result.getString("name");<br> 
  out.print(name);<br> 
  }<br> 
      result.close();<br> 
      int n= (int)(count/pagesize);<br> 
      if (n*pagesize&lt;count) n++;<br> 
      if (n>1)<br> 
      {for(i=1;i&lt;=n;i++)<br> 
   out.print("&lt;a href=query.jsp?pages="+i+">"+i+"&amp;nbsp;&lt;/a&gt;&quot;); 
      <p>} 
      <p>} 
      <p>} 
      <p>%&gt; 
      <br>
        
    </td>  
  </tr>  
<!-- 以下是底边-->              
<script language="javascript" src="../gapbottom.js"></script> 
</center>   
</body>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -