数据库单元测试

首先需要在配置清单加上如下代码：

<pre name="code" class="java"><uses-library android:name="android.test.runner"/>

<instrumentation android:name="android.test.InstrumentationTestRunner"
        android:targetPackage="com.example.com.ls.acounts"></instrumentation>

数据库创建类DBService.java

package com.example.com.ls.acounts;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * @author 巨龙
 *
 * 2014-7-6
 */
public class DBService extends SQLiteOpenHelper{

	/**
	 * @param context
	 * @param name
	 * @param factory
	 * @param version
	 */
	
	private final static String NAME = "gzcwt.db";
	private final static int VERSION = 1;
	public DBService(Context context) {
		
		super(context, NAME, null, VERSION);
		// TODO Auto-generated constructor stub
	}
	
	@Override
	public void onCreate(SQLiteDatabase db) {
		// 构建基本信息表
		String sql = "create table if not exists c_handbook(" +
				" hb_id integer primary key autoincrement," +
				" hb_add_date varchar(8)," +
				" hb_car varchar(8),"+
				" hb_car_type varchar(8),"+
				" hb_client_hb_id integer,"+
				" hb_co_driver varchar(8),"+
				" hb_driver varchar(8),"+
				" hb_end_work varchar(8)," +
				" hb_follow_control varchar(8),"+
				" hb_last_upload_time varchar(8),"+
				" hb_master_control varchar(8),"+
				" hb_note varchar(100),"+
				" hb_other_car varchar(8),"+
				" hb_other_car_driver varchar(8),"+
				" hb_other_car_type varchar(8),"+
				" hb_precaution varchar(100),"+
				" hb_start_work varchar(8),"+
				" hb_student varchar(8),"+
				" hb_train_no varchar(8),"+
				" hb_weather varchar(8),"+
				" hb_train_line_id integer,"+
				" hb_user_id integer)";
		db.execSQL(sql);
		
		//构建运行信息表
		String sql1 = "create table if not exists c_handbook_run(" +
				" hbr_id integer primary key autoincrement," +
				" hbr_car_count integer," +
				" hbr_charge_wind varchar(8)," +
				" hbr_client_hbr_id integer," +
				" hbr_discharge_wind varchar(8)," +
				" hbr_driver varchar(8)," +
				" hbr_flag varchar(8)," +
				" hbr_length varchar(8)," +
				" hbr_offtime varchar(8)," +
				" hbr_part_interval varchar(8)," +
				" hbr_parttime varchar(8)," +
				" hbr_speed_limit integer," +
				" hbr_station varchar(8)," +
				" hbr_tonnage varchar(8)," +
				" hbr_handbook_id integer)";
		db.execSQL(sql1);
		
		//初始化基本信息表数据
		String sql2 = "insert into c_handbook(hb_add_date,hb_car," +
				"hb_car_type,hb_client_hb_id,hb_co_driver,hb_driver," +
				"hb_end_work,hb_follow_control,hb_last_upload_time," +
				"hb_master_control,hb_note,hb_other_car,hb_other_car_driver," +
				"hb_other_car_type,hb_precaution,hb_start_work,hb_student,hb_train_no," +
				"hb_weather,hb_train_line_id,hb_user_id)" +
				" values ('2013年','坦克','T101','1','黄超','李勇','7点','叶秋东','2014年','陈小彪','第一次开坦克','飞机','许钦百','FJ-001','安全驾驶','6点','卢路路','001','晴朗','1','01')";
		db.execSQL(sql2);
		
		//初始化运行信息表数据
		/*String sql3 = "insert into c_handbook_run(hbr_car_count," +
				"hbr_charge_wind,hbr_client_hbr_id,hbr_discharge_wind," +
				"hbr_driver,hbr_flag,hbr_length,hbr_offtime,hbr_part_interval," +
				"hbr_parttime,hbr_speed_limit,hbr_station,hbr_tonnage,hbr_handbook_id)" +
				" values ('5','13分钟','1','12分钟','黄超','快车','30','50','10','60','20','体育中心','60','1')";
		db.execSQL(sql3);*/
		
		String sql3 = "insert into c_handbook_run(hbr_car_count," +
				"hbr_charge_wind,hbr_client_hbr_id,hbr_discharge_wind," +
				"hbr_driver,hbr_flag,hbr_length,hbr_offtime,hbr_part_interval," +
				"hbr_parttime,hbr_speed_limit,hbr_station,hbr_tonnage,hbr_handbook_id)" +
				" values (' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','1')";
		db.execSQL(sql3);
	}
	
	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		// TODO Auto-generated method stub
		
	}
	
	

}

测试类TestDBService.java

<pre name="code" class="java">/**
 * 
 */
package com.example.com.ls.acounts;

import android.test.AndroidTestCase;
/**
 * @author 巨龙
 *
 * 2014-7-7
 */
public class TestDBService extends AndroidTestCase{

	public TestDBService(){
		
	}
	
	public void testCreateDb(){
		DBService dbService = new DBService(this.getContext());
		dbService.getWritableDatabase();
	}
}