Редакция 42 | Редакция 45 | К новейшей редакции | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 42 | Редакция 44 | ||
|---|---|---|---|
| Строка 17... | Строка 17... | ||
| 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(QString* errorString){ |
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 {errorString->clear(); |
31 | else { |
| 32 | errorString->append(db.lastError().text()); |
32 | MySql::mysqlLastError = db.lastError().text(); |
| 33 | return false; } |
33 | return false; } |
| 34 | 34 | ||
| 35 | /*
|
35 | /*
|
| 36 | pdb->setHostName(hostName);
|
36 | pdb->setHostName(hostName);
|
| 37 | pdb->setDatabaseName(baseName);
|
37 | pdb->setDatabaseName(baseName);
|
| Строка 62... | Строка 62... | ||
| 62 | 62 | ||
| 63 | void MySql::setHostName(QString hname){ |
63 | void MySql::setHostName(QString hname){ |
| 64 | MySql::sqlHostName = hname; |
64 | MySql::sqlHostName = hname; |
| 65 | }
|
65 | }
|
| 66 | 66 | ||
| 67 | bool MySql::createTable(SqlTable* table, QString* errorString){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
67 | bool MySql::createTable(SqlTable* table){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
| 68 | QSqlQuery q;
|
68 | QSqlQuery q;
|
| 69 | bool ok; |
69 | bool ok; |
| 70 | ok = q.prepare(table->sqlString()); |
70 | ok = q.prepare(table->sqlString()); |
| 71 | if(!ok) { |
71 | if(!ok) { |
| 72 | errorString->append(q.lastError().text()); |
72 | MySql::mysqlLastError = q.lastError().text(); |
| 73 | return false;} |
73 | return false;} |
| 74 | ok = q.exec(); |
74 | ok = q.exec(); |
| 75 | if(!ok) { |
75 | if(!ok) { |
| 76 | errorString->append(q.lastError().text()); |
76 | MySql::mysqlLastError = q.lastError().text(); |
| 77 | return false;} |
77 | return false;} |
| 78 | else return true; |
78 | else return true; |
| 79 | }
|
79 | }
|
| - | 80 | ||
| - | 81 | ||
| - | 82 | ||
| - | 83 | QString MySql::lasError(){ |
|
| - | 84 | ||
| - | 85 | return MySql::mysqlLastError; |
|
| - | 86 | }
|
|
| - | 87 | ||
| - | 88 | ||