qsqlrelationaltablemodel使用示例

#include "mainwindow.h" #include "ui_mainwindow.h" #include <QSqlDriver> #include <QDebug> MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); connectdatebase(); } MainWindow::~MainWindow() { delete ui; } void MainWindow::connectdatebase() { m_db = QSqlDatabase::addDatabase("QMYSQL"); m_db.setHostName("192.168.4.202"); m_db.setDatabaseName("test"); m_db.setUserName("root"); m_db.setPassword(""); bool b = m_db.open();//打开数据库 qDebug()<<b; //开启事务 openTransaction(); QSqlRelationalTableModel *model; model = new QSqlRelationalTableModel(nullptr, m_db); model->setTable("person"); model->setRelation(0, QSqlRelation("addr","id","addr")); initModelHeaderData(model, QStringList() <<"地址"<<"姓名"); ui->tableView->setModel(model); model->select(); } void MainWindow::openTransaction() { if(m_db.driver()->hasFeature(QSqlDriver::Transactions)) { m_db.transaction(); } } void MainWindow::initModelHeaderData(QSqlRelationalTableModel *model, QStringList dataList) { for(int i=0;i<dataList.count();i++) { model->setHeaderData(i, Qt::Horizontal, dataList.at(i)); } }