router.post('/filedown',function(req, res, next) {
var abcrr = JSON.parse(req.body['name']);
var zongxrr = [];
for(var i=0; i<abcrr.length;i++){
var xrr = abcrr[i].join(",");
var userSql = 'select * from imagetomp3 where id=? and crr=?';
var param = ["abc",xrr];
selectdatabase(xrr,zongxrr,userSql,param);
}
async function selectdatabase(xrr,zongxrr,userSql,param){
var rows = await myquery(userSql, param);
for(var i=0; i<rows.length; i++){
var arr = [];
arr[0] = xrr;
arr[1] = rows[i].originalname;
arr[2] = rows[i].filename;
arr[3] = rows[i].originalname.substring(rows[i].originalname.length-4);
arr[4] = rows[i].originalname.substring(rows[i].originalname.indexOf('_')+1,rows[i].originalname.lastIndexOf("_"));
zongxrr.push(arr);
}
}
});
abcrr是前台传过来的数组,跟据数组的每个元素查找数据库,每个元素都会查到好几个数据库的row,把这些row通通push进 zongxrr.再传回前台,只是现在遇到异步问题,请问如何解决?
var abcrr = JSON.parse(req.body['name']);
var zongxrr = [];
for(var i=0; i<abcrr.length;i++){
var xrr = abcrr[i].join(",");
var userSql = 'select * from imagetomp3 where id=? and crr=?';
var param = ["abc",xrr];
selectdatabase(xrr,zongxrr,userSql,param);
}
async function selectdatabase(xrr,zongxrr,userSql,param){
var rows = await myquery(userSql, param);
for(var i=0; i<rows.length; i++){
var arr = [];
arr[0] = xrr;
arr[1] = rows[i].originalname;
arr[2] = rows[i].filename;
arr[3] = rows[i].originalname.substring(rows[i].originalname.length-4);
arr[4] = rows[i].originalname.substring(rows[i].originalname.indexOf('_')+1,rows[i].originalname.lastIndexOf("_"));
zongxrr.push(arr);
}
}
});
abcrr是前台传过来的数组,跟据数组的每个元素查找数据库,每个元素都会查到好几个数据库的row,把这些row通通push进 zongxrr.再传回前台,只是现在遇到异步问题,请问如何解决?
解决方案 »
- 这个JS该如何解密,有没有解密工具,大侠们!
- request.getParameter()对那些标签起作用?对radio不起作用?
- ====求Ext grid表格 PagingToolbar 分页实例代码====
- extjs 怎么实现在一个页面点击另一个页面的按钮,在线等
- 跪求一观看图片的js特效代码
- 关于层在窗口缩小后定位的问题(中高分求助)
- 在弹出子窗口后,在不关闭子窗口前怎样控制不让父窗口关闭和打开新页,也就是不让父窗口有任何操作,谢谢!
- 为什么调用showsign()失败,告诉我不能取得visibility 属性
- 显示隐藏菜单?
- 怎样用一个表单控制另一个表单!
- html实现从数据库读取图片列表进行轮播
- 关于js修改文本框状态
var abcrr = JSON.parse(req.body['name']);
var zongxrr = [];
for(var i=0; i<abcrr.length;i++){
var xrr = abcrr[i].join(",");
var userSql = 'select * from imagetomp3 where id=? and crr=?';
var param = ["abc", xrr];
await selectdatabase(xrr, userSql, param);
}
async function selectdatabase(xrr, userSql, param) {
var rows = await myquery(userSql, param);
for(var i=0; i<rows.length; i++){
var arr = [];
arr[0] = xrr;
arr[1] = rows[i].originalname;
arr[2] = rows[i].filename;
arr[3] = rows[i].originalname.substring(rows[i].originalname.length-4);
arr[4] = rows[i].originalname.substring(rows[i].originalname.indexOf('_')+1,rows[i].originalname.lastIndexOf("_"));
zongxrr.push(arr);
}
}
});