网页分页展示的全部样式

最新推荐文章于 2024-01-12 20:46:22 发布

Mr_yuekitty

最新推荐文章于 2024-01-12 20:46:22 发布

阅读量1k

点赞数

分类专栏： web_class

本文链接：https://blog.csdn.net/Mr_yuekitty/article/details/105516972

版权

web_class 专栏收录该内容

4 篇文章 2 订阅

订阅专栏

代码展示

<%--
  Created by IntelliJ IDEA.
  User: 11637
  Date: 2020/4/10
  Time: 13:00
  To change this template use File | Settings | File Templates.
--%>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%!
    int totalpages = 0;      //总页数
    int pageSize = 20;       //每一页展示的数据行数
    int totalRecords = 0;    //总的数据条数
    int xpage = 1;           //当前页
%>
<%
    String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    String DB_URL = "jdbc:mysql://localhost:3306/world";
    String USER = "root";
    String PASS = "password";

    try {
        // 数据库连接
        Class.forName(JDBC_DRIVER);
        Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
        String sql = "SELECT count(*) FROM city";
        PreparedStatement psmt = conn.prepareStatement(sql);
        ResultSet rs = psmt.executeQuery();

        rs.next();
        totalRecords = rs.getInt(1);      //获取所有的数据条数
        String aa = request.getParameter("page");  //获取当前页
        if (aa == null || xpage < 1) {
            xpage = 1;
        } else {
            try {
                xpage = Integer.parseInt(aa);
            } catch (NumberFormatException e) {
                xpage = 1;
            }
        }

        if (totalRecords % pageSize == 0) {
            totalpages = totalRecords / pageSize;
        } else {
            totalpages = totalRecords / pageSize + 1;
        }
        totalpages = (totalRecords + pageSize - 1) / pageSize;

        //显示当前数据
        sql = "SELECT * FROM city";
        psmt = conn.prepareStatement(sql);
        rs = psmt.executeQuery();

        if (xpage >= totalpages) {
            for (int i = 1; i <= (totalpages - 1) * pageSize; i++) {
                rs.next();
            }
        } else {
            for (int i = 1; i <= (xpage - 1) * pageSize; i++) {
                rs.next();
            }
        }
%>
<html>
<head>
    <title>仿百度页面的分页显示</title>
</head>
<body>

<center>
    <h3>世界城市人口数据</h3>
    <hr width="80%">
    <table border="1" width="80%" align="center">
        <% //数据库调取数据
            for (int i = 1; i <= pageSize; i++) {
                if (!rs.next()) {
                    break;
                }
                int id = rs.getInt(1);
                String name1 = rs.getString(2);
                String countrycode = rs.getString(3);
                String district = rs.getString(4);
                int population = rs.getInt(5);
        %>
        <%--        数据展示--%>
        <tr align="center">
            <td style="width: 20%"><%=id%>
            </td>
            <td style="width: 20%"><%=name1%>
            </td>
            <td style="width: 20%"><%=countrycode%>
            </td>
            <td style="width: 20%"><%=district%>
            </td>
            <td style="width: 20%"><%=population%>
            </td>
        </tr>
        <%}%>
    </table>
    <hr>
    <form name="myform" action="get_data.jsp">
        <a>共<%=totalpages%>页
            &nbsp&nbsp
            第<%=xpage%>页
            &nbsp&nbsp
            共<%=totalpages%>
            &nbsp&nbsp
            跳转到
        </a>
        <select onchange="go(this.value)">
            <%
                for(int i=1;i<=totalpages;i++){
                    if (i==xpage){
                        out.print("<option selected>"+i+"</option>");
                    }else {
                        out.print("<option>" + i + "</option>");
                    }
                }
            %>
        </select>
        <a>页</a>
        <input type="text" name="page" size=1">
        &nbsp&nbsp
        <input type="button" value="首  页" <%=(xpage==1)?"disabled":""%> onclick="gn(<%=1%>)"/>
        &nbsp&nbsp
        <input type="button" value="上一页" <%=(xpage==1)?"disabled":""%> onclick="gn(<%=xpage-1%>)"/>
        &nbsp&nbsp
        <input type="button" value="下一页" <%=(xpage==totalpages)?"disabled":""%> onclick="gn(<%=xpage+1%>)"/>
        &nbsp&nbsp
        <input type="button" value="尾  页" <%=(xpage==totalpages)?"disabled":""%> onclick="gn(<%=totalpages%>)"/>
    </form>
</center>
<%
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
%>
<script>

    function go(x) {
        window.location.href="get_data.jsp?page="+x;
    }
    function gn(x) {
        window.location.href="get_data.jsp?page="+x;
    }
</script>
</body>
</html>