TSqlConnectionPoolV2 Class

数据库连接池 More...

Header: #include <TSqlConnectionPoolV2>
Inherits: QObject

Public Functions

  • 31 public functions inherited from QObject

Public Slots

long autocloseTimeout() const
QVariant connectParameter(const QString &iCntName = "") const
QSqlDatabase getSqlDatabase(const QString &iCntName = "")
QSqlDatabase newSqlDatabase(const QString &iNewCntName, const QString &iCntName = "")
void releaseConnection(const QString &iCntName = "")
void removeSqlDatabase(const QString &iCntName)
void setAutocloseTimeout(long iMs)
void setConnectParameter(const QVariant &iParamVar, const QString &iCntName = "")
  • 1 public slot inherited from QObject

Static Public Members

TSqlConnectionPoolV2 *instance()
  • 10 static public members inherited from QObject

Additional Inherited Members

  • 1 property inherited from QObject
  • 2 signals inherited from QObject
  • 1 public variable inherited from QObject
  • 9 protected functions inherited from QObject
  • 2 protected variables inherited from QObject

Detailed Description

数据库连接池

Member Function Documentation

TSqlConnectionPoolV2::~TSqlConnectionPoolV2()

Destroys the instance of TSqlConnectionPoolV2.

[slot] long TSqlConnectionPoolV2::autocloseTimeout() const

获取断开连接的时间,默认为120000ms。

See also setAutocloseTimeout().

[slot] QVariant TSqlConnectionPoolV2::connectParameter(const QString &iCntName = "") const

获取数据库连接参数。 iCntName 为关键字。

See also setConnectParameter().

[slot] QSqlDatabase TSqlConnectionPoolV2::getSqlDatabase(const QString &iCntName = "")

连接数据库,获取一个QSqlDatabase对象 iCntName 为连接名,默认为空。

[static] TSqlConnectionPoolV2 *TSqlConnectionPoolV2::instance()

获取TSqlConnectionPoolV2类的单例对象

[slot] QSqlDatabase TSqlConnectionPoolV2::newSqlDatabase(const QString &iNewCntName, const QString &iCntName = "")

新建一个数据库连接。 iNewCntName 为新的连接名。 iCntName 为连接参数名。

[slot] void TSqlConnectionPoolV2::releaseConnection(const QString &iCntName = "")

从连接池中释放一个数据库连接。 iCntName 为数据库连接名。

[slot] void TSqlConnectionPoolV2::removeSqlDatabase(const QString &iCntName)

从连接池中删除一个数据库连接。 iCntName 为数据库连接名。

[slot] void TSqlConnectionPoolV2::setAutocloseTimeout(long iMs)

设置断开连接的时间为 iMs。 iMs 为毫秒。


  TSqlConnectionPoolV2::instance()->setAutocloseTimeout(1000000);
  TSqlConnectionPoolV2::instance()->autocloseTimeout();//1000000

See also autocloseTimeout().

[slot] void TSqlConnectionPoolV2::setConnectParameter(const QVariant &iParamVar, const QString &iCntName = "")

设置数据库连接参数。 iParamVar 为参数。


  T_SQLCNT_POOL->setConnectParameter(QVariantMap {
                                       {"database_user", "toplinker"},
                                       {"database_type", "QPSQL"},
                                       {"database_pwd", "Vkc5d1RHbHVhMlZ5TURVeE1BPT0="},
                                       {"database_name", "TOPIBD_SNAPSHOT"},
                                       {"database_host", "139.196.104.13"},
                                       {"database_options", ""},
                                       {"database_encrypt", "EB642"}
                                     });

See also connectParameter().