?? 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 + -