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