푸들푸들

2024/10/23p1댓글 삭제BoardCommentDao.javapublic class BoardCommentDao { public int deleteComment(Connection conn, int commentNo,int articleNo) throws Exception { int row=0; String sql = "delete from board_comment where comment_no=? and article_no=?"; PreparedStatement stmt = conn.prepareStatement(sql); stmt.setInt(1, commentNo); stmt.setInt(2, articleNo); row = stmt.executeUpdate(); return ro..

2024/10/23p1댓글 입력 BoardCommentDao.javapublic int insertComment(Connection conn, BoardComment bc) throws Exception { int row=0; String sql = """ insert into board_comment( article_no articleNo , member_id memberId , comment , createdate ) values (?,?,?,now()) """; PreparedStatement stmt = conn.pr..

2024/10/23P1글 입력이 되지않고 빈 화면이 나옴java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vlaues (7,'board','0dcb492f1544495d84dafeb466551c80','sql',now())' at line 3콘솔창 확인public int insertFile(Connection conn, BoardFile bf) throws Exception { int row = 0; String sql = """ insert i..

사소한 오류심각한 오류기록