private ServicePrice constructPriceEntity(ResultSet rs) throws SQLException { ServicePrice servicePrice = new ServicePrice(); servicePrice.setPrice(rs.getBigDecimal("price")); servicePrice.setServiceId(rs.getInt("service_id")); servicePrice.setDate(rs.getDate("date").toLocalDate()); return servicePrice; }
public void deleteServicePrice(ServicePrice servicePrice) { try { PreparedStatement preparedStatement = getConnection() .prepareStatement( "DELETE FROM \"service_price\" where \"service_id\" = ? AND \"date\" = ?"); preparedStatement.setInt(1, servicePrice.getServiceId()); preparedStatement.setDate(2, Date.valueOf(servicePrice.getDate())); preparedStatement.executeUpdate(); } catch (SQLException ex) { ex.printStackTrace(); throw new DAOException(); } }
public void saveServicePrice(ServicePrice servicePrice) { try { PreparedStatement preparedStatement = getConnection() .prepareStatement( "INSERT INTO \"service_price\" (\"service_id\", \"date\", \"price\") VALUES(?, ?, ?)"); preparedStatement.setInt(1, servicePrice.getServiceId()); preparedStatement.setDate(2, Date.valueOf(servicePrice.getDate())); preparedStatement.setBigDecimal(3, servicePrice.getPrice()); preparedStatement.executeUpdate(); } catch (SQLException ex) { ex.printStackTrace(); throw new DAOException(); } }
public List<ServicePrice> getServicePricesByServiceId(int serviceId) { List<ServicePrice> servicePrices = new ArrayList<>(); try { PreparedStatement preparedStatement = getConnection() .prepareStatement("SELECT * FROM \"service_price\" where \"service_id\" = ?"); preparedStatement.setInt(1, serviceId); ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { ServicePrice servicePrice = new ServicePrice(); servicePrice.setServiceId(rs.getInt("service_id")); servicePrice.setPrice(rs.getBigDecimal("price")); servicePrice.setDate(rs.getDate("date").toLocalDate()); servicePrices.add(servicePrice); } } catch (SQLException ex) { ex.printStackTrace(); throw new DAOException(); } return servicePrices; }