Редакция 37 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 37 | Редакция 38 | ||
|---|---|---|---|
| 1 | #ifndef TABLEFIELD_H
|
1 | #ifndef TABLEFIELD_H
|
| 2 | #define TABLEFIELD_H
|
2 | #define TABLEFIELD_H
|
| 3 | 3 | ||
| 4 | #include <QObject>
|
4 | #include <QObject>
|
| 5 | #include <QtGui>
|
5 | #include <QtGui>
|
| 6 | #include <QMainWindow>
|
6 | #include <QMainWindow>
|
| 7 | #include <QString>
|
7 | #include <QString>
|
| 8 | #include <QtSql>
|
8 | #include <QtSql>
|
| 9 | #include <QSqlTableModel>
|
9 | #include <QSqlTableModel>
|
| 10 | #include <QTableView>
|
10 | #include <QTableView>
|
| 11 | #include <QSqlDriverPlugin>
|
11 | #include <QSqlDriverPlugin>
|
| 12 | #include <QIcon>
|
12 | #include <QIcon>
|
| 13 | #include <QVariant>
|
13 | #include <QVariant>
|
| 14 | #include <QProcess>
|
14 | #include <QProcess>
|
| 15 | #include <QByteArray>
|
15 | #include <QByteArray>
|
| 16 | 16 | ||
| 17 | class TableField : public QObject |
17 | class TableField : public QObject |
| 18 | {
|
18 | {
|
| 19 | Q_OBJECT |
19 | Q_OBJECT |
| 20 | public: |
20 | public: |
| 21 | 21 | ||
| 22 | /***********************************************************************************************
|
22 | /***********************************************************************************************
|
| 23 | ** Êîíñòðóêòîð êëàññà TableField èìååò îäèí îáÿçàòåëüíûé ïàðàìåòð - èìÿ ïîëÿ
|
23 | ** Êîíñòðóêòîð êëàññà TableField èìååò îäèí îáÿçàòåëüíûé ïàðàìåòð - èìÿ ïîëÿ
|
| 24 | ** îñòàëüíûå ïàðàìåòðû èìåþò çíà÷åíèÿ ïî óìîë÷àíèþ:
|
24 | ** îñòàëüíûå ïàðàìåòðû èìåþò çíà÷åíèÿ ïî óìîë÷àíèþ:
|
| 25 | ** *parent = 0 (íåò "ðîäèòåëüñêîãî" îáúåêòà)
|
25 | ** *parent = 0 (íåò "ðîäèòåëüñêîãî" îáúåêòà)
|
| 26 | ** ftype = CHAR(30) (òèï õðàíèìûõ â ïîëå äàííûõ - ñòðîêà èç 30 ñèìâîëîâ)
|
26 | ** ftype = CHAR(30) (òèï õðàíèìûõ â ïîëå äàííûõ - ñòðîêà èç 30 ñèìâîëîâ)
|
| 27 | ** fdefaultValue = NULL (äàííûå â ïîëå ìîãóò èìåòü "ïóñòîå" çíà÷åíèå)
|
27 | ** fdefaultValue = NULL (äàííûå â ïîëå ìîãóò èìåòü "ïóñòîå" çíà÷åíèå)
|
| 28 | ***********************************************************************************************/
|
28 | ***********************************************************************************************/
|
| 29 | 29 | ||
| 30 | 30 | ||
| 31 | /////explicit
|
- | |
| 32 | TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL"); |
31 | explicit TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL"); |
| 33 | 32 | ||
| 34 | signals:
|
33 | signals:
|
| 35 | 34 | ||
| 36 | public slots: |
35 | public slots: |
| 37 | 36 | ||
| 38 | private: |
37 | private: |
| 39 | QString fieldName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëÿ |
38 | QString fieldName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëÿ |
| 40 | QString fieldType; // ïåðåìåííàÿ óêàçûâàåò íà òèï äàííûõ, õðàíèìûõ â ïîëå |
39 | QString fieldType; // ïåðåìåííàÿ óêàçûâàåò íà òèï äàííûõ, õðàíèìûõ â ïîëå |
| 41 | QString defaultValue; // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
40 | QString defaultValue; // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
| 42 | QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå |
41 | QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå |
| 43 | bool notNull; // ôëàã, óêàçûâàþùèé, ÷òî õðàíèìîå â ïîëå çíà÷åíèå íå ìîæåò áûòü ïóñòûì (NULL) |
42 | bool notNull; // ôëàã, óêàçûâàþùèé, ÷òî õðàíèìîå â ïîëå çíà÷åíèå íå ìîæåò áûòü ïóñòûì (NULL) |
| 44 | QString SqlString; // ñêòîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ ïîëÿ â áàçå äàííûõ |
43 | QString SqlString; // ñêòîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ ïîëÿ â áàçå äàííûõ |
| 45 | void createSqlString(); // ôóíêöèÿ ãåíåðèðóåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
44 | void createSqlString(); // ôóíêöèÿ ãåíåðèðóåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
| 46 | protected: |
45 | protected: |
| 47 | 46 | ||
| 48 | public: |
47 | public: |
| 49 | void setName(QString name); |
48 | void setName(QString name); |
| 50 | void setType(QString ftype); |
49 | void setType(QString ftype); |
| 51 | QString name(); |
50 | QString name(); |
| 52 | QString type(); |
51 | QString type(); |
| 53 | bool isNotNull(); |
52 | bool isNotNull(); |
| 54 | void setNotNull(bool fnotNull); |
53 | void setNotNull(bool fnotNull); |
| 55 | void setDefaultValue(QString fdefaultValue); |
54 | void setDefaultValue(QString fdefaultValue); |
| 56 | 55 | ||
| 57 | QString sqlString(); // ôóíêöèÿ âîçâðàùàåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
56 | QString sqlString(); // ôóíêöèÿ âîçâðàùàåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
| 58 | }; |
57 | }; |
| 59 | 58 | ||
| 60 | #endif // TABLEFIELD_H
|
59 | #endif // TABLEFIELD_H
|
| 61 | 60 | ||