重大需求分析开发第四天

新增功能

账号角色分配
修改用户表，添加状态和角色属性
修改权限表，将所为用户改为角色
新增代码


<body>
<div class="container-fluid">
    <form class="form-inline" action="${pageContext.request.contextPath}/mywjQuery" method="post"
          style="margin-top: 5px;">

        <div class="form-group">
            <label>问卷状态：</label>
            <select class="form-control" name="state">
                <option value="0">未审核</option>
                <option value="1">已审核</option>
            </select>
        </div>


        <button type="submit" class="btn btn-default">查询</button>

        <button type="button" class="btn btn-default">
            <a href="${pageContext.request.contextPath}/templete/table.jsp">新需求</a>
        </button>

    </form>


    <table class="table table-bordered table-hover table-striped" style="margin-top: 5px;">

        <thead>
                <tr>
                    <th>序号</th>
                    <th>需求名称</th>
                    <th>机构全称</th>
                    <th>机构属性</th>
                    <th>科技活动类型</th>
                    <th>是否审核</th>
                    <th>审核结果</th>
                    <th>提交日期</th>
                    <th>操作</th>
                </tr>
        </thead>

        <c:forEach items="${list}" var="dc" step="1" varStatus="i">

            <tr>
                <td>${i.index + 1}</td>
                <td>${dc.JSXQMC}</td>
                <td>${dc.JGMC}</td>
                <td>${dc.JGSX}</td>
                <td>${dc.YJLX}</td>
                <td>
                    <c:if test="${dc.SFSH == 0}">
                        未审核
                    </c:if>
                    <c:if test="${dc.SFSH == 1 || dc.SFSH == 2 || dc.SFSH == 3 || dc.SFSH == 4 }">
                        已审核
                    </c:if>
                </td>

                <td>
                    <c:if test="${dc.SFSH == 0}">
                        未审核
                    </c:if>

                    <c:if test="${dc.SFSH == 1 }">
                        形式审核通过
                    </c:if>

                    <c:if test="${dc.SFSH == 2 }">
                        形式审核未通过
                    </c:if>

                    <c:if test="${dc.SFSH == 3 }">
                        部门审核通过
                    </c:if>

                    <c:if test="${dc.SFSH == 4 }">
                        部门审核未通过
                    </c:if>
                </td>

                <td>
                    ${dc.SUBMITDATE}
                </td>

                <td>
                    <a href="${pageContext.request.contextPath}/xsshTableUI?id=${dc.WJID}&way=fljs">
                        查看
                    </a>

                    <c:if test="${dc.SFSH == 2 || dc.SFSH == 4}">
                        |
                        <a href="${pageContext.request.contextPath}/resubmitWjUI?id=${dc.WJID}">
                            修改
                        </a>
                    </c:if>

                    |
                    <a href="${pageContext.request.contextPath}/deleteWj?id=${dc.WJID}">
                        删除
                    </a>

                </td>
            </tr>
        </c:forEach>


    </table>

</div>

</body>
</html>