mardi 2 février 2016

my database loads all of my data in listview every time database called

i'm pretty sure my sqlite syntax is right. but i don't know why when database loaded in my listview it returns all of my data. i think the problem is about my cursor snippet. how can i fix this problem that load only rows that table_one.id = table_two.day_id

 @Override
    public List<Model> getAllEx() {
        SQLiteDatabase db = helper.getWritableDatabase();
        List<Model> list = new ArrayList<>();
        String query = "SELECT * FROM " + Constants.TABLE_ONE + " INNER JOIN " + Constants.TABLE_TWO +" ON "+
                Constants.ID_ONE + " = " + Constants.ID_DAY;
      
        Cursor c = db.rawQuery(query, null);
        while (c.moveToNext()) {

            Model model = new Model();
            model.setSecond_id(c.getInt(c.getColumnIndex(Constants.ID_TWO)));
            model.setExercise(c.getString(c.getColumnIndex(Constants.EXERSICE)));
            model.setNumber(c.getString(c.getColumnIndex(Constants.NUMBER)));
            model.setReps(c.getString(c.getColumnIndex(Constants.REPS)));
            model.setId_day(c.getInt(c.getColumnIndex(Constants.ID_DAY)));

            list.add(model);
        }
        return list;
    }

Aucun commentaire:

Enregistrer un commentaire