模拟百度分页效果之纯jsp版实例



数据库连接工具类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<code class="hljs" java="">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;
    }
}</code>

Person实体类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<code class="hljs" java="">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;
    }
}
</code>

数据库连接操作类

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<code class="hljs" java="">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<person> 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<person> ret=new ArrayList<person>();
        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();
    }
}
</person></person></person></code>

jsp页面代码

1
2
3
4
5
6
7
8
9
10
<code class="hljs" xml=""><%@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+/;
%>
</code>

<script src=./js/jquery-1.9.1.js></script> <% final int showPages = 5;//上一页和下一页之间显示的页码数 int pageNum = request.getParameter(pageNum)==null?1:Integer.parseInt(request.getParameter(pageNum));//默认为首页 int pageSize = request.getParameter(pageSize)==null?6:Integer.parseInt(request.getParameter(pageSize));//默认为6条 List list = person.getPersonInf(pageNum,pageSize); int totalRecords = person.getPersonCount();//总数据条数 int totalPages = totalRecords%pageSize==0?(totalRecords/pageSize):(totalRecords/pageSize+1);//总页码数 int pageStart = Math.max(1, pageNum - showPages/2);//显示的起始页码 int pageEnd = Math.min(totalPages, pageStart + showPages - 1);//显示的尾页 pageStart = Math.max(1, pageEnd - showPages + 1); %>

员工信息


<% if(list.size()>0){ for(int i=0;i<list.size();i++) 2="=0){"> <%}else{%> <% } }%>

Id 姓名 性别 手机号 年龄 地址
<%=list.get(i).getId()%> <%=list.get(i).getName()%> <%=list.get(i).getGender()%> <%=list.get(i).getPhone()%> <%=list.get(i).getAge()%> <%=list.get(i).getAddress()%>
<%=list.get(i).getId()%> <%=list.get(i).getName()%> <%=list.get(i).getGender()%> <%=list.get(i).getPhone()%> <%=list.get(i).getAge()%> <%=list.get(i).getAddress()%>

<% if(pageNum>1){ %> index.jsp?pageNum=<%=(pageNum-1)%>><上一页 <% } while(pageStart<=pageEnd){ if(pageStart==pageNum){ %> index.jsp?pageNum=<%=pageStart%>><%=pageStart %> <% }else if(pageStart%2!=0){ %> index.jsp?pageNum=<%=pageStart%>><%=pageStart %> <% }else{ %> index.jsp?pageNum=<%=pageStart%>><%=pageStart %> <% } pageStart++; } if(pageNum<totalpages){%> index.jsp?pageNum=<%=(pageNum+1)%>>下一页> <% } %>

<%}else{%>

暂时没有数据!

<% } %> <script type=text/javascript> </script>

项目完整下载路径：http://download.csdn.net/detail/gao36951/8859947
效果图如下
这里写图片描述
这里写图片描述这里写图片描述