intret; ret =sqlite3_exec(db,"begin transaction",0,0,&zErrorMsg );//开始一个事务 ret =sqlite3_exec(db,"commit transaction",0,0,&zErrorMsg );//提交事务 ret =sqlite3_exec(db,"rollback transaction",0,0,&zErrorMsg );
例程:在进行大量的操作前使用如下语句
ret =sqlite3_exec(db,"begin transaction",0,0,&zErrorMsg); for(...) { //insert into operate //如果操作错误 ret =sqlite3_exec(db,"rollback transaction",0,0,&zErrorMsg ) } ret =sqlite3_exec(db,"commit transaction",0,0,&zErrorMsg );