Table and form views

This section is devoted to explaining the representation of data in a form view or a table view. But, before that, we can look at some examples of accessing databases through high-level model classes. The following classes are available in Qt for this purpose.

• QSqlQueryModel: This provides a read-only data model for SQL result sets

• QSqlTableModel: This provides an editable data model for a single database table

• QSqlRelationalTableModel: This provides an editable data model for a single database table with foreign key support

Let's view some quick examples of each of these classes.

QSqlQueryModel

This model aims at providing a high-level interface to execute SQL queries and traverse the result set. This class is built on top of the QSqlQuery class and can be used to provide data to view classes, such as QTableView, which we are going to discuss in the forthcoming sections. A sample program using QSqlQueryModel is given as follows:

model = QSqlQueryModel()
model.setQuery(...