StudentMapper.xml文件中
<select id="query" parameterType="HashMap" resultType="student">
select stuno,stuname,stuage from student
where stuage = #{stuAge} or stuname like '%${stuName}%'
</select>
测试方法
Map<String,Object> studentMap = new HashMap<>();
studentMap.put("stuAge",24);
studentMap.put("stuName","zs");
List<Student> students = studentMapper.query(studentMap);
当输入对象为HashMap时,map中key的值会匹配占位符#{stuAge},如果匹配成功,就用map的value替换占位符。