Код:
CODE
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("dataCompanyDB.db");
db.open();
model = new QSqlRelationalTableModel(this);
model->setTable("company");
model->select();
model->setHeaderData(0, Qt::Horizontal, QString::fromLocal8Bit("Номер"));
model->setHeaderData(1, Qt::Horizontal, QString::fromLocal8Bit("Название"));
model->setHeaderData(2, Qt::Horizontal, QString::fromLocal8Bit("Адрес"));
model->setHeaderData(3, Qt::Horizontal, QString::fromLocal8Bit("УНП"));
model->setHeaderData(4, Qt::Horizontal, QString::fromLocal8Bit("Банк"));
model->setHeaderData(5, Qt::Horizontal, QString::fromLocal8Bit("Расчетный счет"));
mapper = new QDataWidgetMapper(this);
mapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);
mapper->setModel(model);
mapper->setItemDelegate(new QSqlRelationalDelegate(this));
mapper->addMapping(nameCompany, 1);
mapper->addMapping(adressCompany, 2);
mapper->addMapping(unpEdit, 3);
mapper->addMapping(bankEdit, 4);
mapper->addMapping(numberBankEdit, 5);
mapper->setCurrentIndex(0);
view->setModel(model);
db.close();
db.setDatabaseName("dataCompanyDB.db");
db.open();
model = new QSqlRelationalTableModel(this);
model->setTable("company");
model->select();
model->setHeaderData(0, Qt::Horizontal, QString::fromLocal8Bit("Номер"));
model->setHeaderData(1, Qt::Horizontal, QString::fromLocal8Bit("Название"));
model->setHeaderData(2, Qt::Horizontal, QString::fromLocal8Bit("Адрес"));
model->setHeaderData(3, Qt::Horizontal, QString::fromLocal8Bit("УНП"));
model->setHeaderData(4, Qt::Horizontal, QString::fromLocal8Bit("Банк"));
model->setHeaderData(5, Qt::Horizontal, QString::fromLocal8Bit("Расчетный счет"));
mapper = new QDataWidgetMapper(this);
mapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);
mapper->setModel(model);
mapper->setItemDelegate(new QSqlRelationalDelegate(this));
mapper->addMapping(nameCompany, 1);
mapper->addMapping(adressCompany, 2);
mapper->addMapping(unpEdit, 3);
mapper->addMapping(bankEdit, 4);
mapper->addMapping(numberBankEdit, 5);
mapper->setCurrentIndex(0);
view->setModel(model);
db.close();