业务场景,在sql中进行字符串的拼接,当时写的sql在数据库中运行可以查到数据,因此没有考虑sql,问题,一直在考虑参数绑定的问题,
<select id="getProgramMenuDataList" resultType="com.iboyaa.synthetical.entity.dto.ProgramMenuDTO">
SELECT DISTINCT pm.id, pm.menuname ,c.value AS programtype ,u.username as operator,pm.createtime
,pm.modifytime,c1.value as statusname, s.name as servername ,
<!--<!–-CONCAT('/',t.serverid,'/',REPLACE(t.thumbsrc,'\\','/')) as thumbsrcName ->-->
CONCAT(CONCAT('/',t.serverid,'/',REPLACE(t.thumbsrc,'\\','/'))) as thumbsrcName
from
zs_program_menu_info pm
LEFT JOIN zs_program_menu_dtl pmd ON pmd.menuid = pm.id
LEFT JOIN zs_program_info p on p.id = pmd.programid
LEFT JOIN (SELECT code,VALUE from zs_code where type = '' )c ON c.code = pm.category
LEFT