进度十三(10.31)

部门审核

<%@ 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>
View Code
<%@ 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>
View Code
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();
        }
    }

}
View Code
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;
    }

}
View Code
原文地址:https://www.cnblogs.com/vvxvv/p/14021243.html