| Цитата |
Как у тебя производится запись в БД ?
|
| Код |
model->setEditStrategy(QSqlTableModel::OnFieldChange);
|
Вот весь код:
| Код |
#ifndef CMAIN_H
#define CMAIN_H
//---------------------------------------------------------------------------
#include <QtGui/QWidget>
#include <QtGui/QMessageBox>
#include <QtSql>
#include <QImage>
#include "ui_CMain.h"
//---------------------------------------------------------------------------
class CMain :
public QWidget
{
Q_OBJECT
public:
CMain(QWidget *parent = 0);
~CMain();
private:
Ui::CMainClass ui;
QSqlTableModel *model;
QSqlDatabase _m_dbDatabse;
void setupModel();
};
//---------------------------------------------------------------------------
#endif // CMAIN_H
|
| Код |
#include "CMain.h"
//---------------------------------------------------------------------------
CMain::CMain(QWidget *parent)
: QWidget(parent)
{
ui.setupUi(this);
setupModel();
QImage imgPhoto;
imgPhoto.load("./image.png");
QImage img1 = imgPhoto.scaled(QSize(120 * 2, 90 * 2), Qt::IgnoreAspectRatio, Qt::SmoothTransformation);
ui.lblPhoto->setPixmap(QPixmap::fromImage(img1));
//ui.lblPhoto->setSizePolicy(QSizePolicy::Expanding, QSizePolicy::Expanding);
}
//---------------------------------------------------------------------------
CMain::~CMain()
{
_m_dbDatabse.close();
}
//---------------------------------------------------------------------------
void
CMain::setupModel() {
bool bRes = false;
_m_dbDatabse = QSqlDatabase::addDatabase("QSQLITE");
_m_dbDatabse.setDatabaseName("./base.db");
if (!_m_dbDatabse.open()) {
QMessageBox::critical(0, tr(""), tr("Unable to establish a database connection."), QMessageBox::Cancel);
return;
}
//Set up the main table
QSqlQuery query;
bRes = query.exec("CREATE TABLE T_PERSON (F_ID INT PRIMARY KEY, F_NAME VARCHAR(20), F_ADGE INT)");
if (false == bRes) {
//QMessageBox::critical(0, tr(""), tr("Can't create table."), QMessageBox::Cancel);
}
bRes = query.exec("INSERT INTO T_PERSON VALUES(1, 'Alice', 20)");
if (false == bRes) {
//QMessageBox::critical(0, tr(""), tr("Can't insert record."), QMessageBox::Cancel);
}
bRes = query.exec("INSERT INTO T_PERSON VALUES(2, 'Bob', 30)");
bRes = query.exec("INSERT INTO T_PERSON VALUES(3, 'Carol', 19)");
bRes = query.exec("INSERT INTO T_PERSON VALUES(4, 'Donald', 40)");
bRes = query.exec("INSERT INTO T_PERSON VALUES(5, 'Emma', 25)");
//QSqlTableModel
model = new QSqlTableModel(this, _m_dbDatabse);
model->setTable("T_PERSON");
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
//model->removeColumn(0); // don't show the ID
model->setHeaderData(0, Qt::Horizontal, tr("Id"));
model->setHeaderData(1, Qt::Horizontal, tr("Name"));
model->setHeaderData(2, Qt::Horizontal, tr("Address"));
ui.tabvInfo->setModel(model);
ui.tabvInfo->show();
model->select();
}
//---------------------------------------------------------------------------
|
|