内容

• 公共类型
• 公共函数
• 重实现公共函数
• 公共槽
• 重实现保护函数
• 详细描述

QSqlRelationalTableModel Class

The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support. 更多...

头：	#include <QSqlRelationalTableModel>
qmake:	QT += sql
继承：	QSqlTableModel

• 所有成员列表，包括继承成员

公共类型

enum	JoinMode { InnerJoin, LeftJoin }

公共函数

	QSqlRelationalTableModel (QObject * parent = Q_NULLPTR, QSqlDatabase db = QSqlDatabase())
virtual	~QSqlRelationalTableModel ()
QSqlRelation	relation (int column ) const
virtual QSqlTableModel *	relationModel (int column ) const
void	setJoinMode (QSqlRelationalTableModel::JoinMode joinMode )
virtual void	setRelation (int column , const QSqlRelation & relation )

重实现公共函数

virtual void	clear ()
virtual QVariant	data (const QModelIndex & index , int role = Qt::DisplayRole) const
virtual bool	removeColumns (int column , int count , const QModelIndex & parent = QModelIndex())
virtual bool	select ()
virtual bool	setData (const QModelIndex & index , const QVariant & value , int role = Qt::EditRole)
virtual void	setTable (const QString & table )

• 27 public functions inherited from QSqlTableModel
• 16 public functions inherited from QSqlQueryModel
• 4 公共函数继承自 QAbstractTableModel
• 39 公共函数继承自 QAbstractItemModel
• 32 公共函数继承自 QObject

公共槽

virtual void

revertRow (int row )

• 6 public slots inherited from QSqlTableModel
• 2 公共槽继承自 QAbstractItemModel
• 1 公共槽继承自 QObject

重实现保护函数

virtual bool	insertRowIntoTable (const QSqlRecord & 值 )
virtual QString	orderByClause () const
virtual QString	selectStatement () const
virtual bool	updateRowInTable (int row , const QSqlRecord & 值 )

• 9 保护函数继承自 QSqlTableModel
• 3 保护函数继承自 QSqlQueryModel
• 19 保护函数继承自 QAbstractItemModel
• 9 保护函数继承自 QObject

额外继承成员

• 1 特性继承自 QObject
• 4 信号继承自 QSqlTableModel
• 18 信号继承自 QAbstractItemModel
• 2 信号继承自 QObject
• 11 静态公共成员继承自 QObject
• 9 保护函数继承自 QSqlTableModel
• 3 保护函数继承自 QSqlQueryModel
• 19 保护函数继承自 QAbstractItemModel
• 9 保护函数继承自 QObject
• 1 保护槽继承自 QAbstractItemModel

详细描述

The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support.

QSqlRelationalTableModel acts like QSqlTableModel , but allows columns to be set as foreign keys into other database tables.

The screenshot on the left shows a plain QSqlTableModel 在 QTableView . Foreign keys ( city and country ) aren't resolved to human-readable values. The screenshot on the right shows a QSqlRelationalTableModel , with foreign keys resolved into human-readable text strings.

The following code snippet shows how the QSqlRelationalTableModel was set up:

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

The setRelation () function calls establish a relationship between two tables. The first 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 名称 field to the user. The second call does something similar with column 3.

If you use a read-write QSqlRelationalTableModel , you probably want to use QSqlRelationalDelegate on the view. Unlike the default delegate, QSqlRelationalDelegate provides a combobox for fields that are foreign keys into other tables. To use the class, simply call QAbstractItemView::setItemDelegate () on the view with an instance of QSqlRelationalDelegate :

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

The relationaltablemodel example illustrates how to use QSqlRelationalTableModel in conjunction with QSqlRelationalDelegate to provide tables with foreign key support.

注意事项：

• The table must have a primary key declared.
• The table's primary key may not contain a relation to another table.
• If a relational table contains keys that refer to non-existent rows in the referenced table, the rows containing the invalid keys will not be exposed through the model. The user or the database is responsible for keeping referential integrity.
• If a relation's display column name is also used as a column name in the relational table, or if it is used as display column name in more than one relation it will be aliased. The alias is the relation's table name, display column name and a unique id joined by an underscore (e.g. tablename_columnname_id). QSqlRecord::fieldName () will return the aliased column name. All occurrences of the duplicate display column name are aliased when duplication is detected, but no aliasing is done to the column names in the main table. The aliasing doesn't affect QSqlRelation ，所以 QSqlRelation::displayColumn () will return the original display column name.
• The reference table name is aliased. The alias is the word "relTblAl" and the relationed column index joined by an underscore (e.g. relTblAl_2). The alias can be used to filter the table (For example, setFilter ("relTblAl_2='Oslo' OR relTblAl_3='USA'")).
• 当使用 setData () the role should always be Qt::EditRole , and when using data () the role should always be Qt::DisplayRole .

另请参阅 QSqlRelation , QSqlRelationalDelegate ，和 关系表模型范例 .

成员类型文档编制

enum QSqlRelationalTableModel:: JoinMode

常量	值	描述
QSqlRelationalTableModel::InnerJoin	0	- Inner join mode, return rows when there is at least one match in both tables.
QSqlRelationalTableModel::LeftJoin	1	- Left join mode, returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).

该枚举在 Qt 4.8 引入或被修改。

另请参阅 QSqlRelationalTableModel::setJoinMode ().

成员函数文档编制

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

创建空 QSqlRelationalTableModel and sets the parent to parent and the database connection to db 。若 db is not valid, the default database connection will be used.

[虚拟] QSqlRelationalTableModel:: ~QSqlRelationalTableModel ()

销毁对象并释放任何分配资源。

[虚拟] void QSqlRelationalTableModel:: clear ()

重实现自 QSqlQueryModel::clear ().

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

重实现自 QAbstractItemModel::data ().

另请参阅 setData ().

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

重实现自 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 () 和 QSqlRelation::isValid ().

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

返回 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 () 和 relation ().

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

重实现自 QAbstractItemModel::removeColumns ().

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

重实现自 QSqlTableModel::revertRow ().

[虚拟] bool QSqlRelationalTableModel:: select ()

重实现自 QSqlTableModel::select ().

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

重实现自 QSqlTableModel::selectStatement ().

[虚拟] 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 到 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.

返回 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 ()，和 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.

该函数在 Qt 4.8 引入。

另请参阅 QSqlRelationalTableModel::JoinMode .

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

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

范例：

    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 名称 field to the user.

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

另请参阅 relation ().

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

重实现自 QSqlTableModel::setTable ().

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

重实现自 QSqlTableModel::updateRowInTable ().