mysql中有没有FM_mysql事务

原生mysql操作

var mysql = require('mysql');

var connection = mysql.createConnection(sqlServer);

connection.connect();

connection.beginTransaction(function(err) {

connection.query('INSERT INTO `text1` SET title=?', 'title3', function (error, results, fields) {

connection.commit()

connection.rollback(function() {

console.log('出现错误,回滚!');

});

connection.query('SELECT * FROM `text1`', function (error, results, fields) {

if (error) throw error;

console.log('The solution is: ', results);

});

})

})

使用第三方插件node-mysql-promise

var Mysql = require('node-mysql-promise');

var mysql = Mysql.createConnection(sqlServer);

mysql.startTrans().then(()=>{

var data = {title: '订单9'};

mysql.table('text1').add(data).then((insertId)=>{

// mysql.rollback()

//mysql.commit()

var date = {title: '订单10'};

mysql.table('text1').add(date).then((insertId)=>{

//mysql.rollback()

mysql.commit()

mysql.query('SELECT * FROM `text1`').then(function (data) {

console.log(data)

})

})

})

})