乐学成语

来源：互联网发布：优酷淘宝返利搞笑视频编辑：程序博客网时间：2024/04/28 05:12

工程目录如下

具体实现过程以及写的过程中遇到的问题

第一步：建立数据库

第二步：导入数据库将idioms.db复制到ras文件夹下的raw文件夹若没有建一个

在db包中建DBOpenHelper.java代码如下

public class DBOpenHelper {

privatefinal int BUFFER_SIZE=400000;//缓冲区大小

publicstatic final String DB_NAME="idioms.db"; //保存的数据库文件名

publicstatic final String PACKAGE_NAME="com.example.happyidiom";//应用的包名

publicstatic final String DB_PATH="/data"

+Environment.getDataDirectory().getAbsolutePath()+"/"

+PACKAGE_NAME+"/databases";//在手机里存放数据库的位置

privateContext context;

publicDBOpenHelper(Context context){

this.context=context;

}

publicSQLiteDatabase openDatabase(){

try{

FilemyDataPath=new File(DB_PATH);

if(!myDataPath.exists()){

myDataPath.mkdirs();//如果没有这个数据库则创建

}

Stringdbfile=myDataPath+"/"+DB_NAME;

if(!(newFile(dbfile).exists())){//判断数据库文件是否存在，若不存在直接导入，

//否则直接打开数据库

InputStreamis=context.getResources().openRawResource(R.raw.idioms);

FileOutputStreamfos=new FileOutputStream(dbfile);

byte[]buffer=new byte[BUFFER_SIZE];

intcount=0;

while((count=is.read(buffer))>0){

fos.write(buffer,0,count);

}

fos.close();

is.close();

}

SQLiteDatabasedb=SQLiteDatabase.openOrCreateDatabase(dbfile, null);

returndb;

}catch(FileNotFoundExceptione){

Log.e("Database","Filenot found");

e.printStackTrace();

}

catch(IOExceptione){

Log.e("Database","IOexception");

e.printStackTrace();

}

returnnull;

}

在test包下新建DBOpenHelperTest.java测试一下代码如下

public class DBOpenHelperTest extends AndroidTestCase{

publicvoid testDBCopy(){

DBOpenHelperdBOpenHelper=new DBOpenHelper(getContext());

dBOpenHelper.openDatabase();

}

}出现如下图视为成功

在entity下建立实体类Animal.java

public class Animal {

privateint id;

privateString name;

privateString pronounce;

privateString explain;

privateString autonym;

privateString homoionym;

privateString derivation;

privateString examples;

public intgetId() {

returnid;

}

publicvoid setId(int id) {

this.id= id;

}

publicString getName() {

returnname;

}

publicvoid setName(String name) {

this.name= name;

}

publicString getPronounce() {

returnpronounce;

}

publicvoid setPronounce(String pronounce) {

this.pronounce= pronounce;

}

publicString getExplain() {

returnexplain;

}

publicvoid setExplain(String explain) {

this.explain= explain;

}

publicString getAutonym() {

returnautonym;

}

publicvoid setAutonym(String autonym) {

this.autonym= autonym;

}

publicString getHomoionym() {

returnhomoionym;

}

publicvoid setHomoionym(String homoionym) {

this.homoionym= homoionym;

}

publicString getDerivation() {

returnderivation;

}

publicvoid setDerivation(String derivation) {

this.derivation= derivation;

}

publicString getExamples() {

returnexamples;

}

publicvoid setExamples(String examples) {

this.examples= examples;

}

在dao包建立AnimalDao.java

public class AnimalDao {

privatestatic AnimalDao animalDao;

privateSQLiteDatabase db;

/**

* 将构造方法私有化

privateAnimalDao(Context context){

DBOpenHelperdbHelper =new DBOpenHelper(context);

db=dbHelper.openDatabase();

}

/**

* 获取AnimalDao的实例

publicsynchronized static AnimalDao getInstance(Context context){

if(animalDao==null){

animalDao=newAnimalDao(context);

}

returnanimalDao;

}

/**

* 从数据库获取所有的动物类成语

publicList<Animal> getAllAnimals(){

List<Animal>list=new ArrayList<Animal>();

Cursorcursor =db.query("animal",null, null,null,null,null,null);

if(cursor.moveToFirst()){

do{

Animalanimal=new Animal();

animal.setId(cursor.getInt(cursor.getColumnIndex("_id")));

animal.setName(cursor.getString(cursor.getColumnIndex("name")));

animal.setPronounce(cursor.getString(cursor.getColumnIndex("pronounce")));

animal.setAutonym(cursor.getString(cursor.getColumnIndex("antonym")));

animal.setHomoionym(cursor.getString(cursor.getColumnIndex("homoionym")));

animal.setDerivation(cursor.getString(cursor.getColumnIndex("derivation")));

animal.setExamples(cursor.getString(cursor.getColumnIndex("explain")));

list.add(animal);

}while(cursor.moveToNext());

}

returnlist;

}

进行单元测试：在test下建立AnimalDaotest.Java

public class AnimalDaoTest extends AndroidTestCase{

publicvoid testGetAllAnimals(){

AnimalDaoanimalDao=AnimalDao.getInstance(getContext());

List<Animal>animals=animalDao.getAllAnimals();

System.out.println(animals.size());

for(Animalanimal:animals){

System.out.println(animal.getName());

}

}}

出现下图视为测试成功

UI界面

Activity_main.xml 代码如下

<RelativeLayoutxmlns:android="http://schemas.android.com/apk/res/android"

xmlns:tools="http://schemas.android.com/tools"