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