java 代码
xml 代码
- package com.student.util.page;
- import java.sql.*;
- public class DBcon{
- private String url="proxool.mytest";
- private String driver="org.logicalcobwebs.proxool.ProxoolDriver";
- Connection con=null;
- Statement stmt=null;
- public DBcon () throws ClassNotFoundException, SQLException {
- Class.forName(driver);
- con=DriverManager.getConnection(url);
- stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
- }
- public Connection getCon() throws SQLException {
- return con;
- }
- public void setCon(Connection con) {
- this.con = con;
- }
- public Statement getStmt() {
- return stmt;
- }
- public void setStmt(Statement stmt) {
- this.stmt = stmt;
- }
- }
- -----------------------------
- <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
- <%@ page import="java.sql.*" %>
- <jsp:useBean id="db" class="com.student.util.page.DBcon" ></jsp:useBean>
- <jsp:setProperty property="con" name="db"/>
- <jsp:setProperty property="stmt" name="db"/>
- <br> <br> <br>
- <%
- java.sql.ResultSet rs; //结果集对象
- String sql; //SQL语句
- int pageSize; //一页显示的记录数
- int RowCount; //记录总数
- int PageCount; //总页数
- int intPage; //待显示页码
- String strPage;
- int i;
- pageSize = 3;
- strPage = request.getParameter("page");
- if(strPage==null){//表明在QueryString中没有page这一个参数,此时显示第一页数据
- intPage = 1;
- }
- else{
- intPage = java.lang.Integer.parseInt(strPage);
- if(intPage<1) intPage = 1;
- }
- //连接数据库
- db.getCon().createStatement();
- //创建一个可以滚动的只读的SQL语句对象
- sql = "select * from teacher";
- rs=db.getStmt().executeQuery(sql);
- rs.last();
- RowCount = rs.getRow();
- PageCount = (RowCount+pageSize-1) / pageSize;
- if(intPage>PageCount) intPage = PageCount;
- %>
- <body>
- <table border="1" cellspacing="0" cellpadding="0" align="center">
- <tr>
- <th>姓名</th>
- <th>爱好</th>
- </tr>
- <%
- if(PageCount>0){
- rs.absolute((intPage-1) * pageSize + 1);
- i = 0;
- while(i<pageSize && !rs.isAfterLast()){
- %>
- <tr>
- <td><%=rs.getString(1)%></td>
- <td><%=rs.getString(2)%></td>
- </tr>
- <%
- rs.next();
- i++;
- }
- }
- %>
- </table>
- <p align="center">
- 第 <input type="text" value="<%=intPage%>" size="1" style> 页
- 共
- <font color="red" size=15>
- <%=PageCount%></font> 页 <br>
- <%if(intPage<PageCount){%>
- <a href="partpage.jsp?page=<%=intPage+1%>">下一页</a>
- <%}%>
- <%if(intPage>1){%><a href="partpage.jsp?page=<%=intPage-1%>">上一页</a>
- <a href="partpage.jsp?page=<%=intPage-intPage%>">首页</a>
- <%}%>
- </p>
- <%
- //关闭结果集
- rs.close();
- //关闭SQL语句对象
- db.getCon().close();
- db.getStmt().close();
- //关闭数据库
- %>