我的查询语句是这样SELECT cas_file_no,cas_typ_bid,cas_code,cas_name,SUBSTRING_INDEX(c.att_path, '/', -1) AS path_name,REPLACE(CONCAT('https://192.168.28.8:8443/CCDS/downloadAction.do?op=getStreamlnfo&fileId=',COALESCE(c.att_id, ''),'&path=',COALESCE(c.att_path, '')),'/vis/','%2Fvis%2F') AS pathFROM DY_BANK_CASE_NEW aLEFT JOIN DY_VIS_RECORD b ON a.cas_id = b.vr_cas_idLEFT JOIN DY_ATTACHMENT_NEW c ON b.vr_id = c.att_fk_idWHERE a.cas_file_no = '${cas_no}'and cas_typ_bid='${cas_typ}';在网页上的展示是这样想要的效果是点击路径是可以在线查看后面链接图片,应该怎么做?完整路径是:REPLACE(CONCAT('https://192.168.28.8:8443/CCDS/downloadAction.do?op=getStreamlnfo&fileId=',COALESCE(c.att_id, ''),'&path=',COALESCE(c.att_path, '')),'/vis/','%2Fvis%2F') AS path数据路径是截取出来的:SUBSTRING_INDEX(c.att_path, '/', -1) AS path_name