1 | /****************************************************************************
|
---|
2 | **
|
---|
3 | ** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies).
|
---|
4 | ** Contact: Qt Software Information ([email protected])
|
---|
5 | **
|
---|
6 | ** This file is part of the Qt3Support module of the Qt Toolkit.
|
---|
7 | **
|
---|
8 | ** $QT_BEGIN_LICENSE:LGPL$
|
---|
9 | ** Commercial Usage
|
---|
10 | ** Licensees holding valid Qt Commercial licenses may use this file in
|
---|
11 | ** accordance with the Qt Commercial License Agreement provided with the
|
---|
12 | ** Software or, alternatively, in accordance with the terms contained in
|
---|
13 | ** a written agreement between you and Nokia.
|
---|
14 | **
|
---|
15 | ** GNU Lesser General Public License Usage
|
---|
16 | ** Alternatively, this file may be used under the terms of the GNU Lesser
|
---|
17 | ** General Public License version 2.1 as published by the Free Software
|
---|
18 | ** Foundation and appearing in the file LICENSE.LGPL included in the
|
---|
19 | ** packaging of this file. Please review the following information to
|
---|
20 | ** ensure the GNU Lesser General Public License version 2.1 requirements
|
---|
21 | ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
|
---|
22 | **
|
---|
23 | ** In addition, as a special exception, Nokia gives you certain
|
---|
24 | ** additional rights. These rights are described in the Nokia Qt LGPL
|
---|
25 | ** Exception version 1.0, included in the file LGPL_EXCEPTION.txt in this
|
---|
26 | ** package.
|
---|
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 | **
|
---|
36 | ** If you are unsure which license is appropriate for your use, please
|
---|
37 | ** contact the sales department at [email protected].
|
---|
38 | ** $QT_END_LICENSE$
|
---|
39 | **
|
---|
40 | ****************************************************************************/
|
---|
41 |
|
---|
42 | #include "q3sqlform.h"
|
---|
43 |
|
---|
44 | #ifndef QT_NO_SQL_FORM
|
---|
45 |
|
---|
46 | #include "qsqlfield.h"
|
---|
47 | #include "q3sqlpropertymap.h"
|
---|
48 | #include "qsqlrecord.h"
|
---|
49 | #include "qstringlist.h"
|
---|
50 | #include "qwidget.h"
|
---|
51 | #include "qhash.h"
|
---|
52 |
|
---|
53 | QT_BEGIN_NAMESPACE
|
---|
54 |
|
---|
55 | class Q3SqlFormPrivate
|
---|
56 | {
|
---|
57 | public:
|
---|
58 | Q3SqlFormPrivate() : propertyMap(0), buf(0), dirty(false) {}
|
---|
59 | ~Q3SqlFormPrivate() { if (propertyMap) delete propertyMap; }
|
---|
60 | QStringList fld;
|
---|
61 | QHash <QString, QWidget*> wgt;
|
---|
62 | QMap <QWidget*, QSqlField *> map;
|
---|
63 | Q3SqlPropertyMap * propertyMap;
|
---|
64 | QSqlRecord* buf;
|
---|
65 | bool dirty;
|
---|
66 | };
|
---|
67 |
|
---|
68 | /*!
|
---|
69 | \class Q3SqlForm
|
---|
70 | \brief The Q3SqlForm class creates and manages data entry forms
|
---|
71 | tied to SQL databases.
|
---|
72 |
|
---|
73 | \compat
|
---|
74 |
|
---|
75 | Typical use of a Q3SqlForm consists of the following steps:
|
---|
76 | \list
|
---|
77 | \i Create the widgets you want to appear in the form.
|
---|
78 | \i Create a cursor and navigate to the record to be edited.
|
---|
79 | \i Create the Q3SqlForm.
|
---|
80 | \i Set the form's record buffer to the cursor's update buffer.
|
---|
81 | \i Insert each widget and the field it is to edit into the form.
|
---|
82 | \i Use readFields() to update the editor widgets with values from
|
---|
83 | the database's fields.
|
---|
84 | \i Display the form and let the user edit values etc.
|
---|
85 | \i Use writeFields() to update the database's field values with
|
---|
86 | the values in the editor widgets.
|
---|
87 | \endlist
|
---|
88 |
|
---|
89 | Note that a Q3SqlForm does not access the database directly, but
|
---|
90 | most often via QSqlFields which are part of a Q3SqlCursor. A
|
---|
91 | Q3SqlCursor::insert(), Q3SqlCursor::update() or Q3SqlCursor::del()
|
---|
92 | call is needed to actually write values to the database.
|
---|
93 |
|
---|
94 | Some sample code to initialize a form successfully:
|
---|
95 |
|
---|
96 | \snippet doc/src/snippets/code/src_qt3support_sql_q3sqlform.cpp 0
|
---|
|
---|