📄 loginok.jsp
字号:
<%-- 这个JSP脚本是用来验证登录信息的 --%>
<%@ page language="java"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page errorPage="errorpage.jsp" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBexecuteBean" scope="page" class="bookSearchOrderBean.DBexecuteBean"/> <%-- 调用JavaBean --%>
<html>
<head>
<title>网上图书信息检索和订购</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.TableLine { border: #6666FF; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px}
-->
</style>
</head>
<body bgcolor="#FFFFFF" link="#00A800" vlink="#00A800" alink="#00a800">
<%
String LoginName = null;
String LoginPassword = null;
String UserName = null;
String UserAddress = null;
String UserTelNumber = null;
String UserEmail = null;
String UserID = null;
String sSQLCmd = null;
ResultSet rset;
int flag = 0;
/* 验证用户的身份 */
LoginName = request.getParameter("textfieldTxt_LoginName"); // 获取登录名和密码
LoginPassword = request.getParameter("textfieldTxt_Password");
if((LoginName == null) || (LoginName.length() < 1))
{
throw new Exception("请正确填写登录名！");
}
else
{
LoginName = LoginName.trim();
if((LoginPassword == null) || (LoginPassword.length() < 1))
{
throw new Exception("请正确填写登录密码！");
}
else
{
LoginPassword = LoginPassword.trim();
sSQLCmd = "select UserID,UserName,TelNumber,UserAddress,UserEmail from userinfo where LoginName = '" + LoginName + "' and Password='" + LoginPassword + "'";
rset = DBexecuteBean.getTableRecords(sSQLCmd); //调用Bean中的checkLoginInfo()方法进行身份验证
while(rset.next())
{
flag = 1;
UserID = rset.getString(1);
UserName = rset.getString(2);
UserTelNumber = rset.getString(3);
UserAddress = rset.getString(4);
UserEmail = rset.getString(5);
}
if(flag == 1)
{
/* 将所有的信息放入Session对象，以便以后调用 */
UserTelNumber = (UserTelNumber == null) ? "无" : UserTelNumber.trim();
UserEmail = (UserEmail == null) ? "无" : UserEmail.trim();
session.putValue("UserID",UserID);
session.putValue("LoginName",LoginName);
session.putValue("UserName",UserName);
session.putValue("LoginPassword",LoginPassword);
session.putValue("UserTelNumber",UserTelNumber);
session.putValue("UserAddress",UserAddress);
session.putValue("UserEmail",UserEmail);
Cookie hadlogin = new Cookie("hadlogin","1"); // 定义一个hadlogin的Cookie对象，此Cookie对象用来检测用户是否已经成功登录
hadlogin.setMaxAge(8640000); // 定义Cookie的有效期限
response.addCookie(hadlogin); // 将所定义的Cookie对象发送到客户端
}
else
{
throw new Exception("对不起，你所填写的信息不正确！请重新填写。");
}
}
}
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="TableLine">
<tr>
<td height="7">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td height="2">
<div align="center"><font color="#6666FF" size="5" face="华文新魏"><font size="+3"><b><font size="6">欢迎登录网上书店</font></b></font></font></div>
</td>
</tr>
<tr>
<td height="2"> </td>
</tr>
<tr>
<td height="0"> <font face="幼圆" size="4"><b><font color="#6666FF">
<%=LoginName%>
<font size="3">用户:</font></font></b></font>
</td>
</tr>
<tr>
<td><font face="幼圆" size="4"><b><font face="幼圆" size="4"><b><font color="#6666FF"><font size="3"> 您已经成功登录，请查看
<a href="http://127.0.0.1/chapter5/book/Statistics.jsp"><i>图书统计信息</i></a>
或 <a href="http://127.0.0.1/chapter5/book/BookInfoSearch.jsp"><i>选购图书</i></a></font></font></b></font>
<font color="#6666FF"></font></b></font></td>
</tr>
<tr>
<td><font face="幼圆" size="4"><b><font color="#6666FF"><font size="3"> </font></font></b></font></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -