C++/Qt/QTableView

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

Load data to QTableView

  
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();
}


QVariant model for QTableView

  

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


Set header for QTableView

  
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();
}


Set model for QTableView

  

#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();
}


Set model for QTreeView

  

#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();
}