团队冲刺个人博客3

今日代码:

test1.jsp

<%--
  Created by IntelliJ IDEA.
  User: pangshaohang
  Date: 2023/4/10
  Time: 16:04
  To change this template use File | Settings | File Templates.
--%>
<%@ 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 = 11;//每页显示行数
            //总共分几页
            if(num/pageSize > parseInt(num/pageSize)){
                totalPage=parseInt(num/(pageSize-1))+1;
            }else{
                totalPage=parseInt(num/(pageSize-1));
            }
            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 onLoad="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="jieguo1.jsp" method="post" target="hideIframe1" >
        <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="jieguo1.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/test";
                String USERNAME = "root";
                String PWD = "123456";

                //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 WHERE name LIKE ? AND document LIKE ? AND organ LIKE ? ORDER BY id DESC " ;

                    pstmt=connection.prepareStatement(sql);

                    pstmt.setString(1, "%"+a+"%");
                    pstmt.setString(2, "%"+b+"%");
                    pstmt.setString(3, "%"+c+"%");







                    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);%></a></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>

 

posted @ 2023-04-19 21:44  庞司令  阅读(27)  评论(0)    收藏  举报