C++/Qt/QTableView

Материал из C\C++ эксперт
Перейти к: навигация, поиск

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.
*
*/
  1. include <QApplication>
  2. include <QTableView>
  3. 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.
*
*/
  1. include <QApplication>
  2. include <QTableView>
  3. 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.
*
*/
  1. 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.
*
*/
  1. ifndef MULMODEL_H
  2. define MULMODEL_H
  3. 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;

};

  1. 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.
*
*/
  1. include <QApplication>
  2. include <QTableView>
  3. 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">

  1. 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">

  1. 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>
Источник — «http://cppe.ru/index.php?title=C%2B%2B/Qt/QTableView&oldid=1011»