有道词典Demo（WebView）

来源：互联网发布：excel数据透视表应用编辑：程序博客网时间：2024/05/17 01:20

效果图:

Dictionary.java

package com.bzu.gxs;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;

import com.bzu.gxs.dao.DictionaryAdapter;
import com.bzu.gxs.db.DBHelper;
import com.bzu.gxs.R;

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 Dictionary 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);

  // 绑定适配器
  word.setAdapter(dictionaryAdapter);

}

public void beforeTextChanged(CharSequence s, int start, int count,
int after) {

}

public void onTextChanged(CharSequence s, int start, int before, int count) {

}

public void onClick(View view) {
  // 查询指定的单词
  String sql = "select chinese from t_words where english=?";

  Cursor cursor = database.rawQuery(sql, new String[] { word.getText()
    .toString() });

  String result = "查无该词"; // 如果查找单词，显示其中文的意思

  if (cursor.getCount() > 0) {

   cursor.moveToFirst(); // 须使用moveToFirst方法将记录指针移动到第1条记录的位置
   result = cursor.getString(cursor.getColumnIndex("chinese"))
     .replace("&", "&");
  }

showResult.setText(word.getText() + "\n" + result.toString());// 将结果显示到TextView中
}

}

DictionaryAdapter.java

package com.bzu.gxs.dao;

import android.content.Context;
import android.database.Cursor;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.CursorAdapter;
import android.widget.TextView;
import com.bzu.gxs.R;

//自定义Adapter类
public class DictionaryAdapter extends CursorAdapter {
private LayoutInflater layoutInflater;

@Override
public CharSequence convertToString(Cursor cursor) {
return cursor == null ? "" : cursor.getString(cursor
.getColumnIndex("_id"));
}

// 将单词信息显示到列表中
private void setView(View view, Cursor cursor) {
TextView tvWordItem = (TextView) view;
tvWordItem.setText(cursor.getString(cursor.getColumnIndex("_id")));
}

// 绑定选项到列表中
@Override
public void bindView(View view, Context context, Cursor cursor) {
setView(view, cursor);
}

// 生成新的选项
@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
  View view = layoutInflater.inflate(R.layout.word_list_item, null);
  setView(view, cursor);
  return view;
}

public DictionaryAdapter(Context context, Cursor c, boolean autoRequery) {
  super(context, c, autoRequery);
  layoutInflater = (LayoutInflater) context
    .getSystemService(Context.LAYOUT_INFLATER_SERVICE);
}
}

DBHelper.java

package com.bzu.gxs.db;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import com.bzu.gxs.R;
public class DBHelper {
//定义数据库的存放路径
  private final String DATABASE_PATH = android.os.Environment
    .getExternalStorageDirectory().getAbsolutePath()
    + "/dictionary";
  private final String DATABASE_FILENAME = "dictionary.db";

  private Context context;

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


  public SQLiteDatabase openDatabase()
  {
   try
   {
    // 获得dictionary.db文件的绝对路径
    String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;
    File dir = new File(DATABASE_PATH);
    // 如果/sdcard/dictionary目录中存在，创建这个目录
    if (!dir.exists())
     dir.mkdir();
    // 如果在/sdcard/dictionary目录中不存在
    // dictionary.db文件，则从res\raw目录中复制这个文件到
    // SD卡的目录（/sdcard/dictionary）
    if (!(new File(databaseFilename)).exists())
    {
     // 获得封装dictionary.db文件的InputStream对象
     InputStream is = context.getResources().openRawResource(
       R.raw.dictionary);
     FileOutputStream fos = new FileOutputStream(databaseFilename);
     byte[] buffer = new byte[8192];
     int count = 0;
     // 开始复制dictionary.db文件
     while ((count = is.read(buffer)) > 0)
     {
      fos.write(buffer, 0, count);
     }
     //关闭文件流
     fos.close();
     is.close();
    }
    // 打开/sdcard/dictionary目录中的dictionary.db文件
    SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(
      databaseFilename, null);
    return database;
   }
   catch (Exception e)
   {
   }
   //如果打开出错，则返回null
   return null;
  }

}

activity_main.xml

</AutoCompleteTextView>

</RelativeLayout>

word_list_item.xml

<?xml version="1.0" encoding="utf-8"?>
<TextView xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/tvWordItem"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:gravity="center_vertical"
    android:minHeight="?android:attr/listPreferredItemHeight"
    android:paddingLeft="6dip"
    android:textAppearance="?android:attr/textAppearanceLarge"
    android:textColor="@color/gray" />
color.xml

<?xml version="1.0" encoding="utf-8"?>
<resources>
    <color name="white">#FFFFFF</color>
    <color name="blue">#0066CC</color>
    <color name="gray">#999999</color>

</resources>

dimens.xml

<dimen name="activity_horizontal_margin">16dp</dimen>
    <dimen name="activity_vertical_margin">16dp</dimen>

</resources>

string.xml

<?xml version="1.0" encoding="utf-8"?>
<resources>
    <string name="app_name">电子词典</string>
    <string name="action_settings">Settings</string>
    <string name="hello_world">Hello world!</string>
    <string name="searchHint">请输入您要查询的单词</string>
    <string name="serachWord">查询</string>
</resources>

0 0