QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName(":memory:"); if (!db.open()) { qDebug() << "Failed to open database"; return -1; } QSqlQuery query(db); query.prepare("INSERT INTO mytable (name, age) VALUES (:name, :age)"); query.bindValue(":name", "John"); query.bindValue(":age", 30); if (!query.exec()) { qDebug() << "Failed to execute query"; } query.prepare("SELECT * FROM mytable WHERE age > :age"); query.bindValue(":age", 25); if (query.exec()) { while (query.next()) { qDebug() << query.value(0).toString() << query.value(1).toInt(); } }
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setDatabaseName("mydatabase"); db.setHostName("localhost"); db.setUserName("myusername"); db.setPassword("mypassword"); if (!db.open()) { qDebug() << "Failed to open database"; return -1; } QSqlQuery query(db); if (query.exec("SELECT * FROM mytable")) { QSqlRecord record = query.record(); qDebug() << "There are" << record.count() << "columns in the query result"; for (int i = 0; i < record.count(); ++i) { qDebug() << "Column" << i << "name is" << record.fieldName(i) << "of type" << record.field(i).type(); } }The QSqlQuery class is part of the Qt Sql module, which is included in the Qt core library. Therefore, the package library required to use QSqlQuery is the Qt core library.