QSqlRelationalTableModel Class

      model->setTable("employee");

      model->setRelation(2, QSqlRelation("city", "id", "name"));
      model->setRelation(3, QSqlRelation("country", "id", "name"));

      QTableView *view = new QTableView;
      view->setModel(model);
      view->setItemDelegate(new QSqlRelationalDelegate(view));

成员函数

QSqlRelationalTableModel::QSqlRelationalTableModel(QObject *parent = Q_NULLPTR, QSqlDatabase db = QSqlDatabase())

Creates an empty QSqlRelationalTableModel and sets the parent to parent and the database connection to db. If db is not valid, the default database connection will be used.

[virtual] QSqlRelationalTableModel::~QSqlRelationalTableModel()

Destroys the object and frees any allocated resources.

[virtual] void QSqlRelationalTableModel::clear()

重新实现 QSqlQueryModel::clear().

[virtual] QVariant QSqlRelationalTableModel::data(const QModelIndex &index, int role = Qt::DisplayRole) const

重新实现 QAbstractItemModel::data().

参见 setData().

[virtual protected] bool QSqlRelationalTableModel::insertRowIntoTable(const QSqlRecord &values)

重新实现 QSqlTableModel::insertRowIntoTable().

[virtual protected] QString QSqlRelationalTableModel::orderByClause() const

重新实现 QSqlTableModel::orderByClause().

QSqlRelation QSqlRelationalTableModel::relation(int column) const

Returns the relation for the column column, or an invalid relation if no relation is set.

参见 setRelation() and QSqlRelation::isValid().

[virtual] QSqlTableModel *QSqlRelationalTableModel::relationModel(int column) const

Returns a QSqlTableModel object for accessing the table for which column is a foreign key, or 0 if there is no relation for the given column.

The returned object is owned by the QSqlRelationalTableModel.

参见 setRelation() and relation().

[virtual] bool QSqlRelationalTableModel::removeColumns(int column, int count, const QModelIndex &parent = QModelIndex())

重新实现 QAbstractItemModel::removeColumns().

[virtual slot] void QSqlRelationalTableModel::revertRow(int row)

重新实现 QSqlTableModel::revertRow().

[virtual] bool QSqlRelationalTableModel::select()

重新实现 QSqlTableModel::select().

[virtual protected] QString QSqlRelationalTableModel::selectStatement() const

重新实现 QSqlTableModel::selectStatement().

[virtual] bool QSqlRelationalTableModel::setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole)

重新实现 QAbstractItemModel::setData().

Sets the data for the role in the item with the specified index to the value given. Depending on the edit strategy, the value might be applied to the database at once, or it may be cached in the model.

Returns true if the value could be set, or false on error (for example, if index is out of bounds).

For relational columns, value must be the index, not the display value. The index must also exist in the referenced table, otherwise the function returns false.

参见 editStrategy(), data(), submit(), and revertRow().

void QSqlRelationalTableModel::setJoinMode(QSqlRelationalTableModel::JoinMode joinMode)

Sets the SQL joinMode to show or hide rows with NULL foreign keys. In InnerJoin mode (the default) these rows will not be shown: use the LeftJoin mode if you want to show them.

This function was introduced in Qt 4.8.

参见 QSqlRelationalTableModel::JoinMode.

[virtual] void QSqlRelationalTableModel::setRelation(int column, const QSqlRelation &relation)

Lets the specified column be a foreign index specified by relation.

Example:

      model->setTable("employee");

      model->setRelation(2, QSqlRelation("city", "id", "name"));

The setRelation() call specifies that column 2 in table employee is a foreign key that maps with field id of table city, and that the view should present the city's name field to the user.

Note: The table's primary key may not contain a relation to another table.

参见 relation().

[virtual] void QSqlRelationalTableModel::setTable(const QString &table)

重新实现 QSqlTableModel::setTable().

[virtual protected] bool QSqlRelationalTableModel::updateRowInTable(int row, const QSqlRecord &values)

重新实现 QSqlTableModel::updateRowInTable().