直接使用SQLite C API时，还必须使用C函数来执行SQL命令:

When you are using the SQLite C API directly, you must also use a C function to execute SQL commands:

sqlite3_exec(connection, "PRAGMA foreign_keys = on", NULL, NULL, NULL);