?? 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");
//定義轉(zhuǎn)發(fā)提示信息
List msg = new ArrayList();
if (!"".equals(action) && null != action && "register".equals(action)) {
//表示由表單提交了數(shù)據(jù)，進行登錄處理
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("聯(lián)系電話不能為空，請認真填寫！");
} else {
//數(shù)據(jù)合法,保存注冊信息到數(shù)據(jù)庫中
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">
聯(lián)系電話：
</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">聯(lián)系電話</div></td>
<td bgcolor="#3366CC"><div align="center">刪除</div></td>
</tr>
<%
//從數(shù)據(jù)庫中取出當(dāng)前的合法注冊用戶信息
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">聯(lián)系電話</div></td>
<td bgcolor="#3366CC"><div align="center">刪除</div></td>
</tr>
<%
//從數(shù)據(jù)庫中取出當(dāng)前的合法注冊用戶信息
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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -