Package by.bsuir.hypermarket.entity

Examples of by.bsuir.hypermarket.entity.Producer

210
211
212
213
214
215
216
217
218
219
220
221
222
    category.setUid(resultSet.getInt("c_uid"));
    category.setName(resultSet.getString("c_name"));
    category.setDescription(resultSet.getString("c_description"));
    goods.setCategory(category);
   
    Producer producer = new Producer();
    producer.setUid(resultSet.getInt("p_uid"));
    producer.setName(resultSet.getString("p_name"));
    producer.setPhoneNumber(resultSet.getString("p_phone"));
    producer.setEmail(resultSet.getString("p_email"));
    goods.setProducer(producer);
    return goods;
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement statement = connection.prepareStatement(FIND_ALL);
        PreparedStatement producerStatement = connection.prepareStatement(FIND_PRODUCER_BY_ID)) {
      ResultSet resultSet = statement.executeQuery();
      while (resultSet.next()) {
        Producer producer = new Producer();
        producer.setUid(resultSet.getInt("p_uid"));
        producer.setName(resultSet.getString("p_name"));
        producer.setPhoneNumber(resultSet.getString("p_phone"));
        producer.setEmail(resultSet.getString("p_email"));
       
        producerStatement.setInt(1, producer.getUid());
        ResultSet producerResultSet = producerStatement.executeQuery();
        setProducerAddresses(producerResultSet, producer);
       
        producers.add(producer);
      }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
    return producers;
  }

  @Override
  public Producer findEntityById(int id) throws DaoException {
    Producer producer = new Producer();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement idStatement = connection.prepareStatement(FIND_BY_ID);
        PreparedStatement producerStatement = connection.prepareStatement(FIND_PRODUCER_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      if (resultSet.next()) {
        producer.setUid(id);
        producer.setName(resultSet.getString("p_name"));
        producer.setPhoneNumber(resultSet.getString("p_phone"));
        producer.setEmail(resultSet.getString("p_email"));
       
        producerStatement.setInt(1, producer.getUid());
        ResultSet producerResultSet = producerStatement.executeQuery();
        setProducerAddresses(producerResultSet, producer);
      }
    } catch (SQLException e) {
      log.error("Error during statement creation", e);
View Full Code Here
TOP

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

  • 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.