厲害啦

你是真的牛逼

解決了。

有兩個(gè)地方需要改。

1. ?public Cursor getAllCostData() {
   ? ?SQLiteDatabase database = getWritableDatabase();
   ? ?return database.query("imooc_daily", null, null, null, null, null, "cost_date" +"ASC");
   }最后面的排序需要改成 "cost_date ASC"

2. if (cursor != null) {
   ? ?while (cursor.moveToNext()) {
   ? ? ? ?CostBean costBean = new CostBean();
   ? ? ? ?costBean.costTitle = cursor.getString(cursor.getColumnIndex("cost_title"));
   ? ? ? ?costBean.costDate = cursor.getString(cursor.getColumnIndex("cost_date"));
   ? ? ? ?costBean.costMoney = cursor.getString(cursor.getColumnIndex("cost_money"));
   ? ? ? ?mCostBeanList.add(costBean);
   ? ?}
   ? ?cursor.close();
   }這里獲取不了cost_money的準(zhǔn)確列數(shù)，所以需要改成如下形式。

????????if (cursor != null) {
? ?while (cursor.moveToNext()) {
? ? ? ?CostBean costBean = new CostBean();
? ? ? ?int dataColumnIndex = cursor.getColumnIndex("cost_title");
? ? ? ?costBean.costTitle = cursor.getString(dataColumnIndex + 0);
? ? ? ?costBean.costDate = cursor.getString(dataColumnIndex + 1);
? ? ? ?costBean.costMoney = cursor.getString(dataColumnIndex + 2);
? ? ? ?mCostBeanList.add(costBean);
? ?}
? ?cursor.close();
}這里是以cost_title為基準(zhǔn)列數(shù)，向后退出cost_date和cost_money的列數(shù)。