// querymodel.h
#ifndef QUERYMODEL_H
#define QUERYMODEL_H
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlQueryModel>
#include <QSqlTableModel>
#include <QtDebug>
#include <QtGui/QWidget>
#include "ui_querymodel.h"
{
Q_OBJECT
public:
~querymodel();
public slots:
void showTable();
private:
Ui::querymodelClass ui;
};
#endif // QUERYMODEL_H
// querymodel.h
#ifndef QUERYMODEL_H
#define QUERYMODEL_H
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlQueryModel>
#include <QSqlTableModel>
#include <QtDebug>
#include <QtGui/QWidget>
#include "ui_querymodel.h"
class querymodel : public QWidget
{
Q_OBJECT
public:
querymodel(QWidget *parent = 0);
~querymodel();
public slots:
void showTable();
private:
Ui::querymodelClass ui;
QSqlTableModel *model;
};
#endif // QUERYMODEL_H
To copy to clipboard, switch view to plain text mode
// querymodel.cpp
#include "querymodel.h"
querymodel
::querymodel(QWidget *parent
){
ui.setupUi(this);
connect( ui.pushButtonShowTable, SIGNAL(clicked()), this, SLOT(showTable()) );
}
querymodel::~querymodel()
{
delete model;
}
void querymodel::showTable()
{
db.setHostName("localhost");
db.setDatabaseName("landonx");
db.setUserName("landon4");
db.setPassword("3141");
db.
setConnectOptions(QString("CLIENT_INTERACTIVE"));
bool ok = db.open();
model->setTable( "log_book" );
model->select();
model
->setHeaderData
( 0, Qt
::Horizontal,
QObject::tr("rowid") );
model
->setHeaderData
( 1, Qt
::Horizontal,
QObject::tr("fdate") );
model
->setHeaderData
( 2, Qt
::Horizontal,
QObject::tr("acid") );
model
->setHeaderData
( 3, Qt
::Horizontal,
QObject::tr("actype") );
model
->setHeaderData
( 4, Qt
::Horizontal,
QObject::tr("nlandings") );
model
->setHeaderData
( 5, Qt
::Horizontal,
QObject::tr("nhours") );
// QTableView *view = new QTableView();
ui.tableView->setModel( model );
ui.tableView->setAlternatingRowColors ( true );
ui.tableView->setFixedSize ( 800,500 );
ui.tableView->show();
}
// querymodel.cpp
#include "querymodel.h"
querymodel::querymodel(QWidget *parent)
: QWidget(parent)
{
ui.setupUi(this);
connect( ui.pushButtonShowTable, SIGNAL(clicked()), this, SLOT(showTable()) );
}
querymodel::~querymodel()
{
delete model;
}
void querymodel::showTable()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("landonx");
db.setUserName("landon4");
db.setPassword("3141");
db.setConnectOptions(QString("CLIENT_INTERACTIVE"));
bool ok = db.open();
model = new QSqlTableModel();
model->setTable( "log_book" );
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
model->setHeaderData( 0, Qt::Horizontal, QObject::tr("rowid") );
model->setHeaderData( 1, Qt::Horizontal, QObject::tr("fdate") );
model->setHeaderData( 2, Qt::Horizontal, QObject::tr("acid") );
model->setHeaderData( 3, Qt::Horizontal, QObject::tr("actype") );
model->setHeaderData( 4, Qt::Horizontal, QObject::tr("nlandings") );
model->setHeaderData( 5, Qt::Horizontal, QObject::tr("nhours") );
// QTableView *view = new QTableView();
ui.tableView->setModel( model );
ui.tableView->setAlternatingRowColors ( true );
ui.tableView->setFixedSize ( 800,500 );
ui.tableView->show();
}
To copy to clipboard, switch view to plain text mode
Bookmarks