[2] | 1 | /****************************************************************************
|
---|
| 2 | **
|
---|
[651] | 3 | ** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).
|
---|
[561] | 4 | ** All rights reserved.
|
---|
| 5 | ** Contact: Nokia Corporation ([email protected])
|
---|
[2] | 6 | **
|
---|
| 7 | ** This file is part of the examples of the Qt Toolkit.
|
---|
| 8 | **
|
---|
| 9 | ** $QT_BEGIN_LICENSE:LGPL$
|
---|
| 10 | ** Commercial Usage
|
---|
| 11 | ** Licensees holding valid Qt Commercial licenses may use this file in
|
---|
| 12 | ** accordance with the Qt Commercial License Agreement provided with the
|
---|
| 13 | ** Software or, alternatively, in accordance with the terms contained in
|
---|
| 14 | ** a written agreement between you and Nokia.
|
---|
| 15 | **
|
---|
| 16 | ** GNU Lesser General Public License Usage
|
---|
| 17 | ** Alternatively, this file may be used under the terms of the GNU Lesser
|
---|
| 18 | ** General Public License version 2.1 as published by the Free Software
|
---|
| 19 | ** Foundation and appearing in the file LICENSE.LGPL included in the
|
---|
| 20 | ** packaging of this file. Please review the following information to
|
---|
| 21 | ** ensure the GNU Lesser General Public License version 2.1 requirements
|
---|
| 22 | ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
|
---|
| 23 | **
|
---|
[561] | 24 | ** In addition, as a special exception, Nokia gives you certain additional
|
---|
| 25 | ** rights. These rights are described in the Nokia Qt LGPL Exception
|
---|
| 26 | ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
|
---|
[2] | 27 | **
|
---|
| 28 | ** GNU General Public License Usage
|
---|
| 29 | ** Alternatively, this file may be used under the terms of the GNU
|
---|
| 30 | ** General Public License version 3.0 as published by the Free Software
|
---|
| 31 | ** Foundation and appearing in the file LICENSE.GPL included in the
|
---|
| 32 | ** packaging of this file. Please review the following information to
|
---|
| 33 | ** ensure the GNU General Public License version 3.0 requirements will be
|
---|
| 34 | ** met: http://www.gnu.org/copyleft/gpl.html.
|
---|
| 35 | **
|
---|
[561] | 36 | ** If you have questions regarding the use of this file, please contact
|
---|
| 37 | ** Nokia at [email protected].
|
---|
[2] | 38 | ** $QT_END_LICENSE$
|
---|
| 39 | **
|
---|
| 40 | ****************************************************************************/
|
---|
| 41 |
|
---|
| 42 | #include <QtGui>
|
---|
| 43 | #include <QtSql>
|
---|
| 44 |
|
---|
| 45 | #include "tableeditor.h"
|
---|
| 46 |
|
---|
| 47 | //! [0]
|
---|
| 48 | TableEditor::TableEditor(const QString &tableName, QWidget *parent)
|
---|
| 49 | : QDialog(parent)
|
---|
| 50 | {
|
---|
| 51 | model = new QSqlTableModel(this);
|
---|
| 52 | model->setTable(tableName);
|
---|
| 53 | model->setEditStrategy(QSqlTableModel::OnManualSubmit);
|
---|
| 54 | model->select();
|
---|
| 55 |
|
---|
| 56 | model->setHeaderData(0, Qt::Horizontal, tr("ID"));
|
---|
| 57 | model->setHeaderData(1, Qt::Horizontal, tr("First name"));
|
---|
| 58 | model->setHeaderData(2, Qt::Horizontal, tr("Last name"));
|
---|
| 59 |
|
---|
| 60 | //! [0] //! [1]
|
---|
| 61 | QTableView *view = new QTableView;
|
---|
| 62 | view->setModel(model);
|
---|
| 63 | //! [1]
|
---|
| 64 |
|
---|
| 65 | //! [2]
|
---|
| 66 | submitButton = new QPushButton(tr("Submit"));
|
---|
| 67 | submitButton->setDefault(true);
|
---|
| 68 | revertButton = new QPushButton(tr("&Revert"));
|
---|
| 69 | quitButton = new QPushButton(tr("Quit"));
|
---|
| 70 |
|
---|
| 71 | buttonBox = new QDialogButtonBox(Qt::Vertical);
|
---|
| 72 | buttonBox->addButton(submitButton, QDialogButtonBox::ActionRole);
|
---|
| 73 | buttonBox->addButton(revertButton, QDialogButtonBox::ActionRole);
|
---|
| 74 | buttonBox->addButton(quitButton, QDialogButtonBox::RejectRole);
|
---|
| 75 | //! [2]
|
---|
| 76 |
|
---|
| 77 | //! [3]
|
---|
| 78 | connect(submitButton, SIGNAL(clicked()), this, SLOT(submit()));
|
---|
| 79 | connect(revertButton, SIGNAL(clicked()), model, SLOT(revertAll()));
|
---|
| 80 | connect(quitButton, SIGNAL(clicked()), this, SLOT(close()));
|
---|
| 81 | //! [3]
|
---|
| 82 |
|
---|
| 83 | //! [4]
|
---|
| 84 | QHBoxLayout *mainLayout = new QHBoxLayout;
|
---|
| 85 | mainLayout->addWidget(view);
|
---|
| 86 | mainLayout->addWidget(buttonBox);
|
---|
| 87 | setLayout(mainLayout);
|
---|
| 88 |
|
---|
| 89 | setWindowTitle(tr("Cached Table"));
|
---|
| 90 | }
|
---|
| 91 | //! [4]
|
---|
| 92 |
|
---|
| 93 | //! [5]
|
---|
| 94 | void TableEditor::submit()
|
---|
| 95 | {
|
---|
| 96 | model->database().transaction();
|
---|
| 97 | if (model->submitAll()) {
|
---|
| 98 | model->database().commit();
|
---|
| 99 | } else {
|
---|
| 100 | model->database().rollback();
|
---|
| 101 | QMessageBox::warning(this, tr("Cached Table"),
|
---|
| 102 | tr("The database reported an error: %1")
|
---|
| 103 | .arg(model->lastError().text()));
|
---|
| 104 | }
|
---|
| 105 | }
|
---|
| 106 | //! [5]
|
---|