[196] | 1 | /****************************************************************************
|
---|
| 2 | **
|
---|
| 3 | ** Definition of QSqlQuery class
|
---|
| 4 | **
|
---|
| 5 | ** Created : 2000-11-03
|
---|
| 6 | **
|
---|
| 7 | ** Copyright (C) 2005-2007 Trolltech ASA. All rights reserved.
|
---|
| 8 | **
|
---|
| 9 | ** This file is part of the sql module of the Qt GUI Toolkit.
|
---|
| 10 | **
|
---|
| 11 | ** This file may be distributed under the terms of the Q Public License
|
---|
| 12 | ** as defined by Trolltech ASA of Norway and appearing in the file
|
---|
| 13 | ** LICENSE.QPL included in the packaging of this file.
|
---|
| 14 | **
|
---|
| 15 | ** This file may be distributed and/or modified under the terms of the
|
---|
| 16 | ** GNU General Public License version 2 as published by the Free Software
|
---|
| 17 | ** Foundation and appearing in the file LICENSE.GPL included in the
|
---|
| 18 | ** packaging of this file.
|
---|
| 19 | **
|
---|
| 20 | ** Licensees holding valid Qt Enterprise Edition licenses may use this
|
---|
| 21 | ** file in accordance with the Qt Commercial License Agreement provided
|
---|
| 22 | ** with the Software.
|
---|
| 23 | **
|
---|
| 24 | ** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
|
---|
| 25 | ** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
|
---|
| 26 | **
|
---|
| 27 | ** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for
|
---|
| 28 | ** information about Qt Commercial License Agreements.
|
---|
| 29 | ** See http://www.trolltech.com/qpl/ for QPL licensing information.
|
---|
| 30 | ** See http://www.trolltech.com/gpl/ for GPL licensing information.
|
---|
| 31 | **
|
---|
| 32 | ** Contact info@trolltech.com if any conditions of this licensing are
|
---|
| 33 | ** not clear to you.
|
---|
| 34 | **
|
---|
| 35 | **********************************************************************/
|
---|
| 36 |
|
---|
| 37 | #ifndef QSQLQUERY_H
|
---|
| 38 | #define QSQLQUERY_H
|
---|
| 39 |
|
---|
| 40 | #ifndef QT_H
|
---|
| 41 | #include "qobject.h"
|
---|
| 42 | #include "qstring.h"
|
---|
| 43 | #include "qvariant.h"
|
---|
| 44 | #include "qvaluelist.h"
|
---|
| 45 | #include "qsqlerror.h"
|
---|
| 46 | #include "qsqlfield.h"
|
---|
| 47 | #include "qsql.h"
|
---|
| 48 | #endif // QT_H
|
---|
| 49 |
|
---|
| 50 | #ifndef QT_NO_SQL
|
---|
| 51 |
|
---|
| 52 | class QSqlDriver;
|
---|
| 53 | class QSqlResult;
|
---|
| 54 | class QSqlDatabase;
|
---|
| 55 |
|
---|
| 56 | class Q_EXPORT QSqlResultShared : public QObject, public QShared
|
---|
| 57 | {
|
---|
| 58 | Q_OBJECT
|
---|
| 59 | public:
|
---|
| 60 | QSqlResultShared( QSqlResult* result );
|
---|
| 61 | virtual ~QSqlResultShared();
|
---|
| 62 | QSqlResult* sqlResult;
|
---|
| 63 | QString executedQuery;
|
---|
| 64 | private slots:
|
---|
| 65 | void slotResultDestroyed();
|
---|
| 66 | };
|
---|
| 67 |
|
---|
| 68 | class Q_EXPORT QSqlQuery
|
---|
| 69 | {
|
---|
| 70 | public:
|
---|
| 71 | QSqlQuery( QSqlResult * r );
|
---|
| 72 | QSqlQuery( const QString& query = QString::null, QSqlDatabase* db = 0 );
|
---|
| 73 | Q_EXPLICIT QSqlQuery( QSqlDatabase* db );
|
---|
| 74 | QSqlQuery( const QSqlQuery& other );
|
---|
| 75 | QSqlQuery& operator=( const QSqlQuery& other );
|
---|
| 76 | virtual ~QSqlQuery();
|
---|
| 77 |
|
---|
| 78 | bool isValid() const;
|
---|
| 79 | bool isActive() const;
|
---|
| 80 | bool isNull( int field ) const;
|
---|
| 81 | int at() const;
|
---|
| 82 | QString lastQuery() const;
|
---|
| 83 | int numRowsAffected() const;
|
---|
| 84 | QSqlError lastError() const;
|
---|
| 85 | bool isSelect() const;
|
---|
| 86 | int size() const;
|
---|
| 87 | const QSqlDriver* driver() const;
|
---|
| 88 | const QSqlResult* result() const;
|
---|
| 89 | bool isForwardOnly() const;
|
---|
| 90 | void setForwardOnly( bool forward );
|
---|
| 91 |
|
---|
| 92 | virtual bool exec ( const QString& query );
|
---|
| 93 | virtual QVariant value( int i ) const;
|
---|
| 94 |
|
---|
| 95 | virtual bool seek( int i, bool relative = FALSE );
|
---|
| 96 | virtual bool next();
|
---|
| 97 | virtual bool prev();
|
---|
| 98 | virtual bool first();
|
---|
| 99 | virtual bool last();
|
---|
| 100 |
|
---|
| 101 | // prepared query support
|
---|
| 102 | bool exec();
|
---|
| 103 | bool prepare( const QString& query );
|
---|
| 104 | void bindValue( const QString& placeholder, const QVariant& val );
|
---|
| 105 | void bindValue( int pos, const QVariant& val );
|
---|
| 106 | void addBindValue( const QVariant& val );
|
---|
| 107 | // remove these overloads in 4.0
|
---|
| 108 | void bindValue( const QString& placeholder, const QVariant& val, QSql::ParameterType type );
|
---|
| 109 | void bindValue( int pos, const QVariant& val, QSql::ParameterType type );
|
---|
| 110 | void addBindValue( const QVariant& val, QSql::ParameterType type );
|
---|
| 111 | QVariant boundValue( const QString& placeholder ) const;
|
---|
| 112 | QVariant boundValue( int pos ) const;
|
---|
| 113 | QMap<QString, QVariant> boundValues() const;
|
---|
| 114 | QString executedQuery() const;
|
---|
| 115 |
|
---|
| 116 | protected:
|
---|
| 117 | virtual void beforeSeek();
|
---|
| 118 | virtual void afterSeek();
|
---|
| 119 |
|
---|
| 120 | private:
|
---|
| 121 | void init( const QString& query, QSqlDatabase* db );
|
---|
| 122 | void deref();
|
---|
| 123 | bool checkDetach();
|
---|
| 124 | QSqlResultShared* d;
|
---|
| 125 | };
|
---|
| 126 |
|
---|
| 127 |
|
---|
| 128 | #endif // QT_NO_SQL
|
---|
| 129 | #endif
|
---|