@Override
public void addAttraction(Attraction attraction) {
Connection con = MySQLConnection.getWebInstance();
try (PreparedStatement pstm = con.prepareStatement(ADD_ATTRACTION)) {
int k = 1;
pstm.setString(k++, attraction.getTitle());
pstm.setString(k++, attraction.getDescription());
pstm.setInt(k++, attraction.getHeight());
pstm.setString(k++, attraction.getImage());
pstm.setInt(k++, attraction.getAdultPrice());
pstm.setInt(k++, attraction.getChildPrice());
pstm.executeUpdate();
} catch (SQLException ex) {
rollback(con);
throw new DBLayerException("Failed to add attraction" + attraction, ex);
} finally {
commit(con);
}
}
