Пример #1
0
  public OfferUser getOfferUser(int offerId, int userId) throws InvocationTargetException {
    String sql =
        "select offer_id as offerId, USER_ID as userId,status from offer_user "
            + " where offer_id = ? and USER_ID= ?";
    OfferUser offerUser = null;
    try {
      this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
      this.pstmt.setInt(1, offerId);
      this.pstmt.setInt(2, userId);
      ResultSet rs = this.pstmt.executeQuery();

      Object[] obj =
          ResultSetToModel.parseDataEntityBeans(rs, "com.offerme.server.database.model.OfferUser");
      if (obj.length > 0) {
        offerUser = (OfferUser) obj[0];
      }

    } catch (Exception e) {

      String err = Log.getStackInfo(e);
      myLog.error(err);
      throw new InvocationTargetException(e, err);
    } finally {
      this.free();
    }

    return offerUser;
  }
Пример #2
0
 public void deleteOfferUser(OfferUser offerUser) throws InvocationTargetException {
   String sql = "delete from offer_user " + " where offer_id=? and user_id=?";
   try {
     this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
     this.pstmt.setInt(1, offerUser.getOfferId());
     this.pstmt.setInt(2, offerUser.getUserId());
     this.pstmt.execute();
   } catch (SQLException e) {
     String err = Log.getStackInfo(e);
     myLog.error(err);
     throw new InvocationTargetException(e, err);
   } finally {
     this.free();
   }
 }
Пример #3
0
 public void insertOfferUser(OfferUser offerUser) throws InvocationTargetException {
   String sql = "Insert into offer_user (user_id,offer_id, status)Values(?,?,?)";
   try {
     this.pstmt =
         JDBCDataConnection.getConnection().prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
     this.pstmt.setInt(1, offerUser.getUserId());
     this.pstmt.setInt(2, offerUser.getOfferId());
     this.pstmt.setString(3, offerUser.getStatus());
     this.pstmt.executeUpdate();
   } catch (Exception e) {
     String err = Log.getStackInfo(e);
     myLog.error(err);
     throw new InvocationTargetException(e, err);
   } finally {
     this.free();
   }
 }
Пример #4
0
  public int getFavoriteOfferCount(int offerId) throws InvocationTargetException {
    int count = 0;
    String sql = "select count(*) as count from offer_user " + " where OFFER_ID = ? ";
    try {
      this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
      this.pstmt.setInt(1, offerId);
      ResultSet rs = this.pstmt.executeQuery();
      if (rs.next()) {
        count = rs.getInt(1);
      }

    } catch (Exception e) {
      String err = Log.getStackInfo(e);
      myLog.error(err);
      throw new InvocationTargetException(e, err);
    } finally {
      this.free();
    }
    return count;
  }
Пример #5
0
  public List<Integer> getOfferListIdByUserId(int userId) throws InvocationTargetException {
    List<Integer> offerIdList = new ArrayList<Integer>();
    String sql = "select offer_id as offerId from offer_user " + " where USER_ID = ? ";
    try {
      this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
      this.pstmt.setInt(1, userId);
      ResultSet rs = this.pstmt.executeQuery();
      List<Object> obj = ResultSetToModel.parseDataEntityBeanList(rs, "java.lang.Integer");
      Integer offerId = null;
      for (Object object : obj) {
        offerId = (Integer) object;
        offerIdList.add(offerId);
      }
    } catch (Exception e) {

      String err = Log.getStackInfo(e);
      myLog.error(err);
      throw new InvocationTargetException(e, err);
    } finally {
      this.free();
    }
    return offerIdList;
  }
Пример #6
0
  public boolean checkFavorite(int offerId, int userId) throws InvocationTargetException {
    boolean bFavorite = false;
    String sql =
        "select offer_id as offerId, USER_ID as userId, status from offer_user "
            + " where offer_id = ? and USER_ID = ? ";
    try {
      this.pstmt = JDBCDataConnection.getConnection().prepareStatement(sql);
      this.pstmt.setInt(1, offerId);
      this.pstmt.setInt(2, userId);
      ResultSet rs = this.pstmt.executeQuery();
      if (rs.next()) {
        bFavorite = true;
      }
    } catch (SQLException e) {

      String err = Log.getStackInfo(e);
      myLog.error(err);
      throw new InvocationTargetException(e, err);
    } finally {
      this.free();
    }
    return bFavorite;
  }