well i dont understand what it means..huhuh
now i try write database using progrmmg..
this my mainwindow.h
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>
#include <QWidget>
Q_OBJECT
public:
private slots:
void updateButton(int row);
private:
void setupModel();
};
#endif // MAINWINDOW_H
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>
#include <QWidget>
class QComboBox;
class QDataWidgetMapper;
class QItemSelectionModel;
class QLabel;
class QLineEdit;
class QPushButton;
class QSqlRelationalTableModel;
class QStandardItemModel;
class QStringListModel;
class QTextEdit;
class MainWindow : public QMainWindow {
Q_OBJECT
public:
MainWindow(QWidget *parent = 0);
private slots:
void updateButton(int row);
private:
void setupModel();
QLabel *label;
QTextEdit *textEdit;
QComboBox *comboBox;
QPushButton *pushButton;
QSqlRelationalTableModel *model;
QItemSelectionModel *selectionModel;
QDataWidgetMapper *mapper;
};
#endif // MAINWINDOW_H
To copy to clipboard, switch view to plain text mode
mainwindow.cpp
#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QSqlTableModel>
#include <QDataWidgetMapper>
#include <QSqlRelationalDelegate>
#include <QSqlRelationalTableModel>
#include <QMessageBox>
#include <QSqlQuery>
MainWindow
::MainWindow(QWidget *parent
) :
{
setupModel();
mapper->setModel(model);
mapper->addMapping(comboBox, model->fieldIndex("name"));
mapper->addMapping(textEdit, model->fieldIndex("address"));
connect(pushButton, SIGNAL(clicked()),
mapper, SLOT(updateButton(int)));
setWindowTitle(tr("WiseAviation"));
mapper->toFirst();
}
void MainWindow::setupModel()
{
db.setHostName("localhost");
db.setDatabaseName("wiseavi");
db.setUserName("root");
db.setPassword("root");
if (!db.open()) {
tr("Unable to establish a database connection.\n"
"This example needs SQMySQL support. Please read "
"the Qt SQL driver documentation for information how "
return;
}
query.exec("create table workers (name varchar(20), address varchar(200)");
query.exec("insert into workers values( 'Siti', "
"'Sabah')");
query.exec("insert into workers values( 'Atun', "
"'Perak')");
query.exec("insert into workers values( 'fifa', "
"'kedah')");
model->setTable("workers");
model->select();
}
void MainWindow::updateButton(int row)
{
pushButton->update();
}
#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QSqlTableModel>
#include <QDataWidgetMapper>
#include <QSqlRelationalDelegate>
#include <QSqlRelationalTableModel>
#include <QMessageBox>
#include <QSqlQuery>
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent)
{
setupModel();
mapper = new QDataWidgetMapper(this);
mapper->setModel(model);
mapper->setItemDelegate(new QSqlRelationalDelegate(this));
mapper->addMapping(comboBox, model->fieldIndex("name"));
mapper->addMapping(textEdit, model->fieldIndex("address"));
connect(pushButton, SIGNAL(clicked()),
mapper, SLOT(updateButton(int)));
setWindowTitle(tr("WiseAviation"));
mapper->toFirst();
}
void MainWindow::setupModel()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("wiseavi");
db.setUserName("root");
db.setPassword("root");
if (!db.open()) {
QMessageBox::critical(0, tr("Cannot open database"),
tr("Unable to establish a database connection.\n"
"This example needs SQMySQL support. Please read "
"the Qt SQL driver documentation for information how "
"to build it."), QMessageBox::Cancel);
return;
}
QSqlQuery query;
query.exec("create table workers (name varchar(20), address varchar(200)");
query.exec("insert into workers values( 'Siti', "
"'Sabah')");
query.exec("insert into workers values( 'Atun', "
"'Perak')");
query.exec("insert into workers values( 'fifa', "
"'kedah')");
model = new QSqlRelationalTableModel(this);
model->setTable("workers");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
}
void MainWindow::updateButton(int row)
{
pushButton->update();
}
To copy to clipboard, switch view to plain text mode
main.cpp
#include <QtGui/QApplication>
#include "mainwindow.h"
int main(int argc, char *argv[])
{
MainWindow w;
w.show();
return a.exec();
}
#include <QtGui/QApplication>
#include "mainwindow.h"
int main(int argc, char *argv[])
{
QApplication a(argc, argv);
MainWindow w;
w.show();
return a.exec();
}
To copy to clipboard, switch view to plain text mode
Bookmarks