Редакция 143 | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 143 | Редакция 210 | ||
|---|---|---|---|
| 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 | #include <QSqlQuery>
|
32 | #include <QSqlQuery>
|
| 33 | 33 | ||
| 34 | 34 | ||
| 35 | class MySql : public QObject |
35 | class MySql : public QObject |
| 36 | {
|
36 | {
|
| 37 | Q_OBJECT |
37 | Q_OBJECT |
| 38 | public: |
38 | public: |
| 39 | explicit MySql(QObject *parent = 0); |
39 | explicit MySql(QObject *parent = 0); |
| 40 | ~MySql(); |
40 | ~MySql(); |
| 41 | bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ |
41 | bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ |
| 42 | bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses) |
42 | bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses) |
| 43 | bool createListOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è êëàññîâ (Òàáëèöà ListOfClasses) |
43 | bool createListOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è êëàññîâ (Òàáëèöà ListOfClasses) |
| 44 | bool createDescriptionOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses) |
44 | bool createDescriptionOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses) |
| 45 | bool createListModelsTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ ìîäåëåé (Òàáëèöà ListOfModels) |
45 | bool createListModelsTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ ìîäåëåé (Òàáëèöà ListOfModels) |
| - | 46 | bool createFiltersTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ ôèëüòðîâ (Òàáëèöà Filters) |
|
| 46 | signals:
|
47 | signals:
|
| 47 | 48 | ||
| 48 | public slots: |
49 | public slots: |
| 49 | 50 | ||
| 50 | private: |
51 | private: |
| 51 | QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
52 | QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
| 52 | QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ |
53 | QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ |
| 53 | QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ |
54 | QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ |
| 54 | QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ |
55 | QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ |
| 55 | QSqlDatabase db;
|
56 | QSqlDatabase db;
|
| 56 | QString mysqlLastError;
|
57 | QString mysqlLastError;
|
| 57 | 58 | ||
| 58 | protected: |
59 | protected: |
| 59 | 60 | ||
| 60 | public: |
61 | public: |
| 61 | void setDatabaseName(QString dbname); |
62 | void setDatabaseName(QString dbname); |
| 62 | void setUserName(QString uname); |
63 | void setUserName(QString uname); |
| 63 | void setPassword(QString passwrd); |
64 | void setPassword(QString passwrd); |
| 64 | void setHostName(QString hname); |
65 | void setHostName(QString hname); |
| 65 | bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó |
66 | bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó |
| 66 | void close(); // çàêîûâàåì ñîåäèíåíèå ñ áàçîé |
67 | void close(); // çàêîûâàåì ñîåäèíåíèå ñ áàçîé |
| 67 | 68 | ||
| 68 | QString lasError(); |
69 | QString lasError(); |
| 69 | QSqlError dbLastError(); // ôóíêöèÿ ôîçâðàùàåò ïîñëåäíþþ îøèáêó áàçû äàííûõ |
70 | QSqlError dbLastError(); // ôóíêöèÿ ôîçâðàùàåò ïîñëåäíþþ îøèáêó áàçû äàííûõ |
| 70 | 71 | ||
| 71 | 72 | ||
| 72 | }; |
73 | }; |
| 73 | 74 | ||
| 74 | #endif // MYSQL_H
|
75 | #endif // MYSQL_H
|
| 75 | 76 | ||