private String id;
private String code;
// ID列表
private List<String> idList;
// code 列表
private List<String> codeList;
// 外部 code列表
private List<String> codeExpList;
<!-- 这段代码有问题! -->
<sql id="listByWhereConditionSQL" >
<if test="idList != null" >
AND id IN
<foreach collection="idList" open="(" separator="," item="id" close=")">
#{id , jdbcType=VARCHAR }
</foreach>
</if>
<if test="codeList != null" >
AND code IN
<foreach collection="codeList" open="(" separator="," item="code" close=")">
#{code , jdbcType=VARCHAR }
</foreach>
</if>
<if test="id != null" >
AND id =#{id}
</if>
<if test="code != null" >
AND code =#{code}
</if>
</sql>