/**************************************************************************** ** ** Copyright (C) 2013 Digia Plc and/or its subsidiary(-ies). ** Contact: http://www.qt-project.org/legal ** ** This file is part of the QtSql module of the Qt Toolkit. ** ** $QT_BEGIN_LICENSE:LGPL$ ** 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 Digia. For licensing terms and ** conditions see http://qt.digia.com/licensing. For further information ** use the contact form at http://qt.digia.com/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 as published by the Free Software ** Foundation and appearing in the file LICENSE.LGPL included in the ** packaging of this file. Please review the following information to ** ensure the GNU Lesser General Public License version 2.1 requirements ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. ** ** In addition, as a special exception, Digia gives you certain additional ** rights. These rights are described in the Digia Qt LGPL Exception ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. ** ** GNU General Public License Usage ** Alternatively, this file may be used under the terms of the GNU ** General Public License version 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 the GNU General Public License version 3.0 requirements will be ** met: http://www.gnu.org/copyleft/gpl.html. ** ** ** $QT_END_LICENSE$ ** ****************************************************************************/ #ifndef QSQLQUERY_H #define QSQLQUERY_H #include #include #include QT_BEGIN_NAMESPACE class QVariant; class QSqlDriver; class QSqlError; class QSqlResult; class QSqlRecord; template 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 boundValues() const; QString executedQuery() const; QVariant lastInsertId() const; void finish(); bool nextResult(); private: QSqlQueryPrivate* d; }; QT_END_NAMESPACE #endif // QSQLQUERY_H