科技政策查询系统
index.jsp
<%--
Created by IntelliJ IDEA.
User: 榕宝
Date: 2022/10/25
Time: 14:01
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>河北省科技政策查询系统</title>
<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>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="renderer" content="webkit">
<link href="css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
<link href="css/font-awesome.min.css?v=4.4.0" rel="stylesheet">
<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css?v=4.1.0" rel="stylesheet">
<style>
.biaoti{
font-family:"幼圆";/*设置字体*/
font-size:30px;/*设置字体大小*/
font-weight:900;/*调整字体粗细*/
color:#136dab;
}
</style>
</head>
<body class="fixed-sidebar full-height-layout gray-bg" style="overflow:hidden">
<div style="width:100%;height:90px; ">
<div style="width: 330px;height: 80px; margin:auto;">
<p> </p>
<div style="width: 70px;height: 70px;background: url(LOGO.png); background-size:cover ;text-align: center;float:left"></div>
<div style="float:left">
<p class="biaoti"> 科技政策查询系统</p>
</div></div>
</div>
<div id="wrapper" style="width:100%;height:100%;margin: auto; ">
<!--左侧导航开始-->
<nav class="navbar-default navbar-static-side" role="navigation">
<div class="sidebar-collapse" >
<ul class="nav" id="side-menu">
<li>
<a class="J_menuItem" href="layouts.html"><i class="fa fa-columns"></i> <span class="nav-label">政策查询</span></a>
</li>
<li>
<a href="#"><i class="fa fa-flask"></i> <span class="nav-label">政策分类</span><span class="fa arrow"></span></a>
<ul class="nav nav-second-level">
<li><a class="J_menuItem" href="table2.jsp?id=100">综合(87)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=200">科研机构改革(17)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=300">科研计划管理(93)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=400">科研经费与财务(39)</a>
</li>
<li>
<a href="#">基础研究与科研基地(108) <span class="fa arrow"></span></a>
<ul class="nav nav-third-level">
<li><a class="J_menuItem" href="table2.jsp?id=501">基础研究(29)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=502">平台基地(79)</a>
</li>
</ul>
</li>
<li>
<a href="#">企业技术进步与高新科技(137) <span class="fa arrow"></span></a>
<ul class="nav nav-third-level">
<li><a class="J_menuItem" href="table2.jsp?id=601">企业(85)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=602">产业(27)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=603">创新载体(25)</a>
</li>
</ul>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=700">农村科技与社会发展(29)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=800">科技人才(39)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=900">科技中介服务(17)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=1000">科技条件与标准(2)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=1100">科技金融与税收(30)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=1200">科技成果与知识产权(84)</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=1300">科技奖励（18）</a>
</li>
<li><a class="J_menuItem" href="table2.jsp?id=1400">科学技术普及（10）</a>
</li>
</ul>
</li>
<li>
<a class="J_menuItem" href="layouts.html"><i class="fa fa-desktop"></i> <span class="nav-label">退出系统</span></a>
</li>
</ul>
</div>
</nav>
<!--左侧导航结束-->
<!--右侧部分开始-->
<div id="page-wrapper" class="gray-bg dashbard-1">
<div class="row content-tabs">
<button class="roll-nav roll-left J_tabLeft"><i class="fa fa-backward"></i>
</button>
<nav class="page-tabs J_menuTabs">
<div class="page-tabs-content">
<a href="javascript:;" class="active J_menuTab" data-id="index_v1.html">首页</a>
</div>
</nav>
<button class="roll-nav roll-right J_tabRight"><i class="fa fa-forward"></i>
</button>
<div class="btn-group roll-nav roll-right">
<button class="dropdown J_tabClose" data-toggle="dropdown">关闭操作<span class="caret"></span>
</button>
<ul role="menu" class="dropdown-menu dropdown-menu-right">
<li class="J_tabShowActive"><a>定位当前选项卡</a>
</li>
<li class="divider"></li>
<li class="J_tabCloseAll"><a>关闭全部选项卡</a>
</li>
<li class="J_tabCloseOther"><a>关闭其他选项卡</a>
</li>
</ul>
</div>
<a href="login.html" class="roll-nav roll-right J_tabExit"><i class="fa fa fa-sign-out"></i> 退出</a>
</div>
<div class="row J_mainContent" id="content-main">
<iframe class="J_iframe" name="iframe0" width="100%" height="100%" src="../index_v1.html?v=4.0" frameborder="0" data-id="index_v1.html" seamless></iframe>
</div>
<div class="footer">
<div class="pull-right">© 2014-2015 <a href="http://www.zi-han.net/" target="_blank">zihan's blog</a>
</div>
</div>
</div>
<!--右侧部分结束-->
<!--右侧边栏开始-->
<!-- 全局js -->
<script src="js/jquery.min.js?v=2.1.4"></script>
<script src="js/bootstrap.min.js?v=3.3.6"></script>
<script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>
<script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
<script src="js/plugins/layer/layer.min.js"></script>
<!-- 自定义js -->
<script src="js/hplus.js?v=4.1.0"></script>
<script type="text/javascript" src="js/contabs.js"></script>
<!-- 第三方插件 -->
<script src="js/plugins/pace/pace.min.js"></script>
</div>
</body>
</html>
layouts.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Title</title>
<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>
<div style="width:100%;height:65px;float:left; position:relative; display: table-cell;vertical-align: middle; color: rgb(128, 0, 0); font-family: consolas, "Source Code Pro", monaco, monospace !important; font-size: 16px !important;">">
<form class="layui-form"action="table1.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=" color: rgb(128, 0, 0); font-family: consolas, "Source Code Pro", monaco, monospace !important; font-size: 16px !important;">">查询</button>
</div>
</div>
</div>
</form>
</div>
<div class="container3">
<iframe id="myIframe1" name="hideIframe1" style="" src="table1.jsp" frameborder="0" width="100%" height="850px"></iframe>
</div>
</body>
</html>
table1.jsp
<%--
Created by IntelliJ IDEA.
User: 榕宝
Date: 2022/10/25
Time: 15:14
To change this template use File | Settings | File Templates.
--%>
<%@ page import="Bean.bean" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.List" %>
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Title</title>
<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>
<jsp:useBean id="util" class="Dao.dao"/>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
String name=request.getParameter("name");
String document=request.getParameter("document");
String organ=request.getParameter("organ");
%>
<%if (name == null||document==null||organ==null){
List<bean> list = util.searchAll();
%>
<table class="layui-table"style="table-layout: fixed;word-wrap:break-word;" >
<thead>
<tr>
<td style="width: 300px">政策名称</td>
<td style="width: 150px">发文机构</td>
<td style="width: 70px">颁布日期</td>
<td style="width: 80px">政策分类</td>
<td style="width: 100px">操作</td>
</tr>
</thead>
<tbody>
<%for (bean b : list) {%>
<tr>
<td style="width: 300px"><%=b.getName()%></td>
<td style="width: 150px"><%=b.getOrgan()%></td>
<td style="width: 70px"><%=b.getPubdata()%></td>
<td style="width: 80px"><%=b.getType()%></td>
<td style="width: 100px"><a href="xiangqing.jsp?id=<%=b.getId()%>"><button type="submit" class="layui-btn"style=" color: rgb(128, 0, 0); font-family: consolas, "Source Code Pro", monaco, monospace !important; font-size: 16px !important;">" >查看详情</button></a> </td>
</tr>
<%} %>
</tbody>
</table>
<%}else{
List<bean> list = util.search(name,document,organ);
%>
<div class="container3" id="container3">
<table class="layui-table"style="table-layout: fixed;word-wrap:break-word;" >
<thead>
<tr>
<td style="width: 200px">政策名称</td>
<td style="width: 150px">发文机构</td>
<td style="width: 100px">颁布日期</td>
<td style="width: 150px">政策分类</td>
<td style="width: 100px">操作</td>
</tr>
</thead>
<tbody>
<%for (bean b : list) {%>
<tr>
<td style="width: 200px"><%=b.getName()%></td>
<td style="width: 150px"><%=b.getOrgan()%></td>
<td style="width: 100px"><%=b.getPubdata()%></td>
<td style="width: 150px"><%=b.getType()%></td>
<td style="width: 100px"><a href="xiangqing.jsp?id=<%=b.getId()%>"><button type="submit" class="layui-btn"style=" color: rgb(128, 0, 0); font-family: consolas, "Source Code Pro", monaco, monospace !important; font-size: 16px !important;">">查看详情</button></a> </td>
</tr>
<%} %>
<p><a href="javascript:history.go(-1);"><button class="layui-btn"style=" color: rgb(128, 0, 0); font-family: consolas, "Source Code Pro", monaco, monospace !important; font-size: 16px !important;">">返回</button></a> </p>
</tbody>
</table>
</div>
<%}%>
</html>
Dao.dao.java
package Dao;
import Bean.Menu;
import Bean.bean;
import Bean.policy;
import DBUtil.dbutil;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.Reader;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class dao {
public List<bean> searchAll( ){
List<bean> list = new ArrayList<bean>();
try {
Connection conn = dbutil.getConn();
Statement state = null;
String sql="select * from policy";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
System.out.println("搜索全部政策");
while(rs.next()){
bean lu = new bean();
lu.setId(rs.getString("id"));
lu.setType(rs.getString("type"));
lu.setOrgan(rs.getString("organ"));
lu.setPubdata(rs.getString("pubdata"));
lu.setName(rs.getString("name"));
list.add(lu);
}
rs.close();
pstmt.close();
conn.close();
}catch(SQLException e) {
System.out.println("发生错误");
e.printStackTrace();
}
return list;
}
public List<bean> search(String name,String document,String organ){
List<bean> list = new ArrayList<bean>();
try {
Connection conn = dbutil.getConn();
Statement state = null;
String sql = "select * from policy where name REGEXP '"+name+"' and document REGEXP '"+document+"' and organ REGEXP '"+organ+"'";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
System.out.println("多项条件搜索运行中");
while(rs.next()){
bean lu = new bean();
lu.setId(rs.getString("id"));
lu.setType(rs.getString("type"));
lu.setOrgan(rs.getString("organ"));
lu.setPubdata(rs.getString("pubdata"));
lu.setName(rs.getString("name"));
list.add(lu);
}
rs.close();
pstmt.close();
conn.close();
}catch(SQLException e) {
System.out.println("发生错误");
e.printStackTrace();
}
return list;
}
public static bean getOne(String id){
bean lu = new bean();
try {
Connection conn = dbutil.getConn();
Statement state = null;
String sql="select * from policy where id=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1,id);
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
lu.setId(rs.getString("id"));
lu.setType(rs.getString("type"));
lu.setCategory(rs.getString("category"));
lu.setOrgan(rs.getString("organ"));
lu.setPubdata(rs.getString("pubdata"));
lu.setName(rs.getString("name"));
lu.setDocument(rs.getString("document"));
lu.setRange(rs.getString("range"));
lu.setPerdata(rs.getString("perdata"));
lu.setViadata(rs.getString("viadata"));
lu.setText(rs.getString("text"));
}
rs.close();
pstmt.close();
conn.close();
}
catch(SQLException e) {
e.printStackTrace();
}
return lu;
}
}
Bean.bean.java
package Bean;
public class bean {
private String id;
private String name;//
private String type;//
private String category;
private String range;
private String document;
private String organ;//
private String viadata;
private String pubdata;//
private String perdata;
Menu menu;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getCategory() {
return category;
}
public void setCategory(String category) {
this.category = category;
}
public String getRange() {
return range;
}
public void setRange(String range) {
this.range = range;
}
public String getDocument() {
return document;
}
public void setDocument(String document) {
this.document = document;
}
public String getOrgan() {
return organ;
}
public void setOrgan(String organ) {
this.organ = organ;
}
public String getViadata() {
return viadata;
}
public void setViadata(String viadata) {
this.viadata = viadata;
}
public String getPubdata() {
return pubdata;
}
public void setPubdata(String pubdata) {
this.pubdata = pubdata;
}
public String getPerdata() {
return perdata;
}
public void setPerdata(String perdata) {
this.perdata = perdata;
}
}
Bean.Menu.java
package Bean;
import java.util.List;
public class Menu {
private Integer id;
private String type;
private List<Menu> bean;
public Menu(Integer id,Integer pid,String type)
{
this.id =id;
this.type= type;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
@Override
public String toString() {
return "Menu{" +
"id=" + id +
", type='" + type + '\'' +
", bean=" + bean +
'}';
}
public List<Menu> getBean(){
return bean;
}
public void setBean(List<Menu> bean) {
this.bean = bean;
}
}
DBUtil.dbutil.java
package DBUtil;
import java.sql.*;
public class dbutil {
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; //数据库驱动名
static final String url = "jdbc:mysql://localhost:3306/policy";//数据库地址
static final String user = "root";
static final String password = "123456";
//连接数据库
public static Connection getConn () {
Connection conn = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
//关闭连接
public static void close (PreparedStatement preparedState, Connection conn) {
if (preparedState != null) {
try {
preparedState.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close (ResultSet rs, PreparedStatement preparedState, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (preparedState != null) {
try {
preparedState.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 关闭连接
* @param state
* @param conn
*/
public static void close (Statement state, Connection conn) {
if (state != null) {
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close (ResultSet rs, Statement state, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (state != null) {
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//测试是否连接成功
public static void main(String[] args) throws SQLException {
Connection conn = getConn();
PreparedStatement preparedStatement = null;
ResultSet rs = null;
String sql ="select * from policy limit 10";//数据库名称
preparedStatement = conn.prepareStatement(sql);
rs = preparedStatement.executeQuery();
if(rs.next()){
System.out.println("数据库不为空");
}
else{
System.out.println("数据库为空");
}
}
}
