logon.jsp

网站的实例

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

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

//判断用户是否存在
if(!Rst.next())
response.sendRedirect(err1);
else
{
//判断密码是否正确
String pass=Rst.getString("user_pw").trim();
if(!user_pw.equals(pass))
response.sendRedirect(err2);
else
{
String sql1="UPDATE user_info SET user_login=user_login+1 WHERE user_name='"+user_name+"'";
Stmt.executeUpdate(sql1);

//设置Session
session.setAttribute("user_name",user_name);
session.setAttribute("user_login","yes");
//Rst.close();
Stmt.close();
Conn.close();
response.sendRedirect("index.jsp");
}
}
%>