📄 addadministrator.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="my.shop.db.*"%>
<%-- 会话过滤 --%>
<%@ include file="sessionfilter.jsp" %>
<%
String action = request.getParameter("action");
//定义转发提示信息
List msg = new ArrayList();
if (!"".equals(action) && null != action && "register".equals(action)) {
//表示由表单提交了数据，进行登录处理
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String confirmuserpwd = request.getParameter("confirmuserpwd");
String name = request.getParameter("name");
String address = request.getParameter("address");
String mail = request.getParameter("mail");
String phone = request.getParameter("phone");
//中文乱码处理操作
name = new String(name.getBytes("ISO8859_1"),"GBK");
address = new String(address.getBytes("ISO8859_1"),"GBK");
if ("".equals(username) || null == username) {
msg.add("用户名不能为空，请认真填写！");
} else if ("".equals(userpwd) || null == userpwd) {
msg.add("密码不能为空，请认真填写！");
} else if ("".equals(confirmuserpwd) || null == confirmuserpwd) {
msg.add("确认密码不能为空，请认真填写！");
} else if (!userpwd.equals(confirmuserpwd)) {
msg.add("两次输入的密码不一致，请认真填写！");
}else if ("".equals(name) || null == name) {
msg.add("姓名不能为空，请认真填写！");
} else if ("".equals(address) || null == address) {
msg.add("地址不能为空，请认真填写！");
} else if ("".equals(mail) || null == mail) {
msg.add("邮箱地址不能为空，请认真填写！");
} else if ("".equals(phone) || null == phone) {
msg.add("联系电话不能为空，请认真填写！");
} else {
//数据合法,保存注册信息到数据库中
String sql = "insert into manager(username,userpwd,name,address,mail,phone) values(?,?,?,?,?,?)";
Connection conn = DBConnection.getInstance().getConnection();
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, userpwd);
pstmt.setString(3, name);
pstmt.setString(4, address);
pstmt.setString(5, mail);
pstmt.setString(6, phone);
pstmt.executeUpdate();
out.println("<div align='center'><font color=blue>新管理员添加成功！</font></div><br><a href='addadministrator.jsp'>返回</a>") ;
pstmt.close() ;
conn.close() ;
return ;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>添加用户</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<jsp:include page="top.html"></jsp:include>
<%
if(null != msg && msg.size() > 0){
for(Iterator it = msg.iterator();it.hasNext();){
String m = (String)it.next() ;
%>
<div align="center"><font color=red ><%= m %></font></div><br>
<%
}
}
%>
<form action="addadministrator.jsp" method="post">
<input type="hidden" name="action" value="register">
<table width="302" height="125" border="0" align="center">
<tr>
<td height="26" colspan="5" bgcolor="#3366CC">
<div align="center">
<span class="STYLE1">添加管理员</span>
</div>
</td>
</tr>
<tr>
<td height="24" bgcolor="#899BE4">
用户名：
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="text" name="username" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
密 码：
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="password" name="userpwd" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
确认密码：
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="password" name="confirmuserpwd" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
姓名：
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="text" name="name" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
地址：
</td>
<td colspan="2" bgcolor="#899BE4">
<input name="address" type="text" id="address" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
E-mail:
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="text" name="mail" />
</td>
</tr>
<tr>
<td height="25" bgcolor="#899BE4">
联系电话：
</td>
<td colspan="2" bgcolor="#899BE4">
<input type="text" name="phone" />
</td>
</tr>
<tr>
<td height="23" bgcolor="#899BE4" align="right">
<input type="button" value="管理首页" onClick="javascript:location.href='admin.jsp'">
</td>
<td bgcolor="#899BE4">
<input type="submit" value="添加" />
</td>
<td bgcolor="#899BE4">
<input type="button" value="返回" onClick="javascript:history.back(-1)"/>
</td>
</tr>
</table>
</form>
<hr>
<div align="center"><h3>合法管理员</h3></div>
<table width="1024" border="0" align="center">
<tr>
<td bgcolor="#3366CC"><div align="center">ID</div></td>
<td bgcolor="#3366CC"><div align="center">用户名</div></td>
<td bgcolor="#3366CC"><div align="center">姓名</div></td>
<td bgcolor="#3366CC"><div align="center">E－mail</div></td>
<td bgcolor="#3366CC"><div align="center">联系电话</div></td>
<td bgcolor="#3366CC"><div align="center">删除</div></td>
</tr>
<%
//从数据库中取出当前的合法注册用户信息
String sql = "select * from manager" ;
Connection conn = DBConnection.getInstance().getConnection() ;
PreparedStatement pstmt = conn.prepareStatement(sql) ;
ResultSet rs = pstmt.executeQuery() ;
while(rs.next()){
String id = rs.getString(1) ;
String name = rs.getString(2) ;
%>
<tr>
<td bgcolor="#899BE4"><%=id %></td>
<td bgcolor="#899BE4"><%=name %></td>
<td bgcolor="#899BE4"><%=rs.getString(4) %></td>
<td bgcolor="#899BE4"><%=rs.getString(6) %></td>
<td bgcolor="#899BE4"><%=rs.getString(7) %></td>
<td bgcolor="#899BE4" width="200" align="center">
<%if(!"admin".equals(name)) {%>
<a href="deluser.jsp?id=<%=id %>&table=manager">删除</a>
<%} else{
out.print("此管理员不允许删除");
}%>
</td>
</tr>
<%
}
%>
</table>
<hr>
<div align="center"><h3>合法注册用户</h3></div>
<table width="1024" border="0" align="center">
<tr>
<td bgcolor="#3366CC"><div align="center">ID</div></td>
<td bgcolor="#3366CC"><div align="center">用户名</div></td>
<td bgcolor="#3366CC"><div align="center">姓名</div></td>
<td bgcolor="#3366CC"><div align="center">E－mail</div></td>
<td bgcolor="#3366CC"><div align="center">联系电话</div></td>
<td bgcolor="#3366CC"><div align="center">删除</div></td>
</tr>
<%
//从数据库中取出当前的合法注册用户信息
sql = "select * from user" ;
pstmt = conn.prepareStatement(sql) ;
rs = pstmt.executeQuery() ;
while(rs.next()){
String id = rs.getString(1) ;
%>
<tr>
<td bgcolor="#899BE4"><%=id %></td>
<td bgcolor="#899BE4"><%=rs.getString(2) %></td>
<td bgcolor="#899BE4"><%=rs.getString(4) %></td>
<td bgcolor="#899BE4"><%=rs.getString(6) %></td>
<td bgcolor="#899BE4"><%=rs.getString(7) %></td>
<td bgcolor="#899BE4"><a href="deluser.jsp?id=<%=id %>&table=user">删除</a></td>
</tr>
<%
}
rs.close() ;
pstmt.close() ;
conn.close() ;
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -