📄 users.jsp
字号:
<%@ include file="conn.jsp"%>
<%
request.setCharacterEncoding("GB2312");
String username=request.getParameter("user");
password=request.getParameter("password");
String sql="select * from scott.user1 where username = '" + username + "' and password = '" + password + "'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
session.putValue("user",rs.getString("username"));
response.sendRedirect("index.jsp");
}else{
out.print(" <LINK rel='stylesheet' type='text/css' href='style.css'> ");
out.print(" <TITLE>会员身份验证</TITLE> ");
out.print(" <BODY bgcolor='#39867B'> ");
out.print(" <BR><BR><BR> ");
out.print(" <TABLE align='center' width='300' cellpadding='1' cellspacing='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='index.jsp'>再次登录！</A><BR> ");
out.print(" <BR> ");
out.print(" </DIV> ");
out.print(" </TD> ");
out.print(" </TR> " );
out.print(" </TABLE> " );
}
rs.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -