代码展示
<%--Created by IntelliJ IDEA.User: 11637Date: 2020/4/10Time: 13:00To 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%>页  第<%=xpage%>页  共<%=totalpages%>  跳转到</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\">  <input type=\"button\" value=\"首 页\" <%=(xpage==1)?\"disabled\":\"\"%> onclick=\"gn(<%=1%>)\"/>  <input type=\"button\" value=\"上一页\" <%=(xpage==1)?\"disabled\":\"\"%> onclick=\"gn(<%=xpage-1%>)\"/>  <input type=\"button\" value=\"下一页\" <%=(xpage==totalpages)?\"disabled\":\"\"%> onclick=\"gn(<%=xpage+1%>)\"/>  <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>
- 效果展示
爱站程序员基地
