Android开发教程之--sql语句
一、创建/删除表
String?sql="Create?table?"+TABLE_NAME+"("+FIELD_ID+"?integer?primary?key?autoincrement,"??+FIELD_TITLE+"?text?);";
????????db.execSQL(sql);
String?sql="?DROP?TABLE?IF?EXISTS?"+TABLE_NAME;
????????db.execSQL(sql);
?
二、查询
从表中查询数据（in）?? SELECT * FROM meta where media_id in (1,2,9);
?
三、插入
SQLiteDatabase?db=this.getWritableDatabase();
????????ContentValues?cv=new?ContentValues();?
????????cv.put(FIELD_TITLE,?Title);
????????long?row=db.insert(TABLE_NAME,?null,?cv);
四、更新
SQLiteDatabase?db=this.getWritableDatabase();
????????String?where=FIELD_ID+"=?";
????????String[]?whereValue={Integer.toString(id)};
????????ContentValues?cv=new?ContentValues();?
????????cv.put(FIELD_TITLE,?Title);
????????db.update(TABLE_NAME,?cv,?where,?whereValue);
五、删除
SQLiteDatabase?db=this.getWritableDatabase();
????????String?where=FIELD_ID+"=?";
????????String[]?whereValue={Integer.toString(id)};
????????db.delete(TABLE_NAME,?where,?whereValue);
