WebSVN - OpenInventory - Различия - Редакция 41 и 42


#include "mysql.h"

MySql::MySql(QObject *parent) :
    QObject(parent)
{
}



/************************************************
** Ôóíêöèÿ ïðèñâîåíèÿ çíà÷åíèÿ èìåíè áàçû äàííûõ
**
************************************************/



void MySql::setDatabaseName(QString name){
    MySql::sqlDatabaseName = name;
}


bool MySql::connect(QString* errorString){
    db = QSqlDatabase::addDatabase("QMYSQL");

    db.setHostName(MySql::sqlHostName);
    db.setDatabaseName(MySql::sqlDatabaseName);
    db.setUserName(MySql::sqlUserName);
    db.setPassword(MySql::sqlPassword);
    bool ok = db.open();
    if (ok) return true;
    else {errorString->clear();
          errorString->append(db.lastError().text());
        return false; }

    /*
    pdb->setHostName(hostName);
    pdb->setDatabaseName(baseName);
    pdb->setUserName(userName);
    pdb->setPassword(password);
    bool ok = pdb->open();

if (!ok) {
                            QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå.
                                                                            QWidget(this->parent()),                      // Ðîäèòåëüñêèé âèäæåò.
                                                                            QObject::tr("Database Error"),   // Çàãîëîâîê.
                                                                            db.lastError().text());          // Òåêñò ñîîáùåíèÿ.
                     }
  */

    return true;
}


void MySql::setUserName(QString uname){
    MySql::sqlUserName = uname;
}

void MySql::setPassword(QString passwrd){
    MySql::sqlPassword = passwrd;
}


void MySql::setHostName(QString hname){
    MySql::sqlHostName = hname;
}

bool  MySql::createTable(SqlTable* table, QString* errorString){ // ñîçäàåò â áàçå äàííûõ òàáëèöó
QSqlQuery q;
bool ok;
ok = q.prepare(table->sqlString());
if(!ok) {
    errorString->append(q.lastError().text());
    return false;}
ok = q.exec();
if(!ok) {
    errorString->append(q.lastError().text());
    return false;}
else return true;
}
 

Редакция 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

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/mysql.cpp - Редакция 41 → 42