logon.jsp

网站的实例

<%
/*
文件名: logon.jsp
所需文件：data.jsp/error.jsp
调用文件：index.jsp
调用条件：填入的名字密码
功能描述：登陆验证
编码人：sT
编码日期：2002-05-23
*/
%>

<%@ include file="data.jsp"%>
<%
//读取表单输入的账号密码
String admin_name=request.getParameter("admin_name").trim();
String admin_pw=request.getParameter("admin_pw").trim();
//定义错误处理
String err1="error.jsp?error=Administrator name error!&url=index.jsp";
String err2="error.jsp?error=Administrator password error!&url=index.jsp";
//从数据库读取账号密码
String sql="SELECT admin_pw FROM admin WHERE admin_name='"+admin_name+"'";
Rst=Stmt.executeQuery(sql);

//判断用户是否存在
if(!Rst.next())
response.sendRedirect(err1);
else
{
//判断密码是否正确
String pass=Rst.getString("admin_pw").trim();
if(!admin_pw.equals(pass))
response.sendRedirect(err2);
else
{
//设置Session
session.setAttribute("admin_name",admin_name);
session.setAttribute("admin_login","yes");
Rst.close();
Stmt.close();
Conn.close();
response.sendRedirect("admin.jsp");
}
}
%>