February 2019
Beginner
136 pages
3h 7m
English
In the previous section, we saw how to access the database using the model as an abstraction. Now, we shall try to link it with a model for display. Using the code listing from the previous section, modify main.cpp to appear as follows:
#include <QApplication>#include <QtSql>#include <QVBoxLayout>#include <QPushButton>#include <QDebug>#include <Qt>#include <QTableView>#include <QHeaderView>int main(int argc, char *argv[]){ QApplication app(argc, argv); // Setup db connection QSqlDatabase db_conn = QSqlDatabase::addDatabase("QMYSQL", "contact_db"); db_conn.setHostName("127.0.0.1"); db_conn.setDatabaseName("contact_db"); db_conn.setUserName("root"); db_conn.setPassword(""); db_conn.setPort(3306); // Error checks if (!db_conn.open()) ...Read now
Unlock full access