Package by.bsuir.hypermarket.entity

Examples of by.bsuir.hypermarket.entity.Department

30
31
32
33
34
35
36
37
38
39
40
41
42
43
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement categoryStatement = connection.prepareStatement(SQL_CATEGORY_BY_DEPARTMENT);
        PreparedStatement departmentStatement = connection.prepareStatement(SQL_FIND_ALL)) {   
      ResultSet resultSet = departmentStatement.executeQuery();
      while (resultSet.next()) {
        Department department = new Department();
        fillUpDepartment(resultSet, department);
       
        categoryStatement.setInt(1, department.getUid());
        ResultSet categoriesResultSet = categoryStatement.executeQuery();
        setDepartmentCategories(categoriesResultSet, department);
   
        departments.add(department);
      }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    return departments;
  }

  @Override
  public Department findEntityById(int id) throws DaoException {
    Department department = new Department();
    try (DbConnection connection = DbConnectionPool.INSTANCE.getConnection();
        PreparedStatement categoryStatement = connection.prepareStatement(SQL_CATEGORY_BY_DEPARTMENT);
        PreparedStatement idStatement = connection.prepareStatement(SQL_FIND_BY_ID)) {
      idStatement.setInt(1, id);
      ResultSet resultSet = idStatement.executeQuery();
      if (resultSet.next()) {
        fillUpDepartment(resultSet, department);
       
        categoryStatement.setInt(1, department.getUid());
        ResultSet categoriesResultSet = categoryStatement.executeQuery();
        setDepartmentCategories(categoriesResultSet, department);
      }
    } catch (SQLException e) {
      log.error("Error during statement creation", e);
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
209
210
211
    Country country = new Country();
    country.setUid(resultSet.getInt("country_uid"));
    country.setName(resultSet.getString("goods_from"));
    goods.setCountry(country);
   
    Department department = new Department();
    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"));
View Full Code Here
TOP

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

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