📄 login_chk.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="../ConnDB.jsp"%>
<!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");
String rand = (String)session.getAttribute("rand");
String CheckCode = request.getParameter("CheckCode");
Statement stmt_Check=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from tAdmin 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);
response.sendRedirect("Ad_Index.jsp");
}
else
{
out.print("您输入的确认码和系统产生的不一致，请重新输入。");
}
}
else
{
out.print("用户名或密码错误！！！");
}
%>
<br />
=================
</body>
</html>
</body>
</html>
<%
//*********** 数据库关闭代码 *******************************
RsLoginCheck.close(); //关闭记录集对象
stmt_Check.close(); //关闭语句对象
conn.close(); //关闭连接对象
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -