댓글 추가될수록 본게시글에도 숫자뜨도록

댓글 추가 함수 예제 (Java)

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public void addComment(Connection conn, int pseq, String writer, String password, String content) throws SQLException {
    String insertCommentSQL = "INSERT INTO album_cmt_comment1 (pseq, writer, password, content, wdate) VALUES (?, ?, ?, ?, NOW())";
    String updateBoardSQL = "UPDATE album_cmt_board1 SET cmtcnt = cmtcnt + 1 WHERE seq = ?";

    try (PreparedStatement pstmt1 = conn.prepareStatement(insertCommentSQL);
         PreparedStatement pstmt2 = conn.prepareStatement(updateBoardSQL)) {
        conn.setAutoCommit(false);

        // 댓글 추가
        pstmt1.setInt(1, pseq);
        pstmt1.setString(2, writer);
        pstmt1.setString(3, password);
        pstmt1.setString(4, content);
        pstmt1.executeUpdate();

        // cmtcnt 업데이트
        pstmt2.setInt(1, pseq);
        pstmt2.executeUpdate();

        conn.commit();
    } catch (SQLException e) {
        conn.rollback();
        throw e;
    } finally {
        conn.setAutoCommit(true);
    }
}