chklogin.jsp

来自「季风流量统计系统(JSP)是一个数据统计系统」· JSP 代码 · 共 54 行

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />

<%
/*
     季风流量统计系统1.0版(JSP)                   
                                                        
                                                         
     程序作者：季风                                     
                                                        
     QQ:9183838                                         
     E-Mail:[e-mail]                             
     网站:http://www.hxwa.net       
*/	
 String User_Name=request.getParameter("username");
 String Pass_Word=request.getParameter("password");
  if ((User_Name.equals("")) || (Pass_Word.equals("")))
     response.sendRedirect("err.jsp?id=1");
  else
  {
    Connection con=feng.getConn();
    Statement  stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ResultSet  rs=null;
    String sql="Select * From admin Where username='"+User_Name+"' And password='"+Pass_Word+"'";
    rs=stmt.executeQuery(sql);
    rs.last();
    if (rs.getRow()>0)
    {
 	 session.putValue("UserName",User_Name);
	 if (rs.getInt("qx")==1) {
	 session.putValue("admin","ok");
	
     response.sendRedirect("admin.jsp");
	 }
	 else {
      response.sendRedirect("info.jsp?id="+User_Name);
	}
	// <a href="javascript:history.go(-1)"></a>
	 
    }
	else 
        response.sendRedirect("err.jsp?id=2");
	
			 try {
              rs.close();
              stmt.close();
              con.close();
            }
            catch (Exception ex) {
            }
	
  }
%>