- Main Page
- Related Pages
- Modules
- Namespaces
- Classes
- Files
- Directories
- Examples

- File List
- File Members

# qsqlquery.h

Go to the documentation of this file.

    00001 /****************************************************************************
    00002 **
    00003 ** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).
    00004 ** All rights reserved.
    00005 ** Contact: Nokia Corporation (qt-info@nokia.com)
    00006 **
    00007 ** This file is part of the QtSql module of the Qt Toolkit.
    00008 **
    00009 ** $QT_BEGIN_LICENSE:LGPL$
    00010 ** Commercial Usage
    00011 ** Licensees holding valid Qt Commercial licenses may use this file in
    00012 ** accordance with the Qt Commercial License Agreement provided with the
    00013 ** Software or, alternatively, in accordance with the terms contained in
    00014 ** a written agreement between you and Nokia.
    00015 **
    00016 ** GNU Lesser General Public License Usage
    00017 ** Alternatively, this file may be used under the terms of the GNU Lesser
    00018 ** General Public License version 2.1 as published by the Free Software
    00019 ** Foundation and appearing in the file LICENSE.LGPL included in the
    00020 ** packaging of this file.  Please review the following information to
    00021 ** ensure the GNU Lesser General Public License version 2.1 requirements
    00022 ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
    00023 **
    00024 ** In addition, as a special exception, Nokia gives you certain additional
    00025 ** rights.  These rights are described in the Nokia Qt LGPL Exception
    00026 ** version 1.1, included in the file LGPL_EXCEPTION.txt in this module.
    00027 **
    00028 ** GNU General Public License Usage
    00029 ** Alternatively, this file may be used under the terms of the GNU
    00030 ** General Public License version 3.0 as published by the Free Software
    00031 ** Foundation and appearing in the file LICENSE.GPL included in the
    00032 ** packaging of this file.  Please review the following information to
    00033 ** ensure the GNU General Public License version 3.0 requirements will be
    00034 ** met: http://www.gnu.org/copyleft/gpl.html.
    00035 **
    00036 ** If you have questions regarding the use of this file, please contact
    00037 ** Nokia at qt-info@nokia.com.
    00038 ** $QT_END_LICENSE$
    00039 **
    00040 ****************************************************************************/
    00041
    00042 #ifndef QSQLQUERY_H
    00043 #define QSQLQUERY_H
    00044
    00045 #include <QtSql/qsql.h>
    00046 #include <QtSql/qsqldatabase.h>
    00047 #include <QtCore/qstring.h>
    00048
    00049 QT_BEGIN_HEADER
    00050
    00051 QT_BEGIN_NAMESPACE
    00052
    00053 QT_MODULE(Sql)
    00054
    00055 class QVariant;
    00056 class QSqlDriver;
    00057 class QSqlError;
    00058 class QSqlResult;
    00059 class QSqlRecord;
    00060 template <class Key, class T> class QMap;
    00061 class QSqlQueryPrivate;
    00062
    00063 class Q_SQL_EXPORT QSqlQuery
    00064 {
    00065 public:
    00066     QSqlQuery(QSqlResult *r);
    00067     QSqlQuery(const QString& query = QString(), QSqlDatabase db = QSqlDatabase());
    00068     explicit QSqlQuery(QSqlDatabase db);
    00069     QSqlQuery(const QSqlQuery& other);
    00070     QSqlQuery& operator=(const QSqlQuery& other);
    00071     ~QSqlQuery();
    00072
    00073     bool isValid() const;
    00074     bool isActive() const;
    00075     bool isNull(int field) const;
    00076     int at() const;
    00077     QString lastQuery() const;
    00078     int numRowsAffected() const;
    00079     QSqlError lastError() const;
    00080     bool isSelect() const;
    00081     int size() const;
    00082     const QSqlDriver* driver() const;
    00083     const QSqlResult* result() const;
    00084     bool isForwardOnly() const;
    00085     QSqlRecord record() const;
    00086
    00087     void setForwardOnly(bool forward);
    00088     bool exec(const QString& query);
    00089     QVariant value(int i) const;
    00090
    00091     void setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy precisionPolicy);
    00092     QSql::NumericalPrecisionPolicy numericalPrecisionPolicy() const;
    00093
    00094     bool seek(int i, bool relative = false);
    00095     bool next();
    00096     bool previous();
    00097 #ifdef QT3_SUPPORT
    00098     inline QT3_SUPPORT bool prev() { return previous(); }
    00099 #endif
    00100     bool first();
    00101     bool last();
    00102
    00103     void clear();
    00104
    00105     // prepared query support
    00106     bool exec();
    00107     enum BatchExecutionMode { ValuesAsRows, ValuesAsColumns };
    00108     bool execBatch(BatchExecutionMode mode = ValuesAsRows);
    00109     bool prepare(const QString& query);
    00110     void bindValue(const QString& placeholder, const QVariant& val,
    00111                    QSql::ParamType type = QSql::In);
    00112     void bindValue(int pos, const QVariant& val, QSql::ParamType type = QSql::In);
    00113     void addBindValue(const QVariant& val, QSql::ParamType type = QSql::In);
    00114     QVariant boundValue(const QString& placeholder) const;
    00115     QVariant boundValue(int pos) const;
    00116     QMap<QString, QVariant> boundValues() const;
    00117     QString executedQuery() const;
    00118     QVariant lastInsertId() const;
    00119     void finish();
    00120     bool nextResult();
    00121
    00122 private:
    00123     QSqlQueryPrivate* d;
    00124 };
    00125
    00126 QT_END_NAMESPACE
    00127
    00128 QT_END_HEADER
    00129
    00130 #endif // QSQLQUERY_H