/trunk/ClassEditor/mysql.cpp |
---|
15,5 → 15,51 |
void MySql::setDatabaseName(QString name){ |
MySql::database_name = 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; |
} |
/trunk/ClassEditor/mysql.h |
---|
37,18 → 37,26 |
public: |
explicit MySql(QObject *parent = 0); |
bool connect(QString* errorString); // ñîåäèíåíèå ñ áàçîé äàííûõ |
signals: |
public slots: |
private: |
QString database_name; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå |
QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ |
QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ |
QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ |
QSqlDatabase db; |
protected: |
public: |
void setDatabaseName(QString name); |
void setDatabaseName(QString dbname); |
void setUserName(QString uname); |
void setPassword(QString passwrd); |
void setHostName(QString hname); |
}; |
#endif // MYSQL_H |
/trunk/ClassEditor/classeditor.cpp |
---|
70,8 → 70,38 |
italicFormat.setFontItalic(true); |
cursor->insertText(table->sqlString(), format); |
QString errorString; |
sql.setDatabaseName(tr("an_db")); |
sql.setHostName(tr("localhost")); |
sql.setUserName(tr("an")); |
sql.setPassword(tr("393939")); |
bool ok; |
ok = sql.connect(&errorString); |
if (!ok) { |
QMessageBox::critical( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Error"), // Çàãîëîâîê. |
errorString); // Òåêñò ñîîáùåíèÿ. |
} |
else { |
QMessageBox::information( // Äèàëîã ñ ñîîáùåíèåì îá îøèáêå. |
this, // Ðîäèòåëüñêèé âèäæåò. |
QObject::tr("Database Connect"), // Çàãîëîâîê. |
QObject::tr("Ñîåäèíåíèå ñ áàçîé äàííûõ óñïåøíî óñòàíîâëåíî.")); // Òåêñò ñîîáùåíèÿ. |
} |
} |
ClassEditor::~ClassEditor() |
{ |
delete ui; |