Редакция 44 | Редакция 56 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 44 | Редакция 45 | ||
---|---|---|---|
1 | #include "mysql.h"
|
1 | #include "mysql.h"
|
2 | 2 | ||
3 | MySql::MySql(QObject *parent) : |
3 | MySql::MySql(QObject *parent) : |
4 | QObject(parent) |
4 | QObject(parent) |
5 | {
|
5 | {
|
6 | }
|
6 | }
|
7 | 7 | ||
8 | 8 | ||
9 | 9 | ||
10 | /************************************************
|
10 | /************************************************
|
11 | ** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
|
11 | ** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
|
12 | **
|
12 | **
|
13 | ************************************************/
|
13 | ************************************************/
|
14 | 14 | ||
15 | 15 | ||
16 | 16 | ||
17 | void MySql::setDatabaseName(QString name){ |
17 | void MySql::setDatabaseName(QString name){ |
18 | MySql::sqlDatabaseName = name; |
18 | MySql::sqlDatabaseName = name; |
19 | }
|
19 | }
|
20 | 20 | ||
21 | 21 | ||
22 | bool MySql::connect(){ |
22 | bool MySql::connect(){ |
23 | db = QSqlDatabase::addDatabase("QMYSQL"); |
23 | db = QSqlDatabase::addDatabase("QMYSQL"); |
24 | 24 | ||
25 | db.setHostName(MySql::sqlHostName); |
25 | db.setHostName(MySql::sqlHostName); |
26 | db.setDatabaseName(MySql::sqlDatabaseName); |
26 | db.setDatabaseName(MySql::sqlDatabaseName); |
27 | db.setUserName(MySql::sqlUserName); |
27 | db.setUserName(MySql::sqlUserName); |
28 | db.setPassword(MySql::sqlPassword); |
28 | db.setPassword(MySql::sqlPassword); |
29 | bool ok = db.open(); |
29 | bool ok = db.open(); |
30 | if (ok) return true; |
30 | if (ok) return true; |
31 | else { |
31 | else { |
32 | MySql::mysqlLastError = db.lastError(). |
32 | MySql::mysqlLastError = db.lastError().text(); |
33 | 33 | return false; } |
|
34 | 34 | ||
35 | 35 | /*
|
|
36 | 36 | pdb->setHostName(hostName);
|
|
37 | 37 | pdb->setDatabaseName(baseName);
|
|
38 | 38 | pdb->setUserName(userName);
|
|
39 | 39 | pdb->setPassword(password);
|
|
40 | 40 | bool ok = pdb->open();
|
|
41 | 41 | ||
42 | 42 | if (!ok) {
|
|
43 | 43 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
|
44 | 44 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
|
45 | 45 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
|
46 | 46 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
|
47 | 47 | }
|
|
48 | 48 | */
|
|
49 | 49 | ||
50 | 50 | return true; |
|
51 | 51 | }
|
|
52 | 52 | ||
53 | 53 | ||
54 | 54 | void MySql::setUserName(QString uname){ |
|
55 | 55 | MySql::sqlUserName = uname; |
|
56 | 56 | }
|
|
57 | 57 | ||
58 | 58 | void MySql::setPassword(QString passwrd){ |
|
59 | 59 | MySql::sqlPassword = passwrd; |
|
60 | 60 | }
|
|
61 | 61 | ||
62 | 62 | ||
63 | 63 | void MySql::setHostName(QString hname){ |
|
64 | 64 | MySql::sqlHostName = hname; |
|
65 | 65 | }
|
|
66 | 66 | ||
67 | 67 | bool MySql::createTable(SqlTable* table){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
|
68 | 68 | QSqlQuery q;
|
|
69 | 69 | bool ok; |
|
70 | 70 | ok = q.prepare(table->sqlString()); |
|
71 | 71 | if(!ok) { |
|
72 | 72 | MySql::mysqlLastError = q.lastError().text(); |
|
73 | 73 | return false;} |
|
74 | 74 | ok = q.exec(); |
|
75 | 75 | if(!ok) { |
|
76 | 76 | MySql::mysqlLastError = q.lastError().text(); |
|
77 | 77 | return false;} |
|
78 | 78 | else return true; |
|
79 | 79 | }
|
|
80 | 80 | ||
81 | 81 | ||
82 | 82 | ||
83 | 83 | QString MySql::lasError(){ |
|
84 | 84 | ||
85 | 85 | return MySql::mysqlLastError; |
|
86 | 86 | }
|
|
87 | 87 | ||
88 | 88 | ||
- | 89 | ||
- | 90 | /************************************************
|
|
- | 91 | ** Ôóíêöèÿ ñîçäàåò íåîáõîäèìûå òàáëèöû â áàçå äàííûõ
|
|
- | 92 | ** äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ
|
|
- | 93 | ** (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
|
|
- | 94 | ************************************************/
|
|
- | 95 | ||
- | 96 | ||
- | 97 | bool MySql::createDataBase(){ |
|
- | 98 | SqlTable* tbl; |
|
- | 99 | TableField* fld; |
|
- | 100 | if (!db.isOpen()){ |
|
- | 101 | MySql::mysqlLastError = tr("Database is not open!"); |
|
- | 102 | return false; |
|
- | 103 | }
|
|
- | 104 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
|
- | 105 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
- | 106 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 107 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 108 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 109 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 110 | ||
- | 111 | fld = new TableField(tr("ClassAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 112 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 113 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 114 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 115 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 116 | ||
- | 117 | fld = new TableField(tr("TableWhithInstance"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 118 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 119 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 120 | fld->setDefaultValue(tr("New class instance")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 121 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 122 | ||
- | 123 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 124 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 125 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 126 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 127 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 128 | ||
- | 129 | ||
- | 130 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
- | 131 | ||
- | 132 | // delete fld;
|
|
- | 133 | delete tbl; // ÷èñòèì ç |
|
- | 134 | ||
- | 135 | ||
- | 136 | ||
- | 137 | ||
- | 138 | ||
- | 139 | ||
- | 140 | ||
- | 141 | ||
- | 142 | ||
- | 143 | ||
- | 144 | ||
- | 145 | ||
- | 146 |