Autocomplete means it show the complete text automatically.It have two types
1.Single line autocomplete
2.Multi line autocomplete
what letter we type in the searchbox,that letter of the complete words to show.Here i use autocomplete searchbox ,The select item can pass into the textview
.I use DATABASE NAME as="itemsearchsqlite.db",TABLE NAME as="itemsearch" and DB COLUMN NAME as="item_name".
I use two java classes namely Home.java and SQLiteItemsearch.java
//SQLiteItemSearch.java//
------------------------
package com.autocomplete.sample;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class SQLiteItemSearch extends SQLiteOpenHelper
{
private static final String DB_NAME = "itemsearchsqlite.db";
private static final int DB_VERSION_NUMBER = 1;
private static final String DB_TABLE_NAME = "itemsearch";
private static final String DB_COLUMN_1_NAME = "item_name";
private static final String DB_CREATE_SCRIPT = "create table " + DB_TABLE_NAME +
" (_id integer primary key autoincrement, item_name text not null);)";
private SQLiteDatabase sqliteDBInstance = null;
public SQLiteItemSearch(Context context)
{
super(context, DB_NAME, null, DB_VERSION_NUMBER);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
// TODO: Implement onUpgrade
}
@Override
public void onCreate(SQLiteDatabase sqliteDBInstance)
{
Log.i("onCreate", "Creating the database...");
sqliteDBInstance.execSQL(DB_CREATE_SCRIPT);
}
public void openDB() throws SQLException
{
Log.i("openDB", "Checking sqliteDBInstance...");
if(this.sqliteDBInstance == null)
{
Log.i("openDB", "Creating sqliteDBInstance...");
this.sqliteDBInstance = this.getWritableDatabase();
}
}
public void closeDB()
{
if(this.sqliteDBInstance != null)
{
if(this.sqliteDBInstance.isOpen())
this.sqliteDBInstance.close();
}
}
public long insertitmSearch(String ItemBrandName)
{
ContentValues contentValues = new ContentValues();
contentValues.put(DB_COLUMN_1_NAME, ItemBrandName);
Log.i(this.toString() + " - insertitmSearch", "Inserting: " + ItemBrandName);
return this.sqliteDBInstance.insert(DB_TABLE_NAME, null, contentValues);
}
public boolean removeitmSearch(String ItemBrandName)
{
int result = this.sqliteDBInstance.delete(DB_TABLE_NAME, "item_name='" + ItemBrandName + "'", null);
if(result > 0)
return true;
else
return false;
}
public long updateitmSearch(String oldItemBrandName, String newItemBrandName)
{
ContentValues contentValues = new ContentValues();
contentValues.put(DB_COLUMN_1_NAME, newItemBrandName);
return this.sqliteDBInstance.update(DB_TABLE_NAME, contentValues, "item_name='" + oldItemBrandName + "'", null);
}
public String[] getAllItemFilter()
{
Cursor cursor = this.sqliteDBInstance.query(DB_TABLE_NAME, new String[] {DB_COLUMN_1_NAME}, null, null, null, null, null);
if(cursor.getCount() >0)
{
String[] str = new String[cursor.getCount()];
int i = 0;
while (cursor.moveToNext())
{
str[i] = cursor.getString(cursor.getColumnIndex(DB_COLUMN_1_NAME));
i++;
}
return str;
}
else
{
return new String[] {};
}
}
}
Then again we have to insert a rows of dataitems inside of the Home.java class
public class Home extends Activity {
private SQLiteItemSearch sqllitebb;
TextView tv;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.list_item);
final AutoCompleteTextView actv=(AutoCompleteTextView)findViewById(R.id.autocompleteitem);
sqllitebb=new SQLiteItemSearch(Home.this);
sqllitebb.openDB();
// Insert a few item list statically//
sqllitebb.insertitmSearch("Color Monitor");
sqllitebb.insertitmSearch("Compact Disk");
sqllitebb.insertitmSearch("Computer");
sqllitebb.insertitmSearch("Copy Righter");
sqllitebb.insertitmSearch("Hard Disk");
sqllitebb.insertitmSearch("HP Printer");
sqllitebb.insertitmSearch("HP Laser Printer");
sqllitebb.insertitmSearch("HP Injet Printer");
// sqllitebb.removeitmsearch("Computer");
// sqllitebb.updateitmSearch("Computer","DELL");
final String[] deal = sqllitebb.getAllItemFilter();
// Print out the values to the log
for(int i = 0; i < deal.length; i++)
{
Log.i(this.toString(), deal[i]);
}
ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,android.R.layout.simple_dropdown_item_1line,deal);
actv.setAdapter(adapter);
actv.setThreshold(1);
actv.setOnItemClickListener(new OnItemClickListener() {
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2, long arg3) {
tv=(TextView)findViewById(R.id.selecteditem_tv);
tv.setText(deal[arg2]);
arg0.getItemAtPosition(arg2);
Log.i("SELECTED TEXT WAS------->", deal[arg2]);
}
});
}
public void onDestroy()
{
super.onDestroy();
sqllitebb.close();
}
}
Have to drag and drop the autocomplete control,the two textview controls.
[code=list_item.xml]
<LinearLayout xmlns:android="
http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:padding="5dp" android:orientation="vertical">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="ITEM_SEARCH" />
<AutoCompleteTextView android:id="@+id/autocompleteitem"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_marginLeft="5dp"/>
<TextView android:text="TextView" android:id="@+id/selecteditem_tv" android:layout_width="wrap_content" android:layout_height="wrap_content"></TextView>
</LinearLayout>
If u want to check the database in sqlite,no problem Go to DDMS or
Go to Window->open Perspective-> select File explorer->go to data, then->select data->inside of the data all packages are availabel,here my application
package name is com.autocomplete.sample,after select our package there is two options are availabel 1.databases,2.lib.first have to select it or open it.open
databases inside of the databases our application database name itemsearchsqlite.db had held we have to pull a file from the device.u have to choose the db
in any location,for example i select desktop and pull it .Then u go to Android-SDK,inside of the SDK u have to open Tools,because the sqlite3 has present
inside of the tools.u click the sqlite3.open our db in desktop asusal click right side ,go to open with and select SQLITE3.At the begining we have to type
DOT or .tables,In sqlite it shows our correct and current table name at the final open our table like select * from itemsearch;
finished all the things.ITS show our records.
Note:If u not understand my hints means better u see my screen schots.
Go to Android SDK
Open DB in desktop
Download full source code
