百度分頁效果之純jsp版

百度分頁效果之純jsp版

數據庫連接工具類

package com.gao.page.utils;

import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection {
    /**
     *一個靜態方法，返回一個數據庫的連接。
     *這樣達到了對數據庫連接統一控制的目的。
     */ 
    public static Connection getConnection()
    {
        Connection con=null;
        String classForName=com.mysql.jdbc.Driver;
        String servAndDB=jdbc:mysql://localhost/gaodb;
        String user=root;
        String pwd=123; 
        try
        {
            Class.forName(classForName);
            con = DriverManager.getConnection(servAndDB,user,pwd);
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return con;
    }
}

Person實體類

package com.gao.page;

/** 
 * @作者   Relieved
 * @創建日期   2015年6月14日
 * @描述  （person類） 
 * @版本 V 1.0
 */
public class Person {
    private Integer id;
    private String name;
    private Integer gender;
    private String phone;
    private Integer age;
    private String address;
    /**
     * @return the id
     */
    public Integer getId() {
        return id;
    }
    /**
     * @param id the id to set
     */
    public void setId(Integer id) {
        this.id = id;
    }
    /**
     * @return the name
     */
    public String getName() {
        return name;
    }
    /**
     * @param name the name to set
     */
    public void setName(String name) {
        this.name = name;
    }
    /**
     * @return the gender
     */
    public Integer getGender() {
        return gender;
    }
    /**
     * @param gender the gender to set
     */
    public void setGender(Integer gender) {
        this.gender = gender;
    }
    /**
     * @return the age
     */
    public Integer getAge() {
        return age;
    }
    /**
     * @param age the age to set
     */
    public void setAge(Integer age) {
        this.age = age;
    }
    /**
     * @return the phone
     */
    public String getPhone() {
        return phone;
    }
    /**
     * @param phone the phone to set
     */
    public void setPhone(String phone) {
        this.phone = phone;
    }
    /**
     * @return the address
     */
    public String getAddress() {
        return address;
    }
    /**
     * @param address the address to set
     */
    public void setAddress(String address) {
        this.address = address;
    }


}

數據庫連接操作類

package com.gao.page;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.gao.page.utils.DatabaseConnection;
public class Personbean {
    private static Connection con;
    //構造方法，獲得數據庫的連接。
    static  {
        con=DatabaseConnection.getConnection();
    }
    /**
     * 帶分頁的查詢
     * @param pageSize
     * @param pageNum
     * @return
     * @throws Exception
     */
    public static List getPersonInf(int pageNum,int pageSize)throws Exception
    {
        PreparedStatement   pstmt=con.prepareStatement(select * from person limit ?,? );
        pstmt.setInt(1,(pageNum-1)*pageSize);
        pstmt.setInt(2,pageSize);
        ResultSet rst=pstmt.executeQuery();
        List ret=new ArrayList();
        while(rst.next())
        {
            Person temp=new Person();
            temp.setId(rst.getInt(1));
            temp.setName(rst.getString(2));
            temp.setGender(rst.getInt(3));
            temp.setPhone(rst.getString(4));
            temp.setAge(rst.getInt(5));
            temp.setAddress(rst.getString(6));

            ret.add(temp);
        }
        return ret;
    }
    /**
     * 獲取記錄總條數
     * @return
     * @throws Exception
     */
    public static int getPersonCount()throws Exception
    {
        Statement   pstmt=con.createStatement();
        String sql = select * from person;
        ResultSet rst=pstmt.executeQuery(sql);
        rst.last();//移動到最後一行
        return rst.getRow();
    }

}

jsp頁面代碼

<%@page import=java.util.*,com.gao.page.Person%>
<%@ page language=java contentType=text/html; charset=UTF-8
    pageEncoding=UTF-8%>
<%
    request.setCharacterEncoding(UTF-8); 
    String path = request.getContextPath();
    String basePath = request.getScheme()+://+request.getServerName()+:+request.getServerPort()+path+/;
%>

項目完整下載路徑：http://download.csdn.net/detail/gao36951/8859947
效果圖如下