我将以下代码添加到测试活动中,并按预期运行：

sqliteDatabase connection = getApplicationContext().openOrCreateDatabase("foo.db",MODE_PRIVATE,null);
try {
    connection.execsql("drop table if exists person");
    connection.execsql("create table person (id integer,name string)");
    ContentValues cv = new ContentValues();
    cv.put("id",1);
    cv.put("name","leo");
    connection.insert("person",null,cv);
    cv = new ContentValues();
    cv.put("id",2);
    cv.put("name","yui");
    connection.insert("person",cv);

    Cursor rs = connection.query("person",new String[] {"id","name" },null);

    while(rs.moveToNext())
    {
        System.out.println("name = " + rs.getString(1));
        System.out.println("id = " + rs.getString(0));

        Cursor rs2 = connection.query("person",null);
        while (rs2.moveToNext()) {
            System.out.println("name = " + rs2.getString(1));
            System.out.println("id = " + rs2.getString(0));
        }
    }
} catch (Exception e) {
    System.out.println("Exception " + e);
}