diff options
Diffstat (limited to 'examples/sql/overview/form2')
-rw-r--r-- | examples/sql/overview/form2/form2.pro | 8 | ||||
-rw-r--r-- | examples/sql/overview/form2/main.cpp | 77 | ||||
-rw-r--r-- | examples/sql/overview/form2/main.h | 33 |
3 files changed, 118 insertions, 0 deletions
diff --git a/examples/sql/overview/form2/form2.pro b/examples/sql/overview/form2/form2.pro new file mode 100644 index 0000000..c490bed --- /dev/null +++ b/examples/sql/overview/form2/form2.pro @@ -0,0 +1,8 @@ +TEMPLATE = app + +CONFIG += qt warn_on release + +REQUIRES = full-config + +HEADERS = main.h +SOURCES = main.cpp ../connection.cpp diff --git a/examples/sql/overview/form2/main.cpp b/examples/sql/overview/form2/main.cpp new file mode 100644 index 0000000..80bce49 --- /dev/null +++ b/examples/sql/overview/form2/main.cpp @@ -0,0 +1,77 @@ +/**************************************************************************** +** +** Copyright (C) 1992-2008 Trolltech ASA. All rights reserved. +** +** This file is part of an example program for Qt. This example +** program may be used, distributed and modified without limitation. +** +*****************************************************************************/ + +#include "main.h" + +FormDialog::FormDialog() + : staffCursor( "staff" ) +{ + staffCursor.setTrimmed( "forename", TRUE ); + staffCursor.setTrimmed( "surname", TRUE ); + + QLabel *forenameLabel = new QLabel( "Forename:", this ); + QLineEdit *forenameEdit = new QLineEdit( this ); + QLabel *surnameLabel = new QLabel( "Surname:", this ); + QLineEdit *surnameEdit = new QLineEdit( this ); + QLabel *salaryLabel = new QLabel( "Salary:", this ); + QLineEdit *salaryEdit = new QLineEdit( this ); + QPushButton *saveButton = new QPushButton( "&Save", this ); + connect( saveButton, SIGNAL(clicked()), this, SLOT(save()) ); + + QGridLayout *grid = new QGridLayout( this ); + grid->addWidget( forenameLabel, 0, 0 ); + grid->addWidget( forenameEdit, 0, 1 ); + grid->addWidget( surnameLabel, 1, 0 ); + grid->addWidget( surnameEdit, 1, 1 ); + grid->addWidget( salaryLabel, 2, 0 ); + grid->addWidget( salaryEdit, 2, 1 ); + grid->addWidget( saveButton, 3, 0 ); + grid->activate(); + + idIndex = staffCursor.index( "id" ); + staffCursor.select( idIndex ); + staffCursor.first(); + + sqlForm = new QSqlForm( this ); + sqlForm->setRecord( staffCursor.primeUpdate() ); + sqlForm->insert( forenameEdit, "forename" ); + sqlForm->insert( surnameEdit, "surname" ); + sqlForm->insert( salaryEdit, "salary" ); + sqlForm->readFields(); +} + + +FormDialog::~FormDialog() +{ + +} + + +void FormDialog::save() +{ + sqlForm->writeFields(); + staffCursor.update(); + staffCursor.select( idIndex ); + staffCursor.first(); +} + + +int main( int argc, char *argv[] ) +{ + QApplication app( argc, argv ); + + if ( ! createConnections() ) + return 1; + + FormDialog *formDialog = new FormDialog(); + formDialog->show(); + app.setMainWidget( formDialog ); + + return app.exec(); +} diff --git a/examples/sql/overview/form2/main.h b/examples/sql/overview/form2/main.h new file mode 100644 index 0000000..c19a354 --- /dev/null +++ b/examples/sql/overview/form2/main.h @@ -0,0 +1,33 @@ +/**************************************************************************** +** +** Copyright (C) 1992-2008 Trolltech ASA. All rights reserved. +** +** This file is part of an example program for Qt. This example +** program may be used, distributed and modified without limitation. +** +*****************************************************************************/ + +#include <qapplication.h> +#include <qdialog.h> +#include <qlabel.h> +#include <qlayout.h> +#include <qlineedit.h> +#include <qpushbutton.h> +#include <qsqldatabase.h> +#include <qsqlcursor.h> +#include <qsqlform.h> +#include "../connection.h" + +class FormDialog : public QDialog +{ + Q_OBJECT + public: + FormDialog(); + ~FormDialog(); + public slots: + void save(); + private: + QSqlCursor staffCursor; + QSqlForm *sqlForm; + QSqlIndex idIndex; +}; |