|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
page是要害字,不能当变量。 conn.jsp <% String sDBDriver = "COM.ibm.db2.jdbc.app.DB2Driver"; String sConnStr = "jdbc:db2:faq"; Connection conn = null; Statement stmt = null; ResultSet rs=null; try { Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { out.print("faq(): " + e.getMessage()); } try{ conn = DriverManager.getConnection(sConnStr,"wsdemo","wsdemo1"); stmt = conn.createStatement(); }catch(SQLException e){ out.print(e.toString()); } %> query.jsp <%@ page language="java" import="java.sql.*" %> <%@ page contentType="text/html; charset=gb2312" %> <%@ include file="conn.jsp" %> <% ...... int pages=0; int pagesize=10; ResultSet result = null; ResultSet rcount = null; pages = new Integer(request.getParameter("pages")).intValue(); if (pages>0) { String sql=" state=\\\'我不傻\\\'"; int count=0; try { rcount = stmt.executeQuery("SELECT count(id) as id from user where "+sql); catch(SQLException ex) { out.print("aq.executeQuery: " + ex.getMessage()); } if(rcount.next()) count = rcount.getInt("id"); rcount.close(); if (count>0) { sql="select * from user where "+sql; try { result = stmt.executeQuery(sql); } catch(SQLException ex) { out.print("aq.executeQuery: " + ex.getMessage()); } int i; String name; // result.first(); // result.absolute((pages-1)*pagesize); // 此方式jdbc2.0支持。编译通过,但执行不过,不知是不是跟驱动有关,只好用下面的笨办法。 for(i=1;i<=(pages-1)*pagesize;i++) result.next(); for(i=1;i<=pagesize;i++) { if (result.next()) { name=result.getString("name"); out.print(name); } result.close(); int n= (int)(count/pagesize); if (n*pagesize<count) n++; if (n>1) {for(i=1;i<=n;i++) out.print("<a href=query.jsp?pages="+i+">"+i+" </a>"); } } } %> 返回类别: 教程 上一教程: JAVA语言中链表和双向链表的实现 下一教程: JAVA应用技巧-JAVA中的发声提示 您可以阅读与"在JSP中实现分页"相关的教程: · 在JSP页面中实现检索数据的分页显示 · 开发实例:JSP中实现全文检索 · 一个用JSP实现的分页的类及调用方式 · JSP中实现连接池 · JSP中实现全文检索 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |