Qt Reference Documentation

# tableeditor.cpp Example File

sql/cachedtable/tableeditor.cpp

     /****************************************************************************
     **
     ** Copyright (C) 2011 Nokia Corporation and/or its subsidiary(-ies).
     ** All rights reserved.
     ** Contact: Nokia Corporation (qt-info@nokia.com)
     **
     ** This file is part of the examples of the Qt Toolkit.
     **
     ** $QT_BEGIN_LICENSE:BSD$
     ** You may use this file under the terms of the BSD license as follows:
     **
     ** "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 Nokia Corporation and its Subsidiary(-ies) 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."
     ** $QT_END_LICENSE$
     **
     ****************************************************************************/

     #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"));

         buttonBox = new QDialogButtonBox(Qt::Vertical);
         buttonBox->addButton(submitButton, QDialogButtonBox::ActionRole);
         buttonBox->addButton(revertButton, QDialogButtonBox::ActionRole);
         buttonBox->addButton(quitButton, QDialogButtonBox::RejectRole);

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

         QHBoxLayout *mainLayout = new QHBoxLayout;
         mainLayout->addWidget(view);
         mainLayout->addWidget(buttonBox);
         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()));
         }
     }