Viadeo Twitter Google Bookmarks ! Facebook Digg del.icio.us MySpace Yahoo MyWeb Blinklist Netvouz Reddit Simpy StumbleUpon Bookmarks Windows Live Favorites 
Logo Documentation Qt ·  Page d'accueil  ·  Toutes les classes  ·  Toutes les fonctions  ·  Vues d'ensemble  · 

QSqlQueryModel Class Reference
[QtSql module]

The QSqlQueryModel class provides a read-only data model for SQL result sets. More...

 #include <QSqlQueryModel>

This class is not part of the Qt GUI Framework Edition.

Inherits QAbstractTableModel.

Inherited by QSqlTableModel.


Public Functions

QSqlQueryModel ( QObject * parent = 0 )
virtual ~QSqlQueryModel ()
virtual void clear ()
QSqlError lastError () const
QSqlQuery query () const
QSqlRecord record ( int row ) const
QSqlRecord record () const
void setQuery ( const QSqlQuery & query )
void setQuery ( const QString & query, const QSqlDatabase & db = QSqlDatabase() )

Reimplemented Public Functions

virtual bool canFetchMore ( const QModelIndex & parent = QModelIndex() ) const
virtual int columnCount ( const QModelIndex & index = QModelIndex() ) const
virtual QVariant data ( const QModelIndex & item, int role = Qt::DisplayRole ) const
virtual void fetchMore ( const QModelIndex & parent = QModelIndex() )
virtual QVariant headerData ( int section, Qt::Orientation orientation, int role = Qt::DisplayRole ) const
virtual bool insertColumns ( int column, int count, const QModelIndex & parent = QModelIndex() )
virtual bool removeColumns ( int column, int count, const QModelIndex & parent = QModelIndex() )
virtual int rowCount ( const QModelIndex & parent = QModelIndex() ) const
virtual bool setHeaderData ( int section, Qt::Orientation orientation, const QVariant & value, int role = Qt::EditRole )

Protected Functions

QModelIndex indexInQuery ( const QModelIndex & item ) const
virtual void queryChange ()
void setLastError ( const QSqlError & error )

Additional Inherited Members


Detailed Description

The QSqlQueryModel class provides a read-only data model for SQL result sets.

QSqlQueryModel is a high-level interface for executing SQL statements and traversing the result set. It is built on top of the lower-level QSqlQuery and can be used to provide data to view classes such as QTableView. For example:

     QSqlQueryModel *model = new QSqlQueryModel;
     model->setQuery("SELECT name, salary FROM employee");
     model->setHeaderData(0, Qt::Horizontal, tr("Name"));
     model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

     QTableView *view = new QTableView;
     view->setModel(model);
     view->show();

We set the model's query, then we set up the labels displayed in the view header.

QSqlQueryModel can also be used to access a database programmatically, without binding it to a view:

     QSqlQueryModel model;
     model.setQuery("SELECT * FROM employee");
     int salary = model.record(4).value("salary").toInt();

The code snippet above extracts the salary field from record 4 in the result set of the query SELECT * from employee. Assuming that salary is column 2, we can rewrite the last line as follows:

     int salary = model.data(model.index(4, 2)).toInt();

The model is read-only by default. To make it read-write, you must subclass it and reimplement setData() and flags(). Another option is to use QSqlTableModel, which provides a read-write model based on a single database table.

The sql/querymodel example illustrates how to use QSqlQueryModel to display the result of a query. It also shows how to subclass QSqlQueryModel to customize the contents of the data before showing it to the user, and how to create a read-write model based on QSqlQueryModel.

If the database doesn't return the amount of selected rows in a query, the model will fetch rows incrementally. See fetchMore() for more information.

See also QSqlTableModel, QSqlRelationalTableModel, QSqlQuery, Model/View Programming, and Query Model Example.


Member Function Documentation

QSqlQueryModel::QSqlQueryModel ( QObject * parent = 0 )

Creates an empty QSqlQueryModel with the given parent.

QSqlQueryModel::~QSqlQueryModel ()   [virtual]

Destroys the object and frees any allocated resources.

See also clear().

bool QSqlQueryModel::canFetchMore ( const QModelIndex & parent = QModelIndex() ) const   [virtual]

Reimplemented from QAbstractItemModel::canFetchMore().

Returns true if it is possible to read more rows from the database. This only affects databases that don't report back the size of a query (see QSqlDriver::hasFeature()).

parent should always be an invalid QModelIndex.

This function was introduced in Qt 4.1.

See also fetchMore().

void QSqlQueryModel::clear ()   [virtual]

Clears the model and releases any acquired resource.

int QSqlQueryModel::columnCount ( const QModelIndex & index = QModelIndex() ) const   [virtual]

Reimplemented from QAbstractItemModel::columnCount().

QVariant QSqlQueryModel::data ( const QModelIndex & item, int role = Qt::DisplayRole ) const   [virtual]

Reimplemented from QAbstractItemModel::data().

Returns the value for the specified item and role.

If item is out of bounds or if an error occurred, an invalid QVariant is returned.

See also lastError().

void QSqlQueryModel::fetchMore ( const QModelIndex & parent = QModelIndex() )   [virtual]

Reimplemented from QAbstractItemModel::fetchMore().

Fetches more rows from a database. This only affects databases that don't report back the size of a query (see QSqlDriver::hasFeature()).

To force fetching of the entire database, you can use the following:

 while (myModel->canFetchMore())
     myModel->fetchMore();

parent should always be an invalid QModelIndex.

This function was introduced in Qt 4.1.

See also canFetchMore().

QVariant QSqlQueryModel::headerData ( int section, Qt::Orientation orientation, int role = Qt::DisplayRole ) const   [virtual]

Reimplemented from QAbstractItemModel::headerData().

Returns the header data for the given role in the section of the header with the specified orientation.

See also setHeaderData().

QModelIndex QSqlQueryModel::indexInQuery ( const QModelIndex & item ) const   [protected]

Returns the index of the value in the database result set for the given item in the model.

The return value is identical to item if no columns or rows have been inserted, removed, or moved around.

Returns an invalid model index if item is out of bounds or if item does not point to a value in the result set.

See also QSqlTableModel::indexInQuery(), insertColumns(), and removeColumns().

bool QSqlQueryModel::insertColumns ( int column, int count, const QModelIndex & parent = QModelIndex() )   [virtual]

Reimplemented from QAbstractItemModel::insertColumns().

Inserts count columns into the model at position column. The parent parameter must always be an invalid QModelIndex, since the model does not support parent-child relationships.

Returns true if column is within bounds; otherwise returns false.

By default, inserted columns are empty. To fill them with data, reimplement data() and handle any inserted column separately:

 QVariant MyModel::data(const QModelIndex &item, int role) const
 {
     if (item.column() == m_specialColumnNo) {
         // handle column separately
     }
     return QSqlQueryModel::data(item, role);
 }

See also removeColumns().

QSqlError QSqlQueryModel::lastError () const

Returns information about the last error that occurred on the database.

See also setLastError() and query().

QSqlQuery QSqlQueryModel::query () const

Returns the QSqlQuery associated with this model.

See also setQuery().

void QSqlQueryModel::queryChange ()   [virtual protected]

This virtual function is called whenever the query changes. The default implementation does nothing.

query() returns the new query.

See also query() and setQuery().

QSqlRecord QSqlQueryModel::record ( int row ) const

Returns the record containing information about the fields of the current query. If row is the index of a valid row, the record will be populated with values from that row.

If the model is not initialized, an empty record will be returned.

See also QSqlRecord::isEmpty().

QSqlRecord QSqlQueryModel::record () const

This is an overloaded function.

Returns an empty record containing information about the fields of the current query.

If the model is not initialized, an empty record will be returned.

See also QSqlRecord::isEmpty().

bool QSqlQueryModel::removeColumns ( int column, int count, const QModelIndex & parent = QModelIndex() )   [virtual]

Reimplemented from QAbstractItemModel::removeColumns().

Removes count columns from the model starting from position column. The parent parameter must always be an invalid QModelIndex, since the model does not support parent-child relationships.

Removing columns effectively hides them. It does not affect the underlying QSqlQuery.

Returns true if the columns were removed; otherwise returns false.

int QSqlQueryModel::rowCount ( const QModelIndex & parent = QModelIndex() ) const   [virtual]

Reimplemented from QAbstractItemModel::rowCount().

If the database supports returning the size of a query (see QSqlDriver::hasFeature()), the amount of rows of the current query is returned. Otherwise, returns the amount of rows currently cached on the client.

parent should always be an invalid QModelIndex.

This function was introduced in Qt 4.1.

See also canFetchMore() and QSqlDriver::hasFeature().

bool QSqlQueryModel::setHeaderData ( int section, Qt::Orientation orientation, const QVariant & value, int role = Qt::EditRole )   [virtual]

Reimplemented from QAbstractItemModel::setHeaderData().

Sets the caption for a horizontal header for the specified role to value. This is useful if the model is used to display data in a view (e.g., QTableView).

Returns true if orientation is Qt::Horizontal and the section refers to a valid section; otherwise returns false.

Note that this function cannot be used to modify values in the database since the model is read-only.

See also headerData() and data().

void QSqlQueryModel::setLastError ( const QSqlError & error )   [protected]

Protected function which allows derived classes to set the value of the last error that occurred on the database to error.

See also lastError().

void QSqlQueryModel::setQuery ( const QSqlQuery & query )

Resets the model and sets the data provider to be the given query. Note that the query must be active and must not be isForwardOnly().

lastError() can be used to retrieve verbose information if there was an error setting the query.

See also query(), QSqlQuery::isActive(), QSqlQuery::setForwardOnly(), and lastError().

void QSqlQueryModel::setQuery ( const QString & query, const QSqlDatabase & db = QSqlDatabase() )

This is an overloaded function.

Executes the query query for the given database connection db. If no database is specified, the default connection is used.

lastError() can be used to retrieve verbose information if there was an error setting the query.

Example:

 QSqlQueryModel model;
 model.setQuery("select * from MyTable");
 if (model.lastError().isValid())
     qDebug() << model.lastError();

See also query(), queryChange(), and lastError().

Publicité

Best Of

Actualités les plus lues

Semaine
Mois
Année
  1. « Quelque chose ne va vraiment pas avec les développeurs "modernes" », un développeur à "l'ancienne" critique la multiplication des bibliothèques 103
  2. Pourquoi les programmeurs sont-ils moins payés que les gestionnaires de programmes ? Manquent-ils de pouvoir de négociation ? 56
  3. «Le projet de loi des droits du développeur» : quelles conditions doivent remplir les entreprises pour que le développeur puisse réussir ? 90
  4. Les développeurs détestent-ils les antivirus ? Un programmeur manifeste sa haine envers ces solutions de sécurité 31
  5. Qt Commercial : Digia organise un webinar gratuit le 27 mars sur la conception d'interfaces utilisateur et d'applications avec le framework 0
  6. Quelles nouveautés de C++11 Visual C++ doit-il rapidement intégrer ? Donnez-nous votre avis 10
  7. 2017 : un quinquennat pour une nouvelle version du C++ ? Possible, selon Herb Sutter 11
Page suivante
  1. Linus Torvalds : le "C++ est un langage horrible", en justifiant le choix du C pour le système de gestion de version Git 100
  2. Comment prendre en compte l'utilisateur dans vos applications ? Pour un développeur, « 90 % des utilisateurs sont des idiots » 231
  3. Quel est LE livre que tout développeur doit lire absolument ? Celui qui vous a le plus marqué et inspiré 96
  4. Apple cède et s'engage à payer des droits à Nokia, le conflit des brevets entre les deux firmes s'achève 158
  5. Nokia porte à nouveau plainte contre Apple pour violation de sept nouveaux brevets 158
  6. « Quelque chose ne va vraiment pas avec les développeurs "modernes" », un développeur à "l'ancienne" critique la multiplication des bibliothèques 103
  7. Quel est le code dont vous êtes le plus fier ? Pourquoi l'avez-vous écrit ? Et pourquoi vous a-t-il donné autant de satisfaction ? 83
Page suivante

Le Qt Developer Network au hasard

Logo

Comment fermer une application

Le Qt Developer Network est un réseau de développeurs Qt anglophone, où ils peuvent partager leur expérience sur le framework. Lire l'article.

Communauté

Ressources

Liens utiles

Contact

  • Vous souhaitez rejoindre la rédaction ou proposer un tutoriel, une traduction, une question... ? Postez dans le forum Contribuez ou contactez-nous par MP ou par email (voir en bas de page).

Qt dans le magazine

Cette page est une traduction d'une page de la documentation de Qt, écrite par Nokia Corporation and/or its subsidiary(-ies). Les éventuels problèmes résultant d'une mauvaise traduction ne sont pas imputables à Nokia. Qt 4.6-snapshot
Copyright © 2012 Developpez LLC. Tous droits réservés Developpez LLC. Aucune reproduction, même partielle, ne peut être faite de ce site et de l'ensemble de son contenu : textes, documents et images sans l'autorisation expresse de Developpez LLC. Sinon, vous encourez selon la loi jusqu'à 3 ans de prison et jusqu'à 300 000 E de dommages et intérêts. Cette page est déposée à la SACD.
Vous avez déniché une erreur ? Un bug ? Une redirection cassée ? Ou tout autre problème, quel qu'il soit ? Ou bien vous désirez participer à ce projet de traduction ? N'hésitez pas à nous contacter ou par MP !
 
 
 
 
Partenaires

Hébergement Web