Package by.bsuir.hypermarket.entity

Examples of by.bsuir.hypermarket.entity.Goods

58
59
60
61
62
63
64
65
66
67
68
69
70
71
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement statement = connection.prepareStatement(SQL_FIND_ALL);
        PreparedStatement producerStatement = connection.prepareStatement(SQL_FIND_PRODUCER_BY_ID)) {
      ResultSet resultSet = statement.executeQuery();
      while (resultSet.next()) {
        Goods goods = new Goods();
        fillUpGoodsEntity(resultSet, goods);
       
        producerStatement.setInt(1, goods.getProducer().getUid());
        ResultSet producerResultSet = producerStatement.executeQuery();
        setProducerAddresses(producerResultSet, goods);
       
        goodsList.add(goods);
      }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
    return goodsList;
  }

  @Override
  public Goods findEntityById(int id) throws DaoException {
    Goods goods = new Goods();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_ID);
        PreparedStatement producerStatement = connection.prepareStatement(SQL_FIND_PRODUCER_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      if (resultSet.next()) {
        fillUpGoodsEntity(resultSet, goods);
       
        producerStatement.setInt(1, goods.getProducer().getUid());
        resultSet = producerStatement.executeQuery();
        setProducerAddresses(resultSet, goods);
      }
    } catch (SQLException e) {
      log.error("Error during goods searching by id", e);
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
129
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_DEPARTMENT);
        PreparedStatement producerStatement = connection.prepareStatement(SQL_FIND_PRODUCER_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      while (resultSet.next()) {
        Goods goods = new Goods();
        fillUpGoodsEntity(resultSet, goods);
       
        producerStatement.setInt(1, goods.getProducer().getUid());
        ResultSet producerAddresses = producerStatement.executeQuery();
        setProducerAddresses(producerAddresses, goods);
       
        goodsList.add(goods);
      }
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_CATEGORY);
        PreparedStatement producerStatement = connection.prepareStatement(SQL_FIND_PRODUCER_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      while (resultSet.next()) {
        Goods goods = new Goods();
        fillUpGoodsEntity(resultSet, goods);
       
        producerStatement.setInt(1, goods.getProducer().getUid());
        ResultSet producerAddresses = producerStatement.executeQuery();
        setProducerAddresses(producerAddresses, goods);
       
        goodsList.add(goods);
      }
View Full Code Here
TOP

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

  • by.bsuir.hypermarket.dao.concrete.GoodsDao
    • 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.