MyBatis传递多个参数的方法

1.顺序传参法

dao层

public User selectUser(String name, int id);

mapper

<select id="select" resultMap="UserResultMap">
    select * from user
    where user_name = #{0} and id = #{1}
</select>

使用#{}里面的数字来指代dao的参数

2.@Param注解法

public User selectUser(@Param("name")String name,@Param("id") int id);

<select id="select" resultMap="UserResultMap">
    select * from user
    where user_name = #{name} and id = #{id}
</select>

 @Param括号中的名字即为mapper的名字

3.Map传参法

public User selectUser(Map<String,Object>param);

<select id="select" resultMap="UserResultMap">
    select * from user
    where user_name = #{name} and id = #{id}
</select>

 #{}中属性名即为Map的key值

4.JavaBean传参法

public User selectUser(User user);

 

<select id="select" resultMap="UserResultMap">
    select * from user
    where user_name = #{name} and id = #{id}
</select>

#{}中的属性属性名即为User对象中的属性