2.乐学成语-------------编写动物类

二：

1.在entity包下新建一个Animal类，代码如下：

package cn.edu.bztc.happyidiom.entity;

public class Animal {
     private int id;
     private String name;//成语名称
     private String pronounce;//成语发音
     private String explain;//成语解释
     private String antonym;//反义词
     private String homoionym;//同义词
     private String derivation;//源自
     private String examples;//例子
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPronounce() {
		return pronounce;
	}
	public void setPronounce(String pronounce) {
		this.pronounce = pronounce;
	}
	public String getExplain() {
		return explain;
	}
	public void setExplain(String explain) {
		this.explain = explain;
	}
	public String getAntonym() {
		return antonym;
	}
	public void setAntonym(String antonym) {
		this.antonym = antonym;
	}
	public String getHomoionym() {
		return homoionym;
	}
	public void setHomoionym(String homoionym) {
		this.homoionym = homoionym;
	}
	public String getDerivation() {
		return derivation;
	}
	public void setDerivation(String derivation) {
		this.derivation = derivation;
	}
	public String getExamples() {
		return examples;
	}
	public void setExamples(String examples) {
		this.examples = examples;
	}
	
     
}

2.继续创建一个AnimalDao类，代码如下：

package cn.edu.bztc.happyidiom.dao;

import java.util.ArrayList;
import java.util.List;

import cn.edu.bztc.happyidiom.db.DBOpenHelper;
import cn.edu.bztc.happyidiom.entity.Animal;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class AnimalDao {
  private static AnimalDao animalDao;
  private SQLiteDatabase db;
  /**
   * 将构造方法私有化
   */
  private AnimalDao(Context context){
	  DBOpenHelper dbHelper = new DBOpenHelper(context);
	  db=dbHelper.openDatabase();
  }
  /**
   * 获取AnimalDao的实例。
   */
  public synchronized static AnimalDao getInstance(Context context){
	  if(animalDao==null){
		  animalDao = new AnimalDao(context);
	  }
	return animalDao;
	  }
  /**
   * 从数据库读取所有的动物类成语。
   */
  public List<Animal> getAllAnimals(){
	  List <Animal> list=new ArrayList<Animal>();
	  Cursor cursor = db.query("animal",null,null,null,null,null,null);
	  if(cursor.moveToFirst()){
		  do{
			  Animal animal = new Animal();
			  animal.setId(cursor.getInt(cursor.getColumnIndex("_id")));
			  animal.setName(cursor.getString(cursor.getColumnIndex("name")));
			  animal.setPronounce(cursor.getString(cursor.getColumnIndex("pronounce")));
			  animal.setExplain(cursor.getString(cursor.getColumnIndex("explain")));
			  animal.setAntonym(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("examples")));
			  list.add(animal);
		  }while(cursor.moveToNext());
	  }
	return list;
	}
}

3.创建测试类AnimalDaoTest继承AndroidTestCase,代码如下：

package cn.edu.bztc.happyidiom.test;

import java.util.List;

import cn.edu.bztc.happyidiom.dao.AnimalDao;
import cn.edu.bztc.happyidiom.entity.Animal;
import android.test.AndroidTestCase;

public class AnimalDaoTest extends AndroidTestCase {
   public void testGetAllAnimals(){
	   AnimalDao animalDao=AnimalDao.getInstance(getContext());
	   List <Animal> animals = animalDao.getAllAnimals();
	   System.out.println(animals.size());
	   for(Animal animal:animals){
		   System.out.println(animal.getName());
	   }
   }
}