d1/d3e/qsqlresult_8h_source.html

// Copyright (C) 2016 The Qt Company Ltd.

// SPDX-License-Identifier: LicenseRef-Qt-Commercial OR LGPL-3.0-only OR GPL-2.0-only OR GPL-3.0-only


#ifndef QSQLRESULT_H

#define QSQLRESULT_H


#include <QtSql/qtsqlglobal.h>

#include <QtCore/qvariant.h>

#include <QtCore/qcontainerfwd.h>


QT_BEGIN_NAMESPACE


class QString;

class QSqlRecord;

class QVariant;

class QSqlDriver;

class QSqlError;

class QSqlResultPrivate;


class Q_SQL_EXPORT QSqlResult

{

    Q_DECLARE_PRIVATE(QSqlResult)

    friend class QSqlQuery;

    friend class QSqlTableModelPrivate;


public:

    virtual ~QSqlResult();

    virtual QVariant handle() const;


protected:


    enum BindingSyntax {

        PositionalBinding,

        NamedBinding

    };


    explicit QSqlResult(const QSqlDriver * db);

    QSqlResult(QSqlResultPrivate &dd);

    int at() const;

    QString lastQuery() const;

    QSqlError lastError() const;

    bool isValid() const;

    bool isActive() const;

    bool isSelect() const;

    bool isForwardOnly() const;

    const QSqlDriver* driver() const;

    virtual void setAt(int at);

    virtual void setActive(bool a);

    virtual void setLastError(const QSqlError& e);

    virtual void setQuery(const QString& query);

    virtual void setSelect(bool s);

    virtual void setForwardOnly(bool forward);


    // prepared query support

    virtual bool exec();

    virtual bool prepare(const QString& query);

    virtual bool savePrepare(const QString& sqlquery);

    virtual void bindValue(int pos, const QVariant& val, QSql::ParamType type);

    virtual void bindValue(const QString& placeholder, const QVariant& val,

                           QSql::ParamType type);

    void addBindValue(const QVariant& val, QSql::ParamType type);

    QVariant boundValue(const QString& placeholder) const;

    QVariant boundValue(int pos) const;

    QSql::ParamType bindValueType(const QString& placeholder) const;

    QSql::ParamType bindValueType(int pos) const;

    int boundValueCount() const;

#if QT_SQL_REMOVED_SINCE(6, 6)

    QList<QVariant> &boundValues() const;

#endif

    QVariantList &boundValues(QT6_DECL_NEW_OVERLOAD);

    QVariantList boundValues(QT6_DECL_NEW_OVERLOAD) const;


    QString executedQuery() const;

    QStringList boundValueNames() const;

    QString boundValueName(int pos) const;

    void clear();

    bool hasOutValues() const;


    BindingSyntax bindingSyntax() const;


    virtual QVariant data(int i) = 0;

    virtual bool isNull(int i) = 0;

    virtual bool reset(const QString& sqlquery) = 0;

    virtual bool fetch(int i) = 0;

    virtual bool fetchNext();

    virtual bool fetchPrevious();

    virtual bool fetchFirst() = 0;

    virtual bool fetchLast() = 0;

    virtual int size() = 0;

    virtual int numRowsAffected() = 0;

    virtual QSqlRecord record() const;

    virtual QVariant lastInsertId() const;


    enum VirtualHookOperation { };

    virtual void virtual_hook(int id, void *data);

    virtual bool execBatch(bool arrayBind = false);

    virtual void detachFromResultSet();

    virtual void setNumericalPrecisionPolicy(QSql::NumericalPrecisionPolicy policy);

    QSql::NumericalPrecisionPolicy numericalPrecisionPolicy() const;

    void setPositionalBindingEnabled(bool enable);

    bool isPositionalBindingEnabled() const;

    virtual bool nextResult();

    void resetBindCount(); // HACK


    QSqlResultPrivate *d_ptr;


private:

    Q_DISABLE_COPY(QSqlResult)

};


QT_END_NAMESPACE


#endif // QSQLRESULT_H

isActive
bool isActive
Definition btsdpinquiry.mm:194

QList< QVariant >

QSqlDriver
The QSqlDriver class is an abstract base class for accessing specific SQL databases.
Definition qsqldriver.h:26

QSqlError
The QSqlError class provides SQL database error information.
Definition qsqlerror.h:17

QSqlQuery
The QSqlQuery class provides a means of executing and manipulating SQL statements.
Definition qsqlquery.h:24

QSqlRecord
The QSqlRecord class encapsulates a database record.
Definition qsqlrecord.h:20

QSqlResultPrivate
Definition qsqlresult_p.h:41

QSqlResult
The QSqlResult class provides an abstract interface for accessing data from specific SQL databases.
Definition qsqlresult.h:22

QSqlResult::isNull
virtual bool isNull(int i)=0
Returns true if the field at position index in the current row is null; otherwise returns false.

QSqlResult::boundValues
QVariantList boundValues(QT6_DECL_NEW_OVERLOAD) const

QSqlResult::data
virtual QVariant data(int i)=0
Returns the data for field index in the current row as a QVariant.

QSqlResult::BindingSyntax
BindingSyntax
This enum type specifies the different syntaxes for specifying placeholders in prepared queries.
Definition qsqlresult.h:32

QSqlResult::PositionalBinding
@ PositionalBinding
Definition qsqlresult.h:33

QSqlResult::VirtualHookOperation
VirtualHookOperation
Definition qsqlresult.h:94

QSqlResult::fetchLast
virtual bool fetchLast()=0
Positions the result to the last record (last row) in the result.

QSqlResult::fetch
virtual bool fetch(int i)=0
Positions the result to an arbitrary (zero-based) row index.

QSqlResult::boundValues
QVariantList & boundValues(QT6_DECL_NEW_OVERLOAD)

QSqlResult::size
virtual int size()=0
Returns the size of the SELECT result, or -1 if it cannot be determined or if the query is not a SELE...

QSqlResult::fetchFirst
virtual bool fetchFirst()=0
Positions the result to the first record (row 0) in the result.

QSqlResult::numRowsAffected
virtual int numRowsAffected()=0
Returns the number of rows affected by the last query executed, or -1 if it cannot be determined or i...

QSqlResult::reset
virtual bool reset(const QString &sqlquery)=0
Sets the result to use the SQL statement query for subsequent data retrieval.

QSqlResult::d_ptr
QSqlResultPrivate * d_ptr
Definition qsqlresult.h:105

QSqlTableModelPrivate
Definition qsqltablemodel_p.h:28

QStringList
\inmodule QtCore

QString
\macro QT_RESTRICTED_CAST_FROM_ASCII
Definition qstring.h:129

QVariant
\inmodule QtCore
Definition qvariant.h:65

i
i
[1]
Definition doc_src_containers.cpp:169

clear
b clear()

setForwardOnly
query setForwardOnly(true)

QSql::NumericalPrecisionPolicy
NumericalPrecisionPolicy
Definition qtsqlglobal.h:43

QT_BEGIN_NAMESPACE
Combined button and popup list for selecting options.
Definition qstandardpaths_haiku.cpp:21

QT_END_NAMESPACE
Definition qsharedpointer.cpp:1590

handle
GLuint64 GLenum void * handle
Definition qopengles2ext.h:1575

a
GLboolean GLboolean GLboolean GLboolean a
[7]
Definition qopengles2ext.h:337

data
GLint GLsizei GLsizei GLenum GLenum GLsizei void * data
Definition qopengles2ext.h:206

type
GLenum type
Definition qopengles2ext.h:150

enable
GLboolean enable
Definition qopengles2ext.h:855

s
GLdouble s
[6]
Definition qopenglext.h:235

query
GLenum query
Definition qopenglext.h:2738

val
GLuint GLfloat * val
Definition qopenglext.h:1513

QT6_DECL_NEW_OVERLOAD
#define QT6_DECL_NEW_OVERLOAD
Definition qtversionchecks.h:67

pos
pos
[7]
Definition src_corelib_io_qsettings.cpp:57

setQuery
qDebug()<< QUrl("file copy setQuery(copy.query(QUrl::FullyDecoded), QUrl::DecodedMode)

db
QMimeDatabase db
[0]
Definition src_corelib_mimetype_qmimedatabase.cpp:7

record
MyRecord record(int row) const
[0]
Definition src_corelib_tools_qcontiguouscache.cpp:5

exec
dialog exec()

at
QAction * at
Definition src_gui_widgets_qmenu.cpp:36

policy
QSizePolicy policy
Definition src_gui_widgets_qsplitter.cpp:6