| /**************************************************************************** |
| ** |
| ** Copyright (C) 2015 The Qt Company Ltd. |
| ** Contact: http://www.qt.io/licensing/ |
| ** |
| ** This file is part of the QtSql module of the Qt Toolkit. |
| ** |
| ** $QT_BEGIN_LICENSE:LGPL21$ |
| ** Commercial License Usage |
| ** Licensees holding valid commercial Qt licenses may use this file in |
| ** accordance with the commercial license agreement provided with the |
| ** Software or, alternatively, in accordance with the terms contained in |
| ** a written agreement between you and The Qt Company. For licensing terms |
| ** and conditions see http://www.qt.io/terms-conditions. For further |
| ** information use the contact form at http://www.qt.io/contact-us. |
| ** |
| ** GNU Lesser General Public License Usage |
| ** Alternatively, this file may be used under the terms of the GNU Lesser |
| ** General Public License version 2.1 or version 3 as published by the Free |
| ** Software Foundation and appearing in the file LICENSE.LGPLv21 and |
| ** LICENSE.LGPLv3 included in the packaging of this file. Please review the |
| ** following information to ensure the GNU Lesser General Public License |
| ** requirements will be met: https://www.gnu.org/licenses/lgpl.html and |
| ** http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. |
| ** |
| ** As a special exception, The Qt Company gives you certain additional |
| ** rights. These rights are described in The Qt Company LGPL Exception |
| ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. |
| ** |
| ** $QT_END_LICENSE$ |
| ** |
| ****************************************************************************/ |
| |
| #ifndef QSQLQUERY_H |
| #define QSQLQUERY_H |
| |
| #include <QtSql/qsql.h> |
| #include <QtSql/qsqldatabase.h> |
| #include <QtCore/qstring.h> |
| |
| QT_BEGIN_NAMESPACE |
| |
| |
| 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: |
| explicit QSqlQuery(QSqlResult *r); |
| explicit 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; |
| bool isNull(const QString &name) 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; |
| QVariant value(const QString& name) const; |
| |
| void setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy precisionPolicy); |
| QSql::NumericalPrecisionPolicy numericalPrecisionPolicy() const; |
| |
| bool seek(int i, bool relative = false); |
| bool next(); |
| bool previous(); |
| 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 |
| |
| #endif // QSQLQUERY_H |