Hi, i made a sample of using a AutoCompleteTextView to showing names which are saved in a database.
Here is the link of project: http://0467525716.free.fr/Android/AutocompleteTest.zip I hope it helps. On 10 mar, 04:26, aljo <aljochim...@gmail.com> wrote: > i already saw that thread but i still can't understand some of the > codes... i don't know how to incorporate my database in that code... > how can i import my db... > > public ContactListAdapter(Context context, Cursor c) { > super(context, c); > Log.d("exp", "******************* A VER EHJEE > *****************"); > mDb = new Database > (context); > <------- (is this where i will put my DB?) > mDb.open(); > Log.d("exp", "******************* A VER PUES 100 > *****************"); > } > > private static final String[] PEOPLE_PROJECTION = new String[] > <----- (is this where autocomplete extracts its data?) > { > Database.KEY_REASON, > Database.KEY_VALUE, > Database.KEY_TAX > }; > > sorry guyz... im kinda new on this whole thing.... > tnx for any of your help... > > On Mar 5, 6:42 pm, roland <roland...@gmail.com> wrote: > > > Check this > > out,http://groups.google.com/group/android-developers/browse_thread/threa... > > > On 4 mar, 07:22, aljo <aljochim...@gmail.com> wrote: > > > > i'm kinda new to this android application and still a newbei to > > > programming so hope someone could help me.... > > > > i've created an SQLitedatabaseprogram.. but i don't know how to use > > > theautocompletefunction to access mydatabase... here's my code: > > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > > packagedatabase.dev5; > > > > import java.util.ArrayList; > > > > import android.app.ListActivity; > > > import android.database.Cursor; > > > import android.database.sqlite.SQLiteDatabase; > > > import android.os.Bundle; > > > import android.widget.ArrayAdapter; > > > import android.widget.EditText; > > > > public classDatabaseextends ListActivity { > > > > private final String MY_DATABASE_NAME = "myCoolDB_2"; > > > private final String MY_DATABASE_TABLE = "Users"; > > > > /** Called when the activity is first created. */ > > > @Override > > > public void onCreate(Bundle icicle) { > > > super.onCreate(icicle); > > > > EditText et = new EditText(this); > > > et.setSelection(et.getText().length()); > > > /* Will hold the 'Output' we want to display at the end. > > > */ > > > ArrayList<String> results = new ArrayList<String>(); > > > > SQLiteDatabase myDB = null; > > > try { > > > > //Create theDatabase(no Errors if it already > > > exists) > > > this.openOrCreateDatabase(MY_DATABASE_NAME, > > > MODE_PRIVATE, null); > > > // Open the DB and remember it > > > myDB = > > > this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, > > > null); > > > > //this.deleteDatabase(MY_DATABASE_NAME); > > > > // Create a Table in theDatabase. > > > myDB.execSQL("CREATE TABLE IF NOT EXISTS " > > > + > > > MY_DATABASE_TABLE > > > + " (English > > > VARCHAR, Japanese VARCHAR," > > > + " MASU_Form > > > VARCHAR, Definition VARCHAR);"); > > > > //myDB.delete(MY_DATABASE_TABLE, null, null); > > > > // Add two DataSets to the Table. > > > /*myDB.execSQL("INSERT INTO " > > > + > > > MY_DATABASE_TABLE > > > + " (English, > > > Japanese, MASU_Form, Definition)" > > > + " VALUES > > > ('yes', 'hai', 'NA', 'noun');"); > > > myDB.execSQL("INSERT INTO " > > > + > > > MY_DATABASE_TABLE > > > + " (English, > > > Japanese, MASU_Form, Definition)" > > > + " VALUES > > > ('yes', 'ee', 'NA', 'noun');"); > > > myDB.execSQL("INSERT INTO " > > > + > > > MY_DATABASE_TABLE > > > + " (English, > > > Japanese, MASU_Form, Definition)" > > > + " VALUES > > > ('call', 'kakeru', 'kakemasu', 'verb: to call');"); > > > myDB.execSQL("INSERT INTO " > > > + > > > MY_DATABASE_TABLE > > > + " (English, > > > Japanese, MASU_Form, Definition)" > > > + " VALUES > > > ('call', 'kakeru', 'kakemasu', 'verb: to wear');"); > > > myDB.execSQL("INSERT INTO " > > > + > > > MY_DATABASE_TABLE > > > + " (English, > > > Japanese, MASU_Form, Definition)" > > > + " VALUES > > > ('call', 'kakeru', 'kakemasu', 'verb: to > > > hang');");*/ > > > > //myDB.delete(MY_DATABASE_TABLE, "LastName" + "=" > > > + "'Ponce'", > > > null); > > > //myDB.delete(MY_DATABASE_TABLE, null, null); > > > > //Query for some results with Selection and > > > Projection. > > > /*Cursor c = myDB.query(MY_DATABASE_TABLE, > > > new String[] {"FirstName, Age "}, > > > null, > > > null, null, null, null, "7"); */ > > > > Cursor c = myDB.query(MY_DATABASE_TABLE, > > > new String[] {"English, Japanese > > > , MASU_Form, Definition"}, > > > "Japanese" + "=" + "'kakeru'", > > > null, null, null, null, "7"); > > > > // Get the indices of the Columns we will need > > > int EnglishColumn = c.getColumnIndex("English"); > > > int JapaneseColumn = c.getColumnIndex("Japanese"); > > > int MASU_FormColumn = > > > c.getColumnIndex("MASU_Form"); > > > int DefinitionColumn = > > > c.getColumnIndex("Definition"); > > > > // Check if our result was valid. > > > if (c != null) { > > > //Check if at least one Result was > > > returned. > > > if (c.moveToFirst()) { > > > int i = 0; > > > // Loop through all Results > > > do { > > > i++; > > > //Retrieve the values of > > > the Entry > > > // the Cursor is > > > pointing to. > > > String english = > > > c.getString(EnglishColumn); > > > String japanese = > > > c.getString(JapaneseColumn); > > > String masu_form = > > > c.getString(MASU_FormColumn); > > > String definition = > > > c.getString(DefinitionColumn); > > > > //Add current Entry to > > > results. > > > results.add("(" + i + ") > > > " + english + ", " + japanese + ", " + > > > masu_form + ", " + definition); > > > > } while (c.moveToNext()); > > > } > > > } > > > > //} catch (FileNotFoundException e) { > > > } finally { > > > if (myDB != null) > > > myDB.close(); > > > } > > > > this.setListAdapter(new ArrayAdapter<String>(this, > > > android.R.layout.simple_list_item_1, > > > results)); > > > } > > > > } > > ... > > plus de détails » --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
