错误写法:
<select id="getRiskMember" resultMap="BaseResultMap" parameterType="java.lang.String">
<include refid="selectMember"/>
<choose>
<when test="username != null">
and username = #{username}
</when>
<otherwise>
and safetylevel > 1
</otherwise>
</choose>
</select>
正确写法:
<select id="getRiskMember" resultMap="BaseResultMap" parameterType="java.lang.String">
<include refid="selectMember"/>
<choose>
<when test="_parameter != null">
and username = #{username}
</when>
<otherwise>
and safetylevel > 1
</otherwise>
</choose>
</select>
原因分析:当传入参数为字符串时,可将 test="username != null" 换成test="_parameter != null" 即可