📄 chkadmin.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../conn.jsp" %>
<%//×a??óé±íμ￥?áè?μ?êy?Yμ??ú??μ?gb2312
request.setCharacterEncoding("gb2312");
//è?μ?1üàí?±μ?D??￠
String admin=request.getParameter("UserName").trim();
String pwd=request.getParameter("Password").trim();
//2é?ò1üàí?±ê?·?′??ú
String sql=" select * from admin where admin='"+admin+"'";
ResultSet rs=stmt.executeQuery(sql);
//1üàí?±D??￠′??ú?ò?ì2é?ü??ê?·??yè·
if(rs.next()){
//out.print(pwd+"<br>");
//out.print(rs.getString("pwd").trim()+"test");
if(pwd.equals(rs.getString("pwd").trim())){
session.setAttribute("admin",rs.getString("admin"));
session.setAttribute("rights",rs.getString("rights"));
response.sendRedirect("manage.jsp");
}else{
out.print("<Link rel='stylesheet' type='text/css' href='images/Admin_Style.css'>");
out.print("<title>管理员身份验证</title>");
out.print("<body bgcolor='#39867b'>");
out.print("<br><br><br>");
out.print("<table align='center' width='300' cellspacing='1' cellpadding='1'>");
out.print("<tr bgcolor='#CCCCCC'>");
out.print("<td colspan='2' height='15' bgcolor=#E1F4EE'>");
out.print("<div align='center'>操作：密码错误，确认身份失败！</div>");
out.print("</td>");
out.print("</tr>");
out.print("<tr>");
out.print("<td colspan='2' height='23' bgcolor='#E1F4EE'>");
out.print("<Div align='center'><br><br>非法登陆，您的操作已经被记录！！<br>");
out.print("<br><a href='admin.jsp'>再次登陆！</a><br>");
out.print("<br>");
out.print("</div>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("</body>");
}
//1?±??????ˉ???ó
rs.close();
stmt.close();
conn.close();
}else{
out.print("<Link rel='stylesheet' type='text/css' href='images/Admin_Style.css'>");
out.print("<title>管理员身份验证</title>");
out.print("<body bgcolor='#39867b'>");
out.print("<br><br><br>");
out.print("<table align='center' width='300' cellspacing='1' cellpadding='1'>");
out.print("<tr bgcolor='#CCCCCC'>");
out.print("<td colspan='2' height='15' bgcolor=#E1F4EE'>");
out.print("<div align='center'>操作：该账号不存在，确认身份失败！</div>");
out.print("</td>");
out.print("</tr>");
out.print("<tr>");
out.print("<td colspan='2' height='23' bgcolor='#E1F4EE'>");
out.print("<Div align='center'><br><br>非法登陆，您的操作已经被记录！！<br>");
out.print("<br><a href='admin.jsp'>再次登陆！</a><br>");
out.print("<br>");
out.print("</div>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
out.print("</body>");
}
//1?±??????ˉ???ó
rs.close();
stmt.close();
conn.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -