?? ???? SQLiteDatabase db =?? openOrCreateDatabase("user.db", MODE_PRIVATE, null);
?? ??? ??? ?db.execSQL("create table if not exists usertb (_id integer primary key autoincrement, name text not null , age integer not null , sex text not null )");
?? ??? ??? ?db.execSQL("insert into usertb(name,sex,age) values('張三','女',18)");
?? ??? ??? ?db.execSQL("insert into usertb(name,sex,age) values('李四','女',19)");
?? ??? ??? ?db.execSQL("insert into usertb(name,sex,age) values('王五','男',20)");
?? ??? ??? ?
?? ??? ??? ? Cursor c = db.rawQuery("select * from usertb", null);
?? ??? ??? ? ?? ?if (c!=null) {
?? ??? ??? ? ?? ??? ?while (c.moveToNext()) {
?? ??? ??? ??? ??? ??? ?Log.i("info", "_id:"+c.getInt(c.getColumnIndex("_id")));
?? ??? ??? ??? ??? ??? ?Log.i("info", "name:"+c.getString(c.getColumnIndex("name")));
?? ??? ??? ??? ??? ??? ?Log.i("info", "age:"+c.getInt(c.getColumnIndex("age")));
?? ??? ??? ??? ??? ??? ?Log.i("info", "sex:"+c.getString(c.getColumnIndex("sex")));
?? ??? ??? ??? ??? ??? ?Log.i("info", "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");
?? ??? ??? ??? ??? ?}
?? ??? ??? ? ?? ??? ?c.close();
?? ??? ??? ? ?? ?}
?? ??? ??? ? ?? ?db.close();
?? ?}