参数 List“> countryCodesList ”

[[US,ZH,XX],[ALL]]

ibatis 中



authCountryCodes like '%|' || #countryCodesList[][]# || '|%'

如下是生成的脚本
(

(

authCountryCodes like '%|' || ? || '|%'

and

authCountryCodes like '%|' || ? || '|%'

and

authCountryCodes like '%|' || ? || '|%'

)

or

(

authCountryCodes like '%|' || ? || '|%'

)

)

[2015-08-27 15:27:42.691 ,WARN ,Portal,504016000001508271527390043001,http-bio-11100-exec-11,null]:Content=Exception, cause is:
com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred while applying a parameter map.

--- Check the ProjectPackageContentext.queryCount-InlineParameterMap.

--- Check the parameter mapping for the 'countryCodesList[0][0]' property.

--- Cause: java.lang.NullPointerException

ibatis 中



authCountryCodes like '%|' || #countryCodesList[][]# || '|%'

 <select id="whereSelect" parameterType="java.util.Map" resultType="StudyMybatisMap">  
118.        select * from studymybatis where studymybatis_classid in  
119.        <foreach collection="array" index="index" item="item" open="(" separator="," close=")">  
120.            #{item}  
121.        </foreach>  
122.    </select>