C++/Qt/QTableView — различия между версиями
Admin (обсуждение | вклад) м (1 версия: Импорт контента...) |
|
(нет различий)
|
Версия 17:21, 25 мая 2010
Содержание
Load data to QTableView
<source lang="cpp"> Foundations of Qt Development\Chapter13\modelview\main.cpp /*
* Copyright (c) 2006-2007, Johan Thelin * * All rights reserved. * * Redistribution and use in source and binary forms, with or without modification, * are permitted provided that the following conditions are met: * * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of APress nor the names of its contributors * may be used to endorse or promote products derived from this software * without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */
- include <QApplication>
- include <QTableView>
- include <QtSql>
void relModel() {
QSqlRelationalTableModel *model = new QSqlRelationalTableModel(); model->setTable( "names" ); model->setRelation( 0, QSqlRelation( "salaries", "id", "annual" ) ); model->select(); model->setHeaderData( 0, Qt::Horizontal, QObject::tr("Annual Pay") ); model->setHeaderData( 1, Qt::Horizontal, QObject::tr("First Name") ); model->setHeaderData( 2, Qt::Horizontal, QObject::tr("Last Name") ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
} void tabModel() {
QSqlTableModel *model = new QSqlTableModel(); model->setTable( "names" ); model->setFilter( "lastname = "Doe"" ); model->select(); model->removeColumn( 0 ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
} void qryModel() {
QSqlQueryModel *model = new QSqlQueryModel(); model->setQuery( "SELECT firstname, lastname FROM names" ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
}
int main( int argc, char **argv ) {
QApplication app( argc, argv ); QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" ); db.setDatabaseName( ":memory:" ); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." ); } qDebug( "Connected!" ); QSqlQuery qry; qry.prepare( "CREATE TABLE IF NOT EXISTS names (id INTEGER UNIQUE PRIMARY KEY, firstname VARCHAR(30), lastname VARCHAR(30))" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (1, "John", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (2, "Jane", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (3, "James", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (4, "Judy", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (5, "Richard", "Roe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (6, "Jane", "Roe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (7, "John", "Noakes")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (8, "Donna", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (:id, :firstname, :lastname)" ); qry.bindValue( ":id", 9 ); qry.bindValue( ":firstname", "Ralph" ); qry.bindValue( ":lastname", "Roe" ); qry.exec(); qry.prepare( "CREATE TABLE IF NOT EXISTS salaries (id INTEGER UNIQUE PRIMARY KEY, annual INTEGER)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (1, 1000)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (2, 900)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (3, 900)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (5, 1100)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (6, 1000)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (8, 1200)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (9, 1200)" ); qry.exec(); relModel(); tabModel(); qryModel(); return app.exec();
}
</source>
QVariant model for QTableView
<source lang="cpp">
Foundations of Qt Development\Chapter05\mulmodel\main.cpp /*
* Copyright (c) 2006-2007, Johan Thelin * * All rights reserved. * * Redistribution and use in source and binary forms, with or without modification, * are permitted provided that the following conditions are met: * * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of APress nor the names of its contributors * may be used to endorse or promote products derived from this software * without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */
- include <QApplication>
- include <QTableView>
- include "mulmodel.h"
int main( int argc, char **argv ) {
QApplication app( argc, argv ); MulModel model( 12, 12 ); QTableView table; table.setModel( &model ); table.show(); return app.exec();
}
Foundations of Qt Development\Chapter05\mulmodel\mulmodel.cpp /*
* Copyright (c) 2006-2007, Johan Thelin * * All rights reserved. * * Redistribution and use in source and binary forms, with or without modification, * are permitted provided that the following conditions are met: * * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of APress nor the names of its contributors * may be used to endorse or promote products derived from this software * without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */
- include "mulmodel.h"
MulModel::MulModel( int rows, int columns, QObject *parent ) : QAbstractTableModel( parent ) {
m_rows = rows; m_columns = columns;
} int MulModel::rowCount( const QModelIndex &parent ) const {
return m_rows;
} int MulModel::columnCount( const QModelIndex &parent ) const {
return m_columns;
} Qt::ItemFlags MulModel::flags( const QModelIndex &index ) const {
return Qt::ItemIsSelectable | Qt::ItemIsEnabled;
} QVariant MulModel::data( const QModelIndex &index, int role ) const {
switch( role ) { case Qt::DisplayRole: return (index.row()+1) * (index.column()+1); case Qt::ToolTipRole: return QString( "%1 x %2" ).arg( index.row()+1 ).arg( index.column()+1 ); default: return QVariant(); }
} QVariant MulModel::headerData( int section, Qt::Orientation orientation, int role ) const {
if( role != Qt::DisplayRole ) return QVariant(); return QString::number( section+1 );
}
Foundations of Qt Development\Chapter05\mulmodel\mulmodel.h /*
* Copyright (c) 2006-2007, Johan Thelin * * All rights reserved. * * Redistribution and use in source and binary forms, with or without modification, * are permitted provided that the following conditions are met: * * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of APress nor the names of its contributors * may be used to endorse or promote products derived from this software * without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */
- ifndef MULMODEL_H
- define MULMODEL_H
- include <QAbstractTableModel>
class MulModel : public QAbstractTableModel { public:
MulModel( int rows, int columns, QObject *parent = 0 ); Qt::ItemFlags flags( const QModelIndex &index ) const; QVariant data( const QModelIndex &index, int role = Qt::DisplayRole ) const; QVariant headerData( int section, Qt::Orientation orientation, int role = Qt::DisplayRole ) const; int rowCount( const QModelIndex &parent = QModelIndex() ) const; int columnCount( const QModelIndex &parent = QModelIndex() ) const;
private:
int m_rows, m_columns;
};
- endif // MULMODEL_H
</source>
Set header for QTableView
<source lang="cpp"> Foundations of Qt Development\Chapter13\modelview\main.cpp /*
* Copyright (c) 2006-2007, Johan Thelin * * All rights reserved. * * Redistribution and use in source and binary forms, with or without modification, * are permitted provided that the following conditions are met: * * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright notice, * this list of conditions and the following disclaimer in the documentation * and/or other materials provided with the distribution. * * Neither the name of APress nor the names of its contributors * may be used to endorse or promote products derived from this software * without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * */
- include <QApplication>
- include <QTableView>
- include <QtSql>
void relModel() {
QSqlRelationalTableModel *model = new QSqlRelationalTableModel(); model->setTable( "names" ); model->setRelation( 0, QSqlRelation( "salaries", "id", "annual" ) ); model->select(); model->setHeaderData( 0, Qt::Horizontal, QObject::tr("Annual Pay") ); model->setHeaderData( 1, Qt::Horizontal, QObject::tr("First Name") ); model->setHeaderData( 2, Qt::Horizontal, QObject::tr("Last Name") ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
} void tabModel() {
QSqlTableModel *model = new QSqlTableModel(); model->setTable( "names" ); model->setFilter( "lastname = "Doe"" ); model->select(); model->removeColumn( 0 ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
} void qryModel() {
QSqlQueryModel *model = new QSqlQueryModel(); model->setQuery( "SELECT firstname, lastname FROM names" ); QTableView *view = new QTableView(); view->setModel( model ); view->show();
}
int main( int argc, char **argv ) {
QApplication app( argc, argv ); QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" ); db.setDatabaseName( ":memory:" ); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." ); } qDebug( "Connected!" ); QSqlQuery qry; qry.prepare( "CREATE TABLE IF NOT EXISTS names (id INTEGER UNIQUE PRIMARY KEY, firstname VARCHAR(30), lastname VARCHAR(30))" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (1, "John", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (2, "Jane", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (3, "James", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (4, "Judy", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (5, "Richard", "Roe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (6, "Jane", "Roe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (7, "John", "Noakes")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (8, "Donna", "Doe")" ); qry.exec(); qry.prepare( "INSERT INTO names (id, firstname, lastname) VALUES (:id, :firstname, :lastname)" ); qry.bindValue( ":id", 9 ); qry.bindValue( ":firstname", "Ralph" ); qry.bindValue( ":lastname", "Roe" ); qry.exec(); qry.prepare( "CREATE TABLE IF NOT EXISTS salaries (id INTEGER UNIQUE PRIMARY KEY, annual INTEGER)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (1, 1000)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (2, 900)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (3, 900)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (5, 1100)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (6, 1000)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (8, 1200)" ); qry.exec(); qry.prepare( "INSERT INTO salaries (id, annual) VALUES (9, 1200)" ); qry.exec(); relModel(); tabModel(); qryModel(); return app.exec();
}
</source>
Set model for QTableView
<source lang="cpp">
- include <QtGui>
int main(int argc, char* argv[]){
QApplication app(argc, argv); QDirModel dirModel; QWidgetw; w.setWindowTitle(QObject::tr("Four directory views using one model")); QGridLayout *lay = new QGridLayout(&w); QListView *lv =new QListView; lay->addWidget(lv, 0, 0); lv->setModel(&dirModel); QListView *lvi = new QListView; lay->addWidget(lvi, 0, 1); lvi->setViewMode(QListView::IconMode); lvi->setModel(&dirModel); QTreeView *trv =new QTreeView; lay->addWidget(trv, 1, 0); trv->setModel(&dirModel); QTableView *tav =new QTableView; tav->setModel(&dirModel); lay->addWidget(tav, 1, 1); QModelIndex cwdIndex = dirModel.index(QDir::currentPath()); lv->setRootIndex(cwdIndex); lvi->setRootIndex(cwdIndex); trv->setRootIndex(cwdIndex); tav->setRootIndex(cwdIndex); w.show(); return app.exec();
}
</source>
Set model for QTreeView
<source lang="cpp">
- include <QtGui>
int main(int argc, char* argv[]){
QApplication app(argc, argv); QDirModel dirModel; QWidgetw; w.setWindowTitle(QObject::tr("Four directory views using one model")); QGridLayout *lay = new QGridLayout(&w); QListView *lv =new QListView; lay->addWidget(lv, 0, 0); lv->setModel(&dirModel); QListView *lvi = new QListView; lay->addWidget(lvi, 0, 1); lvi->setViewMode(QListView::IconMode); lvi->setModel(&dirModel); QTreeView *trv =new QTreeView; lay->addWidget(trv, 1, 0); trv->setModel(&dirModel); QTableView *tav =new QTableView; tav->setModel(&dirModel); lay->addWidget(tav, 1, 1); QModelIndex cwdIndex = dirModel.index(QDir::currentPath()); lv->setRootIndex(cwdIndex); lvi->setRootIndex(cwdIndex); trv->setRootIndex(cwdIndex); tav->setRootIndex(cwdIndex); w.show(); return app.exec();
}
</source>