Android cursor遍历数据

数据存储为一行多列时

Person person = new Person();
double amount = 0;
if (cursor != null && cursor.moveToFirst()) {
	int indexOfPerson = cursor.getColumnIndex(Calculate.COLUMN_PERSON);
	int indexOfAmount = cursor.getColumnIndex(Calculate.COLUMN_AMOUNT);

	String personStr = cursor.getString(indexOfPerson);
	person = JSONObject.parseObject(personStr, Person.class);

	amount = cursor.getDouble(indexOfAmount);

}
1
2
3
4
5
6
7
8
9
10
11
12

数据存储为多行多列时

if (cursor != null && cursor.moveToFirst()) {
	Role[] roles = new Role[cursor.getCount()];
	int roleIndex = cursor.getColumnIndex(Role.COLUMN_ROLE);

	while (cursor.moveToNext()) {
		Role role = JSONObject.parseObject(cursor.getString(roleIndex), Role.class);
		roles[cursor.getPosition()] = role;
	}
	return roles;

}
1
2
3
4
5
6
7
8
9
10
11