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