public PersonSQLite(Context context) {
    super(context, "person.db", null, 1);
    // TODO 自动生成的构造函数存根
    }

private int id;
    private String name;
    private String number;

private PersonSQLite sqlite;

    public PersonDao2(Context context) {
        sqlite = new PersonSQLite(context);
    }
    
    public long add(String name ,String number)
    {
        SQLiteDatabase db = sqlite.getWritableDatabase();
        //db.execSQL("insert into person (name,number) values (?,?)", new Object[]{name,number});
        ContentValues values = new ContentValues();
        values.put("name", name);
        values.put("number", number);
        long id = db.insert("person", null, values);
        db.close();
        return id;
    }
    
    public boolean find(String name)
    {
        SQLiteDatabase db = sqlite.getReadableDatabase();
        //Cursor cursor = db.rawQuery("select * from person where name=?", new String[]{name});
        Cursor cursor = db.query("person", null,"name=?", new String[]{name}, null, null, null);
        boolean result = cursor.moveToNext();
        cursor.close();
        db.close();
        return result;
    }
    
    public int update(String name , String newnumber)
    {
        SQLiteDatabase db = sqlite.getWritableDatabase();
        //db.execSQL("update person set number=? where name =?",new Object[]{newnumber,name});
        ContentValues values = new ContentValues();
        values.put("number", newnumber);
        int number = db.update("person", values, "name=?", new String[]{newnumber});
        db.close();
        return number;
    }
    
    public int delete(String name)
    {
        SQLiteDatabase db = sqlite.getWritableDatabase();
        //db.execSQL("delete from person where name = ?",new Object[]{name});
        int number = db.delete("person", "name=?", new String[]{name});
        db.close();
        return number;
    }
    
    public List<Person> findAll()
    {
        SQLiteDatabase db = sqlite.getReadableDatabase();
        List<Person> persons = new ArrayList<Person>();
        //Cursor cursor = db.rawQuery("select name,id,number from person",null);
        Cursor cursor = db.query("person", new String[]{"name","id","number"}, null, null, null, null, null);
        while(cursor.moveToNext())
        {
            int id = cursor.getInt(cursor.getColumnIndex("id"));
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String number = cursor.getString(cursor.getColumnIndex("number"));
            Person p = new Person(id,name,number);
            persons.add(p);
        }
        cursor.close();
        db.close();
        return persons;
    }

public class testDB extends AndroidTestCase {
    public void testCreateDB() throws Exception {
        PersonSQLite sqlite = new PersonSQLite(getContext());
        sqlite.getWritableDatabase();

    }
    
    public void testAdd() throws Exception
    {
        PersonDao dao = new PersonDao(getContext());
        dao.add("wangwu","123321");
    }
    
    public void testFind()
    {
        PersonDao dao = new PersonDao(getContext());
        boolean result = dao.find("wangwu");
        assertEquals(true, result);
    }
    
    public void testUpdate()
    {
        PersonDao dao = new PersonDao(getContext());
        dao.update("wangwu", "122222222");
    }
    
    public void testeDelete()
    {
        PersonDao dao = new PersonDao(getContext());
        dao.delete("wangwu");
    }
    
    public void testFindAll()
    {
        PersonDao dao = new PersonDao(getContext());
        List<Person> persons = dao.findAll();
        for(Person p : persons)
        {
            System.out.println(p.toString());
        }
    }
    
}

<instrumentation 
        android:name="android.test.InstrumentationTestRunner"
        android:targetPackage="com.yuyidong.sqlite">        
</instrumentation>

<uses-library android:name="android.test.runner"/>