/trunk/DBViewer/mainwindow.h |
---|
5,7 → 5,7 |
//#include "mysql.h" |
#include "mymodel.h" |
#include "settingform.h" |
#include "delegate.h" |
#include <QMainWindow> |
61,6 → 61,19 |
private: |
Ui::MainWindow *ui; |
settingForm setFrm; |
//ïåðåìåííûå äëÿ ñîåäèíåíèÿ ñ áàçîé |
QString baseName; |
QString hostName; |
QString userName; |
QString password; |
QString tableName; |
void readSettings(); |
void writeSettings(); |
QList<QTreeWidgetItem *> root_items_list; |
QStandardItemModel *model; |
QStandardItem *item; |
110,6 → 123,13 |
SpinBoxDelegate spinDelegate; |
QItemDelegate standart_delegate; |
private slots: |
void on_comboBox_currentIndexChanged( int index ); |
void on_treeWidget_itemChanged ( QTreeWidgetItem * item, int column ); |
120,7 → 140,8 |
void on_pushButton_3_clicked();// íàæàòèå êíîïêè "Ïðèìåíèòü" |
void on_pushButton_4_clicked();// íàæàòèå êíîïêè "Ñáðîñèòü èçìåíåíèÿ" |
void on_sql_mogel_dataChanged ( const QModelIndex & topLeft, const QModelIndex & bottomRight ); // èçìåíèëè ñâîéñòâà îáúåêòà èëè äîáàâèëè íîâûé îáúåêò |
void applySetting(); |
void getSetting(); // îòêðîåì îêíî íàñòðîåê |
}; |
/trunk/DBViewer/database.cpp |
---|
650,3 → 650,73 |
return result_map; |
} |
// Ñ÷èòûâàåì íàñòðîéêè |
void MainWindow::readSettings() |
{ |
QSettings settings("Trolltech", "Application Example"); |
baseName = settings.value("baseName", "an_db").toString(); |
userName = settings.value("userName", "an").toString(); |
password = settings.value("password", "393939").toString(); |
tableName = settings.value("tableName", "inventar").toString(); |
hostName = settings.value("hostName", "server").toString(); |
// resize(size); |
// move(pos);tableName |
} |
void MainWindow::writeSettings() |
{ |
QSettings settings("Trolltech", "Application Example"); |
settings.setValue("baseName", baseName); |
settings.setValue("userName", userName); |
settings.setValue("password", password); |
settings.setValue("tableName", tableName); |
settings.setValue("hostName", hostName); |
} |
void MainWindow::applySetting() |
{ |
bool ok; |
baseName = setFrm.lineEdit->text(); |
userName = setFrm.lineEdit_2->text(); |
password = setFrm.lineEdit_3->text(); |
// tableName = setFrm->lineEdit_4->text(); |
hostName = setFrm.lineEdit_5->text(); |
writeSettings(); |
ok=openDataBase(); |
if (!ok) return; |
// // // ui->treeWidget->clear(); // î÷èùàåì äåðåâî ñ ìîäåëüþ |
// // // buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1")); |
class_list_map.clear(); // î÷èùàåì ñïèñîê êëàññîâ |
initComboBox(); |
// // // getDatabaseData(); |
// delete setFrm; |
setFrm.close(); |
} |
void MainWindow::getSetting() |
{ |
// setFrm = new settingForm; |
// // // connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting())); |
setFrm.lineEdit->setText(baseName); |
setFrm.lineEdit_2->setText(userName); |
setFrm.lineEdit_3->setText(password); |
// setFrm->lineEdit_4->setText(tableName); |
setFrm.lineEdit_5->setText(hostName); |
setFrm.show(); |
} |
/trunk/DBViewer/DBViewer.pro |
---|
17,9 → 17,12 |
mainwindow.cpp \ |
database.cpp \ |
delegate.cpp \ |
mymodel.cpp |
mymodel.cpp \ |
settingform.cpp |
HEADERS += mainwindow.h \ |
delegate.h \ |
mymodel.h |
FORMS += mainwindow.ui |
mymodel.h \ |
settingform.h |
FORMS += mainwindow.ui \ |
settingform.ui |
RESOURCES += dbviewer.qrc |
/trunk/DBViewer/mainwindow.ui |
---|
226,6 → 226,13 |
<height>27</height> |
</rect> |
</property> |
<widget class="QMenu" name="menu"> |
<property name="title"> |
<string>База данных</string> |
</property> |
<addaction name="getsettingAct"/> |
</widget> |
<addaction name="menu"/> |
</widget> |
<widget class="QToolBar" name="mainToolBar"> |
<attribute name="toolBarArea"> |
236,6 → 243,11 |
</attribute> |
</widget> |
<widget class="QStatusBar" name="statusBar"/> |
<action name="getsettingAct"> |
<property name="text"> |
<string>Параметры соединения</string> |
</property> |
</action> |
</widget> |
<layoutdefault spacing="6" margin="11"/> |
<resources/> |
/trunk/DBViewer/mainwindow.cpp |
---|
23,6 → 23,10 |
ui->treeWidget->setAlternatingRowColors(true); |
ui->treeWidget_2->setAlternatingRowColors(true); |
MainWindow::readSettings(); |
MainWindow::openDataBase(); |
MainWindow::buildPreviewModel(tr("Ìîÿ ìîäåëü"), tr("1")); |
MainWindow::initComboBox(); |
36,7 → 40,13 |
ui->pushButton_3->setEnabled(false); |
ui->pushButton_4->setEnabled(false); |
// setFrm.show(); |
connect(ui->getsettingAct, SIGNAL(triggered()), this, SLOT(getSetting())); // âûáîð â ãëàâíîé ôîðìå â ìåíþ "Áàçà äàííûõ" ïóíêòà "Ïàðàìåòðû ñîåäèíåíèÿ" |
connect(setFrm.pushButton, SIGNAL(clicked()), this, SLOT(applySetting())); |
} |
MainWindow::~MainWindow() |
254,15 → 264,30 |
sql = QSqlDatabase::addDatabase("QMYSQL"); |
// sql.setDatabaseName(tr("an_db")); |
sql.setDatabaseName(tr("inventory")); |
sql.setHostName(tr("localhost")); |
// // // sql.setDatabaseName(tr("inventory")); |
sql.setDatabaseName(baseName); |
sql.setUserName(tr("an")); |
sql.setPassword(tr("393939")); |
// // // sql.setHostName(tr("localhost")); |
sql.setHostName(hostName); |
// // // sql.setUserName(tr("an")); |
sql.setUserName(userName); |
// // // sql.setPassword(tr("393939")); |
sql.setPassword(password); |
bool ok; |
ok = sql.open(); |
607,6 → 632,9 |
tmp_stringList << tmp_str; |
} |
// int count = ui->comboBox->count(); |
ui->comboBox->clear(); |
ui->comboBox->addItems(tmp_stringList); |
617,6 → 645,8 |
QStringList classesNameList; |
QStringList classesID_list; |
QString ID_str; |
if (index == -1) return; |
classesID_list = class_list_map.keys(); |
classesNameList = class_list_map.values(); |
ID_str = classesID_list[index]; |
647,7 → 677,7 |
classesID_list = class_list_map.keys(); |
classesNameList = class_list_map.values(); |
index = classesID_list.indexOf(item->child(0)->text(1)); |
ui->comboBox->setCurrentIndex(index); |
if (index != -1) ui->comboBox->setCurrentIndex(index); |
ui->comboBox->setEnabled(true); |