Хранилища Subversion qb

Редакция

Редакция 3 | Редакция 6 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
2 diffor 1 
#include <QtGui>
2 
#include <QtSql>
3 
#include "mainwindow.h"
4 
#include "dbconfigdialog.h"
5 
 
6 
MainWindow::MainWindow(QWidget *parent)
7 
    : QMainWindow(parent)
8 
{
9 
    QLabel *dbLabel = new QLabel("Database");
10 
    QComboBox *dbCombo = new QComboBox;
11 
    dbCombo->addItem("default");
12 
    dbCombo->setEnabled(false);
13 
    QPushButton *dbPrefButton = new QPushButton("Config");
14 
    QPushButton *dbConnectButton = new QPushButton("Connect");
15 
    QHBoxLayout *dbLayout = new QHBoxLayout;
16 
    dbLayout->addWidget(dbLabel);
17 
    dbLayout->addWidget(dbCombo);
18 
    dbLayout->addWidget(dbPrefButton);
19 
    dbLayout->addWidget(dbConnectButton);
20 
 
4 diffor 21 
    QGroupBox *queryGroup = new QGroupBox("Query");
2 diffor 22 
    queryEdit = new QTextEdit;
23 
    QPushButton *queryExecButton = new QPushButton("Exec");
24 
    QHBoxLayout *queryLayout = new QHBoxLayout;
25 
    queryLayout->addWidget(queryEdit);
26 
    queryLayout->addWidget(queryExecButton);
4 diffor 27 
    queryGroup->setLayout(queryLayout);
2 diffor 28 
 
4 diffor 29 
    QGroupBox *logGroup = new QGroupBox("Log");
30 
    logEdit = new QTextEdit;
31 
    logEdit->setReadOnly(true);
32 
    QHBoxLayout *logLayout = new QHBoxLayout;
33 
    logLayout->addWidget(logEdit);
34 
    logGroup->setLayout(logLayout);
35 
 
36 
    QGroupBox *resultGroup = new QGroupBox("Result");
2 diffor 37 
    resultTable = new QTableView;
38 
    resultModel = new QSqlQueryModel;
4 diffor 39 
    QHBoxLayout *resultLayout = new QHBoxLayout;
40 
    resultLayout->addWidget(resultTable);
41 
    resultGroup->setLayout(resultLayout);
2 diffor 42 
 
43 
    QWidget *mainWidget = new QWidget;
44 
    QVBoxLayout *mainLayout = new QVBoxLayout;
45 
    mainLayout->addLayout(dbLayout);
4 diffor 46 
    mainLayout->addWidget(queryGroup);
47 
    mainLayout->addWidget(logGroup);
48 
    mainLayout->addWidget(resultGroup);
2 diffor 49 
 
50 
    mainWidget->setLayout(mainLayout);
51 
    setCentralWidget(mainWidget);
52 
 
53 
    connect(queryExecButton,SIGNAL(clicked()),this,SLOT(queryExec()));
54 
    connect(dbPrefButton, SIGNAL(clicked()),this,SLOT(settingsDB()));
55 
    connect(dbConnectButton, SIGNAL(clicked()),this,SLOT(connectDB()));
3 diffor 56 
    statusBar()->showMessage(tr("Ready"));
2 diffor 57 
}
58 
 
59 
MainWindow::~MainWindow()
60 
{
61 
 
62 
}
63 
 
64 
void MainWindow::queryExec()
65 
{
4 diffor 66 
    statusBar()->showMessage("SQL process...");
2 diffor 67 
    resultModel->setQuery(queryEdit->toPlainText());
68 
    resultTable->setModel(resultModel);
69 
    resultTable->show();
4 diffor 70 
 
71 
    if(resultModel->lastError().isValid())
72 
        logEdit->insertPlainText(resultModel->lastError().text());
73 
        else logEdit->insertPlainText("No error.");
74 
    logEdit->insertPlainText("\n");
75 
    statusBar()->showMessage("Ready");
2 diffor 76 
}
77 
 
78 
void MainWindow::settingsDB()
79 
{
80 
    DbConfigDialog *dbc = new DbConfigDialog();
81 
    dbc->exec();
82 
}
83 
 
84 
void MainWindow::connectDB()
85 
{
86 
    QSettings settings;
87 
 
88 
    QSqlDatabase db = QSqlDatabase::addDatabase(settings.value("DB/driver").toString());
89 
    db.setDatabaseName(settings.value("DB/database").toString());
90 
    if (!db.open())
91 
        QMessageBox::critical(this, tr("Connection error"), tr("Can't open database\n%1").arg(db.lastError().text()), QMessageBox::Ok);
92 
    else
93 
        QMessageBox::information(this,tr("Connection complete"), tr("Connection complete!"),QMessageBox::Ok);
94 
}