18,20 → 18,34 |
dbLayout->addWidget(dbPrefButton); |
dbLayout->addWidget(dbConnectButton); |
|
QGroupBox *queryGroup = new QGroupBox("Query"); |
queryEdit = new QTextEdit; |
QPushButton *queryExecButton = new QPushButton("Exec"); |
QHBoxLayout *queryLayout = new QHBoxLayout; |
queryLayout->addWidget(queryEdit); |
queryLayout->addWidget(queryExecButton); |
queryGroup->setLayout(queryLayout); |
|
QGroupBox *logGroup = new QGroupBox("Log"); |
logEdit = new QTextEdit; |
logEdit->setReadOnly(true); |
QHBoxLayout *logLayout = new QHBoxLayout; |
logLayout->addWidget(logEdit); |
logGroup->setLayout(logLayout); |
|
QGroupBox *resultGroup = new QGroupBox("Result"); |
resultTable = new QTableView; |
resultModel = new QSqlQueryModel; |
QHBoxLayout *resultLayout = new QHBoxLayout; |
resultLayout->addWidget(resultTable); |
resultGroup->setLayout(resultLayout); |
|
QWidget *mainWidget = new QWidget; |
QVBoxLayout *mainLayout = new QVBoxLayout; |
mainLayout->addLayout(dbLayout); |
mainLayout->addLayout(queryLayout); |
mainLayout->addWidget(resultTable); |
mainLayout->addWidget(queryGroup); |
mainLayout->addWidget(logGroup); |
mainLayout->addWidget(resultGroup); |
|
mainWidget->setLayout(mainLayout); |
setCentralWidget(mainWidget); |
49,10 → 63,16 |
|
void MainWindow::queryExec() |
{ |
statusBar()->showMessage("SQL process..."); |
resultModel->setQuery(queryEdit->toPlainText()); |
resultTable->setModel(resultModel); |
resultTable->show(); |
statusBar()->showMessage(resultModel->lastError().text()); |
|
if(resultModel->lastError().isValid()) |
logEdit->insertPlainText(resultModel->lastError().text()); |
else logEdit->insertPlainText("No error."); |
logEdit->insertPlainText("\n"); |
statusBar()->showMessage("Ready"); |
} |
|
void MainWindow::settingsDB() |