存储数据列表的两种方式

int position=1;

Cursor cursor = atfDB.getCursorScrollData(0, 20);

publicCursor getCursorScrollData(intoffset,intmaxResult){

        Cursor cursor = db.rawQuery("select _id as _id,give_name,family_name,plate_no,service_date,brand,model,key_id 
					from history_list limit ?,?",
                new String[]{String.valueOf(offset), String.valueOf(maxResult)});
        return cursor;
    }

1.

private List<Map<String, Object>> data;
data = getData();
放数据:
private List<Map<String, Object>> getData() {
    List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
    Map<String, Object> map;
    while(cursor.moveToNext())
    {
         map = new HashMap<String, Object>();
        map.put("id", cursor.getString(cursor.getColumnIndex("_id")));
        map.put("date", cursor.getString(cursor.getColumnIndex("service_date")));
        map.put("plate_no", cursor.getString(cursor.getColumnIndex("plate_no")));
        map.put("give_name", cursor.getString(cursor.getColumnIndex("give_name")));
        map.put("family_name", cursor.getString(cursor.getColumnIndex("family_name")));
        map.put("brand", cursor.getString(cursor.getColumnIndex("brand")));
        map.put("model", cursor.getString(cursor.getColumnIndex("model")));
        map.put("key_id", cursor.getString(cursor.getColumnIndex("key_id")));
        list.add(map);
    }
    return list;
}
取数据:
String []list =new String[6];
list[0]=(String)data.get((position)).get("key_id");
list[1]=(String)data.get((position)).get("plate_no");
list[2]=(String)data.get((position)).get("give_name");
list[3]=(String)data.get((position)).get("family_name");
list[4]=(String)data.get((position)).get("brand");
list[5]=(String)data.get((position)).get("model");

 
2.实例化
ArrayList<HistoryInfo> dataList = new ArrayList<HistoryInfo>();
dataList=getDataHistoryInfo();
private ArrayList<HistoryInfo> getDataHistoryInfo() {
        ArrayList<HistoryInfo> list = new ArrayList<HistoryInfo>();
        Map<String, Object> map;
        while(cursor.moveToNext())
        {
            HistoryInfo history = new HistoryInfo();
            history._id = cursor.getString(cursor.getColumnIndex("_id"));
            history.service_date = cursor.getString(cursor.getColumnIndex("service_date"));
            history.plate_no = cursor.getString(cursor.getColumnIndex("plate_no"));
            history.give_name = cursor.getString(cursor.getColumnIndex("give_name"));
            history.family_name = cursor.getString(cursor.getColumnIndex("family_name"));
            history.brand = cursor.getString(cursor.getColumnIndex("brand"));
            history.model = cursor.getString(cursor.getColumnIndex("model"));
            history.key_id=cursor.getString(cursor.getColumnIndex("key_id"));
            list.add(history);
        }
        return list;
    }
取数据:
String []list =new String[6];
list[0]=dataList.get((position)).key_id;
list[1]=dataList.get((position)).plate_no;
list[2]=dataList.get((position)).give_name;
list[3]=dataList.get((position)).family_name;
list[4]=dataList.get((position)).brand;
list[5]=dataList.get((position)).model;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值