计算机外文翻译31

《计算机外文翻译31》由会员分享，可在线阅读，更多相关《计算机外文翻译31（17页珍藏版）》请在毕设资料网上搜索。

1、- 1 - 外文原文 The Connection Lifecycle Connections are the sole means through which to operate on a database. The connection lifecycle consists of three phases: 1. Connect to the database. Connecting involves creating a database connection object of some sort. The connection object manages transactions

2、 (through its associated pager), often performs simple one-step queries (using the wrapped query functions), and creates statement objects for prepared queries. 2. Perform transactions. As you know, all commands are executed within transactions. By default, a database connection runs in autocommit m

3、ode. This means that every SQL command it executes runs under its own independent transaction. The alternative is to manually declare transactions using BEGINCOMMIT. In this scenario, multiple commands can run together within the same transaction. 3. Disconnect from the database. Disconnecting from

4、a database involves closing the database file and the files of any attached databases. Other activities involved with query processing include handling errors, busy conditions, and schema changes, all of which are done through the utility functions covered in the following sections. Connecting to a Database Connecting to a database involves little more than opening a file. Every SQLite database is stored in a single operating system fileone database to one file. The function used to connect,