问从SQLite数据库加载的AutocompleteText

EN

private static final String CREATE_TABLE_QUESTION =
        "CREATE TABLE  " + TABLE_QUESTION + "("
        + KEY_ID_QUESTION + " INTEGER PRIMARY KEY autoincrement NOT NULL, "
        + KEY_QUESTION + " TEXT, "
        + KEY_PROFIL_CIBLE + " TEXT, "
        + KEY_PROFIL_WAITEDANSWER + " TEXT, "
        + KEY_REGLE + " TEXT, "
        + KEY_PLANACT + " TEXT, "
        + KEY_THEME + " TEXT"
        + ")";

public ArrayList getQuestionForSearch() {
    ArrayList lst = new ArrayList();
    int zise = lst.size();
    Random rand = new Random();
    SQLiteDatabase db = this.getReadableDatabase();

    // Cursor c = db.rawQuery(" SELECT  DISTINCT " + KEY_QUESTION + " from " + TABLE_QUESTION+ " where " +KEY_QUESTION+ " LIKE '%" +search+ "%'" , null);
    Cursor c = db.rawQuery(" SELECT " + KEY_QUESTION + " from " + TABLE_QUESTION, null);

    if (c.moveToFirst()) {
        while (c.isAfterLast() == false) {
            String t1 = c.getString(c.getColumnIndex(KEY_QUESTION));
            lst.add(t1);
            c.moveToNext();
        }
    }
    return lst;
}

<AutoCompleteTextView xmlns:android="http://schemas.android.com/apk/res/android"
        android:id="@+id/txtcomplete"
        android:layout_width="wrap_content"
        android:hint="Tapez votre recherche ici"
        android:layout_height="wrap_content"
        app:layout_constraintLeft_toLeftOf="parent"
        app:layout_constraintRight_toRightOf="parent"
        tools:layout_editor_absoluteY="0dp"
        tools:ignore="MissingConstraints" />

AutoCompleteTextView txt = (AutoCompleteTextView)findViewById(R.id.txtcomplete);

ModelHelper md = new ModelHelper(this);

String search= txt.getText().toString();
//getting list from the modelhelper
ArrayList<String> questions= md.getQuestionForSearch();
//arrayadapter
ArrayAdapter<String> myadap =   new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1);
//set the adapter to the autocomplete text
txt.setAdapter(myadap);