团队冲刺第一天

今天进行了课堂测试，做了一个科技政策查询系统，初步构思了团队项目的步骤

<%@ page import="java.util.ArrayList"%>
<%@ page import="hhh.finaBean"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>河北省科技政策查询</title>
</head>
<body>
    <form action="Servlet">
        <table align="center">
        <tr align="center"><td align="center" colspan="9"><img src="LOGO.jpg" width="20" height="20">科技政策查询系统</td></tr>
            <tr>
                <td>政策名称</td>
                <td><input type="text" name="name" placeholder="请输入政策名称"></td>
                <td>发文字号</td>
                <td><input type="text" name="document" placeholder="请输入发文字号"></td>
                <td>发文机构</td>
                <td><input type="text" name="organ"></td>
                <td>全文检索</td>
                <td><input type="text" name="text"></td>
                <td><input type="submit" value="查询" /></td>
            </tr>
        </table>
    </form>
</body>
</html>

<%@ page import="java.util.ArrayList"%>
<%@ page import="hhh.finaBean"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>科技政策查询</title>
<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 = psize;//每页显示行数
  //总共分几页
  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>
</head>
<body onLoad="goPage(1,10);">
    <form action="Servlet">
        <table align="center">
        <tr align="center"><td align="center" colspan="9"><img src="LOGO.jpg" width="20" height="20">科技政策查询系统</td></tr>
            <tr>
                <td>政策名称</td>
                <td><input type="text" name="name" placeholder="请输入政策名称"></td>
                <td>发文字号</td>
                <td><input type="text" name="document" placeholder="请输入发文字号"></td>
                <td>发文机构</td>
                <td><input type="text" name="organ"></td>
                <td>全文检索</td>
                <td><input type="text" name="text"></td>
                <td><input type="submit" value="查询" />
            </tr>
        </table>
    </form>
        <table id="idData" width="1510" border="0px">
            <tr width="100%">
                <th  width=302>政策名称</th>
                <th  width=302>发文机构</th>
                <th width=302>颁布日期</th>
                <th  width=302>政策分类</th>
                <th  width=302>操作</th>
            </tr>
            <%
            response.setContentType("text/html;charset=UTF-8");

            ArrayList<finaBean> arr = (ArrayList<finaBean>) request.getAttribute("routeMain");

            for (int i = 0; i < arr.size(); i++) {

                finaBean subwayBean = new finaBean();
                subwayBean.s = arr.get(i).s;
                subwayBean.d = arr.get(i).d;
                subwayBean.e = arr.get(i).e;
                subwayBean.q = arr.get(i).q;
                subwayBean.a = arr.get(i).a;
            %>

            <tr>
                <td align="center" width=20%><%=subwayBean.s%></td>
                <td align="center" width=20%><%=subwayBean.d%></td>
                <td align="center" width=20%><%=subwayBean.e%></td>
                <td align="center" width=20%><%=subwayBean.a%></td>
                <td align="center" width=20%><a href = see.jsp?num=<%=subwayBean.s%>>查看</a></td>

            </tr>


            <%
            }
            %>
        </table>
        <table width="60%" align="right">
    <tr><td><div id="barcon" name="barcon"></div></td></tr>
  </table>
</body>
</html>

<%@ page import="java.util.ArrayList"%>
<%@ page import="hhh.finaBean"%>
<%@ page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>科技政策查询</title>
</head>
<body>
<%String type1=request.getParameter("num");
String URL = "jdbc:mysql://localhost:3306/www";
String USERNAME = "root";
String PWD = "1234";
Connection connection = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {

    // 1、导入驱动，加载具体驱动类
    Class.forName("com.mysql.cj.jdbc.Driver");
    // 2、与数据库建立连接
    connection = DriverManager.getConnection(URL, USERNAME, PWD);
    // 3、发送sql，执行增
    String sql = "select * from policy where name like ?";
    pstmt = connection.prepareStatement(sql);// 预处理
    pstmt.setString(1, "%"+type1+"%");


    rs = pstmt.executeQuery();
    while (rs.next()) {

        String text = rs.getString("text");
        out.print(text);
    }

} 
catch (ClassNotFoundException e) {
    e.printStackTrace();
    
} catch (SQLException e) {
    e.printStackTrace();
    
} catch (Exception e) {
    e.printStackTrace();

} finally {
    try {
        if (pstmt != null)
            pstmt.close();
        if (connection != null)
            connection.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }

}
%>


</body>
</html>

posted @ 2023-04-11 21:48 lcz111 阅读(26) 评论(0) 收藏举报

刷新页面返回顶部

LCZ

团队冲刺第一天

公告