Qt数据库模型

Qt中使用了自己的机制来避免使用SQL语句，为我们提供了更简单的数据库操作及数据显示模型，分别是

• 只读的QSqlQueryModel
• 操作单表的QSqlTableModel
• 可以支持外键的QSqlRelationalTableModel

QSqlQueryModel

The QSqlQueryModel class provides a read-only data model for SQL result sets.
QSqlQueryModel is a high-level interface for executing SQL statements and traversing the result set. It is built on top of the lower-level QSqlQuery and can be used to provide data to view classes such as QTableView.

示例

    QSqlQueryModel *model = new QSqlQueryModel;
    model->setQuery("SELECT name, salary FROM employee");
    model->setHeaderData(0, Qt::Horizontal, tr("Name"));
    model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

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

---

创建自定的QSqlQueryModel</