android数据库，查询满足条件的数据集合，并且返回List<E>

 

　　/***
     *取得主卦所有名称和gua_id并且返回。用于浏览64卦。
     */
    public List<Divine> getZhuGua() {

        List<Divine> divines = new ArrayList<Divine>();
        //  Cursor cursor = db.query("divine", null, "yao_shu=0", null, null, null, "_id ", null);
        Cursor cursor = db.rawQuery("select  _id,gua_id,gua_name  from divine where yao_shu = 0", null);


        cursor.moveToFirst();
        int i = 0;
        while (!cursor.isAfterLast()) {
            Divine d = new Divine();
            d.set_id(cursor.getInt(cursor.getColumnIndex("_id")));
            d.setGua_name(cursor.getString(cursor.getColumnIndex("gua_name")));
            d.setGua_id(cursor.getString(cursor.getColumnIndex("gua_id")));
            i=i+1;
            Log.e("TAGxx ----------", i + cursor.getString(cursor.getColumnIndex("gua_name")));
            divines.add(d);
            cursor.moveToNext();
        }

        


        cursor.close();
        db.close();

        return divines;

    }

 

转载于:https://www.cnblogs.com/sdgtxuyong/p/10625478.html