How to connect a database in QT and send data there?

Question

MySQL

Can you please tell me how to connect a database in QT and send there read values ​​entered by the user in the fields of the program?

Answer 1

Connect to base

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL","CurrentThread");
db.setDatabaseName("table");
db.setUserName("username");
db.setHostName("localhost");
db.setPassword("123456");
db.open();

Send request

QSqlQuery query(db);
if(query.exec("SELECT * FROM `Users`"))
while(query.next())
{
//query.record().value("Name").toString();
}