예제 #1
0
파일: OrderDAO.java 프로젝트: pbs0306/Bams
  public void insertOrderDetail(CartVO cartVO, int maxOseq) {
    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
      conn = DBManager.getConnection();

      String insertOrderDetail =
          "insert into order_detail(odseq, oseq, "
              + "pseq, quantity) values(order_detail_seq.nextval, ?, ?, ?)";
      pstmt = conn.prepareStatement(insertOrderDetail);
      pstmt.setInt(1, maxOseq);
      pstmt.setInt(2, cartVO.getPseq());
      pstmt.setInt(3, cartVO.getQuantity());
      pstmt.executeUpdate();
      pstmt.close();

      String updateCartResult = "update cart set result=2 where cseq=?";
      pstmt = conn.prepareStatement(updateCartResult);
      pstmt.setInt(1, cartVO.getCseq());
      pstmt.executeUpdate();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DBManager.close(conn, pstmt);
    }
  }
예제 #2
0
파일: OrderDAO.java 프로젝트: pbs0306/Bams
  // 사용자가 주문
  public int insertOrder(ArrayList<CartVO> cartList, String id) {
    int maxOseq = 0;

    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs;

    try {
      conn = DBManager.getConnection();

      String selectMaxOseq = "select max(oseq) from orders";
      pstmt = conn.prepareStatement(selectMaxOseq);
      rs = pstmt.executeQuery();
      if (rs.next()) {
        maxOseq = rs.getInt(1);
      }
      pstmt.close();

      String insertOrder = "insert into orders(oseq, id) values(" + "orders_seq.nextval, ?)";
      pstmt = conn.prepareStatement(insertOrder);
      pstmt.setString(1, id);
      pstmt.executeUpdate();

      for (CartVO cartVO : cartList) {
        insertOrderDetail(cartVO, maxOseq);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DBManager.close(conn, pstmt);
    }
    return maxOseq;
  }
예제 #3
0
파일: OrderDAO.java 프로젝트: pbs0306/Bams
  public void updateOrderResult(String oseq) {
    String sql = "update order_detail set result='2' where odseq=?";

    Connection conn = null;
    PreparedStatement pstmt = null;

    try {
      conn = DBManager.getConnection();
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, oseq);
      pstmt.executeUpdate();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DBManager.close(conn, pstmt);
    }
  }
예제 #4
0
파일: OrderDAO.java 프로젝트: pbs0306/Bams
  /* *
   * 관리자 모드에서 사용되는 메소드 * *
   */
  public ArrayList<OrderVO> listOrder(String member_name) {
    ArrayList<OrderVO> orderList = new ArrayList<OrderVO>();
    String sql =
        "select * from order_view where mname like '%'||?||'%' " + "order by result, oseq desc";

    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {
      conn = DBManager.getConnection();
      pstmt = conn.prepareStatement(sql);
      if (member_name == "") {
        pstmt.setString(1, "%");
      } else {
        pstmt.setString(1, member_name);
      }
      rs = pstmt.executeQuery();
      while (rs.next()) {
        OrderVO orderVO = new OrderVO();
        orderVO.setOdseq(rs.getInt("ODSEQ"));
        orderVO.setOseq(rs.getInt("OSEQ"));
        orderVO.setId(rs.getString("ID"));
        orderVO.setPseq(rs.getInt("PSEQ"));
        orderVO.setMname(rs.getString("MNAME"));
        orderVO.setPname(rs.getString("PNAME"));
        orderVO.setQuantity(rs.getInt("QUANTITY"));
        orderVO.setZipNum(rs.getString("ZIP_NUM"));
        orderVO.setAddress(rs.getString("ADDRESS"));
        orderVO.setPhone(rs.getString("PHONE"));
        orderVO.setIndate(rs.getTimestamp("INDATE"));
        orderVO.setPrice2(rs.getInt("PRICE2"));
        orderVO.setResult(rs.getString("RESULT"));
        orderList.add(orderVO);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DBManager.close(conn, pstmt, rs);
    }
    return orderList;
  }
예제 #5
0
파일: OrderDAO.java 프로젝트: pbs0306/Bams
  // 현재 진행 중인 주문 내역만 조회
  public ArrayList<Integer> selectSeqOrderIng(String id) {
    ArrayList<Integer> oseqList = new ArrayList<Integer>();
    String sql =
        "select distinct oseq from order_view " + "where id=? and result='1' order by oseq desc";
    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    try {
      con = DBManager.getConnection();
      pstmt = con.prepareStatement(sql);
      pstmt.setString(1, id);
      rs = pstmt.executeQuery();
      while (rs.next()) {
        oseqList.add(rs.getInt(1));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      DBManager.close(con, pstmt, rs);
    }
    return oseqList;
  }