checklogon.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");
	session.putValue("adminID",adminID);
	if (superadmin==1)
	{
	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("superadmin/super_admin_user_index.jsp");
	}
	else
	{
	session.putValue("book_login_guard",book);
	session.putValue("dzzl_login_guard",dzzl);
	session.putValue("lwzl_login_guard",lwzl);
	session.putValue("device_login_guard",device);
	session.putValue("xmgl_login_guard",xmgl);
	session.putValue("rygl_login_guard",rygl);
	response.sendRedirect("book/book_index.jsp");
	}
		}

    else{
        rs.close();
        book_log.closeStmt();
        book_log.closeConn();%>
		<SCRIPT LANGUAGE="JavaScript">
				<!--
				alert("管理员代码或密码错误！");
				window.location.href("index.html");
				//-->
		</SCRIPT>
		<%

	}
%>