| 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() |