sqlite3_close()

最新推荐文章于 2024-09-25 09:25:33 发布

转载最新推荐文章于 2024-09-25 09:25:33 发布 · 1.5k 阅读

文章标签：

#sqlite #destructor #constants #object #resources #database

Sqlite 专栏收录该内容

13 篇文章

订阅专栏

本文介绍如何使用sqlite3_close()函数安全地销毁SQLite数据库连接对象并释放所有资源。文章强调了在调用此函数前需要先完成所有准备好的语句及BLOB句柄的关闭工作，并解释了在不同情况下该函数可能返回的状态。

Closing A Database Connection

int sqlite3_close(sqlite3 *);

The sqlite3_close() routine is the destructor for the sqlite3 object. Calls to sqlite3_close() return SQLITE_OK if the sqlite3 object is successfully destroyed and all associated resources are deallocated.

Applications must finalize all prepared statements and close all BLOB handles associated with the sqlite3 object prior to attempting to close the object. If sqlite3_close() is called on a database connection that still has outstanding prepared statements or BLOB handles, then it returns SQLITE_BUSY.

If sqlite3_close() is invoked while a transaction is open, the transaction is automatically rolled back.

The C parameter to sqlite3_close(C) must be either a NULL pointer or an sqlite3 object pointer obtained from sqlite3_open(), sqlite3_open16(), orsqlite3_open_v2(), and not previously closed. Calling sqlite3_close() with a NULL pointer argument is a harmless no-op.

See also lists of Objects, Constants, and Functions.