jsp入門教程:使用者登陸密碼判斷代碼
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="../DB.jsp"%>
<jsp:useBean id="loginMD5" scope="page" class="ITstudy_cn.tool.MD5" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>登入檢查</title>
</head>
<body>
<%
String UserName = request.getParameter("admin");
String UserPwd = request.getParameter("UserPassword");
UserPwd=loginMD5.getMD5ofStr(UserPwd);
String rand = (String)session.getAttribute("rand");
String CheckCode = request.getParameter("CheckCode");
//String sel = request.getParameter("sel_admin");
Statement stmt_Check=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from hl_admin where fPassword='"+ UserPwd + "' and fUserName='" + UserName +"'";
ResultSet RsLoginCheck = stmt_Check.executeQuery(sql);
if(RsLoginCheck.next()){
if(rand.equals(CheckCode)){
//out.print("成功");
session.setAttribute("AdminName",UserName);
session.setAttribute("Aforder",RsLoginCheck.getString("forder"));
//if(sel.equals("2")){
// response.sendRedirect("../enadmin/Ad_Index.jsp");
//}else{
response.sendRedirect("Ad_Index.jsp");
//}
}
else
{
out.print("您輸入的確認碼和系統產生的不一致,請重新輸入。");
}
}
else
{
out.print("使用者名稱或密碼錯誤!!!");
}
%>
<br />
=================
</body>
</html>
</body>
</html>
<%
RsLoginCheck.close();
stmt_Check.close();
conn.close();
%>