1.mapper如何按要求遍历数组,当数组为空,如何让他不遍历
<select id="getAllData" resultMap="ckCkdx"> select CKLSH,ZJLX,ZJHM,MC,CBR,SJY,HJSZD,GJ,ZT,AH,FYDM,DJPC,SSDW,CKFW,LASTUPDATE from CK_CKDX <where> <if test="zt!=null and zt!=''"> AND ZT in <foreach collection="zt.split(',')" item="zt" open="(" close=")" separator=","> #{zt} </foreach> </if> <if test="ah!=null and ah!=''"> AND AH LIKE CONCAT(#{ah},'%') </if> <if test="mc!=null and mc!=''"> AND MC LIKE CONCAT(#{mc},'%') </if> <if test="zjhm!=null and zjhm!=''"> AND ZJHM LIKE CONCAT(#{zjhm},'%') </if> </where> ORDER BY LASTUPDATE DESC limit #{start},#{limit} </select>