|  | Home · All Classes · Main Classes · Grouped Classes · Modules · Functions |

# tablemodel.cpp Example File
sql/tablemodel/tablemodel.cpp

        /****************************************************************************
        **
        ** Copyright (C) 2004-2006 Trolltech AS. All rights reserved.
        **
        ** This file is part of the documentation of the Qt Toolkit.
        **
        ** This file may be used under the terms of the GNU General Public
        ** License version 2.0 as published by the Free Software Foundation
        ** and appearing in the file LICENSE.GPL included in the packaging of
        ** this file.  Please review the following information to ensure GNU
        ** General Public Licensing requirements will be met:
        ** http://www.trolltech.com/products/qt/opensource.html
        **
        ** If you are unsure which license is appropriate for your use, please
        ** review the following information:
        ** http://www.trolltech.com/products/qt/licensing.html or contact the
        ** sales department at sales@trolltech.com.
        **
        ** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
        ** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
        **
        ****************************************************************************/

        #include <QtGui>
        #include <QtSql>

        #include "../connection.h"

        void initializeModel(QSqlTableModel *model)
        {
            model->setTable("person");
            model->setEditStrategy(QSqlTableModel::OnManualSubmit);
            model->select();

            model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
            model->setHeaderData(1, Qt::Horizontal, QObject::tr("First name"));
            model->setHeaderData(2, Qt::Horizontal, QObject::tr("Last name"));
        }

        QTableView *createView(const QString &title, QSqlTableModel *model)
        {
            QTableView *view = new QTableView;
            view->setModel(model);
            view->setWindowTitle(title);
            return view;
        }

        int main(int argc, char *argv[])
        {
            QApplication app(argc, argv);
            if (!createConnection())
                return 1;

            QSqlTableModel model;

            initializeModel(&model);

            QTableView *view1 = createView(QObject::tr("Table Model (View 1)"), &model);
            QTableView *view2 = createView(QObject::tr("Table Model (View 2)"), &model);

            view1->show();
            view2->move(view1->x() + view1->width() + 20, view1->y());
            view2->show();

            return app.exec();
        }