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