?? execute.jsp~5~
字號:
<%@ 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 + -