qsqldatabase.html
来自「QT 下载资料仅供参考」· HTML 代码 · 共 344 行 · 第 1/2 页
HTML
344 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><!-- /home/reggie/tmp/qt-3.0-reggie-5401/qt-x11-commercial-3.0.5/src/sql/qsqldatabase.cpp:276 --><html><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><title>QSqlDatabase Class</title><style type="text/css"><!--h3.fn,span.fn { margin-left: 1cm; text-indent: -1cm; }a:link { color: #004faf; text-decoration: none }a:visited { color: #672967; text-decoration: none }body { background: #ffffff; color: black; }--></style></head><body><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr bgcolor="#E5E5E5"><td valign=center> <a href="index.html"><font color="#004faf">Home</font></a> | <a href="classes.html"><font color="#004faf">All Classes</font></a> | <a href="mainclasses.html"><font color="#004faf">Main Classes</font></a> | <a href="annotated.html"><font color="#004faf">Annotated</font></a> | <a href="groups.html"><font color="#004faf">Grouped Classes</font></a> | <a href="functions.html"><font color="#004faf">Functions</font></a></td><td align="right" valign="center"><img src="logo32.png" align="right" width="64" height="32" border="0"></td></tr></table><h1 align=center>QSqlDatabase Class Reference<br><small>[<a href="sql.html">sql module</a>]</small></h1><p>The QSqlDatabase class is used to create SQL databaseconnections and provide transaction handling.<a href="#details">More...</a><p><tt>#include <<a href="qsqldatabase-h.html">qsqldatabase.h</a>></tt><p>Inherits <a href="qobject.html">QObject</a>.<p><a href="qsqldatabase-members.html">List of all member functions.</a><h2>Public Members</h2><ul><li><div class=fn><a href="#~QSqlDatabase"><b>~QSqlDatabase</b></a> ()</div></li><li><div class=fn>bool <a href="#open"><b>open</b></a> ()</div></li><li><div class=fn>bool <a href="#open-2"><b>open</b></a> ( const QString & user, const QString & password )</div></li><li><div class=fn>void <a href="#close"><b>close</b></a> ()</div></li><li><div class=fn>bool <a href="#isOpen"><b>isOpen</b></a> () const</div></li><li><div class=fn>bool <a href="#isOpenError"><b>isOpenError</b></a> () const</div></li><li><div class=fn>QStringList <a href="#tables"><b>tables</b></a> () const</div></li><li><div class=fn>QSqlIndex <a href="#primaryIndex"><b>primaryIndex</b></a> ( const QString & tablename ) const</div></li><li><div class=fn>QSqlRecord <a href="#record"><b>record</b></a> ( const QString & tablename ) const</div></li><li><div class=fn>QSqlRecord <a href="#record-2"><b>record</b></a> ( const QSqlQuery & query ) const</div></li><li><div class=fn>QSqlRecordInfo <a href="#recordInfo"><b>recordInfo</b></a> ( const QString & tablename ) const</div></li><li><div class=fn>QSqlRecordInfo <a href="#recordInfo-2"><b>recordInfo</b></a> ( const QSqlQuery & query ) const</div></li><li><div class=fn>QSqlQuery <a href="#exec"><b>exec</b></a> ( const QString & query = QString::null ) const</div></li><li><div class=fn>QSqlError <a href="#lastError"><b>lastError</b></a> () const</div></li><li><div class=fn>bool <a href="#transaction"><b>transaction</b></a> ()</div></li><li><div class=fn>bool <a href="#commit"><b>commit</b></a> ()</div></li><li><div class=fn>bool <a href="#rollback"><b>rollback</b></a> ()</div></li><li><div class=fn>virtual void <a href="#setDatabaseName"><b>setDatabaseName</b></a> ( const QString & name )</div></li><li><div class=fn>virtual void <a href="#setUserName"><b>setUserName</b></a> ( const QString & name )</div></li><li><div class=fn>virtual void <a href="#setPassword"><b>setPassword</b></a> ( const QString & password )</div></li><li><div class=fn>virtual void <a href="#setHostName"><b>setHostName</b></a> ( const QString & host )</div></li><li><div class=fn>virtual void <a href="#setPort"><b>setPort</b></a> ( int p )</div></li><li><div class=fn>QString <a href="#databaseName"><b>databaseName</b></a> () const</div></li><li><div class=fn>QString <a href="#userName"><b>userName</b></a> () const</div></li><li><div class=fn>QString <a href="#password"><b>password</b></a> () const</div></li><li><div class=fn>QString <a href="#hostName"><b>hostName</b></a> () const</div></li><li><div class=fn>QString <a href="#driverName"><b>driverName</b></a> () const</div></li><li><div class=fn>int <a href="#port"><b>port</b></a> () const</div></li><li><div class=fn>QSqlDriver * <a href="#driver"><b>driver</b></a> () const</div></li></ul><h2>Static Public Members</h2><ul><li><div class=fn>QSqlDatabase * <a href="#addDatabase"><b>addDatabase</b></a> ( const QString & type, const QString & connectionName = defaultConnection )</div></li><li><div class=fn>QSqlDatabase * <a href="#database"><b>database</b></a> ( const QString & connectionName = defaultConnection, bool open = TRUE )</div></li><li><div class=fn>void <a href="#removeDatabase"><b>removeDatabase</b></a> ( const QString & connectionName )</div></li><li><div class=fn>bool <a href="#contains"><b>contains</b></a> ( const QString & connectionName = defaultConnection )</div></li><li><div class=fn>QStringList <a href="#drivers"><b>drivers</b></a> ()</div></li></ul><h2>Properties</h2><ul><li><div class=fn>QString <a href="#databaseName-prop"><b>databaseName</b></a> - the name of the database. Note that the database name is the TNS Service Name for the QOCI8 (Oracle) driver, and the Data Source Name for the QODBC3 driver</div></li><li><div class=fn>QString <a href="#hostName-prop"><b>hostName</b></a> - the host name where the database resides</div></li><li><div class=fn>QString <a href="#password-prop"><b>password</b></a> - the password used to connect to the database</div></li><li><div class=fn>int <a href="#port-prop"><b>port</b></a> - the port used to connect to the database</div></li><li><div class=fn>QString <a href="#userName-prop"><b>userName</b></a> - the user name connected to the database</div></li></ul><h2>Protected Members</h2><ul><li><div class=fn><a href="#QSqlDatabase"><b>QSqlDatabase</b></a> ( const QString & driver, const QString & name, QObject * parent = 0, const char * objname = 0 )</div></li></ul><hr><a name="details"></a><h2>Detailed Description</h2><p> The QSqlDatabase class is used to create SQL databaseconnections and provide transaction handling.<p> <p> This class is used to create connections to SQL databases. It alsoprovides transaction handling functions for those database driversthat support transactions.<p> The QSqlDatabase class itself provides an abstract interface foraccessing many types of database backend. Database-specific driversare used internally to actually access and manipulate data, (see<a href="qsqldriver.html">QSqlDriver</a>). Result set objects provide the interface for executingand manipulating SQL queries (see <a href="qsqlquery.html">QSqlQuery</a>).<p> <p>See also <a href="database.html">Database Classes</a>.<hr><h2>Member Function Documentation</h2><h3 class=fn><a name="QSqlDatabase"></a>QSqlDatabase::QSqlDatabase ( const <a href="qstring.html">QString</a> & driver, const <a href="qstring.html">QString</a> & name, <a href="qobject.html">QObject</a> * parent = 0, const char * objname = 0 )<tt> [protected]</tt></h3> Creates a QSqlDatabase connection named <em>name</em> that uses thedriver referred to by <em>driver</em>, with the parent <em>parent</em> andthe object name <em>objname</em>. If the <em>driver</em> is not recognized,the database connection will have no functionality.<p> The currently available drivers are:<p> <ul><li> <a href="sql-driver.html#QODBC3">QODBC3</a> - ODBC (Open Database Connectivity) Driver<li> <a href="sql-driver.html#QOCI8">QOCI8</a> - Oracle Call Interface Driver<li> <a href="sql-driver.html#QPSQL7">QPSQL7</a> - PostgreSQL v6.x and v7.x Driver<li> <a href="sql-driver.html#QTDS7">QTDS7</a> - Sybase Adaptive Server and Microsoft SQL Server Driver<li> <a href="sql-driver.html#QMYSQL3">QMYSQL3</a> - MySQL Driver</ul><p> Note that additional 3<sup>rd</sup> party drivers can be loadeddynamically.<p> <h3 class=fn><a name="~QSqlDatabase"></a>QSqlDatabase::~QSqlDatabase ()</h3> Destroys the object and frees any allocated resources.<p> <h3 class=fn><a href="qsqldatabase.html">QSqlDatabase</a> * <a name="addDatabase"></a>QSqlDatabase::addDatabase ( const <a href="qstring.html">QString</a> & type, const <a href="qstring.html">QString</a> & connectionName = defaultConnection )<tt> [static]</tt></h3> Adds a database to the list of database connections using thedriver <em>type</em> and the connection name <em>connectionName</em>.<p> The database connection is referred to by <em>connectionName</em>. Apointer to the newly added database connection is returned. Thispointer is owned by QSqlDatabase and will be deleted on program exitor when <a href="#removeDatabase">removeDatabase</a>() is called. If <em>connectionName</em> is notspecified, the newly added database connection becomes the defaultdatabase connection for the application, and subsequent calls to<a href="#database">database</a>() (without a database name parameter) will return a pointerto it.<p> <p>See also <a href="#database">database</a>() and <a href="#removeDatabase">removeDatabase</a>().<p> <p>Examples: <a href="sql.html#x2141">sql/overview/connect1/main.cpp</a>, <a href="sql.html#x2147">sql/overview/create_connections/main.cpp</a> and <a href="sqltable-example.html#x2793">sql/sqltable/main.cpp</a>.<h3 class=fn>void <a name="close"></a>QSqlDatabase::close ()</h3> Closes the database connection, freeing any resources acquired.<p> <h3 class=fn>bool <a name="commit"></a>QSqlDatabase::commit ()</h3> Commits a transaction to the database if the driver supports transactions.Returns TRUE if the operation succeeded, FALSE otherwise.<p> <p>See also <a href="qsqldriver.html#hasFeature">QSqlDriver::hasFeature</a>() and <a href="#rollback">rollback</a>().<h3 class=fn>bool <a name="contains"></a>QSqlDatabase::contains ( const <a href="qstring.html">QString</a> & connectionName = defaultConnection )<tt> [static]</tt></h3> Returns TRUE if the list of database connections contains <em>connectionName</em>, otherwise returns FALSE.<p> <h3 class=fn><a href="qsqldatabase.html">QSqlDatabase</a> * <a name="database"></a>QSqlDatabase::database ( const <a href="qstring.html">QString</a> & connectionName = defaultConnection, bool open = TRUE )<tt> [static]</tt></h3> Returns a pointer to the database connection named <em>connectionName</em>. The database connection must have been previouslyadded with <a href="#database">database</a>(). If <em>open</em> is TRUE (the default) and thedatabase connection is not already open it is opened now. If no <em>connectionName</em> is specified the default connection is used. If <em>connectionName</em> does not exist in the list of databases, 0 isreturned. The pointer returned is owned by QSqlDatabase and should<em>not</em> be deleted.<p> <p>Examples: <a href="sql.html#x2155">sql/overview/basicbrowsing/main.cpp</a> and <a href="sql.html#x2148">sql/overview/create_connections/main.cpp</a>.<h3 class=fn><a href="qstring.html">QString</a> <a name="databaseName"></a>QSqlDatabase::databaseName () const</h3><p>Returns the name of the database. Note that the database name is the TNS Service Name for the QOCI8 (Oracle) driver, and the Data Source Name for the QODBC3 driver.See the <a href="qsqldatabase.html#databaseName-prop">"databaseName"</a> property for details.<h3 class=fn><a href="qsqldriver.html">QSqlDriver</a> * <a name="driver"></a>QSqlDatabase::driver () const</h3> Returns a pointer to the database driver used to access the database connection.<p> <h3 class=fn><a href="qstring.html">QString</a> <a name="driverName"></a>QSqlDatabase::driverName () const</h3> Returns the name of the driver used by the database connection.<p> ⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?