pass.jsp

来自「用jsp实现在线留言！采用MVC三层架构！」· JSP 代码 · 共 46 行

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%!String User_Name,Pass_Word,sql;%>
<%
  User_Name=request.getParameter("username");
  User_Name=yy.ex_chinese(User_Name);
  Pass_Word=request.getParameter("password");
  if ((User_Name.equals("")) || (Pass_Word.equals("")))
     response.sendRedirect("err.jsp?id=2");
  else
  {
    Connection con=yy.getConn();
    Statement  stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ResultSet  rs=null;
    sql="Select * From 用户表 Where 用户名='"+User_Name+"' And 用户密码='"+Pass_Word+"'";
    rs=stmt.executeQuery(sql);
    rs.last();
//out.println(sql);
    if (rs.getRow()>0)
    {
       if (rs.getString("认证身份").equals("0"))
		{
	   response.sendRedirect("err.jsp?id=8");
	   return;
	   }
	 
	 session.putValue("UserName",User_Name);
     session.putValue("UserClass",rs.getString("用户等级"));
     sql="update 用户表 set 访问次数=访问次数+1 where 用户名='"+User_Name+"'";
     stmt.executeUpdate(sql);
     response.sendRedirect("index.jsp");
     //out.println(session.getValue("UserClass"));
     //out.println(("<font size=2 color=blue>欢迎您的到来，正在登陆,请稍后...</font><meta http-equiv='refresh' content='2;url=index.jsp'>"));
    }else
    {
      response.sendRedirect("err.jsp?id=4");
    }



  }



%>