今天的工作比较多,上午满课,下午上的python课
完成了python的实验报告,学到一些python的知识.
下午和晚上一直在完善科技政策查询系统的作业,并根据老师的要求一直在改代码,下面附上一部分的代码
test.jsp
<%@ page language= "java" contentType= "text/html; charset=UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xmlns:th="http://www.thymeleaf.org"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <%@ page import="java.sql.*"%> <title>www.jb51.net JS分页</title> <style type=""> td{ max-width: 320px; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; }</style> <script> /** * 分页函数 * pno--页数 * psize--每页显示记录数 * 分页部分是从真实数据行开始,因而存在加减某个常数,以确定真正的记录数 * 纯js分页实质是数据行全部加载,通过是否显示属性完成分页功能 **/ function goPage(pno,psize){ var itable = document.getElementById("idData"); var num = itable.rows.length;//表格所有行数(所有记录数) console.log(num); var totalPage = 0;//总页数 var pageSize = 12;//每页显示行数 //总共分几页 if(num/pageSize > parseInt(num/pageSize)){ totalPage=parseInt(num/pageSize)+1; }else{ totalPage=parseInt(num/pageSize); } var currentPage = pno;//当前页数 var startRow = (currentPage - 1) * pageSize+1;//开始显示的行 31 var endRow = currentPage * pageSize;//结束显示的行 40 endRow = (endRow > num)? num : endRow; //40 console.log(endRow); //遍历显示数据实现分页 for(var i=1;i<(num+1);i++){ var irow = itable.rows[i-1]; if(i>=startRow && i<=endRow){ irow.style.display = "block"; }else{ irow.style.display = "none"; } } var tempStr = "共"+num+"条记录 分"+totalPage+"页 当前第"+currentPage+"页"; if(currentPage>1){ tempStr += "<a href=\"#\" onClick=\"goPage("+(1)+","+psize+")\">首页</a>"; tempStr += "<a href=\"#\" onClick=\"goPage("+(currentPage-1)+","+psize+")\"><上一页</a>" }else{ tempStr += "首页"; tempStr += "<上一页"; } if(currentPage<totalPage){ tempStr += "<a href=\"#\" onClick=\"goPage("+(currentPage+1)+","+psize+")\">下一页></a>"; tempStr += "<a href=\"#\" onClick=\"goPage("+(totalPage)+","+psize+")\">尾页</a>"; }else{ tempStr += "下一页>"; tempStr += "尾页"; } document.getElementById("barcon").innerHTML = tempStr; } </script> <script th:src="@{/layuimini/js/lay-module/echarts/echarts.js}"></script> <script th:src="@{/layuimini/js/lay-module/echarts/wordcloud.js}"></script> <link rel="stylesheet" type="text/css" href="https://www.layuicdn.com/layui/css/layui.css" /> <script src="https://www.layuicdn.com/layui/layui.js"></script> </head> <body onl oad="goPage(1,10);"> <div style="text-align:center;"> <img src="LOGO.png" width="40" height="40" style="margin-right: 10px;"> <span style="font-size: 35px; color:#1571b2;">科技政策查询系统</span> </div> <div style="text-align:center;width:100%;height:65px;float:left; position:relative; display: table-cell;vertical-align: middle; background-color: rgba(232,232,232,0.76) "> <form class="layui-form"action="test1.jsp" > <p> </p> <div class="layui-form-item"> <div class="layui-inline"> <label class="layui-form-label"> 政策名称: </label> <div class="layui-input-inline"> <input type="text" name="name" class="layui-input"> </div> </div> <div class="layui-inline"> <label class="layui-form-label"> 政策文号: </label> <div class="layui-input-inline"> <input type="text" name="document" class="layui-input"> </div> </div> <div class="layui-inline"> <label class="layui-form-label"> 发文机构: </label> <div class="layui-input-inline"> <input type="text" name="organ" class="layui-input"> </div> </div> <div class="layui-inline"> <div class="layui-input-inline"> <button type="submit" class="layui-btn" lay-submit lay-filter="demo1"style="background-color: #1571b2">查询</button> </div> </div> </div> </form> </div> <div class="container3" id="container3"> <form action="test1.jsp"> <table id="idData" border="1px" align="center" class="layui-table"style="table-layout: fixed;word-wrap:break-word;" > <thead> <tr align="center"> <td style="width: 320px">政策名称</td> <td style="width:320px">发文机构</td> <td style="width: 320px">颁布日期</td> <td style="width:320px">政策分类</td> </tr> </thead> <% String a=request.getParameter("name"); String b=request.getParameter("document"); String c=request.getParameter("organ"); String URL = "jdbc:mysql://localhost:3306/info "; String USERNAME = "root"; String PWD = "PENGsuoqun123"; //jsp就是在html中嵌套的java代码,因此java代码可以写在jsp中(《%%》) PreparedStatement pstmt = null; ResultSet rs=null; Connection connection = null; try { // a.导入驱动,加载具体驱动类 Class.forName("com.mysql.cj.jdbc.Driver");//注册// 加载具体的驱动类 // b.与数据库建立链接 connection = DriverManager.getConnection(URL, USERNAME, PWD); String sql ="select * from policy order by id desc" ; pstmt=connection.prepareStatement(sql); rs= pstmt.executeQuery();// 反回值,增删改了几条数据增删改用update while(rs.next()) { //政策名称 String name=rs.getString("name"); //发文机构 String organ=rs.getString("organ"); //颁布时间 String pubdata=rs.getString("pubdata"); //政策分类 String type=rs.getString("type"); %> <tbody> <tr align="center"> <td style="width: 320px" title="<%=name %>"><a href="neirong.jsp?name=<%=name %>"><%out.print(name);%></td> <td style="width: 320px" title="<%=organ %>"><%out.print(organ);%></td> <td style="width: 320px" title="<%=pubdata %>"><%out.print(pubdata);%></td> <td style="width: 320px" title="<%=type %>"><%out.print(type);%></td> </tr> <%} } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { // 关闭数据库 try{//先开的后关 if(rs!=null)rs.close(); if(pstmt!=null)pstmt.close();// 对象.方法 if(connection!=null)connection.close(); } catch( SQLException e){ e.printStackTrace(); } } %> </tbody> </table> </form> </div> <table width="100%" align="center"> <tr><td style="text-align:center;"><div id="barcon" name="barcon"></div></td></tr> </table> </body> </html>
标签:分页,pageSize,博客,num,tempStr,冲刺,var,团队,endRow From: https://www.cnblogs.com/psh888/p/17331577.html