请教一下回调函数
寂寞花如雪 2019-08-01 10:52:08 想请教一下像这种回调函数,该怎么把create接收到对象传到外层去
//3.访问数据库
conn.query(sql, function (err, result) {
if (!err) {
if (result == "") {
create(function(obj){
return obj;
});
} else {
obj.code = '501';
obj.msg = "用户名重复";
}
} else {
console.log('访问数据库出错:', err.message);
obj.code = 409;
obj.msg = "注册失败";
}
res.send(JSON.stringify(obj));
});
//4.关闭数据库连接
conn.end();
function create(fn) {
//sql语句
var sql = `insert into test.user (name,pwd,address) values ('${name}','${pwd}','${address}');`;
var obj = {};
//1.创建连接
var conn = mysql.createConnection({
host: config.host,
user: config.user,
password: config.password,
database: config.database
});
//2.建立连接
conn.connect();
//3.访问数据库
conn.query(sql, function (err, result) {
if (!err) {
obj.code = '202';
obj.msg = "注册成功";
} else {
console.log('访问数据库出错:', err.message);
obj.code = 409;
obj.msg = "注册失败";
}
fn(obj);
});
//4.关闭数据库连接
conn.end();
}