📄 chklogin.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="DBConn" class="jspeshop.DBConn" scope="page"/>
<%
try{
//数据库连接
Statement st = DBConn.GetConn().createStatement();
//获取用户名及密码
String strUID = request.getParameter("name");
String strPWD = request.getParameter("psword");
String sql = "select * from Admin where AD_NAME = '" + strUID + "' and AD_PSWORD = '" + strPWD + "'" ;
ResultSet rs = st.executeQuery(sql);
//判断数据库中是否已有此用户
if(rs.next()){
session.setAttribute("name",rs.getString("AD_NAME"));
session.setAttribute("class",rs.getString("AD_CLASS"));
rs.close();
response.sendRedirect("manage.jsp");
}else{
%>
<html>
<head>
<title>管理员</title>
<link rel="stylesheet" type="text/css" href="../../source/jsp+oracle/sites/Eshop/style.css">
<style type="text/css">
<!--
.style1 {color: #00FFFF}
-->
</style>
</head>
<body bgcolor="#ffffff">
<TABLE cellSpacing=1 cellPadding=4 width=306 bgColor=#416327 height="100" align="center">
<TBODY>
<TR vAlign=top bgColor=#eeeeee>
<TD width="292" height="53" bgcolor="#336699">
<p align="center"><br>
<span class="style1">登录失败，请输入正确账号和密码重新登录!</span></p>
</TD></TR>
<TR bgColor=#eeeeee>
<TD width="292" height="27" bgcolor="#336699">
<DIV align=center><INPUT class=main type=submit size=3 value=返回 name=Submit2 onclick="javascript:window.history.go(-1)">
</DIV></TD></TR></TBODY></TABLE>
<%
}
%>
</body>
</html>
<%
}catch(Exception e){
//错误处理
throw (e);
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -