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