11小数据库



SQLiteDatabase操作
SQLiteOpenHelper

SQLit支持：NULL/INTEGER/REAL/TEXT/BLOB

getReadableDatabase()
getWritableDatabase()

onCreate()
onOpen()
onUpgrade()

close()

//建库建表
Helper h = new Helper(*Activity.this,"LWDB");
SQLiteDatabase db = h.getReadableDatabase();
//库本升级
Helper h = new Helper(*Activity.this,"LWDB",2);
SQLiteDatabase db = h.getReadableDatabase();
//增
Helper h = new Helper(*Activity.this,"LWDB");
SQLiteDatabase db = h.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id",1);
values.put("name","liwei");
db.insert("user",null,values);
//删
Helper h = new Helper(SQLiteActivity.this,"LWDB");
    SQLiteDatabase db = h.getWritableDatabase();
    db.delete("user", "id=?", new String[]{"1"});
    db.close();
//改
Helper h = new Helper(*Activity.this,"LWDB");
SQLiteDatabase db = h.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name","liyan");
db.update("user", values, "id=?", new String[]{"1"});
//查
Helper h = new Helper(*Activity.this,"LWDB");
SQLiteDatabase db = h.getWritableDatabase();
Cursor cursor = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, "", "", "");
    while(cursor.moveToNext()){
        String s = cursor.getString(cursor.getColumnIndex("name"));

}