Редакция 41 | Редакция 44 | К новейшей редакции | Только различия | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 41 | Редакция 42 | ||
---|---|---|---|
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(QString* errorString){ |
22 | bool MySql::connect(QString* errorString){ |
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 {errorString->clear(); |
32 | errorString->append(db.lastError().text()); |
32 | errorString->append(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);
|
38 | pdb->setUserName(userName);
|
38 | pdb->setUserName(userName);
|
39 | pdb->setPassword(password);
|
39 | pdb->setPassword(password);
|
40 | bool ok = pdb->open();
|
40 | bool ok = pdb->open();
|
41 | 41 | ||
42 | if (!ok) {
|
42 | if (!ok) {
|
43 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
43 | QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
|
44 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
44 | QWidget(this->parent()), // Ðîäèòåëüñêèé âèäæåò.
|
45 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
45 | QObject::tr("Database Error"), // Çàãîëîâîê.
|
46 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
46 | db.lastError().text()); // Òåêñò ñîîáùåíèÿ.
|
47 | }
|
47 | }
|
48 | */
|
48 | */
|
49 | 49 | ||
50 | return true; |
50 | return true; |
51 | }
|
51 | }
|
52 | 52 | ||
53 | 53 | ||
54 | void MySql::setUserName(QString uname){ |
54 | void MySql::setUserName(QString uname){ |
55 | MySql::sqlUserName = uname; |
55 | MySql::sqlUserName = uname; |
56 | }
|
56 | }
|
57 | 57 | ||
58 | void MySql::setPassword(QString passwrd){ |
58 | void MySql::setPassword(QString passwrd){ |
59 | MySql::sqlPassword = passwrd; |
59 | MySql::sqlPassword = passwrd; |
60 | }
|
60 | }
|
61 | 61 | ||
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 | ||
- | 67 | bool MySql::createTable(SqlTable* table, QString* errorString){ // ñîçäàåò â áàçå äàííûõ òàáëèöó |
|
- | 68 | QSqlQuery q;
|
|
- | 69 | bool ok; |
|
- | 70 | ok = q.prepare(table->sqlString()); |
|
- | 71 | if(!ok) { |
|
- | 72 | errorString->append(q.lastError().text()); |
|
- | 73 | return false;} |
|
- | 74 | ok = q.exec(); |
|
- | 75 | if(!ok) { |
|
- | 76 | errorString->append(q.lastError().text()); |
|
- | 77 | return false;} |
|
- | 78 | else return true; |
|
- | 79 | }
|
|
66 | 80 |