qt中事务的示例

 代码来源:https://forum.qt.io/topic/109778/qsqldatabase-sqlite-transaction-inside-of-qsqlquery-how/3

auto db = QSqlDatabase::database("my connection name");

if(db.transaction())
{
    QSqlQuery query(db);
    // do stuff 做一些事务,比如下面的这条
    query.execute("INSERT INTO log (value1,value2,value3) VALUES (1,2,3);");

   if(!db.commit())
   {
        qDebug() << "Failed to commit";
        db.rollback();
   }
}
else
{
    qDebug() << "Failed to start transaction mode";
}