Android下的SQLite数据库的相关操作及AndroidTestCase测试
一：创建数据库
package com.itcode.mysqlite;import java.util.List;import java.util.Random;import android.database.sqlite.SQLiteDatabase;import android.test.AndroidTestCase;public class SQLiteTest extends AndroidTestCase{//1.测试创建数据库的方法public void testCreateDB(){//1.创建数据库MySQLiteOpenHelper helper = new MySQLiteOpenHelper(getContext());//2.得到相应的数据库SQLiteDatabase db = helper.getWritableDatabase();db.execSQL("INSERT INTO account(_id,name, balance) VALUES(1,'fuck', 10000)");}//2.测试添加数据的方法public void testAdd(){AccountDao dao = new AccountDao(getContext());// Context android.test.AndroidTestCase.getContext()for(int i=1;i<100;i++){dao.add(new Account("Test" + i,new Random().nextInt(10000)));}}//3.测试删除数据的方法public void testDelete(){AccountDao dao = new AccountDao(getContext());for(int i=100;i<200;i++){dao.delete(i);}}//4.测试修改数据的方法public void testUpdate(){AccountDao dao = new AccountDao(getContext());Account a = new Account(1,"fuck you!!!~",999);dao.update(a);}//5.测试查询数据的方法，根据id查询数据库public void testQuery(){AccountDao dao = new AccountDao(getContext());System.out.println(dao.query(1));System.out.println(dao.query(3));System.out.println(dao.query(4));}//6.测试查询所有的方法public void testQueryAll(){AccountDao dao = new AccountDao(getContext());List<Account> list =null;list = dao.queryAll();for (Account account : list) {System.out.println(account);}}//7.测试分布查询的方法public void testQueryPage(){AccountDao dao = new AccountDao(getContext());List<Account> list = null;list = dao.queryPage(2, 10);for (Account account : list) {System.out.println(account);}}//8.测试查询总记录条数的方法public void testQueryCount(){AccountDao dao = new AccountDao(getContext());int count = dao.queryCount();System.out.println(count);}}