@Override public void editComment(Comment comment) { jdbcTemplate.update( SQL_UPDATE_COMMENT, comment.getPostId(), comment.getUserName(), comment.getEmail(), comment.getCommentText(), comment.getCommentDate(), comment.isCommentPublish(), comment.getCommentId()); }
@Override public Comment addComment(Comment comment) { jdbcTemplate.update( SQL_INSERT_COMMENT, comment.getPostId(), comment.getUserName(), comment.getEmail(), comment.getCommentText(), comment.getCommentDate()); comment.setCommentId(jdbcTemplate.queryForObject("select LAST_INSERT_ID()", Integer.class)); return comment; }