android开发中将从数据库中获取的List数据进行迭代，将其中数据取出并赋值

android开发中将从数据库中获取的List数据进行迭代，将其中数据取出并赋值

List<Person> personList = mMySQLiteOpenHelper.queryFromDbById_person(ID);
        for (Person per : personList) {
            HP = per.getLife();
            DEF = per.getDefense();
            ATT = per.getAd();
            SPD = per.getSpeed();
        }

Person是List中的数据类型。

以下是在数据库中进行查询操作时，查询函数的详细代码。

public List<Person> queryFromDbById_person(String id) {

        SQLiteDatabase db = getWritableDatabase();
        List<Person> list = new ArrayList<>();

        Cursor cursor = db.query(TABLE_NAME_PERSON, null, "id like ? ", new String[]{id}, null, null, null);

        if (cursor != null) {

            while (cursor.moveToNext()) {
                int level = cursor.getInt(cursor.getColumnIndex("level"));
                int exp = cursor.getInt(cursor.getColumnIndex("exp"));
                int stamina = cursor.getInt(cursor.getColumnIndex("stamina"));
                int money = cursor.getInt(cursor.getColumnIndex("money"));
                int life = cursor.getInt(cursor.getColumnIndex("life"));
                int defense = cursor.getInt(cursor.getColumnIndex("defense"));
                int ad = cursor.getInt(cursor.getColumnIndex("ad"));
                int speed = cursor.getInt(cursor.getColumnIndex("speed"));

                Person person = new Person();
                person.setLevel(level);
                person.setExp(exp);
                person.setStamina(stamina);
                person.setMoney(money);
                person.setLife(life);
                person.setDefense(defense);
                person.setAd(ad);
                person.setSpeed(speed);
                list.add(person);
            }
            cursor.close();
        }
        return list;
    }