QSqlTableModel *model = new QSqlTableModel(this, db);
model->setTable(tableName);
model->setFilter(tr(" 1=1 limit 0,%1").arg(rowNumber));
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
QTableView view = new QTableView(this);
view->setModel(model);
view->setSelectionMode(QAbstractItemView::ContiguousSelection);
//提交保存
model->database().transaction();
model->revertAll();
if (model->submitAll())
{
model->database().commit();
}
else
{
model->database().rollback();
QMessageBox::warning(this, tr("Cached Table"),
tr("The database reported an error: %1")
.arg(model->lastError().text()));
}
问一下,我只是想保存,我修改的数据,为啥一列都变成一样的值了呢,点击保存之后