?? analysis.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.text.*"%>
<%@ page import="cn.edu.buaa.nlsde.db.*"%>
<%@ page import="cn.edu.buaa.nlsde.md5.MD5"%>
<%request.setCharacterEncoding("GB2312");
String TheMessage = "";
boolean Warning = false;
int CurrentSuggestID = 0;
String SenderName = "";
String ToDepartment = "";
String SuggestionType = "";
String TextofSuggestion = "";
String CurrentStatus = "";
String CurrentComments = "";
String temp = "";
String temp2 = "";
ResultSet RSSuggestion = null;
//判斷用戶是否擁有合法的意見建議號
if (request.getParameter("SuggestionID") == null
&& request.getQueryString().indexOf("SuggestionID") == -1) {
response.sendRedirect("../login.jsp");
}
//連接系統數據庫
//Connection conn = (new DBConnect()).getODBCConn("EIMS");
Connection conn = (new DBConnect()).getConnPoolConn("eims");
Statement stmt = conn.createStatement();
//如果用戶從電子郵件鏈接到此頁面
if (request.getQueryString() != null
&& request.getQueryString().indexOf("SuggestionID") != -1) {
CurrentSuggestID =
new Integer(request.getParameter("SuggestionID")).intValue();
TheMessage = "請在下面進行意見批閱";
}
else {
//如果用戶批閱意見建議
CurrentSuggestID =
new Integer(request.getParameter("SuggestionID")).intValue();
//校驗用戶輸入的批閱
if (!request.getParameter("Comments").trim().equals("")) {
RSSuggestion =
stmt.executeQuery(
"select * from SuggestionRecords where SuggestionID="
+ CurrentSuggestID);
while (RSSuggestion.next()) {
temp = RSSuggestion.getString("ToDepartment");
}
ResultSet RSCommentor =
stmt.executeQuery(
"select * from PSLogins where Department='"
+ temp
+ "' and Position='主管'");
while (RSCommentor.next()) {
temp = RSCommentor.getString("LoginID");
temp2 = RSCommentor.getString("Password");
}
//判斷用戶是否有權批閱
if (request.getParameter("CommentorName").equals(temp)
&& new MD5()
.getMD5ofStr(
request.getParameter("CommentorPassword"))
.equals(temp2)) {
stmt.executeUpdate(
"update SuggestionRecords set Status = '已處理', Comments = '"
+ request.getParameter("Comments")
+ "' where SuggestionID = "
+ request.getParameter("SuggestionID"));
TheMessage = "您已批閱此條意見建議成功";
}
else {
TheMessage = "您無權對這條意見建議進行批閱，請檢查您輸入的姓名和密碼是否正確";
Warning = true;
}
}
else {
TheMessage = "意見建議的回復意見內容不能為空";
Warning = true;
}
CurrentSuggestID =
new Integer(request.getParameter("SuggestionID")).intValue();
}
RSSuggestion =
stmt.executeQuery(
"select * from SuggestionRecords where SuggestionID="
+ CurrentSuggestID);
while (RSSuggestion.next()) {
SenderName = RSSuggestion.getString("SenderName");
ToDepartment = RSSuggestion.getString("ToDepartment");
SuggestionType = RSSuggestion.getString("SuggestionType");
TextofSuggestion = RSSuggestion.getString("SuggestionText");
CurrentStatus = RSSuggestion.getString("Status");
CurrentComments = RSSuggestion.getString("Comments");
}
%>
<HTML>
<HEAD>
<TITLE>公司內部意見箱-處理意見建議</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<body>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
align=center>
<tr bgcolor=white>
<td valign=middle><img src="../image/jsplogo.jpg" width=796 height=100></td>
</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="800"
height="12"></td>
</tr>
</table>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
align=center>
<tr>
<td colspan=3>
<div align="center"><font color=white>公司辦公信息管理系統->內部信息交流系統->意見建議箱->批閱意見建議 [當前用戶-<%=session.getAttribute("Name")%>]
</font></div>
</td>
</tr>
<tr bgcolor=white>
<td align=left><a href=".././html/home.jsp"><font color="#104DAD">返回系統主頁</font></a></td>
<td align=center><%if (Warning == false) {%> <font color="#104DAD"><%=TheMessage%></FONT>
<%}
else {%> <font color=red><%=TheMessage%></FONT> <%}%></td>
<td align=right><a href=javascript:parent.close();><font
color="#104DAD">退出意見批閱頁面</font></a></td>
</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="800"
height="12"></td>
</tr>
</table>
<TABLE CELLPADDING=1 CELLSPACING=2 BORDER=1 bordercolor="#164DA8"
WIDTH=800 align=center>
<TR VALIGN="middle" ALIGN="center">
<TD WIDTH=35% bgcolor=#B5C7EF><img src="../image/messageboard1.jpg"></td>
<td>
<FORM ACTION="analysis.jsp" METHOD=POST><INPUT TYPE=HIDDEN
NAME="SuggestionID" VALUE="<%=CurrentSuggestID%>">
<table width=100% border=1>
<tr>
<td width=30%>意見號</td>
<td><%=CurrentSuggestID%></td>
</tr>
<tr>
<td>意見提交者姓名</td>
<td><%=SenderName%></td>
</tr>
<tr>
<td>意見提往部門</td>
<td><%=ToDepartment%></td>
</tr>
<tr>
<td>意見類型</td>
<td><%=SuggestionType%></td>
</tr>
<tr>
<td>意見內容</td>
<td><%=TextofSuggestion%></td>
</tr>
<tr>
<td>意見狀態</td>
<td><%=CurrentStatus%></td>
</tr>
<tr>
<td>回復意見</td>
<td><TEXTAREA NAME="Comments" rows=10 cols=50><%=CurrentComments%></TEXTAREA></td>
</tr>
<tr>
<td>您的登錄名</td>
<td><Input type=text NAME="CommentorName" Maxlength=50></td>
</tr>
<tr>
<td>您的登錄密碼</td>
<td><Input type=password NAME="CommentorPassword" Maxlength=50></td>
</tr>
<tr>
<td colspan=2 align=center><input type=submit name=SubmitChanges
value="提交意見批閱"
style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</BODY>
</HTML>
<%DBConnectionManager.getInstance().freeConnection("eims", conn);%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -