方式一:
xml文件写法
<!-- user.xml -->
<select id="selectUsersByCondition" parameterClass="java.util.HashMap" resultMap="UserResult">
<![CDATA[
select
ID as id,
NAME as name,
AGE as age
from
t_user
where id < #id# and age < #age#
]]>
</select>
java代码写法
HashMap<String, Object> map = new HashMap<String, Object>();
map.put("id", 5);
map.put("age", 24);
List list = sqlMapper.queryForList("selectUsersByCondition", map);