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;