📄 confirm.jsp
字号:
<html>
<head>
<title>登录检查</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn =OPDB.getConn();
String userType = request.getParameter("userType");
String regName=OPDB.AsciiToChineseString(request.getParameter("username").trim());
String regPassword=request.getParameter("password");
regPassword=regPassword.trim();
String sql="select userid from t_bbs_user where username='"+ regName +"' and password='"+ regPassword +"' and userType = '" + userType + "'";
ResultSet rs =OPDB.select(conn,sql);
if(rs.next()) {
if (userType.equals("Y")) {
regName = regName + OPDB.AsciiToChineseString("[会员]");
}
session.putValue("username",regName);
rs.close();
response.sendRedirect ("login_success.htm");
}
else {
rs.close();
out.print("<script>alert(\"用户名/密码错误!\");");
out.print("window.location = \"logon.jsp\"</script>");
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -