Package by.bsuir.hypermarket.entity

Examples of by.bsuir.hypermarket.entity.Category

31
32
33
34
35
36
37
38
39
40
41
    List<Category> categories = new ArrayList<Category>();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement statement = connection.prepareStatement(SQL_FIND_ALL);
      ResultSet resultSet = statement.executeQuery()) {
      while (resultSet.next()) {
        Category category = new Category();
        fillUpCategory(resultSet, category);
        categories.add(category);
      }
    } catch (SQLException e) {
      log.error("Error during searching all entities", e);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    return categories;
  }

  @Override
  public Category findEntityById(int id) throws DaoException {
    Category category = new Category();
    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
73
74
75
76
77
78
79
80
81
82
83
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_DEPARTMENT)) {
      idStatement.setInt(1, department_uid);
      ResultSet resultSet = idStatement.executeQuery();
      while (resultSet.next()) {
        Category category = new Category();
        fillUpCategory(resultSet, category);
        categories.add(category);
      }
    } catch (SQLException e) {
      log.error("Error during statement creation or execution", e);
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
  }
 
  private void setDepartmentCategories(ResultSet resultSet, Department department) throws SQLException {
    List<Category> categories = new ArrayList<>();
    while (resultSet.next()) {
      Category category = new Category();
      fillUpCategory(resultSet, category);
      categories.add(category);
    }
    department.setCategories(categories);
  }
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
215
216
217
    department.setUid(resultSet.getInt("d_uid"));
    department.setName(resultSet.getString("d_name")); 
    department.setPhoneNumber(resultSet.getString("d_phone_num"));
    goods.setDepartment(department);
   
    Category category = new Category();
    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"));
View Full Code Here
TOP

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

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