@Override
public Comment mapRow(ResultSet rs, int rowNum) throws SQLException {
Comment comment = new Comment();
comment.setCommentId(rs.getInt("comment_Id"));
comment.setPostId(rs.getInt("post_Id"));
comment.setUserName(rs.getString("username"));
comment.setEmail(rs.getString("email"));
comment.setCommentText(rs.getString("comment_content"));
comment.setCommentDate(rs.getDate("comment_date"));
comment.setCommentPublish(rs.getBoolean("comment_publish"));
return comment;
}
@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;
}
