问将SQLite查询转换为领域查询Android

EN

public List<table_People> getPeople(String filter)
{
    List<table_People> items = new ArrayList<>();

    filter = filter.trim();
    filter = filter.toUpperCase();

    String selectQuery = "SELECT  * FROM People " +
            "WHERE (UPPER(LastName || FirstName) LIKE '%" + filter + "%') " +
            "OR (UPPER(FirstName || LastName) LIKE '%" + filter + "%') ";

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
        do {
            table_People item = new table_People(
                    cursor.getInt((cursor.getColumnIndex("ID"))),
                    cursor.getString((cursor.getColumnIndex("FirstName"))),
                    cursor.getString((cursor.getColumnIndex("LastName")))
            );
            items.add(item);
        } while (cursor.moveToNext());
    }
    return items;
}