/**************************************************************************** ** ** Copyright (C) 1992-2007 Trolltech ASA. All rights reserved. ** ** This file is part of Qt Jambi. ** ** ** 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. ** ****************************************************************************/ package com.trolltech.examples; import com.trolltech.qt.core.Qt; import com.trolltech.qt.gui.*; import com.trolltech.qt.sql.QSqlDatabase; import com.trolltech.qt.sql.QSqlTableModel; @QtJambiExample(name = "Cached Table", canInstantiate = "call-static-method:checkSqlLite") public class CachedTable extends QDialog { private QPushButton submitButton = null; private QPushButton revertButton = null; private QPushButton quitButton = null; private QSqlTableModel model = null; public static void main(String[] args) { QApplication.initialize(args); if (!checkSqlLite()) { System.out.println("Missing support for SQL"); return; } CachedTable table = new CachedTable(null); table.show(); table.exec(); } public CachedTable(QWidget parent) { super(parent); if (!SqlCommon.createConnection()) throw new RuntimeException("Couldn't connect to SQLITE server"); String tableName = "person"; model = new QSqlTableModel(this); model.setTable(tableName); model.setEditStrategy(QSqlTableModel.EditStrategy.OnManualSubmit); model.select(); model.setHeaderData(0, Qt.Orientation.Horizontal, tr("ID")); model.setHeaderData(1, Qt.Orientation.Horizontal, tr("First name")); model.setHeaderData(2, Qt.Orientation.Horizontal, tr("Last name")); QTableView view = new QTableView(); view.setModel(model); setWindowIcon(new QIcon("classpath:com/trolltech/images/qt-logo.png")); submitButton = new QPushButton(tr("Submit")); submitButton.setDefault(true); revertButton = new QPushButton(tr("&Revert")); quitButton = new QPushButton(tr("Quit")); submitButton.clicked.connect(this, "submit()"); revertButton.clicked.connect(model, "revertAll()"); quitButton.clicked.connect(this, "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")); } protected void 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: ") + model.lastError().text()); } } public static boolean checkSqlLite() { return QSqlDatabase.isDriverAvailable("QSQLITE"); } }