DAO:
List<String> getNameByType(String type);
原Mapper:
<select id="getNameByType" resultType="String" parameterType="String">
select name from t_people
where
<if test="type == null">
type is null
</if>
<if test="type != null">
type = #{type}
</if>
</select>
如果只传入一个 String 类型的参数,那么应该把 select 配置中所有用到 type 参数的地方都改成 _parameter
新Mapper:
<select id="getNameByType" resultType="String" parameterType="String">
select name from t_people
where
<if test="_parameter == null">
_parameter is null
</if>
<if test="_parameter != null">
type = #{_parameter}
</if>
</select>