mybatis xml代码：

  <select id="selectInXh" resultMap="BaseResultMap" parameterType="java.lang.String">
    select *
    from carinfo
    where
	<if test="param1 != null and param1 != ''">
		xh in
		<foreach item="item" index="index" collection="param1.split(',')" open="(" separator="," close=")">
			#{item}
		</foreach>
	</if>
	<if test="param1 == null or param1 == ''">
		xh = null
	</if>
  </select>

mybatis sql打印：

==>  Preparing: select * from carinfo where xh in ( ? , ? ) 
==> Parameters: 1(String), 2(String)