Редакция 73 | Редакция 135 | К новейшей редакции | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 73 | Редакция 96 | ||
---|---|---|---|
1 | 1 | #include "mysql.h"
|
|
2 | 2 | ||
3 | 3 | MySql::MySql(QObject *parent) : |
|
4 | 4 | QObject(parent) |
|
5 | 5 | {
|
|
6 | 6 | }
|
|
7 | 7 | ||
- | 8 | MySql::~MySql(){ |
|
- | 9 | db.close(); |
|
8 | 10 | }
|
|
9 | 11 | ||
- | 12 | /************************************************
|
|
- | 13 | ** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
|
|
- | 14 | **
|
|
- | 15 | ************************************************/
|
|
- | 16 | ||
- | 17 | ||
- | 18 | ||
- | 19 | void MySql::setDatabaseName(QString name){ |
|
- | 20 | MySql::sqlDatabaseName = name; |
|
- | 21 | }
|
|
- | 22 | ||
- | 23 | ||
- | 24 | bool MySql::connect(){ |
|
- | 25 | db = QSqlDatabase::addDatabase("QMYSQL"); |
|
- | 26 | ||
- | 27 | db.setHostName(MySql::sqlHostName); |
|
- | 28 | db.setDatabaseName(MySql::sqlDatabaseName); |
|
- | 29 | db.setUserName(MySql::sqlUserName); |
|
- | 30 | db.setPassword(MySql::sqlPassword); |
|
- | 31 | bool ok = db.open(); |
|
- | 32 | if (ok) return true; |
|
- | 33 | else { |
|
- | 34 | MySql::mysqlLastError = db.lastError().text(); |
|
- | 35 | return false; } |
|
- | 36 | ||
- | 37 | /*
|
|
- | 38 | pdb->setHostName(hostName);
|
|
- | 39 | pdb->setDatabaseName(baseName);
|
|
- | 40 | pdb->setUserName(userName);
|
|
- | 41 | pdb->setPassword(password);
|
|
- | 42 | bool ok = pdb->open();
|
|
- | 43 | ||
- | 44 | if (!ok) {
|
|
- | 45 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
|
- | 46 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
|
- | 47 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
|
- | 48 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
|
- | 49 | }
|
|
- | 50 | */
|
|
- | 51 | ||
- | 52 | return true; |
|
- | 53 | }
|
|
- | 54 | ||
- | 55 | ||
- | 56 | void MySql::setUserName(QString uname){ |
|
- | 57 | MySql::sqlUserName = uname; |
|
- | 58 | }
|
|
- | 59 | ||
- | 60 | void MySql::setPassword(QString passwrd){ |
|
- | 61 | MySql::sqlPassword = passwrd; |
|
- | 62 | }
|
|
- | 63 | ||
- | 64 | ||
- | 65 | void MySql::setHostName(QString hname){ |
|
- | 66 | MySql::sqlHostName = hname; |
|
- | 67 | }
|
|
- | 68 | ||
- | 69 | bool MySql::createTable(SqlTable* table){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
|
- | 70 | QSqlQuery q;
|
|
- | 71 | bool ok; |
|
- | 72 | ok = q.prepare(table->sqlString()); |
|
- | 73 | if(!ok) { |
|
- | 74 | MySql::mysqlLastError = q.lastError().text(); |
|
- | 75 | return false;} |
|
- | 76 | ok = q.exec(); |
|
- | 77 | if(!ok) { |
|
- | 78 | MySql::mysqlLastError = q.lastError().text(); |
|
- | 79 | return false;} |
|
- | 80 | else return true; |
|
- | 81 | }
|
|
- | 82 | ||
- | 83 | ||
- | 84 | ||
- | 85 | QString MySql::lasError(){ |
|
- | 86 | ||
- | 87 | return MySql::mysqlLastError; |
|
- | 88 | }
|
|
- | 89 | ||
- | 90 | ||
- | 91 | ||
- | 92 | /************************************************
|
|
- | 93 | ** Ôóíêöèÿ ñîçäàåò íåîáõîäèìûå òàáëèöû â áàçå äàííûõ
|
|
- | 94 | ** äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ
|
|
- | 95 | ** (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
|
|
- | 96 | ************************************************/
|
|
- | 97 | ||
- | 98 | ||
- | 99 | bool MySql::createDataBase(){ |
|
- | 100 | SqlTable* tbl; |
|
- | 101 | TableField* fld; |
|
- | 102 | if (!db.isOpen()){ |
|
- | 103 | MySql::mysqlLastError = tr("Database is not open!"); |
|
- | 104 | return false; |
|
- | 105 | }
|
|
- | 106 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
|
- | 107 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
- | 108 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 109 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 110 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 111 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 112 | ||
- | 113 | fld = new TableField(tr("ClassAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 114 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 115 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 116 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 117 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 118 | ||
- | 119 | fld = new TableField(tr("TableWhithInstance"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 120 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 121 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 122 | fld->setDefaultValue(tr("New class instance")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 123 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 124 | ||
- | 125 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 126 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 127 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 128 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 129 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 130 | ||
- | 131 | ||
- | 132 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
- | 133 | ||
- | 134 | // delete fld;
|
|
- | 135 | delete tbl; // ÷èñòèì çà ñîáîé |
|
- | 136 | return false; // âûâîäèì îøèáêó |
|
- | 137 | }
|
|
- | 138 | ||
- | 139 | ||
- | 140 | else { // òàáëèöó óñïåøíî ñîçäàíà |
|
- | 141 | // delete fld;
|
|
- | 142 | delete tbl; // ÷èñòèì çà ñîáîé |
|
- | 143 | return true; // ñîîáùàåì îá óñïåõå |
|
- | 144 | ||
- | 145 | }
|
|
- | 146 | ||
- | 147 | tbl = new SqlTable(tr("DescriptionOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì DescriptionOfClassess äëÿ õðàíåíèÿ îïèñàíèÿ ïîëåé êëàññîâ |
|
- | 148 | fld = new TableField(tr("FieldName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà ïîëåé, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
- | 149 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 150 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 151 | fld->setDefaultValue(tr("New field")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 152 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 153 | ||
- | 154 | fld = new TableField(tr("FieldAlias"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû ïîëåé êëàññîâ |
|
- | 155 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 156 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 157 | fld->setDefaultValue(tr("New class alias")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 158 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 159 | ||
- | 160 | fld = new TableField(tr("FieldType"), tbl); // ýòî ÷åòâåðòîå ïîëå òàáëèöû áóäåò òèï ïîëÿ êëàññà |
|
- | 161 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 162 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 163 | fld->setDefaultValue(tr("CHAR(30)")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 164 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 165 | ||
- | 166 | fld = new TableField(tr("ClassIdentifer"), tbl); // ýòî ïÿòîå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 167 | fld->setNotNull(false); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 168 | fld->setType(tr("INT(10)")); // òèï ïîëÿ - öåëîå ÷èñëî |
|
- | 169 | fld->setDefaultValue(tr("NULL")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 170 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 171 | ||
- | 172 | ||
- | 173 | ||
- | 174 | fld = new TableField(tr("Comment"), tbl); // ýòî òðåòüå ïîëå òàáëèöû áóäåò õðàíèòü ïñåâäîíèìû êëàññîâ |
|
- | 175 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 176 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 177 | fld->setDefaultValue(tr("without comments")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 178 | tbl->append(fld); // äîáàâëÿåì ïîëå â òàáëèöó |
|
- | 179 | ||
- | 180 | ||
- | 181 | if(!MySql::createTable(tbl)){ // åñëè íå óäàåòñÿ ñîçäàòü òàáëèöó |
|
- | 182 | ||
- | 183 | // delete fld;
|
|
- | 184 | delete tbl; // ÷èñòèì çà ñîáîé |
|
- | 185 | return false; // âûâîäèì îøèáêó |
|
- | 186 | }
|
|
- | 187 | ||
- | 188 | ||
- | 189 | else { // òàáëèöó óñïåøíî ñîçäàíà |
|
- | 190 | // delete fld;
|
|
- | 191 | delete tbl; // ÷èñòèì çà ñîáîé |
|
- | 192 | return true; // ñîîáùàåì îá óñïåõå |
|
- | 193 | ||
- | 194 | }
|
|
- | 195 | ||
- | 196 | ||
- | 197 | ||
- | 198 | ||
- | 199 | ||
- | 200 | }
|
|
- | 201 | ||
- | 202 | ||
- | 203 | ||
- | 204 | ||
- | 205 | bool MySql::createListOfClassesTable(){ |
|
- | 206 | ||
- | 207 | SqlTable* tbl; |
|
- | 208 | TableField* fld; |
|
- | 209 | if (!db.isOpen()){ |
|
- | 210 | MySql::mysqlLastError = tr("Database is not open!"); |
|
- | 211 | return false; |
|
- | 212 | }
|
|
- | 213 | tbl = new SqlTable(tr("ListOfClasses")); // ñîçäàäèì òàáëèöó ñ èìåíåì ListOfClasses äëÿ õðàíåíèÿ ñïèñêà êëàññîâ |
|
- | 214 | fld = new TableField(tr("ClassName"), tbl); // ýòî âòîðîå ïîëå òàáëèöû áóäåò õðàíèòü èìåíà êëàññîâ, ïåðâîå ïîëå ID óæå èìååòñÿ â íîâîé òàáëèöå (îíî ñîçäàåòñÿ ïî óìîë÷àíèþ) |
|
- | 215 | fld->setNotNull(true); // ïîëå íå ìîæåò áûòü ïóñòûì |
|
- | 216 | fld->setType(tr("CHAR(30)")); // òèï ïîëÿ - ñòðîêà èç 30 ñèìâîëîâ |
|
- | 217 | fld->setDefaultValue(tr("New class")); // çíà÷åíèå ïîëÿ ïî óìîë÷àíèþ |
|
- | 218 | tbl->append(fld); |