部门审核
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/4.3.1/css/bootstrap.min.css"> <script src="https://cdn.staticfile.org/jquery/3.2.1/jquery.min.js"></script> <script src="https://cdn.staticfile.org/popper.js/1.15.0/umd/popper.min.js"></script> <script src="https://cdn.staticfile.org/twitter-bootstrap/4.3.1/js/bootstrap.min.js"></script> <script> i = 1; function insert() { if (i<12){ var j=i; i++; var newtr = tbl.insertRow(); var newTd0 = newtr.insertCell(); var newTd1 = newtr.insertCell(); var newTd2 = newtr.insertCell(); var newTd3 = newtr.insertCell(); newTd0.innerHTML="<select name='yhf'>" + "<option value='binghan'>并含</option>" + "<option value='huohan'>或含</option>" + "<option value='buhan'>不含</option>" + "</select>"; newTd1.innerHTML="<select name='name'>" + "<option value='jgqc'>机构全称</option>" + "<option value='gkglbm'>归口管理部门</option>" + "<option value='szdy'>所在地域</option>" + "<option value='frdb'>法人代表</option>" + "<option value='lxr'>联系人</option>" + "<option value='jgsx'>机构属性</option>" + "<option value='jsxqmc'>技术需求名称</option>" + "<option value='gjz'>关键字</option>" + "<option value='ntrjeze'>拟投入金额总额</option>" + "<option value='jsxqjjfs'>技术需求解决方式</option>" + "<option value='kjhdlx'>科技活动类型</option>" + "<option value='xkfl'>学科分类</option>" + "<option value='xqjsssly'>需求技术所属领域</option>" + "<option value='xqjsyyhy'>需求技术应用行业</option>" + "<option value='glch'>管理处室</option>" + ">"; newTd2.innerHTML="<input type='text'name='value'>"; newTd3.innerHTML="<select name='jingmo'>" + "<option value='jingque'>精确</option>" + "<option value='mohu'>模糊</option>" + ">"; } } function deltr() { if (i!=1){ tbl.deleteRow(i+1); i--; } } </script> <title></title> </head> <body> <form action="SelectServlet" method="post"> <table id="tbl"> <tr> <td></td> </tr> <tr> <td> <input type="button" onclick="insert()" value="添加" /> </td> <td> <input type="button" onclick="deltr()" value="删除" /> </td> </tr> <tr> <td> <select name='yhf'> <option value='binghan'>并含</option> <option value='buhan'>不含</option> </select> </td> <td> <select name='name'> <option value='jgqc'>机构全称</option> <option value='gkglbm'>归口管理部门</option> <option value='szdy'>所在地域</option> <option value='frdb'>法人代表</option> <option value='lxr'>联系人</option> <option value='jgsx'>机构属性</option> <option value='jsxqmc'>技术需求名称</option> <option value='gjz'>关键字</option> <option value='ntrjeze'>拟投入金额总额</option> <option value='jsxqjjfs'>技术需求解决方式</option> <option value='kjhdlx'>科技活动类型</option> <option value='xkfl'>学科分类</option> <option value='xqjsssly'>需求技术所属领域</option> <option value='xqjsyyhy'>需求技术应用行业</option> <option value='glch'>管理处室</option> </select> </td> <td> <input type='text'name='value'> </td> <td> <select name='jingmo'> <option value='jingque'>精确</option> <option value='mohu'>模糊</option> </select> </td> </tr> </table> <input type="submit" value="查询"> </form> <div align="center"> <table class="table table-hover table-striped table-bordered table-sm" id="resultshow"> <tr> <td>技术需求名称</td> <td>形式审核状态</td> <td>部门审核状态</td> <td>部门审核</td> </tr> <c:forEach items="${table}" var="item"> <tr> <td><a href="AdminServlet?method=getTheTableById&id=${item.wjid}">${item.jsxqmc}</a></td> <td>${item.xssh}</td> <td>${item.bmsh}</td> <td><a href="BMSHServlet?method=BSTheTableById&id=${item.wjid}" onclick="return check('${item.bmsh}','${item.xssh}')">审核</a></td> </tr> </c:forEach> </table> </div> </body> <script type="text/javascript"> function check(bmsh,xssh) { if(xssh=="通过"){ if (bmsh=="未审核"){ return true; }else{ alert("该需求已被审核"); return false; } }else{ alert("该需求未通过形式审核"); return false; } } </script> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/4.3.1/css/bootstrap.min.css"> <script src="https://cdn.staticfile.org/jquery/3.2.1/jquery.min.js"></script> <script src="https://cdn.staticfile.org/popper.js/1.15.0/umd/popper.min.js"></script> <script src="https://cdn.staticfile.org/twitter-bootstrap/4.3.1/js/bootstrap.min.js"></script> <title></title> <style type="text/css"> .title{ 100%; text-align:center; margin-top:20px; } .left{ 10%; text-align:center; top:50%; } .right{ 30%; broder:1px solid; text-align:center; top:50%; } .write{ border: 0; 100%; height: 100%; margin: 0; padding: 0; } </style> </head> <body> <% Object table = request.getAttribute("table"); if(table!=null && !"".equals(table)){} %> <div class="title"><h2>河北省重大技术需求征集表</h2></div> <form action="BMSHServlet?method=BSTheTable" method="post"> <table border="1" align="center" width="60%"> <tr> <td hidden><input type="text" id="wjid" name="wjid" value="${table.wjid}"></td> </tr> <tr> <td class="left">*机构全称</td> <td colspan="2" class="right"><input class="write" type="text" name="jgqc" id="jgqc" value="${table.jgqc}" readonly></td> <td class="left">归口管理部门</td> <td colspan="2"><input class="write" type="text" name="gkglbm" id="gkglbm" value="${table.gkglbm}" readonly></td> </tr> <tr> <td class="left">*通讯地址</td> <td colspan="2" class="right"><input class="write" type="text" name="txdz" id="txdz" value="${table.txdz}" readonly></td> <td class="left">*所在地域</td> <td colspan="2"><input class="write" type="text" name="szdy" id="szdy" value="${table.szdy}" readonly></td> </tr> <tr> <td class="left">网址</td> <td colspan="2" class="right"><input class="write" type="text" name="wz" id="wz" value="${table.wz}" readonly></td> <td class="left">*电子信箱</td> <td colspan="2"><input class="write" type="text" name="dzxx" id="dzxx" value="${table.dzxx}" readonly></td> </tr> <tr> <td class="left">*法人代表</td> <td colspan="2" class="right"><input class="write" type="text" name="frdb" id="frdb" value="${table.frdb}" readonly></td> <td class="left">邮政编码</td> <td colspan="2"><input class="write" type="text" name="yzbm" id="yzbm" value="${table.yzbm}" readonly></td> </tr> <tr> <td class="left">*联系人</td> <td class="right" colspan="2"><input class="write" type="text" name="lxr" id="lxr" value="${table.lxr}" readonly></td> <td class="left">固定电话</td> <td colspan="2"><input class="write" type="text" name="gddh" id="gddh" value="${table.gddh}" readonly></td> </tr> <tr> <td class="left">*手机</td> <td colspan="2"><input class="write" type="text" name="sj" id="sj" value="${table.sj}" readonly></td> <td class="left">传真</td> <td colspan="2"><input class="write" type="text" name="cz" id="cz" value="${table.cz}" readonly></td> </tr> <tr> <td class="left">*机构属性</td> <td class="right" colspan="5"><input class="write" type="text" name="jgsx" id="jgsx" value="${table.jgsx}" readonly></td> </tr> <tr> <td colspan="6">*机构简介</td> </tr> <tr> <td colspan="6" height="100px"> <div class="formControls col-xs-8 col-sm-9"> <textarea name="jgjj" id="jgjj" cols="100" rows="5" class="textarea" placeholder="${table.jgjj}" readonly></textarea> </div> </td> </tr> <tr> <td class="left">*技术需求名称</td> <td class="right" colspan="2"><input class="write" type="text" name="jsxqmc" value="${table.jsxqmc}" readonly></td> <td class="left">*需求时限</td> <td class="right" colspan="2"><input class="write" type="text" name="qsxqsx" value="${table.qsxqsx}" readonly>年-<input class="write" type="text" name="jzxqsx" value="${table.jzxqsx}" readonly>年</td> </tr> <tr> <td colspan="6">*技术需求概述</td> </tr> <tr> <td colspan="6" height="150px"> <div class="formControls col-xs-8 col-sm-9"> <textarea name="jsxqgs" cols="100" rows="5" class="textarea" placeholder="${table.jsxqgs}" readonly></textarea> </div> </td> </tr> <tr> <td class="left">关键字</td> <td class="right" colspan="5"><input class="write" type="text" name="gjz" id="gjz" value="${table.gjz}" readonly></td> </tr> <tr> <td class="left">拟投入金额总额</td> <td class="right" colspan="5"><input dir="rtl" style=" 50%;border: 0" type="text" name="ntrjeze" id="ntrjeze" value="${table.ntrjeze}" readonly>万元</td> </tr> <tr> <td class="left" rowspan="2">*技术需求解决方式</td> <td class="right" colspan="5"><input class="write" type="text" name="jsxqjjfs" value="${table.jsxqjjfs}" readonly></td> </tr> <tr> <td class="left" colspan="2">合作意向单位(选填)</td> <td class="right" colspan="3"><input class="write" type="text" name="hzyxdw" value="${table.hzyxdw}" readonly></td> </tr> <tr> <td class="left">*科技活动类型</td> <td class="right" colspan="5"><input class="write" type="text" name="kjhdlx" value="${table.kjhdlx}" readonly></td> </tr> <tr> <td class="left">学科分类</td> <td class="right" colspan="5"><input class="write" type="text" name="xkfl" value="${table.xkfl}" readonly></td> </tr> <tr> <td class="left">需求技术所属领域</td> <td class="right" colspan="5"><input class="write" type="text" name="xqjsssly" value="${table.xqjsssly}" readonly></td> </tr> <tr> <td class="left">其他技术</td> <td class="right" colspan='5'><input class="write" type='text' name='qtjs' value='${table.qtjs}' readonly></td> </tr> <tr> <td class="left">需求技术应用行业</td> <td class="right" colspan='5'><input class="write" type='text' name='xqjsyyhy' value="${table.xqjsyyhy}" readonly></td> </tr> <tr> <td class="left">部门审核状态</td> <td class="right" colspan='5'> <input type="radio" name="bmsh" value="通过"> 通过 <input type="radio" name="bmsh" value="不通过"> 不通过 </td> </tr> <tr> <td colspan="6">部门审核意见</td> </tr> <tr> <td colspan="6" height="150px"> <div class="formControls col-xs-8 col-sm-9"> <textarea name="bmyj" cols="100" rows="5" class="textarea"></textarea> </div> </td> </tr> <tr> <td colspan="6"><div align="center"><input type="submit" value="完成" onclick="return check()"></div></td> </tr> </table> </form> </body> <script type="text/javascript"> function check() { if (confirm("确认审核已完成?")){ return true; }else{ return false; } } </script> </html>
package servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import bean.Table; import dao.AdminDao; import dao.BMSHDao; @WebServlet("/BMSHServlet") public class BMSHServlet extends HttpServlet { private static final long serialVersionUID = 1L; public BMSHServlet() { super(); // TODO Auto-generated constructor stub } protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String method = request.getParameter("method"); if ("BSAllTable".equals(method)) { BSAllTable(request, response); } else if ("BSTheTableById".equals(method)) { BSTheTableById(request, response); } else if ("BSTheTable".equals(method)) { BSTheTable(request, response); } else if ("BSMyTable".equals(method)) { BSMyTable(request, response); } } private void BSAllTable(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ request.setCharacterEncoding("utf-8"); List<Table> table = BMSHDao.listtable(); request.setAttribute("table", table); request.getRequestDispatcher("shenhe/bsalltable.jsp").forward(request,response); } private void BSMyTable(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ request.setCharacterEncoding("utf-8"); HttpSession session = request.getSession(); String zzjgdm = (String) session.getAttribute("zzjgdm"); System.out.println("BSMyTable:glcs="+zzjgdm); List<Table> table = BMSHDao.listmytable(zzjgdm); request.setAttribute("table", table); request.getRequestDispatcher("shenhe/bsalltable.jsp").forward(request,response); } private void BSTheTableById(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ request.setCharacterEncoding("utf-8"); int id = Integer.parseInt(request.getParameter("id")); Table table = AdminDao.getTheTableById(id); request.setAttribute("table", table); request.getRequestDispatcher("shenhe/bsthetable.jsp").forward(request,response); } private void BSTheTable(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); String wjid1=request.getParameter("wjid"); int wjid=Integer.parseInt(wjid1); String bmsh=request.getParameter("bmsh"); String bmyj=request.getParameter("bmyj"); Table table = new Table(); table.setWjid(wjid); table.setBmsh(bmsh); table.setBmyj(bmyj); try{ BMSHDao.XSTheTableById(table); request.setAttribute("message", "修改成功"); request.getRequestDispatcher("BMSHServlet?method=BSMyTable").forward(request,response); }catch(Exception e){ System.out.println("保存失败"); e.printStackTrace(); } } }
package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import bean.Table; import util.DBUtil; public class BMSHDao { public static List<Table> listtable() { String sql = "select * from t_table"; List<Table> list2 = new ArrayList<>(); Connection conn = DBUtil.getConnection(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { Table table = new Table(); int wjid = rs.getInt("wjid"); String jsxqmc = rs.getString("jsxqmc"); String jgqc = rs.getString("jgqc"); String gkglbm = rs.getString("gkglbm"); String szdy = rs.getString("szdy"); String frdb = rs.getString("frdb"); String lxr = rs.getString("lxr"); String jgsx = rs.getString("jgsx"); int ntrjeze = rs.getInt("ntrjeze"); String jsxqjjfs = rs.getString("jsxqjjfs"); String kjhdlx = rs.getString("kjhdlx"); String xkfl = rs.getString("xkfl"); String xqjsssly = rs.getString("xqjsssly"); String xqjsyyhy = rs.getString("xqjsyyhy"); String glcs = rs.getString("glcs"); String xssh = rs.getString("xssh"); String bmsh = rs.getString("bmsh"); table.setWjid(wjid); table.setJsxqmc(jsxqmc); table.setJsxqjjfs(jsxqjjfs); table.setKjhdlx(kjhdlx); table.setGkglbm(gkglbm); table.setJgqc(jgqc); table.setLxr(lxr); table.setSzdy(szdy); table.setFrdb(frdb); table.setJgsx(jgsx); table.setNtrjeze(ntrjeze); table.setXkfl(xkfl); table.setXqjsssly(xqjsssly); table.setXqjsyyhy(xqjsyyhy); table.setGlcs(glcs); table.setXssh(xssh); table.setBmsh(bmsh); list2.add(table); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list2; } public static List<Table> listmytable(String zzjgdm) { String sql = "select * from t_table where bmsh = '未审核' and glcs = '"+zzjgdm+"'"; List<Table> list2 = new ArrayList<>(); Connection conn = DBUtil.getConnection(); Statement state = null; ResultSet rs = null; try { state = conn.createStatement(); rs = state.executeQuery(sql); while (rs.next()) { Table table = new Table(); int wjid = rs.getInt("wjid"); String jsxqmc = rs.getString("jsxqmc"); String jgqc = rs.getString("jgqc"); String gkglbm = rs.getString("gkglbm"); String szdy = rs.getString("szdy"); String frdb = rs.getString("frdb"); String lxr = rs.getString("lxr"); String jgsx = rs.getString("jgsx"); int ntrjeze = rs.getInt("ntrjeze"); String jsxqjjfs = rs.getString("jsxqjjfs"); String kjhdlx = rs.getString("kjhdlx"); String xkfl = rs.getString("xkfl"); String xqjsssly = rs.getString("xqjsssly"); String xqjsyyhy = rs.getString("xqjsyyhy"); String glcs = rs.getString("glcs"); String xssh = rs.getString("xssh"); String bmsh = rs.getString("bmsh"); table.setWjid(wjid); table.setJsxqmc(jsxqmc); table.setJsxqjjfs(jsxqjjfs); table.setKjhdlx(kjhdlx); table.setGkglbm(gkglbm); table.setJgqc(jgqc); table.setLxr(lxr); table.setSzdy(szdy); table.setFrdb(frdb); table.setJgsx(jgsx); table.setNtrjeze(ntrjeze); table.setXkfl(xkfl); table.setXqjsssly(xqjsssly); table.setXqjsyyhy(xqjsyyhy); table.setGlcs(glcs); table.setXssh(xssh); table.setBmsh(bmsh); list2.add(table); } } catch (SQLException e) { e.printStackTrace(); } finally { DBUtil.close(rs, state, conn); } return list2; } public static boolean XSTheTableById(Table table) { Connection conn = DBUtil.getConnection(); boolean flag = false; try { String sql = "update t_table set bmsh = '"+table.getBmsh() + "', bmyj = '"+table.getBmyj() + "' where wjid = '"+table.getWjid()+"'"; System.out.println(sql); PreparedStatement pstmt = conn.prepareStatement(sql); int i = pstmt.executeUpdate(); pstmt.close(); conn.close(); if(i>0) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } }