上传者: 42191480
|
上传时间: 2021-11-17 15:13:41
|
文件大小: 201KB
|
文件类型: -
QSqlQuery(批量插入)
//批量插入数据
QSqlQuery query;
query.prepare("insert into myTable values (?, ?)");
QVariantList ints;
ints << 1 << 2 << 3 << 4;
query.addBindValue(ints);
QVariantList names;
names << "Harald" << "Boris" << "Trond" << QVariant(QVariant::String);
query.addBindValue(names);
if (!query.execBatch())
{
qDebug() << query.lastError();
}