www.pudn.com > Hotel.rar > login2_jsp.java

package org.apache.jsp; 
 
import javax.servlet.*; 
import javax.servlet.http.*; 
import javax.servlet.jsp.*; 
import java.sql.*; 
 
public final class login2_jsp extends org.apache.jasper.runtime.HttpJspBase 
    implements org.apache.jasper.runtime.JspSourceDependent { 
 
  private static java.util.List _jspx_dependants; 
 
  public Object getDependants() { 
    return _jspx_dependants; 
  } 
 
  public void _jspService(HttpServletRequest request, HttpServletResponse response) 
        throws java.io.IOException, ServletException { 
 
    JspFactory _jspxFactory = null; 
    PageContext pageContext = null; 
    HttpSession session = null; 
    ServletContext application = null; 
    ServletConfig config = null; 
    JspWriter out = null; 
    Object page = this; 
    JspWriter _jspx_out = null; 
    PageContext _jspx_page_context = null; 
 
 
    try { 
      _jspxFactory = JspFactory.getDefaultFactory(); 
      response.setContentType("text/html; charset=gb2312"); 
      pageContext = _jspxFactory.getPageContext(this, request, response, 
      			"", true, 8192, true); 
      _jspx_page_context = pageContext; 
      application = pageContext.getServletContext(); 
      config = pageContext.getServletConfig(); 
      session = pageContext.getSession(); 
      out = pageContext.getOut(); 
      _jspx_out = out; 
 
      out.write("\r\n"); 
      out.write("\r\n"); 
      myhotel.MyConn MyConn = null; 
      synchronized (session) { 
        MyConn = (myhotel.MyConn) _jspx_page_context.getAttribute("MyConn", PageContext.SESSION_SCOPE); 
        if (MyConn == null){ 
          MyConn = new myhotel.MyConn(); 
          _jspx_page_context.setAttribute("MyConn", MyConn, PageContext.SESSION_SCOPE); 
        } 
      } 
      out.write("  \r\n"); 
 
String user=request.getParameter("user"); 
 
String password=request.getParameter("password"); 
 
String sql="select * from admin where username='"+user+"' and password='"+password+"'" ; 
 
 
 
 ResultSet rs=MyConn.executeQuery(sql);    
if(rs.next()) 
{ 
 
 session.setAttribute("username", user); 
 session.setAttribute("password", password); 
  MyConn.close();   
  out.print("登陆成功"); 
} 
else{ 
 out.print( "登陆失败"); 
} 
 
 
 
      out.write("\r\n"); 
      out.write("\r\n"); 
    } catch (Throwable t) { 
      if (!(t instanceof SkipPageException)){ 
        out = _jspx_out; 
        if (out != null && out.getBufferSize() != 0) 
          out.clearBuffer(); 
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); 
      } 
    } finally { 
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context); 
    } 
  } 
}