Редакция 45 | Редакция 73 | К новейшей редакции | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 45 | Редакция 56 | ||
---|---|---|---|
1 | /************************************************************************************
|
1 | /************************************************************************************
|
2 | ** Êëàññ MySQL ñîäåðæèò ìåòîäû äëÿ ðàáîòû ñ áàçàìè äàííûõ
|
2 | ** Êëàññ MySQL ñîäåðæèò ìåòîäû äëÿ ðàáîòû ñ áàçàìè äàííûõ
|
3 | ** MySQL class contains methods for working with databases
|
3 | ** MySQL class contains methods for working with databases
|
4 | **
|
4 | **
|
5 | **
|
5 | **
|
6 | *************************************************************************************/
|
6 | *************************************************************************************/
|
7 | 7 | ||
8 | 8 | ||
9 | 9 | ||
10 | 10 | ||
11 | 11 | ||
12 | 12 | ||
13 | #ifndef MYSQL_H
|
13 | #ifndef MYSQL_H
|
14 | #define MYSQL_H
|
14 | #define MYSQL_H
|
15 | 15 | ||
16 | #include "settingsdialog.h"
|
16 | #include "settingsdialog.h"
|
17 | #include "tablefield.h"
|
17 | #include "tablefield.h"
|
18 | #include "sqltable.h"
|
18 | #include "sqltable.h"
|
19 | 19 | ||
20 | #include <QObject>
|
20 | #include <QObject>
|
21 | #include <QtGui>
|
21 | #include <QtGui>
|
22 | #include <QMainWindow>
|
22 | #include <QMainWindow>
|
23 | #include <QString>
|
23 | #include <QString>
|
24 | #include <QtSql>
|
24 | #include <QtSql>
|
25 | #include <QSqlTableModel>
|
25 | #include <QSqlTableModel>
|
26 | #include <QTableView>
|
26 | #include <QTableView>
|
27 | #include <QSqlDriverPlugin>
|
27 | #include <QSqlDriverPlugin>
|
28 | #include <QIcon>
|
28 | #include <QIcon>
|
29 | #include <QVariant>
|
29 | #include <QVariant>
|
30 | #include <QProcess>
|
30 | #include <QProcess>
|
31 | #include <QByteArray>
|
31 | #include <QByteArray>
|
32 | 32 | ||
33 | 33 | ||
34 | class MySql : public QObject |
34 | class MySql : public QObject |
35 | {
|
35 | {
|
36 | Q_OBJECT |
36 | Q_OBJECT |
37 | public: |
37 | public: |
38 | explicit MySql(QObject *parent = 0); |
38 | explicit MySql(QObject *parent = 0); |
39 | 39 | ||
40 | bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ |
40 | bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ |
41 | bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses) |
41 | bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses) |
- | 42 | bool createListOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è êëàññîâ (Òàáëèöà ListOfClasses) |
|
- | 43 | bool createDescriptionOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses) |
|
42 | signals:
|
44 | signals:
|
43 | 45 | ||
44 | public slots: |
46 | public slots: |
45 | 47 | ||
46 | private: |
48 | private: |
47 | QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
49 | QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
48 | QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ |
50 | QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ |
49 | QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ |
51 | QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ |
50 | QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ |
52 | QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ |
51 | QSqlDatabase db;
|
53 | QSqlDatabase db;
|
52 | QString mysqlLastError;
|
54 | QString mysqlLastError;
|
53 | 55 | ||
54 | protected: |
56 | protected: |
55 | 57 | ||
56 | public: |
58 | public: |
57 | void setDatabaseName(QString dbname); |
59 | void setDatabaseName(QString dbname); |
58 | void setUserName(QString uname); |
60 | void setUserName(QString uname); |
59 | void setPassword(QString passwrd); |
61 | void setPassword(QString passwrd); |
60 | void setHostName(QString hname); |
62 | void setHostName(QString hname); |
61 | bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó |
63 | bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó |
62 | 64 | ||
63 | QString lasError(); |
65 | QString lasError(); |
64 | 66 | ||
65 | 67 | ||
66 | }; |
68 | }; |
67 | 69 | ||
68 | #endif // MYSQL_H
|
70 | #endif // MYSQL_H
|
69 | 71 |