Mapper接口参数是多个参数的获取
1.mybatis在处理多个参数时,会将多个参数保存到猫集合中会 以 agr0 ,agr1或param1 param2为键 以参数位置进行存储。
例如:
在接口中:
User selectUserByUserNameAndPassword(String username,String password);
对应的sql语句:
<select id="selectUserByUserNameAndPassword" resultType="user">
select * from user where user_name = #{arg0} and password = #{arg1}
</select>
2.通过注解@param("键名")设置参数的获取名字
在接口中:
User selectUserByUserNameAndPassword(@param("username")String username,(@param("password")String password);
对应的sql语句:
<select id="selectUserByUserNameAndPassword" resultType="user">
select * from user where user_name = #{username} and password = #{password}
</select>
或者
<select id="selectUserByUserNameAndPassword" resultType="user">
select * from user where user_name = #{param1} and password = #{param2}
</select>