?? systemmanager.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="cn.edu.buaa.nlsde.db.*"%>
<%String TheMessage = "";
String temp = "";
//判斷用戶是否登錄以及是否是系統管理員
if (session.getAttribute("ID") == null
|| session.getAttribute("IsSystemManager").equals("False")) {
response.sendRedirect("../login.jsp");
}
//連接系統數據庫
//Connection conn = (new DBConnect()).getODBCConn("EIMS");
Connection conn = (new DBConnect()).getConnPoolConn("eims");
Statement stmt = conn.createStatement();
ResultSet EmployeeInformation =
stmt.executeQuery(
" select * from PSLogins order by "
+ session.getAttribute("SystemOrder"));
//添加新用戶信息
if (request.getParameter("Add") != null) {
response.sendRedirect("addnewuser.jsp");
}
//刪除某個用戶信息
else if (request.getParameter("Delete") != null) {
if (request.getParameter("SelectWho") != null) {
stmt.executeUpdate(
"delete from PSLogins where LoginID = '"
+ request.getParameter("SelectWho")
+ "'");
TheMessage = "記錄已被刪除";
EmployeeInformation =
stmt.executeQuery("select * from PSLogins order by Name");
}
}
//修改某個用戶信息
else if (request.getParameter("Modify") != null) {
if (request.getParameter("SelectWho") != null) {
session.setAttribute(
"temp",
request.getParameter("SelectWho"));
response.sendRedirect("modifyuserinformation.jsp");
}
}
else {
TheMessage = "請在下面修改員工信息";
}
%>
<HTML>
<HEAD>
<TITLE>系統管理員頁面</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../theme/Master.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY BGCOLOR="">
<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=100% 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><a href="../html/home.jsp"><font color="#164DA8">返回系統主頁</font></a></td>
<td align=center><font color="#164DA8"><%=TheMessage%></FONT></td>
<td align=right><a href="employeeinformation.jsp"><font
color="#164DA8">返回上一級網頁</font></a></td>
</tr>
</table>
<table width="100%" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="100%"
height="12"></td>
</tr>
</table>
<br>
<FORM ACTION="systemmanager.jsp" METHOD=POST class="little">
<TABLE WIDTH=100% border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
align=center>
<TR>
<TD COLSPAN=14 align=center><font color=white>全部員工信息如下</font></TD>
</TR>
<TR VALIGN="middle" ALIGN="center" bgcolor=white>
<td>選中</td>
<td>登錄名</td>
<td>姓名</td>
<td>電子郵件地址</td>
<td>部門</td>
<td>職位</td>
<td>內部分機</td>
<td>家庭電話</td>
<td>手機</td>
<td>MSN</td>
<td>家庭住址</td>
<td>是否系統管理員</td>
<td>生日</td>
<td>是否財務主管</td>
</TR>
<%while (EmployeeInformation.next()) {
temp = EmployeeInformation.getString(2);
out.println(
"<tr bgcolor=white> <td align=center><input type=radio name=SelectWho value="
+ temp
+ "> </td> <td align=center><font face=arial>"
+ temp
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(3)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(5)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(6)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(7)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(8)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(9)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(10)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(11)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(12)
+ "</font></td> <td align=left><font face=arial>"
+ EmployeeInformation.getString(13)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(14).substring(0, 10)
+ "</font></td> <td align=center><font face=arial>"
+ EmployeeInformation.getString(15)
+ "</font></td></tr>");
}%>
</TABLE>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=1 WIDTH=100% align=center>
<TR VALIGN="top" ALIGN="center">
<TD WIDTH=100% align=center><INPUT TYPE="submit" NAME="Modify"
VALUE="修改此用戶信息"
style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
<INPUT TYPE="submit" NAME="Delete" VALUE="刪除此用戶信息"
style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
<INPUT TYPE="submit" NAME="Add" VALUE="添加新用戶信息"
style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB"></TD>
</TR>
</table>
</FORM>
</body>
</html>
<%DBConnectionManager.getInstance().freeConnection("eims", conn);%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -