mercredi 6 mai 2015

AutoCompleteTextView retrieve from sqlite database

I have problem to retrieve data. When click suggestion at AutoCompleteTextView should be call data where we selected. But how can I retrieve data from sqlite line when we click at AutoCompleteTextView suggestion. I already fetch data from database to AutoCompleteTextView .

Thanks Who helping me,
very appreciate it,
Thanks regards,
Hafizul Reza

 private void item() {

   Cursor c=null;

    EditText editText = (EditText)findViewById(R.id.languages);

    String editTextStr = editText.getText().toString();

    DatabaseHelper db = new DatabaseHelper(getApplicationContext());
    List<String> list = db.getAllLabels();

    ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.select_dialog_singlechoice, list);

    AutoCompleteTextView acTextView = (AutoCompleteTextView) findViewById(R.id.languages);

    acTextView.setThreshold(2);
    //Set the adapter
    acTextView.setAdapter(adapter);

    acTextView.setOnItemClickListener(new OnItemClickListener() {



        @Override
        public void onItemClick(AdapterView<?> arg0, View arg1, int arg2, long arg3) {

            DatabaseHelper myDbHelper = new DatabaseHelper(MapsActivity.this);

            Toast.makeText(getApplicationContext(), (CharSequence) arg0.getItemAtPosition(arg2), Toast.LENGTH_LONG).show();

            AutoCompleteTextView editText = (AutoCompleteTextView)findViewById(R.id.languages);

            String editTextStr = editText.getText().toString();

            Toast.makeText(getApplicationContext(), "Masuk dah!!",
                    Toast.LENGTH_LONG).show();

            mMap.clear();

            SQLiteDatabase db = myDbHelper.getWritableDatabase();
            String selectQuery = "SELECT  * FROM Landslide where Location like '%"+ editTextStr+"%'";
            Cursor c = db.rawQuery(selectQuery, null);

            String loc = c.getString(3);
            lat = c.getDouble(4);
            lng = c.getDouble(5);
            String date = c.getString(1);

                    mMap.addMarker(new MarkerOptions()
                            .position(new LatLng(lat, lng))
                            .title(loc + "")
                            .snippet("Latitude:" + lat + " " + "Longitude:" + lng + " " + "Date:" + date + "")
                            .icon(BitmapDescriptorFactory.fromResource(R.drawable.red1)));
        }
    });

Aucun commentaire:

Enregistrer un commentaire