@Override public void deleteAttraction(Attraction attraction) { Connection con = MySQLConnection.getWebInstance(); try (PreparedStatement pstm = con.prepareStatement(DELETE_ATTRACTION)) { pstm.setInt(1, attraction.getId()); pstm.executeUpdate(); } catch (SQLException ex) { rollback(con); throw new DBLayerException("Failed to delete attraction" + attraction, ex); } finally { commit(con); } }