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

# tableeditor.cpp Example File
sql/cachedtable/tableeditor.cpp

        /****************************************************************************
        **
        ** Copyright (C) 2004-2006 Trolltech ASA. 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 "tableeditor.h"

        TableEditor::TableEditor(const QString &tableName, QWidget *parent)
            : QDialog(parent)
        {
            model = new QSqlTableModel(this);
            model->setTable(tableName);
            model->setEditStrategy(QSqlTableModel::OnManualSubmit);
            model->select();

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

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

            submitButton = new QPushButton(tr("Submit"));
            submitButton->setDefault(true);
            revertButton = new QPushButton(tr("&Revert"));
            quitButton = new QPushButton(tr("Quit"));

            connect(submitButton, SIGNAL(clicked()), this, SLOT(submit()));
            connect(revertButton, SIGNAL(clicked()), model, SLOT(revertAll()));
            connect(quitButton, SIGNAL(clicked()), this, SLOT(close()));

            QVBoxLayout *buttonLayout = new QVBoxLayout;
            buttonLayout->addWidget(submitButton);
            buttonLayout->addWidget(revertButton);
            buttonLayout->addWidget(quitButton);
            buttonLayout->addStretch(1);

            QHBoxLayout *mainLayout = new QHBoxLayout;
            mainLayout->addWidget(view);
            mainLayout->addLayout(buttonLayout);
            setLayout(mainLayout);

            setWindowTitle(tr("Cached Table"));
        }

        void TableEditor::submit()
        {
            model->database().transaction();
            if (model->submitAll()) {
                model->database().commit();
            } else {
                model->database().rollback();
                QMessageBox::warning(this, tr("Cached Table"),
                                     tr("The database reported an error: %1")
                                     .arg(model->lastError().text()));
            }
        }