Package by.bsuir.hypermarket.entity

Examples of by.bsuir.hypermarket.entity.Address

33
34
35
36
37
38
39
40
41
42
43
    List<Address> addresses = new ArrayList<Address>();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement statement = connection.prepareStatement(SQL_FIND_ALL)){
      ResultSet resultSet = statement.executeQuery();
      while (resultSet.next()) {
        Address address = new Address();
        fillUpAddress(resultSet, address);
        addresses.add(address);
      }
    } catch (ConnectionPoolException e) {
      log.error("Error during getting connection from the pool", e);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    return addresses;
  }

  @Override
  public Address findEntityById(int id) throws DaoException {
    Address address = new Address();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      if (resultSet.next()) {
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
  }
 
  private void setProducerAddresses(ResultSet resultSet, Goods goods) throws SQLException {
    List<Address> addresses = new ArrayList<Address>();
    while (resultSet.next()) {
      Address address = new Address();
      address.setAppartment(resultSet.getInt("a_appartment"));
      address.setBuilding(resultSet.getInt("a_building"));
      Country country = new Country();
      country.setName(resultSet.getString("country_name"));
      country.setUid(resultSet.getInt("a_c_uid"));
      address.setCountry(country);
      address.setDistrict(resultSet.getString("a_district"));
      address.setHouseNumber(resultSet.getInt("a_house_num"));
      address.setRegion(resultSet.getString("a_region"));
      address.setStreet(resultSet.getString("a_street"));
      address.setUid(resultSet.getInt("a_uid"));
      address.setZipCode(resultSet.getInt("a_zip_code"));
      addresses.add(address);
    }
    goods.getProducer().setAddresses(addresses);
  }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
  }
 
  private void setProducerAddresses(ResultSet resultSet, Producer producer) throws SQLException {
    List<Address> addresses = new ArrayList<Address>();
    while (resultSet.next()) {
      Address address = new Address();
      address.setAppartment(resultSet.getInt("a_appartment"));
      address.setBuilding(resultSet.getInt("a_building"));
      Country country = new Country();
      country.setName(resultSet.getString("country_name"));
      country.setUid(resultSet.getInt("a_c_uid"));
      address.setCountry(country);
      address.setDistrict(resultSet.getString("a_district"));
      address.setHouseNumber(resultSet.getInt("a_house_num"));
      address.setRegion(resultSet.getString("a_region"));
      address.setStreet(resultSet.getString("a_street"));
      address.setUid(resultSet.getInt("a_uid"));
      address.setZipCode(resultSet.getInt("a_zip_code"));
      addresses.add(address);
    }
    producer.setAddresses(addresses);
  }
View Full Code Here
TOP

Related Classes of by.bsuir.hypermarket.entity.Address

  • by.bsuir.hypermarket.dao.concrete.AddressDao
  • by.bsuir.hypermarket.dao.concrete.GoodsDao
  • by.bsuir.hypermarket.dao.concrete.ProducerDao
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.