<select id="getByNameAndPwd" parameterType="String" resultMap="MemberResult">
select
*
from `member`
<if test="isMerch != '' and isMerch == '1'.toString() " >
where `mobile` = #{name}
and `password` = #{password}
</if>
<if test="isMerch != '' and isMerch == '2'.toString() " >
where `name` = #{name}
and `password` = #{password}
select
*
from `member`
<if test="isMerch != '' and isMerch == '1'.toString() " >
where `mobile` = #{name}
and `password` = #{password}
</if>
<if test="isMerch != '' and isMerch == '2'.toString() " >
where `name` = #{name}
and `password` = #{password}
</if>
</select>
如上所示:要在数字字符串后面加.toString()方法,否则将无法识别。