public ArrayList<Shopping> getShoppings() {
ArrayList<Shopping> mShoppings = new ArrayList<Shopping>();
String table = "Happy";
String[] columns = {"*"};
String selection = null;
String[] selectionArgs = null;
String groupBy = null;
String having = null;
String orderBy = "id";
if (CheckTable.tabbleIsExist(context, table)) {
Cursor c = db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy);
while (c.moveToNext()) {
Shopping shopping = new Shopping();
shopping.setId(c.getString(c.getColumnIndex("id")));
shopping.setName(c.getString(c.getColumnIndex("name")));
shopping.setLogo(c.getString(c.getColumnIndex("logo")));
shopping.setXpoint(c.getString(c.getColumnIndex("xpoint")));
shopping.setYpoint(c.getString(c.getColumnIndex("ypoint")));
shopping.setApi_address(c.getString(c.getColumnIndex("api_address")));
shopping.setMzeatvip(c.getString(c.getColumnIndex("mzeatvip")));
shopping.setAvg_point(c.getString(c.getColumnIndex("avg_point")));
shopping.setTel(c.getString(c.getColumnIndex("tel")));
shopping.setCharacteristic(c.getString(c.getColumnIndex("Characteristic")));
shopping.setOpen_time(c.getString(c.getColumnIndex("open_time")));
shopping.setComment_count(c.getString(c.getColumnIndex("comment_count")));
shopping.setBrand_id(c.getString(c.getColumnIndex("brand_id")));
shopping.setDistance(c.getString(c.getColumnIndex("distance")));
shopping.setMobile_brief(c.getString(c.getColumnIndex("mobile_brief")));
mShoppings.add(shopping);
}
c.close();
}
return mShoppings;
}
