详解Mybatis多参数传递入参四种处理方式

<select id="MutiParameter" resultType="com.jt.mybatis.entity.User">
  select * from user where id = #{param1} and username = #{param2}
</select>

@Select("select * from user where id = #{arg0} and username = #{arg1}")
User MutiParameter(int id,String username);

<select id="MutiParameter" resultType="com.jt.mybatis.entity.User">
  select * from user where id = #{id} and username = #{username}
</select>

@Select("select * from user where id = #{id} and username = #{username}")
User MutiParameter(@Param("id")int id,@Param("username")String username);

<select id="MutiParameter" resultType="com.jt.mybatis.entity.User">
  select * from user where id = #{id} and username = #{username}
</select>

@Select("select * from user where id = #{id} and username = #{username}")
User MutiParameter(Map<String, Object> params);

@Test
 public void testMutiParameter(){
  AuthorityMapper mapper = session.getMapper(AuthorityMapper.class);
  Map<String, Object> params = new HashMap<String, Object>();
  params.put("id", 2);
  params.put("username", "admin");
  mapper.MutiParameter(params);
 }

<select id="MutiParameter" resultType="com.jt.mybatis.entity.User">
  select * from user where id = #{id} and username = #{username}
</select>

@Select("select * from user where id = #{id} and username = #{username}")
User MutiParameter(User user);

   @Test
     public void testMutiParameter(){
      AuthorityMapper mapper = session.getMapper(AuthorityMapper.class);
      User user = new User();
      user.setId(2);
      user.setUsername("admin");
      mapper.MutiParameter(user );
     }