تالار گفتمان nCIS.ir

Cursor result = db.rawQuery("SELECT * from poems WHERE first_category_id=5" , null);

SELECT poems.*,poet.name AS poetname FROM poems LEFT OUTER JOIN poet ON poems.poets_id=poet.id WHERE first_category_id=5

Cursor c = db.rawQuery("SELECT poems.*,poets.name AS poetname FROM poems LEFT OUTER JOIN poets ON poems.poets_id=poets.id WHERE first_category_id=5", null);
ArrayList<String> poetNames = new ArrayList<>();
if (c.moveToFirst()) {
    while (c.moveToNext()) {
        poetNames.add(c.getString(c.getColumnIndex("poetname")));
    }
}

    public List<HashMap <String , Object>> getAshar () {
       
       Cursor result = db.rawQuery
                ("SELECT poems.*,poets.name AS poetname FROM poems LEFT OUTER JOIN poets ON poems.poets_id=poets.id WHERE first_category_id=1" , null);
       
       List<HashMap<String , Object>> all_data= new ArrayList<>();

       while (result.moveToNext())
       {
           HashMap<String , Object> temp= new HashMap<>();

           temp.put("id", result.getString(0));
           temp.put("first_category_id", result.getString(1));
           temp.put("poets_id", result.getString(2));
           temp.put("poetry", result.getString(3));

           all_data.add(temp);
       }
       return all_data;
   }

    private ListView contentListView;
   private List<HashMap<String , Object>> ashar;
   private DatabaseHandler db;

       contentListView = (ListView) findViewById(R.id.list_view);

       db = new DatabaseHandler( getBaseContext() );
       db.open();
       ashar = db.getAshar();

       String[] from= {"poetry", "poets_id"};

       int[] to= {R.id.matne_sher, R.id.shaer};

       SimpleAdapter adb = new SimpleAdapter(
               getBaseContext() , ashar , R.layout.custom_sher_list , from , to
       );

       contentListView.setAdapter( adb );

       db.close();

temp.put("poetname", result.getString(4));

    public List<HashMap <String , Object>> getAshar () {

       Cursor c = db.rawQuery("SELECT poems.*,poets.name AS poetname FROM poems LEFT OUTER JOIN poets ON poems.poets_id=poets.id WHERE first_category_id=1", null);
       ArrayList<String> poetNames = new ArrayList<>();
       if (c.moveToFirst()) {
           while (c.moveToNext()) {
               poetNames.add(c.getString(c.getColumnIndex("poetname")));
           }
       }

       Cursor result = db.rawQuery
("SELECT poems.*,poets.name AS poetname FROM poems LEFT OUTER JOIN poets ON poems.poets_id=poets.id WHERE first_category_id=1"
       , null);

       List<HashMap<String , Object>> all_data= new ArrayList<>();

       while (result.moveToNext())
       {
           HashMap<String , Object> temp= new HashMap<>();

           temp.put("id", result.getString(0));
           temp.put("first_category_id", result.getString(1));
           temp.put("poets_id", result.getString(2));
           temp.put("poetry", result.getString(3));
           temp.put("poetname", result.getString(8));

           all_data.add(temp);
       }
       return all_data;
   }

public List<HashMap <String , Object>> getAshar () {
    Cursor c = db.rawQuery("SELECT poems.*,poets.name AS poetname FROM poems LEFT OUTER JOIN poets ON poems.poets_id=poets.id WHERE first_category_id=1", null);
    List<HashMap<String , Object>> allData = new ArrayList<>();
    while (c.moveToNext()) {
        HashMap<String , Object> temp = new HashMap<>();
        temp.put("id", c.getString(c.getColumnIndex("id"));
        temp.put("first_category_id", c.getString(c.getColumnIndex("first_category_id"));
        temp.put("poets_id", c.getString(c.getColumnIndex("poets_id"));
        temp.put("poetry", c.getString(c.getColumnIndex("poetry"));
        temp.put("poetname", c.getString(c.getColumnIndex("poetname"));
        allData.add(temp);
    }
    return allData;
}