Realm数据库使用教程（三），安卓资深架构师分享学习经验及总结

long min = results.min(“age”).longValue();

long max = results.max(“age”).longValue();

double average = results.average(“age”);

long matches = results.size();

Log.d(“huangxiaoguo”, “sum=” + sum + “,min=” + min + “,max=” + max +

“,average=” + average + “,matches=” + matches);

• or的使用

RealmResults menList2 = mRealm.where(Men.class)

.equalTo(“name”, “huangxiaoguo0”)

.or().equalTo(“name”, “huangxiaoguo2”)

.findAll();

for (int i = 0; i < menList2.size(); i++) {

Log.d(“huangxiaoguo”, “name=” + menList2.get(i).getName() +

“,age=” + menList2.get(i).getAge());

}

• 排序

RealmResults menList3 = mRealm.where(Men.class).findAll();

menList3 = menList3.sort(“age”); //根据age，正序排列

for (int i = 0; i < menList3.size(); i++) {

Log.d(“huangxiaoguo”, “name=” + menList3.get(i).getName() +

“,age=” + menList3.get(i).getAge());

}

menList3 = menList3.sort(“age”, Sort.DESCENDING);//逆序排列

for (int i = 0; i < menList3.size(); i++) {

Log.d(“huangxiaoguo”, “name=” + menList3.get(i).getName() +

“,age=” + menList3.get(i).getAge());

}

• 区间查询

RealmResults menList4 = mRealm.where(Men.class)

.between(“age”, 0, 30)

.findAll();

for (int i = 0; i < menList4.size(); i++) {

Log.d(“huangxiaoguo”, “name=” + menList4.get(i).getName() +

“,age=” + menList4.get(i).getAge());

}

Realm数据库使用教程（四）：更新数据