<%
String logrole=request.getParameter("logrole");
String logname=request.getParameter("logname");
String pwd=request.getParameter("password");
String sql;
String userID;
ResultSet rs;
if(logrole.equals("admin"))
{
sql="Select * from admin where adminName='"+logname+"' and adminPassword="+"'"+pwd+"'";
rs=stmt.executeQuery(sql);
if(rs.next())
    {
        userID=String.valueOf(rs.getInt("adminID"));        session.setAttribute("userID",userID);
        session.setAttribute("loginname",rs.getString("adminName"));
        session.setAttribute("userType","admin");        out.print("<script language=javascript>");
        out.print("alert('登陆成功!');");
        out.print("location.href='adminmain.jsp';");
        out.print("</script>");        //response.sendRedirect("adminmain.jsp");
    }
    rs.close();
}
%>