📄 addadmin.jsp

📁 用JSP写的一个在线购物网站的代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<script language="JavaScript">
function check()
{
  if(document.addthis.name.value.length==0)
  {
    alert("请输入用户ID");
	document.addthis.name.focus();
	return false;
  }
  if(document.addthis.pwd.value.length==0)
  {
     alert("请填写用户密码");
	 document.addthis.pwd.focus();
	 return false;
  }
  if(document.addthis.pwd.value!=document.addthis.repwd.value)
  {
     alert("请检查您两次输入的密码是否相同");
	 document.addthis.repwd.focus();
	 return false;
  }
  if(document.addthis.system.value=="no")
  {
     alert("请选择该用户系统权限");
	 document.addthis.system.focus();
	 return false;
  }
}
</script>
<title>添加管理员</title>
<body leftmargin="0" topmargin="0">
<form action="" method="post" name="addthis" onSubmit="return check()">
<input type="hidden" name="add" value="">
<table width="250" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td height="20" colspan="3"></td>
  </tr>
  <tr> 
    <td width="100" height="20"><div align="right">用户ID:</div></td>
    <td width="10"></td>
    <td width="140"><input type="text" name="name" size="15" maxlength="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
  </tr>
  <tr> 
    <td height="20"><div align="right">用户密码:</div></td>
    <td></td>
    <td><input type="password" name="pwd" size="15" maxlength="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
  </tr>
  <tr> 
    <td height="20"><div align="right">重复密码:</div></td>
    <td></td>
    <td><input type="password" name="repwd" size="15" maxlength="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></td>
  </tr>
  <tr> 
    <td height="20"><div align="right">系统权限:</div></td>
    <td></td>
    <td><select name="system" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
	         <option value='no' selected>请选择</option>
			 <option value='0'>普通管理员</option>
			 <option value='1'>系统管理员</option>
			 </select></td>
  </tr>
  <tr> 
    <td height="10" colspan="3"></td>
  </tr>
  <tr> 
    <td height="30" colspan="3"><div align="center">
        <input type="submit" value="添加" onClick="document.all.add.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
        <input type="button" value="关闭" onClick="javascript:window.close()" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
      </div></td>
  </tr>
</table>
</form>
<%
String add=request.getParameter("add");
if(add!=null && add.equals("true"))
{
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
String system=request.getParameter("system");
String sql="select * from admin where admin='"+name+"'";
ResultSet rs=data.executeQuery(sql);
if(rs.next())
{%>
<script language="JavaScript">
alert("对不起，该用户已经存在，请另换一个");
</script>
<%}else{
sql="insert into admin(admin,password,system) values(\'"+name+"\',\'"+pwd+"\',\'"+system+"\')";
rs=data.executeQuery(sql);

sql="select * from admin where admin='"+name+"'";
rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="JavaScript">
alert("发成异常错误，请重试");
</script>
<%}else{%>
<div align="center"><font color="#FF0000">添加成功</font></div>
<%}}}%>
⌨️ 快捷键说明

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