Question

我想提一点问题。我想知道,什么是我能从qlite数据库中收集的我名单观点的最佳方式,我希望视用户在编辑文本中写过信件而对其进行过滤。我不表示任何守则,因为我只字不提,而且这样说。我不得不改变Im使用人口数据库的板块说明。

因此,我的问题是,在用户用编辑文字写进信件时,我如何改变我的精彩发言,我如何能够更新我的清单,更新新的数据,并用新的缩略语。

Answer 1

回答您的先前问题,这些答复非常相似:https://stackoverflow.com/questions/8848100/rosid-add-custom- research-bar-in-application/8891 185 p8891 185>

Answer 2

我有同样的问题,并解决了如下问题:

//Search text and changed handler
        EditText tbSearch = (EditText)findViewById(R.id.android_searchbox);
        tbSearch.addTextChangedListener(new TextWatcher() {
            public void onTextChanged(CharSequence s, int start, int before, int count) {
            }

            public void beforeTextChanged(CharSequence s, int start, int count, int after) {
            }

            public void afterTextChanged(Editable s) {
                ListView av = getListView();
                SimpleCursorAdapter filterAdapter = (SimpleCursorAdapter)av.getAdapter();
                filterAdapter.getFilter().filter(s.toString());
            }
        });

        entries.setFilterQueryProvider(new FilterQueryProvider() {
            public Cursor runQuery(CharSequence constraint) {
                return mDbHelper.fetchAllEntries(constraint);
            }
        });

With this approach you will need a method similar to FetchAllEntries(string sFilter)

/*
 * Override to return a Cursor over the list of Entries filtered by a
 * constraint
 * 
 * @return Cursor over filtered Entries
 */
public Cursor fetchAllEntries(CharSequence constraint) {

    if (constraint == null || constraint.length() == 0) {
        // Return the full list
        return fetchAllEntries();
    } else {

        String value = "%" + constraint.toString() + "%";

        String[] columns = new String[] { KEY_ROWID, KEY_TITLE,
                KEY_BODY, KEY_USER_PROFICIENCY };

        return mDb.query(DATABASE_TABLE, columns,
                KEY_TITLE + " like ? OR " + KEY_BODY + " like ? ", new String[] { value, value }, null, null,
                KEY_TITLE + " ASC ");

    }
}

这里的表格有两栏(标题、机构)。

友情链接