使用koa 搭建后台时,有个点赞需求需要两条sql语句执行,我在数据库里执行两条语句都能正确返回结果,
但是在Service层里包装语句后去执行query()函数,后台给我返回错误:球球大家
- 这是Service层代码 ``` const query = require('../allServices');
module.exports = async(_arr) => {
//console.log(_arr) [2,2,2,'2019-08-28 10:37:23.352','评论']
let _sql = 'update comments set comment_like_count = comment_like_count +'+ 1 +' where id = ?;'+
'insert into likes (theme_id,user_id,like_time,blogOrCom) values (?,?,?,?);';
return query(_sql, _arr);
}
* 这是query函数
const mysql = require('mysql');
const config = require('../config/config');
let pool = mysql.createPool({
host: config.database.HOST,
user: config.database.USERNAME,
password: config.database.PASSWORD,
database: config.database.DATABASE
});
let query = function(sql,values){
return new Promise((resolve, reject) => {
pool.getConnection(function(err, connection) {
if(err) {
reject(err);
}else {
connection.query(sql, values, (err, rows, fields) => {
if(err) {
reject(err);
}else {
resolve(rows);
}
connection.release();//结束会话
})
}
})
})
}
module.exports = query;
* 这是报错截图
![图片说明](https://img-ask.csdn.net/upload/201908/28/1566961717_980431.jpg)