Mybatis中为Mapper中传入多个值

1.通过顺序

 ​ <select id = "selectTest" resultMap = "SysResult">
     select * from user where name = #{0} and dept = #{1}
 </select>

在#{}中的数字代表了传递参数的顺序，一般不建议使用

2.通过@Param

 public User selectTest(@Param("UserName") String name,@Param("deptID") int deptId)
 <select id = "selectTest" resultMap = "UserResult">
     select * from user where name = #{userName} and dept = #{deptId}
 </select>

其中，#{}中的字符串就是@Param修饰的变量名称，适用于参数较少的情况

3.通过Map

 public User selectTest(Map<String,String> items);
 ​
 <select id = "selectTest" parameterType = "java.util.Map" resultMap = "UserResult">
     select * from use