Tianchi  v0.0.2 build 20130701
C++ library for Qt with VC & mingW
Public 类型 | Public 成员函数 | 静态 Public 成员函数 | 所有成员列表
TcDataAccess类 参考

Public 类型

enum  AttrCase { CaseNatural, CaseLower, CaseUpper }
 
enum  AttrTrim { TrimNone, TrimAll }
 

Public 成员函数

 TcDataAccess (const QString &connectionName=QLatin1String(QSqlDatabase::defaultConnection))
 
 TcDataAccess (const QSqlDatabase &other)
 
QString connectionName () const
 
QSqlQuery sqlQuery () const
 
QSqlDatabase sqlDatabase () const
 
QList< QVariantMap > fetchAll (const QString &sql, const QVariantList &bind=QVariantList())
 
QList< QVariantMap > fetchAll (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
QList< QVariantList > fetchAllList (const QString &sql, const QVariantList &bind=QVariantList())
 
QList< QVariantList > fetchAllList (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
QVariantMap fetchRow (const QString &sql, const QVariantList &bind=QVariantList())
 
QVariantMap fetchRow (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
QVariantList fetchCol (const QString &sql, const QVariantList &bind=QVariantList())
 
QVariantList fetchCol (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
QVariant fetchOne (const QString &sql, const QVariantList &bind=QVariantList())
 
QVariant fetchOne (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
template<typename T >
QMap< T, QVariant > fetchPairs (const QString &sql, const QVariantList &bind=QVariantList())
 
template<typename T >
QMap< T, QVariant > fetchPairs (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
template<typename T >
QMap< T, QVariantMap > fetchAssoc (const QString &sql, const QVariantList &bind=QVariantList())
 
template<typename T >
QMap< T, QVariantMap > fetchAssoc (const TcDataAccessStatement &stat, const QVariantList &bind=QVariantList())
 
QString limitPage (const QString &sql, int page, int rowCount) const
 
QString limit (const QString &sql, int count, int offset=0) const
 
QVariant lastInsertId (const QString &table=QString(), const QString &primaryKey=QString()) const
 
QSqlError lastError () const
 
int doDelete (const QString &table, const QString &where=QString(), const QVariantList &bind=QVariantList())
 
int doUpdate (const QString &table, const QVariantMap &field, const QString &where=QString(), const QVariantList &bind=QVariantList())
 
int doInsert (const QString &table, const QVariantMap &field)
 
TcDataAccessoperator= (const TcDataAccess &da)
 
TcDataAccessoperator= (const QSqlDatabase &db)
 

静态 Public 成员函数

static AttrCase attrCase ()
 
static AttrTrim attrTrim ()
 
static void setAttrCase (AttrCase attrCase)
 
static void setAttrTrim (AttrTrim attrTrim)
 
static TcDataAccessdb (const QString &connectionName=QLatin1String(QSqlDatabase::defaultConnection))
 

该类的文档由以下文件生成: