-
Notifications
You must be signed in to change notification settings - Fork 0
/
detail2.jsp
143 lines (137 loc) · 6.39 KB
/
detail2.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<%--
Created by IntelliJ IDEA.
User: 陈星潼
Date: 2017/8/26
Time: 14:29
To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="Jonathan.SQLConnection" %>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!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>
<!-- Bootstrap CSS 文件 -->
<link rel="stylesheet" href="./static/bootstrap/css/bootstrap.min.css">
</head>
<body>
<%
String id=request.getParameter("id");
Integer standardid = Integer.valueOf(id).intValue();
%>
<sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbgirl?useUnicode=true&characterEncoding=utf-8"
user="root" password="111"/>
<sql:query var="result" dataSource="${snapshot}">
select *from standard where FileId = <%=standardid%>;
<%--<%Integer.valueOf(proposalid).intValue();%>--%>
</sql:query>
<sql:query var="result3" dataSource="${snapshot}">
select *from userinfo where UserId = (select UserId from logininfo where UName='<%=session.getAttribute("user_now")%>')
</sql:query>
<!-- 头部 -->
<div class="jumbotron">
<div class="container">
<div class="row">
<div class="col-md-7">
<h2>BJUT</h2>
<p>能力示范文稿管理系统</p>
</div>
<div class="col-md-5">
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature==2}">
<h3>欢迎您!专委会管理员:<c:out value="${row.Name}"/></h3>
<button class="btn btn-warning" onclick="window.location.href='lay_loginout.jsp';">注销</button>
</c:if>
</c:forEach>
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature==1}">
<h3>欢迎您!写者:<c:out value="${row.Name}"/></h3>
<button class="btn btn-warning" onclick="window.location.href='lay_loginout.jsp';">注销</button>
</c:if>
</c:forEach>
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature==3}">
<h3>欢迎您!行业分会管理员:<c:out value="${row.Name}"/></h3>
<button class="btn btn-warning" onclick="window.location.href='lay_loginout.jsp';">注销</button>
</c:if>
</c:forEach>
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature==4}">
<h3>欢迎您!研究会管理员:<c:out value="${row.Name}"/></h3>
<button class="btn btn-warning" onclick="window.location.href='lay_loginout.jsp';">注销</button>
</c:if>
</c:forEach>
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature==5}">
<h3>欢迎您!系统管理员:<c:out value="${row.Name}"/></h3>
<button class="btn btn-warning" onclick="window.location.href='lay_loginout.jsp';">注销</button>
</c:if>
</c:forEach>
</div>
</div>
</div>
</div>
<!-- 中间内容区局 -->
<div class="container">
<div class="row">
<!-- 左侧菜单区域 -->
<div class="col-md-3">
<div class="list-group">
<a href="index.jsp" class="list-group-item active">所有提案</a>
<a href="personal.jsp" class="list-group-item">我的提案</a>
<a href="form.jsp" class="list-group-item">提案编制</a>
<a href="form2.jsp" class="list-group-item">规范编制</a>
<a href="myinfo.jsp" class="list-group-item">个人信息</a>
<a href="standardmanage.jsp" class="list-group-item">我的规范</a>
<a href="myreferrer.jsp" class="list-group-item">我的推荐</a>
<c:forEach var="row" items="${result3.rows}">
<c:if test="${row.Feature!=1}">
<a href="personmanage.jsp" class="list-group-item">申请管理</a>
<a href="proposalmanage.jsp" class="list-group-item">提案管理</a>
<a href="allstandardmanage.jsp" class="list-group-item">规范管理</a>
</c:if>
</c:forEach>
</div>
</div>
<!-- 右侧内容区域 -->
<div class="col-md-9">
<!-- 自定义内容区域 -->
<div class="panel panel-default">
<div class="panel-body">
<div class="jumbotron">
<th><c:out value="${row.id}"/> </th>
<c:forEach var="row" items="${result.rows}">
<h4 style="text-align: center"><c:out value="${row.Title}"></c:out></h4>
<p style="margin-bottom: 100px;font-size: medium;"><c:out value="${row.Content}"></c:out></p>
</c:forEach>
<!--<textarea class="form-control" rows="6" >你的想法</textarea>-->
<!--<p style="padding-top: 10px;display: inline-block;"><a class="btn btn-primary btn-lg" href="#" role="button">附议</a></p>-->
<!--<p style="display: inline-block;"><a class="btn btn-primary btn-lg" href="#" role="button">反对</a></p>-->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- 尾部 -->
<div class="jumbotron" style="margin:0;">
<div class="container">
<span> @2017 BJUT</span>
</div>
</div>
<!-- jQuery 文件 -->
<script src="./static/jquery/jquery.min.js"></script>
<!-- Bootstrap JavaScript 文件 -->
<script src="./static/bootstrap/js/bootstrap.min.js"></script>
</body>
</html>