adminlogin.jsp

研究生周考核系统

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%
  String name = new String(request.getParameter("username").getBytes("iso-8859-1"));
  String pass = new String(request.getParameter("password").getBytes("iso-8859-1"));
  String rand = (String)session.getAttribute("rand");
  String useryz = request.getParameter("useryz");
  if (rand.equals(useryz))
     {
    String sql="select * from  sysuser where name='"+name+"' and password='"+pass+"'";
    ResultSet rs=stmt.executeQuery(sql);
    
	    //rs.next();
	 if (rs.next())
	    {
		String id=rs.getString("ID");
		String type=rs.getString("type");
		String password=rs.getString("password");
		session.setAttribute("bianma",id);
	    session.setAttribute("name",name);
	    session.setAttribute("type",type);
		session.setAttribute("password",password);
	    out.print("<script language='javascript'>");
	    //out.print("alert('成功');");
		out.print("window.location.href='../sys/xuanze.jsp';");
	    out.print("</script>");
	    out.close();
	    }
	 else
	   {
  	     out.print("<script>");
         out.print("alert('用户名或密码错误');");
         out.print("window.location.href='index.jsp';");
         out.print("</script>");		   
		}

	 stmt.close(); 
     conn.close();
	}
  else
	{
  	     out.print("<script>");
         out.print("alert('验证码输入有误!请核对!');");
         out.print("window.location.href='index.jsp';");
         out.print("</script>"); 
         conn.close();
	}
%>