QSqlQuery query; query.setForwardOnly(true); query.exec("SELECT * FROM customers"); while (query.next()) { // process each row }
QSqlQuery query; query.setForwardOnly(true); query.prepare("SELECT name, age FROM employees WHERE department = ?"); query.addBindValue("Human Resources"); query.exec(); while (query.next()) { QString name = query.value(0).toString(); int age = query.value(1).toInt(); // process each row }In this example, we use a prepared statement to retrieve only the name and age columns from the employees table for a specific department. We bind the department parameter using the addBindValue function, and then we execute the SELECT query. We then iterate through the result set and retrieve the name and age values using the value function. Package library: QtSql.