JSP 接收請求 → 呼叫 JavaBean 方法 → Bean 內部以 JDBC 呼叫預存程序/執行 SQL → 回傳結果 → JSP 轉向。
public boolean checkUser() throws Exception {
boolean flag = false;
ResultSet rs = conn.executeQuery(getSql()); // 自訂 SQL: SELECT * FROM users WHERE userid=? AND pwd=?
if (rs.next()) {
userID = rs.getString("userID");
userName = rs.getString("userName");
userPWD = rs.getString("userPWD");
userUnit = rs.getString("userUnit");
userLoadTime = rs.getDate("userLoadTime");
userLoadNumeric = rs.getInt("userLoadNumber");
flag = true;
}
rs.close();
conn.closeConn();
return flag;
}
public void changeLoginInfo(String userID) throws Exception {
String sql = "UPDATE SystemUserTable SET UserLoadTime=SYSDATE, UserLoadNumber=UserLoadNumber+1 WHERE UserID=?";
// 建議改用 PreparedStatement 防注入
conn.executeUpdate(sql); // 此處為簡化示範
}
HttpSession,建議由 Servlet/Filter 驗證 Session,Bean 僅處理資料邏輯。SYS_REFCURSOR OUT 參數,Java 端以 CallableStatement.getObject() 轉 ResultSet。-- PL/SQL
CREATE OR REPLACE PROCEDURE get_user(p_id IN NUMBER, p_cur OUT SYS_REFCURSOR) AS
BEGIN
OPEN p_cur FOR SELECT * FROM users WHERE user_id = p_id;
END;
// Java
cstmt.registerOutParameter(2, OracleTypes.CURSOR);
cstmt.execute();
ResultSet rs = (ResultSet) cstmt.getObject(2);
while (rs.next()) { ... }