Пример #1
0
 /**
  * Update user.
  *
  * @param user user to update.
  * @throws SQLException
  */
 private void updateUser(Connection con, User user) throws SQLException {
   PreparedStatement pstmt = null;
   try {
     pstmt = con.prepareStatement(SQL_UPDATE_USER);
     int k = 1;
     pstmt.setString(k++, user.getPassword());
     pstmt.setString(k++, user.getFirstName());
     pstmt.setString(k++, user.getLastName());
     pstmt.setLong(k, user.getId());
     pstmt.executeUpdate();
   } finally {
     close(pstmt);
   }
 }
Пример #2
0
  public List<ExtendedUserOrderBean> getExtendedUserOrderBean(User user) throws DBException {
    List<ExtendedUserOrderBean> list = new ArrayList<>();
    PreparedStatement ps = null;

    ResultSet rs = null;
    Connection con = null;

    try {
      con = getConnection();
      con.setAutoCommit(false);

      ps = con.prepareStatement(SQL_GET_EXTENDED_USER_ORDER_BEAN);
      ps.setInt(1, user.getId());
      rs = ps.executeQuery();
      while (rs.next()) {
        list.add(extractExtendedUserOrderBean(rs));
      }
      con.commit();
    } catch (SQLException e) {
      rollback(con);
      LOG.error(Messages.ERR_CANNOT_OBTAIN_USER_ORDER_BEANS, e);
    } finally {
      close(con, ps, rs);
    }
    return list;
  }
Пример #3
0
 /**
  * Extracts a user entity from the result set.
  *
  * @param rs Result set from which a user entity will be extracted.
  * @return User entity
  */
 public User extractUser(ResultSet rs) throws SQLException {
   User user = new User();
   user.setId(rs.getInt(Fields.ENTITY_ID));
   user.setLogin(rs.getString(Fields.USER_LOGIN));
   user.setPassword(rs.getString(Fields.USER_PASSWORD));
   user.setFirstName(rs.getString(Fields.USER_FIRST_NAME));
   user.setLastName(rs.getString(Fields.USER_LAST_NAME));
   user.setRole(rs.getString(Fields.USER_ROLE));
   user.setBan(rs.getBoolean(Fields.USER_BAN));
   return user;
 }
Пример #4
0
 /**
  * Returns orders of the given user and status
  *
  * @param user User entity.
  * @param statusId Status identifier.
  * @return List of order entities.
  * @throws DBException
  */
 public List<Order> findOrders(User user, int statusId) throws DBException {
   List<Order> ordersList = new ArrayList<Order>();
   PreparedStatement pstmt = null;
   ResultSet rs = null;
   Connection con = null;
   try {
     con = getConnection();
     pstmt = con.prepareStatement(SQL_FIND_ORDERS_BY_STATUS_AND_USER);
     pstmt.setInt(1, statusId);
     pstmt.setLong(2, user.getId());
     rs = pstmt.executeQuery();
     while (rs.next()) {
       ordersList.add(extractOrder(rs));
     }
     con.commit();
   } catch (SQLException ex) {
     rollback(con);
     throw new DBException(Messages.ERR_CANNOT_OBTAIN_ORDERS_BY_USER_AND_STATUS_ID, ex);
   } finally {
     close(con, pstmt, rs);
   }
   return ordersList;
 }
Пример #5
0
  public List<CatalogItem> findCatalogItems(User user) throws DBException {

    List<CatalogItem> catalogItemList = new ArrayList<>();
    PreparedStatement ps = null;
    ResultSet rs = null;
    Connection con = null;
    try {
      con = getConnection();
      ps = con.prepareStatement(SQL_GET_CATALOG_ITEMS_BY_USER);
      ps.setInt(1, user.getId());
      rs = ps.executeQuery();
      while (rs.next()) {
        catalogItemList.add(extractCatalogItem(rs));
      }
    } catch (SQLException ex) {
      rollback(con);
      throw new DBException(Messages.ERR_CANNOT_OBTAIN_MENU_ITEMS_BY_IDENTIFIERS, ex);
    } finally {
      close(con);
      close(rs);
      close(ps);
    }
    return catalogItemList;
  }