有道词典

来源：互联网发布：携程自营的旅游团知乎编辑：程序博客网时间：2024/04/29 03:04

1.activity_main.xml

</RelativeLayout>

2.mainactivity.java

package com.example.happydictionary;

import android.app.Activity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.Menu;
import android.view.View;
import android.widget.EditText;
import android.widget.TextView;

import com.example.happydictionary.dao.WordDao;

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

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

initViews();
}

private void initViews() {
etWord = (EditText) findViewById(R.id.etWord);
tvResult = (TextView) findViewById(R.id.tvSearchResult);
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
  // Inflate the menu; this adds items to the action bar if it is present.
  getMenuInflater().inflate(R.menu.main, menu);
  return true;
}

public void searchWord(View view) {
  String english = etWord.getText().toString();
  wordDao = new WordDao(this);
  if (TextUtils.isEmpty(english)) {
   tvResult.setText("请输入您想查询的单词");
  } else {
   String chinese = wordDao.getChinese(english);
   tvResult.setText(chinese);
  }
}

}

3.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=new DBHelper(context);
}
     public String getChinese(String english){
    sqLiteDatabase=dbHelper.openDatabase();
    String sql="select chinese from t_words where english=?";
    Cursor cursor=sqLiteDatabase.rawQuery(sql, new String[]{english});
    String chinese="查无该词";
    if(cursor.moveToFirst()){
       chinese=cursor.getString(cursor.getColumnIndex("chinese"));
    }
    return chinese;
     }
}

4.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目录拷贝到手机里存放数据库的位置
*
* @author cabbage
*/
public class DBHelper {
private final int BUFFER_SIZE = 400000;
public static final String DB_NAME = "idiom.db"; // 保存的数据库文件名
public static final String PACKAGE_NAME = "com.example.happydictionary";// 应用的包名
public static final String DB_PATH = "/data"
   + Environment.getDataDirectory().getAbsolutePath() + "/"
   + PACKAGE_NAME + "/databases";
/*// SDCard 定义数据库的存放路径
private final String DATABASE_PATH = android.os.Environment
   .getExternalStorageDirectory().getAbsolutePath() + "/dictionary";*/

private Context context;

public DBHelper(Context context) {
this.context = context;
}

public SQLiteDatabase openDatabase() {
  try {
   File myDataPath = new File(DB_PATH);
   if (!myDataPath.exists()) {
    myDataPath.mkdirs();// 如果没有这个目录则创建
   }
   String dbfile = myDataPath + "/" + DB_NAME;
   if (!(new File(dbfile).exists())) {// 判断数据库文件是否存在，若不存在则执行导入，否则直接打开数据库
    InputStream is = context.getResources().openRawResource(
      R.raw.dictionary); // 欲导入的数据库
    FileOutputStream fos = new FileOutputStream(dbfile);
    byte[] buffer = new byte[BUFFER_SIZE];
    int count = 0;
    while ((count = is.read(buffer)) > 0) {
     fos.write(buffer, 0, count);
    }
    fos.close();
    is.close();
   }
   SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbfile,
     null);
   return db;
  } catch (FileNotFoundException e) {
   Log.e("Database", "File not found");
   e.printStackTrace();
  } catch (IOException e) {
   Log.e("Database", "IO exception");
   e.printStackTrace();
  }
  return null;
}
}

5.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 = english;
}

public String getChinese() {
return chinese;
}

public void setChinese(String chinese) {
this.chinese = chinese;
}

}

6.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=new DBHelper(getContext());
    dbHelper.openDatabase();
     }
}

0 0