qsqlquery.h
上传用户:detong
上传日期:2022-06-22
资源大小:20675k
文件大小:4k
- /****************************************************************************
- **
- ** Copyright (C) 2008 Nokia Corporation and/or its subsidiary(-ies).
- ** Contact: Qt Software Information (qt-info@nokia.com)
- **
- ** This file is part of the QtSql module of the Qt Toolkit.
- **
- ** Commercial Usage
- ** Licensees holding valid Qt Commercial licenses may use this file in
- ** accordance with the Qt Commercial License Agreement provided with the
- ** Software or, alternatively, in accordance with the terms contained in
- ** a written agreement between you and Nokia.
- **
- **
- ** GNU General Public License Usage
- ** Alternatively, this file may be used under the terms of the GNU
- ** General Public License versions 2.0 or 3.0 as published by the Free
- ** Software Foundation and appearing in the file LICENSE.GPL included in
- ** the packaging of this file. Please review the following information
- ** to ensure GNU General Public Licensing requirements will be met:
- ** http://www.fsf.org/licensing/licenses/info/GPLv2.html and
- ** http://www.gnu.org/copyleft/gpl.html. In addition, as a special
- ** exception, Nokia gives you certain additional rights. These rights
- ** are described in the Nokia Qt GPL Exception version 1.3, included in
- ** the file GPL_EXCEPTION.txt in this package.
- **
- ** Qt for Windows(R) Licensees
- ** As a special exception, Nokia, as the sole copyright holder for Qt
- ** Designer, grants users of the Qt/Eclipse Integration plug-in the
- ** right for the Qt/Eclipse Integration to link to functionality
- ** provided by Qt Designer and its related libraries.
- **
- ** If you are unsure which license is appropriate for your use, please
- ** contact the sales department at qt-sales@nokia.com.
- **
- ****************************************************************************/
- #ifndef QSQLQUERY_H
- #define QSQLQUERY_H
- #include <QtSql/qsql.h>
- #include <QtSql/qsqldatabase.h>
- #include <QtCore/qstring.h>
- QT_BEGIN_HEADER
- QT_BEGIN_NAMESPACE
- QT_MODULE(Sql)
- class QVariant;
- class QSqlDriver;
- class QSqlError;
- class QSqlResult;
- class QSqlRecord;
- template <class Key, class T> class QMap;
- class QSqlQueryPrivate;
- class Q_SQL_EXPORT QSqlQuery
- {
- public:
- QSqlQuery(QSqlResult *r);
- QSqlQuery(const QString& query = QString(), QSqlDatabase db = QSqlDatabase());
- explicit QSqlQuery(QSqlDatabase db);
- QSqlQuery(const QSqlQuery& other);
- QSqlQuery& operator=(const QSqlQuery& other);
- ~QSqlQuery();
- bool isValid() const;
- bool isActive() const;
- bool isNull(int field) const;
- int at() const;
- QString lastQuery() const;
- int numRowsAffected() const;
- QSqlError lastError() const;
- bool isSelect() const;
- int size() const;
- const QSqlDriver* driver() const;
- const QSqlResult* result() const;
- bool isForwardOnly() const;
- QSqlRecord record() const;
- void setForwardOnly(bool forward);
- bool exec(const QString& query);
- QVariant value(int i) const;
- void setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy precisionPolicy);
- QSql::NumericalPrecisionPolicy numericalPrecisionPolicy() const;
- bool seek(int i, bool relative = false);
- bool next();
- bool previous();
- #ifdef QT3_SUPPORT
- inline QT3_SUPPORT bool prev() { return previous(); }
- #endif
- bool first();
- bool last();
- void clear();
- // prepared query support
- bool exec();
- enum BatchExecutionMode { ValuesAsRows, ValuesAsColumns };
- bool execBatch(BatchExecutionMode mode = ValuesAsRows);
- bool prepare(const QString& query);
- void bindValue(const QString& placeholder, const QVariant& val,
- QSql::ParamType type = QSql::In);
- void bindValue(int pos, const QVariant& val, QSql::ParamType type = QSql::In);
- void addBindValue(const QVariant& val, QSql::ParamType type = QSql::In);
- QVariant boundValue(const QString& placeholder) const;
- QVariant boundValue(int pos) const;
- QMap<QString, QVariant> boundValues() const;
- QString executedQuery() const;
- QVariant lastInsertId() const;
- void finish();
- bool nextResult();
- private:
- QSqlQueryPrivate* d;
- };
- QT_END_NAMESPACE
- QT_END_HEADER
- #endif // QSQLQUERY_H