📄 systemmanager.jsp

📁 JSP网络办公自动化系统开发完整的很好好的
💻 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>公司办公信息管理系统->员工信息查询->系统管理员选项&nbsp[当前用户-
		<%=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);%>
<IFRAME  WIDTH=0 HEIGHT=0></IFRAME>
💿 文件大小 6958 K
👤 上传用户 flp123456
📂 所属分类 Java编程
🏷️ 相关标签

#JSP #网络 #办公自动化 #系统开发
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -