Cập nhật cho các tập dữ liệu ngay khi người sử dụng chọn một tập dữ liệu có nghĩa là, một dòng trong xem. SqlTableModel:: OnFieldChange này chuyển mọi thay đổi cơ sở dữ liệu trực tiếp sau khi người dùng đã thay đổi một giá trị trong một lĩnh vực. | Using SQL Model Classes with Interview UPDATE for the dataset as soon as the user selects another dataset-that is another row in the view. Sq lTableModel OnFieldChange This transfers every change to the database directly after the user has changed a value in a field. SqlTableModel OnManualSubmit This temporarily saves all changes in the model until either the submitAll slot which transfers all changes to the database or the revertAll slot is triggered. The latter rejects all cached data and restores the status from the database see Chapter on page 270 for more on the revertAll slot . We will illustrate this last scenario by modifying the example from page 265 so that it additionally contains two buttons that are arranged in a layout beneath the table view. All other commands are left as they are. sqlmvd continued QWidget w QPushButton submitPb new QPushButton QObject tr Save Changes QPushButton revertPb new QPushButton QObject tr Roll back changes QGridLayout lay new QGridLayout w QTableView manualTableView new QTableView lay- addWidget manualTableView 0 0 1 2 lay- addWidget submitPb 1 0 lay- addWidget revertPb 1 1 QSqlTableModel manualTableModel employees QSqlTableModel OnManualSubmit manualTableView- setModel manualTableModel QObject connect submitPb SIGNAL clicked bool manualTableModel SLOT submitAll QObject connect revertPb SIGNAL clicked bool manualTableModel SLOT revertAll manually revertable table return After converting the editing strategy to OnManualSubmit we insert two signal slot connections A click on the submitPb button calls the submitAll slot whereas revertPb triggers revertAll . 269 I Ị 9 The QtSql Module Figure With the OnManualSubmit editing strategy local changes can be transferred at any time you want to the database. manually revertable table _ n X Id lastname firstname department 1 1 Werner Max 1 2 2 .
