android sqlite 用外键关联,Android中使用SQLite的外键约束？在删除级联

用更完整的答案回答问题永远不会过于陈旧。@Override public void onOpen(SQLiteDatabase db) {

super.onOpen(db);

if (!db.isReadOnly()) {

setForeignKeyConstraintsEnabled(db);

}

mOpenHelperCallbacks.onOpen(mContext, db);}private void setForeignKeyConstraintsEnabled(SQLiteDatabase db) {

if (Build.VERSION.SDK_INT 

setForeignKeyConstraintsEnabledPreJellyBean(db);

} else {

setForeignKeyConstraintsEnabledPostJellyBean(db);

}}private void setForeignKeyConstraintsEnabledPreJellyBean(SQLiteDatabase db) {

db.execSQL("PRAGMA foreign_keys=ON;");}@TargetApi(Build.VERSION_CODES.JELLY_BEAN)private void setForeignKeyConstraintsEnabledPostJellyBean(SQLiteDatabase db) {

db.setForeignKeyConstraintsEnabled(true);}