10/04/20 21:26:53
>>241
解決しました! 爆速ですw 本当にありがとうございました!!!
#include <QtCore>
#include <QtSql>
#include <iostream>
int main(int argc, char **argv){
QCoreApplication app(argc, argv);
std::cout << "start" << std::endl;
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("test.db");
if(!db.open()){
//
}else{
db.transaction();
QSqlQuery q;
q.exec("create table testtable (id integer primary key,"
" c1 varchar(255), c2 varchar(255), c3 integer);");
for(int i = 0; i < 500; ++i){
QString s(QObject::tr("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"));
QString v(QObject::tr("'%1', '%2', %3").arg(s).arg(s).arg(i));
q.exec(QObject::tr("insert into testtable (c1, c2, c3) values (%1);")
.arg(v));
}
q.clear();
if(!db.commit()) db.rollback();
db.close();
}
std::cout << "end" << std::endl;
return app.exec();
}