admin_user_adddo.jsp

用JSP实现的 满好的 大家支持哦 大家多多支持

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
    String admin_device_Loginmessage=(String)session.getValue("admin_device_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(admin_device_Loginmessage!="OK")
    {
	response.sendRedirect("../../index.html");
    }
%>
<jsp:useBean class="manage_sys.manage_sys" id="admin_user_adddo" scope="page"></jsp:useBean>
<%
    String username=new String(request.getParameter("username").getBytes("8859_1"));   
	String password=new String(request.getParameter("password2").getBytes("8859_1")); 
	String device="";
	String SQL="select * from admin_sys where adminID='"+username+"'";
	ResultSet Rs=admin_user_adddo.executeQuery(SQL);
	if(Rs.next())
	{
	device=Rs.getString("device");
	Rs.close();

	if(device.equals("admin")||device.equals("user")){%>
<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("已经存在同名用户！");
	window.location.href("admin_user_index.jsp");
	//-->
</SCRIPT>
	<%}
	else{
	//if(device.equals("0")){
	String sql_up="update admin_sys set device='user' where adminID='"+username+"'";
	admin_user_adddo.executeUpdate(sql_up);%>
<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("该用户存已经在，现在成功添加了该用户本模块的使用功能，但密码不能改变！！");
	window.location.href("admin_user_index.jsp");
	//-->
</SCRIPT>
					   <%//}
	        }
	}
else{
	String sql="insert into admin_sys(adminID,password,superadmin,device) values('"+username+"','"+password+"','0','user')";
    admin_user_adddo.executeUpdate(sql);
	String Sql="insert into my_user(adminID) values('"+username+"')";
    admin_user_adddo.executeUpdate(Sql);
	%>
	<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("添加用户成功！");
	window.location.href("admin_user_index.jsp");
	//-->
</SCRIPT>
	<%
	}
	
%>