예제 #1
0
  public HashMap<Integer, Integer> GetUserShoppinCart(UserBean ub) {
    PreparedStatement preparedStatement = null;

    HashMap<Integer, Integer> CartList = new HashMap<Integer, Integer>();

    int uId = ub.getId();

    try {
      // connect to DB
      currentCon = DBUtil.getConnection();

      preparedStatement = currentCon.prepareStatement("select * from shopping_cart where u_id=?");
      System.out.println("Query: " + preparedStatement);
      preparedStatement.setInt(1, uId);

      rs = preparedStatement.executeQuery();

      boolean more = rs.next();
      if (more) {

        while (more) {

          CartList.put(rs.getInt("pro_id"), rs.getInt("quantity"));
        }

        ub.setValid(true);
      }
      // if user does not exist set the isValid variable to false
      else {
        System.out.println("Sorry,Can't get Your cart data");
        ub.setValid(false);
      } // if user exists set the isValid variable to true

    } catch (Exception ex) {
      System.out.println("Load data failed: An Exception has occurred! " + ex);
    } // some exception handling
    finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (Exception e) {
        }
        rs = null;
      }

      if (preparedStatement != null) {
        try {
          preparedStatement.close();
        } catch (Exception e) {
        }
      }

      if (currentCon != null) {
        try {
          currentCon.close();
        } catch (Exception e) {
        }

        currentCon = null;
      }
    }

    return CartList;
  }
예제 #2
0
  public UserBean GetUserData(UserBean ub) {
    PreparedStatement preparedStatement = null;

    String email = ub.getEmail();

    try {
      // connect to DB
      currentCon = DBUtil.getConnection();

      preparedStatement = currentCon.prepareStatement("select * from user where u_email=?");
      System.out.println("Query: " + preparedStatement);
      preparedStatement.setString(1, email);

      rs = preparedStatement.executeQuery();

      boolean more = rs.next();

      // if user does not exist set the isValid variable to false
      if (!more) {
        System.out.println("Sorry, you are not a registered user! Please sign up first");
        ub.setValid(false);
      } // if user exists set the isValid variable to true
      else if (more) {
        ub.setId(rs.getInt("u_id"));
        ub.setName(rs.getString("u_name"));
        ub.setEmail(rs.getString("u_email"));
        ub.setPassword(rs.getString("u_password"));
        ub.setJob(rs.getString("u_job"));
        ub.setAddress(rs.getString("u_address"));
        ub.setBirthDate(rs.getDate("u_bdate"));
        ub.setCardId(rs.getInt("cart_id"));
        ub.setCardLimit(rs.getInt("u_credit_limit"));
      }
    } catch (Exception ex) {
      System.out.println("Log In failed: An Exception has occurred! " + ex);
    } // some exception handling
    finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (Exception e) {
        }
        rs = null;
      }

      if (preparedStatement != null) {
        try {
          preparedStatement.close();
        } catch (Exception e) {
        }
      }

      if (currentCon != null) {
        try {
          currentCon.close();
        } catch (Exception e) {
        }

        currentCon = null;
      }
    }

    return ub;
  }