public int insert(Connection conn, Message message) throws SQLException {
PreparedStatement pstmt = null;
try {
pstmt =
conn.prepareStatement(
"insert into guestbook_message "
+ "(message_id, guest_name, password, message) "
+ "values (message_id_seq.NEXTVAL, ?, ?, ?)");
pstmt.setString(1, message.getGuestName());
pstmt.setString(2, message.getPassword());
pstmt.setString(3, message.getMessage());
return pstmt.executeUpdate();
} finally {
JdbcUtil.close(pstmt);
}
}
public void deleteMessage(int messageId, String password)
throws ServiceException, InvalidMessagePasswordException, MessageNotFoundException {
Connection conn = null;
try {
conn = ConnectionProvider.getConnection();
conn.setAutoCommit(false);
MessageDao messageDao = MessageDaoProvider.getInstance().getMessageDao();
Message message = messageDao.select(conn, messageId);
if (message == null) {
throw new MessageNotFoundException("메시지가 없습니다:" + messageId);
}
if (!message.hasPassword()) {
throw new InvalidMessagePasswordException("메시지가 암호를 가지고 있지 않습니다");
}
if (!message.getPassword().equals(password)) {
throw new InvalidMessagePasswordException("메시지 암호가 다릅니다.");
}
messageDao.delete(conn, messageId);
conn.commit();
} catch (SQLException ex) {
JdbcUtil.rollback(conn);
throw new ServiceException("삭제 처리 중 에러가 발생했습니다.:" + ex.getMessage(), ex);
} catch (InvalidMessagePasswordException ex) {
JdbcUtil.rollback(conn);
throw ex;
} catch (MessageNotFoundException ex) {
JdbcUtil.rollback(conn);
throw ex;
} finally {
if (conn != null) {
try {
conn.setAutoCommit(false);
} catch (SQLException e) {
}
JdbcUtil.close(conn);
}
}
}