addadmin.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
      String username=request.getParameter("username");   
	  String action1=request.getParameter("action");  
	  String password1=request.getParameter("password");
	  String names=request.getParameter("names");


	  if(action1==null){
		  sql="select * from scott.affiche ";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
%>
<form name="form1" method="post" action="addadmin.jsp?action=save">
  <table width="300" border="1" align="center" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
      <td height="25" colspan="2"> <div align="center"><strong>添加管理员</strong></div></td>
    </tr>
    <tr> 
      <td width="78">管理员ID:</td>
      <td width="212"> <input type="text" name="username"> </td>
    </tr>
    <tr> 
      <td>密码:</td>
      <td><input type="password" name="password"></td>
    </tr>
   <tr> 
      <td>确认密码:</td>
      <td><input type="password" name="password1"></td>
    </tr>
    <tr> 
      <td>真实姓名:</td>
      <td><input type="text" name="names"></td>
    </tr>
    <tr> 
      <td colspan="2"><div align="center">
          <input type="submit" name="Submit" value="确定">
          　 
          <input type="reset" name="Submit2" value="重置">
        </div></td>
    </tr>
  </table>
</form>
<%}
 }else{
	  if(action1.equals("save")){		  
	stmt.executeUpdate("INSERT INTO scott.admingly(id,user_name,password,names) VALUES(scott.id.nextval,'"+username+"','"+password1+"','"+names+"')");
	  %>
<table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr> 
    <td height="25" bgcolor="#B1E1F3"> <div align="center"><strong>添加成功</strong></div></td>
  </tr>
  <tr> 
    <td>你可以返回上一页进行查看,你所添加的管理员具有和你一样的权限,请不要随意添加管理员.</td>
  </tr>
  <tr> 
    <td><div align="center"><a href="adminbody.jsp">【返回】</a></div></td>
  </tr>
</table>
<%  }
}  %>
</body>
</html>