本地数据库词典

本文章采用主要引用了本地数据库进行词典构建，之前上传的网页版的词典也是在此基础上进行改造，因此把本地数据库版的版本上传分享一下，依然添加下拉菜单，此内容属于本地数据库进行连接进行自动提示。

1.MainActivity

package com.example.happydictionary;

import java.util.ArrayList;
import java.util.List;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.webkit.WebView;
import android.widget.ArrayAdapter;
import android.widget.AutoCompleteTextView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

import com.example.happydictionary.dao.WordDao;
import com.example.happydictionary.db.DBHelper;

public class MainActivity extends Activity {
	private WordDao wordDao;
	private EditText etWord;
	private TextView tvResult;
	private AutoCompleteTextView ac;

	// protected void onCreate1(Bundle savedInstanceState) {
	// super.onCreate(savedInstanceState);
	// setContentView(R.layout.activity_main);
	//
	// initViews();
	// }

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

	// private void initViews() {
	// // TODO Auto-generated method stub
	//
	// }

	private Button btnSearch;
	// private EditText editText;
	private WebView reswebView;
	private WebView wvSearchResult;

	private void SetView() {
		btnSearch = (Button) findViewById(R.id.btnSearch);
		// etWord = (EditText) findViewById(R.id.etWord);
		tvResult = (TextView) findViewById(R.id.tvSearchResult);
		ac = (AutoCompleteTextView)findViewById(R.id.etWord);
		/**
		 * 原来的editText换成了AutoCompleteTextView
		 */
		DBHelper helper = new DBHelper(MainActivity.this);

		SQLiteDatabase db = helper.openDatabase();
		// Cursor cur = db.query("dictionary", new String[] { "t_words" },
		// null, null, null, null, null);
		String sql = "select english from t_words";
		Cursor cur = db.rawQuery(sql, null);
		int i = 0;
		int j = 0;
		List<String> list = new ArrayList<String>();
		while (cur.moveToNext()) {
			String chinese = cur.getString(cur.getColumnIndex("english"));
			list.add(chinese);

		}

		//
		// String[] countries = new String[] { "Afghanistan", "Albania",
		//