QSqlTableModel Code Examples

http://doc.qt.io/qt-5/QSqlTableModel.html

   
 
      QSqlTableModel *model = new QSqlTableModel(parentObject, database);
      model->setTable("employee");
      model->setEditStrategy(QSqlTableModel::OnManualSubmit);
      model->select();
      model->setHeaderData(0, Qt::Horizontal, tr("Name"));
      model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

      QTableView *view = new QTableView;
      view->setModel(model);
      view->hideColumn(0); // don't show the ID
      view->show();


      QSqlTableModel model;
      model.setTable("employee");
      model.select();
      int salary = model.record(4).value("salary").toInt();