android之自定义SimpleCursorAdapter的使用

来源：互联网发布：protobuf.js 教程编辑：程序博客网时间：2024/04/28 11:16

SimpleCursorAdapter直接使用的方法：

SimpleCursorAdapter允许你绑定一个游标的列到ListView上，并使用自定义的layout显示每个项目。

SimpleCursorAdapter的创建，需要传入当前的上下文、一个layout资源，一个游标和两个数组：一个包含使用的列的名字，另一个（相同大小）数组包含View中的资源ID，用于显示相应列的数据值。

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
//第一步：从数据库读取数据
        dbHelper = newDBHelper(HistoryOrderActivity.this);
        database = dbHelper.getWritableDatabase();
        cursor = database.rawQuery("SELECT * FROM "+DBHelper.TABLE_ORDER+" where feedbackTime is not null",null);
        //startManagingCursor(cursor); 被遗弃的方法，主要是把cursor的生命周期交由Activity管理
        String[] fromColumns = newString[] {
                "orderDescription",
                "orderEffectiveTime",
                "orderConsumeTime",
                "promotion",
                "feedbackInfo",
                "feedbackTime",
                };
        int[] toLayoutIDs = newint[] { 
                R.id.description,
                R.id.effectiveTime,
                R.id.consumeTime,
                R.id.promotion,
                R.id.feedbackInfo,
                R.id.feedbackTime};
        adapter = newSimpleCursorAdapter(this, R.layout.histortyorder, cursor, fromColumns, toLayoutIDs,0);

SimpleCursorAdapter自定义的使用：

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
//第一步：从数据库读取数据
        dbHelper = newDBHelper(HistoryOrderActivity.this);
        database = dbHelper.getWritableDatabase();
        cursor = database.rawQuery("SELECT * FROM "+DBHelper.TABLE_ORDER+" where feedbackTime is not null",null);
        //startManagingCursor(cursor); 被遗弃的方法，主要是把cursor的生命周期交由Activity管理
        String[] fromColumns = newString[] {
                "orderDescription",
                "orderEffectiveTime",
                "orderConsumeTime",
                "promotion",
                "feedbackInfo",
                "feedbackTime",
                };
        int[] toLayoutIDs = newint[] { 
                R.id.description,
                R.id.effectiveTime,
                R.id.consumeTime,
                R.id.promotion,
                R.id.feedbackInfo,
                R.id.feedbackTime};
        if(cursor == null) {
            return;
        }
        adapter = newHistoryOrderAdapter(HistoryOrderActivity.this, R.layout.histortyorder,
                cursor, fromColumns, toLayoutIDs, 0);

适配器的实现：

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
publicclass HistoryOrderAdapter extendsSimpleCursorAdapter {
    privateCursor m_cursor;
    privateContext m_context;
    privateLayoutInflater miInflater;
 
    publicHistoryOrderAdapter(Context context, intlayout, Cursor c,
            String[] from, int[] to, intflags) {
        super(context, layout, c, from, to, flags);
        m_context = context;
        m_cursor = c;
    }
 
    @Override
    publicvoid bindView(View arg0, Context arg1, Cursor arg2) {
        View convertView = null;
        if(arg0 == null) {
            convertView = miInflater.inflate(R.layout.histortyorder, null);
        }else{
            convertView = arg0;
        }
        TextView tv_Description = (TextView) convertView
                .findViewById(R.id.description);
        TextView tv_EffectiveTime = (TextView) convertView
                .findViewById(R.id.effectiveTime);
        TextView tv_ConsumeTime = (TextView) convertView
                .findViewById(R.id.consumeTime);
        TextView tv_promotion = (TextView) convertView
                .findViewById(R.id.promotion);
        TextView tv_FeedbackInfo = (TextView) convertView
                .findViewById(R.id.feedbackInfo);
        TextView tv_FeedbackTime = (TextView) convertView
                .findViewById(R.id.feedbackTime);
 
        tv_Description.setText(arg2.getString(arg2
                .getColumnIndex("orderDescription")));
        tv_EffectiveTime.setText(ShopUtils.changeTimestampToTime(Long
                .valueOf(arg2.getString(arg2
                        .getColumnIndex("orderEffectiveTime")))));
        tv_ConsumeTime
                .setText(ShopUtils.changeTimestampToTime(Long.valueOf(arg2
                        .getString(arg2.getColumnIndex("orderConsumeTime")))));
        tv_promotion.setText(arg2.getString(arg2.getColumnIndex("promotion")));
        tv_FeedbackInfo.setText(arg2.getString(arg2
                .getColumnIndex("feedbackInfo")));
        tv_FeedbackTime.setText(ShopUtils.changeTimestampToTime(Long
                .valueOf(arg2.getString(arg2.getColumnIndex("feedbackTime")))));
    }
}

HistoryOrderAdapter有点糙，需要改进。

0 0