数据存储——SQLite

来源：互联网发布：天猫与淘宝流量对比编辑：程序博客网时间：2024/05/10 01:36

采用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();

0 0