查询mysql数据库
anyDoctorByIds: async function(arr){
let pool = await mysql.pool("sql_main");
let sql ='SELECT * FROM doctor_account WHERE id IN ('+ arr +')';
return await mysql.query(pool, sql, []);
},
在controller中
var doctor = await hospitalDao.anyDoctorByIds("'14345262900310','1428658311672','1428657273817','15439906369986','14569899662405','14358811489424','15731799635497','14560550152247','15440807537797','15467425112312','15097079998657'");