<!--查找某用户绑定的药物不良反应报告列表--> <select id="selectSurveyListByUserProId" resultType="java.util.HashMap"> SELECT id AS `id`,time AS `time`, usr_no AS `id_card_num`, creat_usr_no AS `creat_usr_no` FROM xy_survey <where> <f
mapper.xml文件中传入list参数,使用foreach循环遍历值,但是在遍历的过程中出错了,具体代码如下所示 mapper.xml <select id="selectByCondition2" resultType="java.util.Map"> select id,name from [dbo].[TB_LandInfectantData] where 1=1 and LandMonitoringUid in ( <foreach i
先看解决方案,其他的都是问题的出处 解决方案:if中使用 _parameter,#{value}不变 <if test="_parameter!='' and _parameter!=null"> join scm_product p on pt.ProductTypeID=p.ProductTypeID where (p.ProductNameCN like concat('%',#{value},'%') or p.ProductNameEN like concat('