数据存储——SQLite

1. 采用SQL语句对数据库操作

        SQLiteDatabase sqLiteDatabase = openOrCreateDatabase("myDB",MODE_PRIVATE,null);
        sqLiteDatabase.execSQL("create table if not exists " +
                "userInfo(_id integer primary key autoincrement," +
                "name text not null, " +
                "sex text not null)");
        sqLiteDatabase.execSQL("insert into userInfo(name,sex) values('张三','男')");
        Cursor cur = sqLiteDatabase.rawQuery("select * from userInfo", null);
        while(cur.moveToNext()){
            Log.i("myDB","_id="+cur.getInt(cur.getColumnIndex("_id")));
            Log.i("myDB","name="+cur.getString(cur.getColumnIndex("name")));
            Log.i("myDB","sex="+cur.getString(cur.getColumnIndex("sex")));
        }
        cur.close();
        sqLiteDatabase.close();

2.采用类中的方法操作数据库

        SQLiteDatabase db = openOrCreateDatabase("testDB",MODE_PRIVATE,null);
        db.execSQL("create table if not exists stuInfo" +
                "(_id integer primary key autoincrement," +
                "stu_num text not null," +
                "stu_name text not null)");
        ContentValues values = new ContentValues();
        values.put("stu_num","131110101");
        values.put("stu_name", "张三");
        db.insert("stuInfo", null, values);
        values.put("stu_num","123456789");
        db.update("stuInfo",values,"stu_num='131110101'",null);
        Cursor cur = db.query("stuInfo",null,"stu_name='张三'",null,null,null,null,null);
        while(cur.moveToNext()){
            Log.i("tag",cur.getString(cur.getColumnIndex("stu_num"))+"  "+cur.getString(cur.getColumnIndex("stu_name")));
        }
        cur.close();
        db.close();