admin_user_adddo.jsp

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

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
    String admin_book_Loginmessage=(String)session.getValue("admin_book_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(admin_book_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 book="";
	//String superadmin=new String(request.getParameter("superadmin").getBytes("8859_1")); 
	String SQL="select * from admin_sys where adminID='"+username+"'";// and (book='admin' or book='user')";
	ResultSet Rs=admin_user_adddo.executeQuery(SQL);
	if(Rs.next())
	{
	book=Rs.getString("book");
	Rs.close();
	if(book.equals("admin")||book.equals("user")){%>
<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("已经存在同名用户！");
	window.location.href("admin_user_index.jsp");
	//-->
</SCRIPT>
	<%}
	else{
	//if(book.equals("0")){
	String sql_up="update admin_sys set book='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,book) 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>
	<%
	}
%>