loginpost.jsp

来自「1.开发环境： SunShine留言本v1.0所采用的开发环境为：J2」· JSP 代码 · 共 32 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="DBConnection" scope="page" class="com.guestbook.DBConnection"/>
<%
  Connection conn=DBConnection.getConnectionToAccess(application.getRealPath("data/guestbook.mdb"));
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  String admin=request.getParameter("admin");
  String passwords=request.getParameter("password");

  String sql="select * from admin"; 
  ResultSet rs=stmt.executeQuery(sql);
  while(rs.next())
  {
   if(rs.getString("admin").equals(admin)&&rs.getString("password").equals(passwords)){
   session.setAttribute("a",new Boolean("true"));
   response.sendRedirect("index.jsp");
    }else{
	     out.print("<script>");
         out.print("alert('用户名或密码错误！');");
         out.print("history.back();");
         out.print("</script>");
   }
  }
	//关闭数据库
	if(conn!=null)
	{
		conn.close();
	}
	if(stmt!=null)
	{
		stmt.close();
	}
%>