效果图:
实现方法:
前台:
{align : 'center' , width: '25%' , field: 'filename', title: '检验资质', templet:function(d){
if(d.filename!=null && d.filename !='undefined'){
var fileName = "";
//后台取到的文件名、文件路径通过顿号拼接,在前台拆分
var filename =d.filename.split("、");
var filepath =d.filepath.split("、");
for(var i in filename){
//循环拆分并拼成a标签
fileName+= "<a href='/fileDownload/download?fileName="+encodeURI(filename[i]) +"&filePath=" + filepath[i] + "'>" + filename[i] + "</a></br>"
}
return fileName;
}else return "";
}
后台实现:
SQL语句将查询结果拼接起来
//取
"FILEPATH.FILE_NAME fileName,FILEPATH.FILE_PATH filePath " +
//拼接 运用了KingBase的拼接函数 String—_AGG
(SELECT ATTACHMENT.BUZ_ID, STRING_AGG(ATTACHMENT.ATTACHMENT_NAME, " +
"'、' ORDER BY ATTACHMENT.ID )FILE_NAME, STRING_AGG(ATTACHMENT.ATTACHMENT_PATH, " +
" '、' ORDER BY ATTACHMENT.ID )FILE_PATH " +