我有一个正在从使用SimpleCursorAdapter SQLite数据库填充的列表视图。一个光标返回的列是一个整数值0或1。在我的列表视图中，我想一个更友好的形式来显示这个（即是或否），并可能用不同的文本颜色每个。下面是我的源：

I have a list view that is being populated from an SQLite database using the SimpleCursorAdapter. One of the columns being returned in the cursor is an integer value 0 or 1. In my list view, I would like to display this in a more friendly form (ie. "Yes" or "No") and possibly with different text colors for each. Here is my source:

Cursor c = dbHelper.fetchAllItems();
startManagingCursor(c);

String[] from = {"deployed", "designation", "serial"};
int[] to = {R.id.deployed, R.id.designation, R.id.serial};

setListAdapter(new SimpleCursorAdapter(this, R.layout.list_item, c, from, to));

我将如何有条件开关元件和/或属性的布局时，SimpleCursorAdapter每个视图的列名映射简单。 （它是安全的假设，我不能用SimpleCursorAdapter做到这一点？）

How would I conditionally switch elements and/or properties in the layout when the SimpleCursorAdapter simply maps each view to a column name. (Is it safe to assume I can't use SimpleCursorAdapter to accomplish this?)

推荐答案

通过添加自定义适配器，延长CursorAdapter的解决

Solved by adding a custom adapter, extending CursorAdapter

修改

Cursor c = dbHelper.fetchAllItems();
startManagingCursor(c);

setListAdapter(new RowAdapter(this, c));

新的嵌套类：

private static class RowAdapter extends CursorAdapter {

    public RowAdapter(Context context, Cursor c) {
        super(context, c);
    }

    public void bindView(View view, Context context, Cursor c) {
        TextView vDesignation = (TextView) view.findViewById(R.id.designation);
        TextView vSerial = (TextView) view.findViewById(R.id.serial);
        TextView vDeployed = (TextView) view.findViewById(R.id.deployed);

        String designation = c.getString(c.getColumnIndexOrThrow("designation"));
        String serial = c.getString(c.getColumnIndexOrThrow("serial"));
        int deployed = c.getInt(c.getColumnIndexOrThrow("deployed"));

        vDesignation.setText(designation);
        vSerial.setText(serial);
        vDeployed.setText(deployed > 0 ? R.string.yes : R.string.no);
        vDeployed.setTextColor(deployed > 0 ? view.getResources().getColor(R.color.yes) : view.getResources().getColor(R.color.no));
    }

    public View newView(Context context, Cursor c, ViewGroup parent) {
        LayoutInflater inflater = LayoutInflater.from(context);
        View view = inflater.inflate(R.layout.list_item, parent, false);
        bindView(view, context, c);
        return view;
    }
}