利用AutoCompleteTextView连接到数据库实现自动提示功能

在输入框中输入我们想要输入的信息就会出现其他与其相关的提示信息，这种效果在Android中是用AutoCompleteTextView实现的

主要实现代码

MainActivity

package com.example.happydictionary;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;

import com.example.happydictionary.adapter.DictionaryAdapter;
import com.example.happydictionary.db.DBHelper;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.text.Editable;
import android.text.TextWatcher;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.view.View.OnClickListener;
import android.widget.AutoCompleteTextView;
import android.widget.Button;
import android.widget.CursorAdapter;
import android.widget.TextView;

public class MainActivity extends Activity implements OnClickListener,
		TextWatcher {
	private DBHelper dbHelper; // 用户输入文本框
	private AutoCompleteTextView word; // 定义数据库的名字
	private SQLiteDatabase database;
	private Button searchWord; // 搜索按钮
	private TextView showResult; // 用户显示查询结果

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);

		dbHelper = new DBHelper(getBaseContext());// 打开数据库
		database = dbHelper.openDatabase();

		init();

		searchWord.setOnClickListener(this); // 绑定监听器
		word.addTextChangedListener(this); // 绑定文字改变监听器

	}

	public void init() {
		searchWord = (Button) findViewById(R.id.btnSearch);
		word = (AutoCompleteTextView) findViewById(R.id.etWord);
		showResult = (TextView) findViewById(R.id.tvSearchResult);

	}

	public void afterTextChanged(Editable s) {
		Cursor cursor = database.rawQuery(
				"select english as _id from t_words where english like ?",
				new String[] { s.toString() + "%" });
		
		// 新建新的Adapter
		DictionaryAdapter dictionaryAdapter = new DictionaryAdapter(this,cursor, true);