QSqlDatabase db = QSqlDatabase ::addDatabase( "QSQLITE") It is defined in the connection.h file which is located in the sql example directory (all the examples in the sql directory use this function to connect to a database). The createConnection() function is a helper function provided for convenience. For that reason we need to declare a submit() slot in additon to the model and the editor's buttons.īefore we can use the TableEditor class, we must create a connection to the database containing the table we want to edit: int main( int argc, char *argv ) We are also going to show how a table view can be used to cache any changes to the data until the user explicitly requests to submit them. It is build on top of the lower-level QSqlQuery class which provides means of executing and manipulating SQL statements. The QSqlTableModel class provides an editable data model making it possible to read and write database records from a single table. Note the QSqlTableModel variable declaration: As we will see in this example, the QSqlTableModel class can be used to provide data to view classes such as QTableView. The other is a pointer to the parent widget and is passed on to the base class constructor. The TableEditor constructor takes two arguments: The first is a reference to the database table the TableEditor object will operate on. Explicit TableEditor( const QString &tableName, QWidget *parent = nullptr)
0 kommentar(er)
