新增功能
- 账号角色分配
- 修改用户表，添加状态和角色属性
- 修改权限表，将所为用户改为角色
新增代码
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
Created by IntelliJ IDEA.
User: 79413
Date: 2020/10/15
Time: 8:50
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Title</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" rel="stylesheet">
<!-- jQuery (Bootstrap 的所有 JavaScript 插件都依赖 jQuery，所以必须放在前边) -->
<script src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js"></script>
<!-- 加载 Bootstrap 的所有 JavaScript 插件。你也可以根据需要只加载单个插件。 -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js"></script>
</head>
<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>
