コード例 #1
0
  @Override
  public List<DBUser> findByFriendGroup(DBFriendGroup friendGroup) {
    db = getTransactionDB();

    Cursor cursor =
        db.rawQuery(
            "SELECT "
                + DBColumns.FRIEND_STATE_USER_ACCOUNT
                + " FROM "
                + DBColumns.FRIEND_STATE_TABLE_NAME
                + " WHERE "
                + DBColumns.FRIEND_STATE_FRIEND_GROUP_ACCOUNT
                + "=?",
            new String[] {friendGroup.getAccount()});
    int i = 0;
    String[] us = new String[cursor.getCount()];
    while (cursor.moveToNext()) {
      us[i++] = cursor.getString(0);
    }
    cursor.close();

    List<DBUser> users = new ArrayList<DBUser>();
    for (int j = 0; j < us.length; j++) {
      users.add(userDao.findByAccount(us[j]));
    }

    return users;
  }
コード例 #2
0
  @Override
  public List<DBFriendGroupMapping> findMappingByFriendGroup(DBFriendGroup friendGroup) {
    // friendgroup中分组中包含的user,及user状态
    db = getTransactionDB();
    Cursor cursor =
        db.rawQuery(
            "SELECT * FROM "
                + DBColumns.FRIEND_STATE_TABLE_NAME
                + " WHERE "
                + DBColumns.FRIEND_STATE_FRIEND_GROUP_ACCOUNT
                + "=?",
            new String[] {friendGroup.getAccount()});
    List<DBFriendGroupMapping> mappings = new ArrayList<DBFriendGroupMapping>();
    while (cursor.moveToNext()) {
      String userAccount =
          cursor.getString(cursor.getColumnIndex(DBColumns.FRIEND_STATE_USER_ACCOUNT));
      DBUser user = userDao.findByAccount(userAccount);
      mappings.add(DBObjectHelper.getDB3FriendGroupMapping(user, friendGroup, cursor));
    }
    cursor.close();

    return mappings;
  }