import com.liudw.sql.MySqlHelp;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.test.AndroidTestCase;
/**
* android的单元测试框架
* @author Administrator
*
*/
public class TestCase extends AndroidTestCase {
private MySqlHelp msl;
private SQLiteDatabase db;
//启动测试前,先初始化数据库
protected void setUp() throws Exception {
// TODO Auto-generated method stub
super.setUp();
msl = new MySqlHelp(getContext(), "liudw.db", null, 1);
//创建数据库
db = msl.getReadableDatabase();
}
//启动测试后,关闭数据库连接
@Override
protected void tearDown() throws Exception {
// TODO Auto-generated method stub
super.tearDown();
msl.close();
db.close();
}
public void test01() {
System.out.println("测试框架已经搭建好了");
StringBuffer sb = new StringBuffer();
sb.append("create table person(_id integer primary key autoincrement, name char(10), age char(10), address char(10))");
db.execSQL(sb.toString());
}
public void insertSQL() {
for(int i = 0; i < 50; i++) {
ContentValues values = new ContentValues();
values.put("name", "喀喀喀"+i);
values.put("age", 22+i);
values.put("address", "撒旦撒旦撒旦"+i);
db.insert("person", null, values);
}
}
public void updateSQL() {
ContentValues values = new ContentValues();
values.put("name", "喀喀喀");
values.put("age", 22);
values.put("address", "撒旦撒旦撒旦");
db.update("person", values, "name = ? and age = ?", new String[]{"name","age"});
}
public void deleteSQL() {
db.delete("person", "name = ? and age = ?", new String[]{"name","age"});
}
public void selectSQL() {
Cursor cursor = db.query("person", null, null, null, null, null, null, null);
while(cursor.moveToNext()) {
String name = cursor.getString(cursor.getColumnIndex("name"));
}
}
}
转载于:https://my.oschina.net/u/1433152/blog/483593