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;
}
