#include#include #include int main() { // Connect to the database QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("localhost"); db.setDatabaseName("mydatabase"); db.setUserName("root"); db.setPassword("mypassword"); if (!db.open()) { qDebug() << "Failed to open database connection!"; return 1; } // Execute a simple SELECT statement QSqlQuery query("SELECT * FROM mytable"); while (query.next()) { QString name = query.value("name").toString(); int age = query.value("age").toInt(); qDebug() << "name: " << name << ", age: " << age; } // Close the database connection db.close(); return 0; }
// Connect to the database QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("localhost"); db.setDatabaseName("mydatabase"); db.setUserName("root"); db.setPassword("mypassword"); if (!db.open()) { qDebug() << "Failed to open database connection!"; return 1; } // Prepare a statement with placeholders QSqlQuery query; query.prepare("INSERT INTO mytable (name, age) VALUES (:name, :age)"); query.bindValue(":name", "John"); query.bindValue(":age", 30); query.exec(); // Close the database connection db.close();These examples demonstrate the use of the QSqlQuery class for executing SQL queries and preparing parameterized statements. The package library for QSqlQuery is the Qt SQL module.