qt中mysql怎么支持事务_Qt数据库查询之事务操作

if(QSqlDatabase::database().transaction()){boolres1,res2;

query.prepare("update booklist set borrowNum=?,restNum=? where bookId=?");

query.bindValue(0,++borrownum);

query.bindValue(1,--restnum);

query.bindValue(2,bookId);

res1=query.exec();//qDebug()<

query.prepare("insert into recordlist(bookId,bookName,borrowPeople,borrowTime,backTime,\

backState) values(?,?,?,?,?,?)");

query.bindValue(0,bookId);

query.bindValue(1,bookName);

query.bindValue(2,userName);

query.bindValue(3,borrowTime);

query.bindValue(4,"");

query.bindValue(5,0);

res2=query.exec();//qDebug()<

if(res1&&res2){if(!QSqlDatabase::database().commit()){

QMessageBox::critical(this,"Error","操作失败，将要回滚");if(!QSqlDatabase::database().rollback()){