QSqlQuery query; QStringList values = {"Alice", "Bob", "Charlie"}; QStringList queries; for (const auto& value : values) { queries.append(QString("INSERT INTO users (name) VALUES ('%1')").arg(value)); } if (query.execBatch(queries)) { qDebug() << "Insertion successful"; } else { qCritical() << "Insertion failed:" << query.lastError().text(); }
QSqlQuery query; QStringList values = {"Alice", "Bob", "Charlie"}; QStringList queries; for (const auto& value : values) { queries.append(QString("UPDATE users SET age = %1 WHERE name = '%2'").arg(qrand() % 50 + 20).arg(value)); } if (query.execBatch(queries)) { qDebug() << "Update successful"; } else { qCritical() << "Update failed:" << query.lastError().text(); }In this example, a QStringList of values is defined, and SQL update statements are generated for each value using a loop. The queries are then passed to execBatch, which executes them as a batch. Package Library: Qt (specifically, the Qt SQL module)