loginpost.jsp

来自「时空留言本 v1.0 主要功能： ·支持UBB； ·屏蔽HTML； ·加」· JSP 代码 · 共 31 行

<%@ 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 passwords=request.getParameter("password");

  String sql="select * from admin"; 
  ResultSet rs=stmt.executeQuery(sql);
  while(rs.next())
  {
   if(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();
	}
%>