summaryrefslogtreecommitdiffstats
path: root/examples/sql/overview/form2
diff options
context:
space:
mode:
Diffstat (limited to 'examples/sql/overview/form2')
-rw-r--r--examples/sql/overview/form2/form2.pro8
-rw-r--r--examples/sql/overview/form2/main.cpp77
-rw-r--r--examples/sql/overview/form2/main.h33
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;
+};