📄 execute.jsp~3~
字号:
<%@ page contentType="text/html; charset=GBK" errorPage="error.jsp%>
<%@ page import="java.sql.*"%>
<%@ page import="loginpro.DSBean"%>
<html>
<head>
<title>
execute
</title>
</head>
<jsp:useBean id="userBean" scope="session" class="loginpro.UserBean" />
<jsp:setProperty name="userBean" property="*" />
<body bgcolor="#ffffff">
<h1>
登录密码检验
</h1>
<p>
<%
Connection conn = DSBean.getConnection();
String sqlStr = "select count(*) from T_USER where USER_ID=? and password=?";
PreparedStatement pStat = conn.prepareStatement(sqlStr);
pStat.setString(1,userBean.getUserID());
pStat.setString(2,userBean.getPassword());
ResultSet rs = pStat.executeQuery();
if(rs.next() && rs.getInt(1) == 1)
out.print("您是合法的用户，欢迎您的到来！");
else
out.print("密码不对，或者您还没有注册为系统的用户");
%>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -