guard.jsp

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

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB2312"%>

<jsp:useBean class="manage_sys.manage_sys" id="book_log" scope="page"></jsp:useBean>
<%    
    String adminID=request.getParameter("adminID");
    String password=request.getParameter("password");
	
	String sql="select * from admin_sys where adminID='"+adminID+"' and password='"+password+"'";
    ResultSet rs=book_log.executeQuery(sql);
    if(rs.next()){
    int superadmin=Integer.parseInt(rs.getString("superadmin"));
	String book=rs.getString("book");
	String dzzl=rs.getString("dzzl");
	String lwzl=rs.getString("lwzl");
	String device=rs.getString("device");
	String xmgl=rs.getString("xmgl");
	String rygl=rs.getString("rygl");
	//out.print(dzzl);
	if (superadmin==2)
	{
	session.putValue("adminID",adminID);
	session.putValue("superadmin_book_loginSign","OK");
	session.putValue("superadmin_dzzl_loginSign","OK");
	session.putValue("superadmin_lwzl_loginSign","OK");
	session.putValue("superadmin_device_loginSign","OK");
	session.putValue("superadmin_xmgl_loginSign","OK");
	session.putValue("superadmin_rygl_loginSign","OK");
	response.sendRedirect("book/admin/super_admin_user_index.jsp");
	}
	else
	{
	//out.print(superadmin);
	session.putValue("book_loginSign",book);
	//session.putValue("book_loginSign","OK");
	//String book_Loginmessage=(String)session.getValue("book_loginSign");
	//out.print(book_Loginmessage+" "+book);
	session.putValue("dzzl_loginSign",dzzl);
	session.putValue("lwzl_loginSign",lwzl);
	session.putValue("device_loginSign",device);
	session.putValue("xmgl_loginSign",xmgl);
	session.putValue("rygl_loginSign",rygl);
	String book_Loginmessage=(String)session.getValue("book_loginSign");
	String dzzl_Loginmessage=(String)session.getValue("dzzl_loginSign");
	String lwzl_Loginmessage=(String)session.getValue("lwzl_loginSign");
	String device_Loginmessage=(String)session.getValue("device_loginSign");
	String xmgl_Loginmessage=(String)session.getValue("xmgl_loginSign");
	String rygl_Loginmessage=(String)session.getValue("rygl_loginSign");
	//out.print(book_Loginmessage+dzzl_Loginmessage+lwzl_Loginmessage+device_Loginmessage+xmgl_Loginmessage+rygl_Loginmessage);
	response.sendRedirect("guard.jsp");
	}
					}
	/*else{
    String sql="select * from admin_sys where adminID='"+adminID+"' and password='"+password+"' and door='book'";
    ResultSet rs=book_log.executeQuery(sql);
    if(rs.next()){
	int superadmin =rs.getInt("superadmin");
        rs.close();
        book_log.closeStmt();
        book_log.closeConn();
        session.putValue("book_loginSign","OK");
        session.putValue("adminID",adminID);
	if (radiobutton==superadmin)
	  {
    if (radiobutton == 0 ){
	session.putValue("book_loginSign","OK");
	response.sendRedirect("book_index.jsp");
	}
   else{
    session.putValue("admin_book_loginSign","OK");
	response.sendRedirect("admin/admin_book_index.jsp");
	  }
	 }
	else
	{
	  //response.sendRedirect("error.html");
	  %><SCRIPT LANGUAGE="JavaScript">
				<!--
				alert("您选择的登录类型错误，请重新选择!");
				window.location.href("book.jsp");
				//-->
				</SCRIPT><%
	}
	}*/
    else{
        rs.close();
        book_log.closeStmt();
        book_log.closeConn();%>
		<SCRIPT LANGUAGE="JavaScript">
				<!--
				alert("管理员代码或密码错误！");
				window.location.href("book.jsp");
				//-->
		</SCRIPT>
		<%
        //String msg="管理员代码或密码错误！";
        //session.putValue("login_message",msg);
	//response.sendRedirect("book.jsp");
	}
%>