本地数据库词典

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

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();// }&＃64;Overrideprotected 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 &＃61; (Button) findViewById(R.id.btnSearch);// etWord &＃61; (EditText) findViewById(R.id.etWord);tvResult &＃61; (TextView) findViewById(R.id.tvSearchResult);ac &＃61; (AutoCompleteTextView)findViewById(R.id.etWord);/*** 原来的editText换成了AutoCompleteTextView*/DBHelper helper &＃61; new DBHelper(MainActivity.this);SQLiteDatabase db &＃61; helper.openDatabase();// Cursor cur &＃61; db.query("dictionary", new String[] { "t_words" },// null, null, null, null, null);String sql &＃61; "select english from t_words";Cursor cur &＃61; db.rawQuery(sql, null);int i &＃61; 0;int j &＃61; 0;List list &＃61; new ArrayList();while (cur.moveToNext()) {String chinese &＃61; cur.getString(cur.getColumnIndex("english"));list.add(chinese);}//// String[] countries &＃61; new String[] { "Afghanistan", "Albania",// "Algeria", "American Samoa", "Andorra" };// 这里只举例说明&＃xff0c;数据较少AutoCompleteTextView autoCompleteTextView &＃61; (AutoCompleteTextView) findViewById(R.id.etWord);// 找到相应的控件ArrayAdapter adapter &＃61; new ArrayAdapter(this,R.layout.list_item, list);// 配置AdaptorautoCompleteTextView.setAdapter(adapter);btnSearch.setOnClickListener(new OnClickListener() {public void onClick(View v) {
// String strUri &＃61; etWord.getText().toString();
// strUri &＃61; strUri.trim();
// if (strUri.length() &＃61;&＃61; 0) {
// Toast.makeText(getApplicationContext(), "请输入查询字符", 1)
// .show();
// } else {
// String strURL &＃61; "http://dict.youdao.com/m/search?keyfrom&＃61;dict.mindex&q&＃61;"
// &＃43; strUri;
// // 这个地方抛出空指针异常&＃xff0c;我没学过这个方法&＃xff0c;没办法&＃xff0c;不知道这个有道接口格式
// reswebView.loadUrl(strURL);
// }WordDao wd &＃61; new WordDao(MainActivity.this);String chinese &＃61; wd.getChinese(ac.getText().toString());tvResult.setText(ac.getText().toString()&＃43;"\n"&＃43;chinese);}});}}



2.WordDao.java

package com.example.happydictionary.dao;import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;import com.example.happydictionary.db.DBHelper;public class WordDao {private DBHelper dbHelper;private SQLiteDatabase sqLiteDatabase;public WordDao(Context context){dbHelper&＃61;new DBHelper(context);}public String getChinese(String english){sqLiteDatabase&＃61;dbHelper.openDatabase();String sql&＃61;"select chinese from t_words where english&＃61;?";Cursor cursor&＃61;sqLiteDatabase.rawQuery(sql, new String[]{english});String chinese&＃61;"查无该词";if(cursor.moveToFirst()){chinese&＃61;cursor.getString(cursor.getColumnIndex("chinese"));}return chinese;}
}



3.DBHelper.java

package com.example.happydictionary.db;import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;import com.example.happydictionary.R;
import com.example.happydictionary.R.raw;import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;
import android.util.Log;/*** 实现将数据库文件从raw目录拷贝到手机里存放数据库的位置* * &＃64;author cabbage*/
public class DBHelper {private final int BUFFER_SIZE &＃61; 400000;public static final String DB_NAME &＃61; "idiom.db"; // 保存的数据库文件名public static final String PACKAGE_NAME &＃61; "com.example.happydictionary";// 应用的包名public static final String DB_PATH &＃61; "/data"&＃43; Environment.getDataDirectory().getAbsolutePath() &＃43; "/"&＃43; PACKAGE_NAME &＃43; "/databases";/*// SDCard 定义数据库的存放路径private final String DATABASE_PATH &＃61; android.os.Environment.getExternalStorageDirectory().getAbsolutePath() &＃43; "/dictionary";*/private Context context;public DBHelper(Context context) {this.context &＃61; context;}public SQLiteDatabase openDatabase() {try {File myDataPath &＃61; new File(DB_PATH);if (!myDataPath.exists()) {myDataPath.mkdirs();// 如果没有这个目录则创建}String dbfile &＃61; myDataPath &＃43; "/" &＃43; DB_NAME;if (!(new File(dbfile).exists())) {// 判断数据库文件是否存在&＃xff0c;若不存在则执行导入&＃xff0c;否则直接打开数据库InputStream is &＃61; context.getResources().openRawResource(R.raw.dictionary); // 欲导入的数据库FileOutputStream fos &＃61; new FileOutputStream(dbfile);byte[] buffer &＃61; new byte[BUFFER_SIZE];int count &＃61; 0;while ((count &＃61; is.read(buffer)) > 0) {fos.write(buffer, 0, count);}Log.v("###", "bucunzai");fos.close();is.close();}SQLiteDatabase db &＃61; SQLiteDatabase.openOrCreateDatabase(dbfile,null);Log.v("###", "cunzai");return db;} catch (FileNotFoundException e) {Log.e("###", "File not found");e.printStackTrace();} catch (IOException e) {Log.e("###", "IO exception");e.printStackTrace();}return null;}
}


4.Word.java

package com.example.happydictionary.entity;public class Word {private String english;private String chinese;public String getEnglish() {return english;}public void setEnglish(String english) {this.english &＃61; english;}public String getChinese() {return chinese;}public void setChinese(String chinese) {this.chinese &＃61; chinese;}}



5.DBHelperTest.java

package com.example.happydictionary.test;import com.example.happydictionary.db.DBHelper;import android.test.AndroidTestCase;public class DBHelperTest extends AndroidTestCase {public void testCreateDB(){DBHelper dbHelper&＃61;new DBHelper(getContext());dbHelper.openDatabase();}
}



6.activity_mian.xml

7.list_item.xml






8.menu>mian.xml


电子词典SettingsHello world!请输入您要查询的单词查询