Android AutoCompleteTextView連接數據庫自動提示的方法(附demo源碼下載)

2020-04-11 10:48:45

字體：大中小

來源：轉載

供稿：網友

本文實例講述了Android AutoCompleteTextView連接數據庫自動提示的方法。分享給大家供大家參考，具體如下：

這個簡單例子也體現MVC的思想。AutoCompleteTextView 就是View，而SimpleCursorAdapter就是Controller，SQLiteOpenHelper就相當于Model。

1、首先定義MVC中的Model，自定義DBHelper類繼承SQLiteOpenHelper用于訪問數據庫

import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;/** * * @author lai_zs * @date：2012-2-16 下午4:16:02 */public class DBHelper extends SQLiteOpenHelper {  private static final int DATABASE_VERSION = 1;  private static final String DATABASE_NAME = "autoComplete.db";  // 根據name自動查詢  public static final String NAME = "name";  public DBHelper(Context context) {    super(context, DATABASE_NAME, null, DATABASE_VERSION);  }  @Override  public void onCreate(SQLiteDatabase db) {    String sqlString = "createtable test (_id integer primary key autoincrement,name varchat(20) not null onconflict fail)";    db.execSQL(sqlString);    // 初始數據庫表    String[] nameStrArrayStr = new String[] { "aaa", "abc", "cde", "中國", "美女", "提示" };    for (int i = 0; i < nameStrArrayStr.length; i++) {      db.execSQL("INSERT INTOtest(" + NAME + ")values(?)",new Object[] { nameStrArrayStr[i] });    }  }  @Override  public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {    // do nothing here  }  /**   * 根據輸入內容模糊查詢   * @param name   * @return   */  public Cursor query(String name) {    SQLiteDatabase db = this.getReadableDatabase();    return db.rawQuery("select* from test where name like '%" + name + "%' limit 10",null);  }}

2、定義AutoCompleteAdater繼承SimpleCursorAdapter控制數據交互

import android.content.Context;import android.database.Cursor;import android.widget.SimpleCursorAdapter;/** * * @author lai_zs * @date：2012-2-16 下午3:49:25 */public class AutoCompleteAdater extends SimpleCursorAdapter {  private DBHelper dbHelper = null;  private Context context;  // 查詢字段  private String queryField;  public AutoCompleteAdater(Context context, int layout, Cursor c,String from, int to) {    super(context, layout, c, new String[] { from },new int[] { to });    this.context = context;    this.queryField = from;  }  /**   * 動態查詢數據庫   */  @Override  public Cursor runQueryOnBackgroundThread(CharSequenceconstraint) {    if (constraint != null) {      return getDbHelper().query((String) constraint);    } else {      return null;    }  }  /**   * 這里設置在彈出的提示列表中點擊某一項后的返回值,返回值將被顯示在文本框中   */  @Override  public CharSequence convertToString(Cursor cursor) {    return cursor.getString(cursor.getColumnIndex(queryField));  }  public DBHelper getDbHelper() {    if (dbHelper == null) {      dbHelper = new DBHelper(this.context);    }    return dbHelper;  }}

3、最后定義View

<AutoCompleteTextView    android:id="@+id/autoCompleteTextView1"    android:layout_width="match_parent"    android:layout_height="wrap_content"    android:text=""    android:hint="@string/dbAutoComlete" >    <requestFocus /></AutoCompleteTextView>

4、在Activity中關聯View和Adapter

@Overridepublic void onCreate(Bundle savedInstanceState) {    super.onCreate(savedInstanceState);    setContentView(R.layout.main);    AutoCompleteAdatercursorAdapter = new AutoCompleteAdater(this, android.R.layout.simple_dropdown_item_1line,null, DBHelper.NAME, android.R.id.text1);    // 設置輸入一個字符就彈出提示列表(默認輸入兩個字符時才彈出提示)    ((AutoCompleteTextView) this.findViewById(R.id.autoCompleteTextView1)).setThreshold(1);    ((AutoCompleteTextView) this.findViewById(R.id.autoCompleteTextView1)).setAdapter(cursorAdapter);}