Редакция 38 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 38 | Редакция 39 | ||
---|---|---|---|
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 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"); |
32 | 32 | ||
33 | signals:
|
33 | signals:
|
34 | 34 | ||
35 | public slots: |
35 | public slots: |
36 | 36 | ||
37 | private: |
37 | private: |
38 | QString fieldName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëÿ |
38 | QString fieldName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëÿ |
39 | QString fieldType; // ïåðåìåííàÿ óêàçûâàåò íà òèï äàííûõ, õðàíèìûõ â ïîëå |
39 | QString fieldType; // ïåðåìåííàÿ óêàçûâàåò íà òèï äàííûõ, õðàíèìûõ â ïîëå |
40 | QString defaultValue; // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
40 | QString defaultValue; // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
41 | QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå |
41 | QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå |
42 | bool notNull; // ôëàã, óêàçûâàþùèé, ÷òî õðàíèìîå â ïîëå çíà÷åíèå íå ìîæåò áûòü ïóñòûì (NULL) |
42 | bool notNull; // ôëàã, óêàçûâàþùèé, ÷òî õðàíèìîå â ïîëå çíà÷åíèå íå ìîæåò áûòü ïóñòûì (NULL) |
- | 43 | bool autoIncrement; // ôëàã, óêàçûâàþùèé, ÷òî ïîëå ÿâëÿåòñÿ àâòîèíêåìåíòíûì |
|
43 | QString SqlString; // ñêòîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ ïîëÿ â áàçå äàííûõ |
44 | QString SqlString; // ñêòîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ ïîëÿ â áàçå äàííûõ |
44 | void createSqlString(); // ôóíêöèÿ ãåíåðèðóåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
45 | void createSqlString(); // ôóíêöèÿ ãåíåðèðóåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
45 | protected: |
46 | protected: |
46 | 47 | ||
47 | public: |
48 | public: |
48 | void setName(QString name); |
49 | void setName(QString name); |
49 | void setType(QString ftype); |
50 | void setType(QString ftype); |
- | 51 | void setAutoIncrement(bool autoInc); // óñòàíàâëèâàåì ôëàã, óêàçûâàþùèé, ÷òî ïîëå ÿâëÿåòñÿ àâòîèíêåìåíòíûì |
|
- | 52 | bool isAutoIncrement(); // óñòàíàâëèâàåì ôëàã, óêàçûâàþùèé, ÿâëÿåòñÿ ëè ïîëå àâòîèíêåìåíòíûì |
|
- | 53 | ||
50 | QString name(); |
54 | QString name(); |
51 | QString type(); |
55 | QString type(); |
52 | bool isNotNull(); |
56 | bool isNotNull(); |
53 | void setNotNull(bool fnotNull); |
57 | void setNotNull(bool fnotNull); |
54 | void setDefaultValue(QString fdefaultValue); |
58 | void setDefaultValue(QString fdefaultValue); |
55 | 59 | ||
56 | QString sqlString(); // ôóíêöèÿ âîçâðàùàåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
60 | QString sqlString(); // ôóíêöèÿ âîçâðàùàåò ñòðîêó Sql-çàïðîñà, êîòîðàÿ ñîçäàåò â áàçå äàííûõ ñîîòâåòñòâóþùåå ïîëå |
57 | }; |
61 | }; |
58 | 62 | ||
59 | #endif // TABLEFIELD_H
|
63 | #endif // TABLEFIELD_H
|
60 | 64 |