参数
Map<String,Object> map = new HashMap<>();
map.put("intentionPosition",postition);
接口
List<Bean> rows=beanService.listTalentScreen(map);
BeanMapper.xml
<select id="listTalentScreen" parameterType="Map" resultMap="BeanResult">
a.*
from table a
where 1=1
<if test="intentionPosition!=null and intentionPosition!='' ">
and a.intention_position LIKE CONCAT(CONCAT('%',#{intentionPosition},'%'))
</if>
</select>
CONCAT(’%’,#{intentionPosition},’%’) :防止sql注入