androidsqlitelistactivitycustom-adapter

search a value from sqlite database and retrieve in listview


How to find the exact data in sqlite database and retrieve it in a listactivity? I tried like this but I didn't get the value.

search = (EditText) findViewById(R.id.alertsearch);

search.addTextChangedListener(new TextWatcher(){

        @Override
        public void afterTextChanged(Editable s) {
            // TODO Auto-generated method stub
            list2.clear();
            db =  openOrCreateDatabase(Contactsnew.DB_NAME, MODE_PRIVATE, null);
            Cursor cTitle=db.rawQuery(" SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE " 
                    + Contactsnew.userid + " = " + GetSet.getUserId() + " AND " + Contactsnew.TITLE +
                     " LIKE ? " ,new String []{search.getText()+"%"});
            custAdapter.changeCursor(cTitle);

            while(cTitle.moveToNext()){
                list2.add(cTitle.getString(2));
                }
            cTitle.close();
        }

Solution

  • In your sqliteconnecter create a method and call that method from your respective class. Now type the following code in ur sqlite class.

    Cursor cusror;
    
    cursor=db.rawQuery("SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE " 
                    + Contactsnew.userid + " = " + Contactsnew.userId + " AND " + Contactsnew.TITLE +
                     " LIKE  '"+search.getText()+"%'");
    

    print the query in a string and check whether you are getting the correct values, then return the cursor.

    try this and say!!