ibatis多条件查询

方式一：

xml文件写法

<!-- user.xml --><select id="selectUsersByCondition" parameterClass="java.util.HashMap" resultMap="UserResult"><![CDATA[select  ID as id, NAME as name, AGE as agefrom 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);