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); } }