Android-小項目之迷你英文詞典-使用existing sqlite database-github第三庫android-sqlite-asset-helper

將已有的詞典數據庫文件,用到項目中

谷歌搜索“android existing sqlite database”

https://stackoverflow.com/questions/1951805/how-to-access-an-existing-sqlite-database-in-android

通常來說,

SQLiteDatabase db = SQLiteDatabase.openDatabase(path, null, 0);

 

就可以。

但是,如果 數據庫文件在 assets 目錄下,該如何做呢?

https://stackoverflow.com/questions/513084/how-to-ship-an-android-application-with-a-database

哈,用第三方庫:

 

OK直接看項目吧:

 

數據庫文件:

運行效果圖:

 

 

代碼:

 

package com.jiangge.dictmini;

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

public class MainActivity extends Activity {

	private EditText mEditText; //輸入框
	private TextView mReslutView; //顯示查詢結果
	
	private Cursor resultCursor;
	private MyDatabase db;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		mEditText = (EditText) findViewById(R.id.et_words);
		mReslutView = (TextView) findViewById(R.id.tv_result);
	}
	
	//搜索按鈕響應事件,方法在 xml 文件中定義 android:onClick=search
	public void search(View view){
		String inputValue = mEditText.getText().toString().trim();
		
		if (TextUtils.isEmpty(inputValue)) {
			mReslutView.setText(查詢內容不能為空);
			return;
		}
		
		db = new MyDatabase(MainActivity.this);
		resultCursor = db.getResultFromDB(inputValue);
		if (resultCursor != null && resultCursor.getCount() > 0) {
			resultCursor.moveToFirst();
			String value = resultCursor.getString(resultCursor.getColumnIndex(chinese ));
			mReslutView.setText(value);
		}else {
			mReslutView.setText(查詢結果不存在);
		}
	}
	
}

 

File: MyDatabase.java 根據第三方庫修改而成

 

package com.jiangge.dictmini;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;

import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;

public class MyDatabase extends SQLiteAssetHelper {

	private static final String DATABASE_NAME = dictionary;
	private static final int DATABASE_VERSION = 1;
	
	public MyDatabase(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
		
		// you can use an alternate constructor to specify a database location 
		// (such as a folder on the sd card)
		// you must ensure that this folder is available and you have permission
		// to write to it
		//super(context, DATABASE_NAME, context.getExternalFilesDir(null).getAbsolutePath(), null, DATABASE_VERSION);
		
	}

	public Cursor getResultFromDB(String value) {

		SQLiteDatabase db = getReadableDatabase();
		SQLiteQueryBuilder qb = new SQLiteQueryBuilder();

		String [] sqlSelect = {english, chinese}; 
		String sqlTables = t_words; //select * from t_words where english = 'love'
		
		qb.setTables(sqlTables);
		Cursor cursor = qb.query(db, sqlSelect, english=?, new String[]{value}, null, null, null);

		cursor.moveToFirst();
		return cursor;

	}

}

 

 

 

佈局文件:

 

 

發佈留言