super_admin_user_adddo.jsp

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

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
    String superadmin_book_Loginmessage=(String)session.getValue("superadmin_book_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(superadmin_book_Loginmessage!="OK")
    {
	response.sendRedirect("../index.html");
    }
%>
<jsp:useBean class="manage_sys.manage_sys" id="super_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 dzzl="";
	String device=""; 
	book=request.getParameter("book");
	dzzl=request.getParameter("dzzl");
	device=request.getParameter("device");
	//out.print(book+dzzl);
	String SQL="select * from admin_sys where adminID='"+username+"'";
	ResultSet Rs=super_admin_user_adddo.executeQuery(SQL);
	if(Rs.next())
	{%>
<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("已经存在同名用户！");
	window.location.href("super_admin_user_index.jsp");
	//-->
</SCRIPT>
	<%}
	else{
    String sql="insert into admin_sys(adminID,password,book,dzzl,device) values('"+username+"','"+password+"','"+book+"','"+dzzl+"','"+device+"')";
    super_admin_user_adddo.executeUpdate(sql);
	}
%>
<SCRIPT LANGUAGE="JavaScript">
	<!--
	alert("添加用户成功！");
	window.location.href("super_admin_user_index.jsp");
	//-->
</SCRIPT>