这里我们介绍三种方法:
List<User> selectUserAnd(int age, String gender);
List<User> selectUserMap(Map<String, Object> user);
List<User> selectUserAite(@Param("age") int age, @Param("gender") String gender);
分别是直接传入:
但是再xml配置时,参数名只能为:arg1,arg0,param1,param2
使用map进行映射:
key值便是xml的参数名
使用注解:
通过注解,直接给定参数名
xml配置:
<select id="selectUserAnd" resultType="com.quxiao.mybatis.pojo.User">
select *
from user
where age = #{param1}
and gender = #{param2};
</select>
<select id="selectUserMap" resultType="com.quxiao.mybatis.pojo.User">
select *
from user
where age = #{age}
and gender = #{gender}
</select>
<select id="selectUserAite" resultType="com.quxiao.mybatis.pojo.User">
select *
from user
where age = #{age}
and gender = #{gender}
</select>