public List<Good> getGoodFromDB() { List<Good> goodList = new ArrayList<Good>(); Cursor cursor = db.rawQuery("SELECT * FROM Good", null); // Cursor cursor = db.query("Good", null, null, null, null, null, null); Log.e("Gank", "开始查询!"); if (cursor.moveToFirst()) { do { Good good = new Good(); good.set_id(cursor.getString(cursor.getColumnIndex("_id"))); good.setWho(cursor.getString(cursor.getColumnIndex("who"))); Log.e("Gank", "开始查询!who = " + cursor.getString(cursor.getColumnIndex("who"))); good.setPublishedAt(cursor.getString(cursor.getColumnIndex("publishedAt"))); good.setDesc(cursor.getString(cursor.getColumnIndex("desc"))); good.setType(cursor.getString(cursor.getColumnIndex("type"))); good.setUrl(cursor.getString(cursor.getColumnIndex("url"))); goodList.add(good); } while (cursor.moveToNext()); } if (cursor != null) { cursor.close(); } db.close(); return goodList; }