mybatis传递多个参数

mybatis传递多个参数
    1、序号传递多个参数
        WHERE id=#{arg0} AND username=#{arg1}

 User getUser(Integer id, String username);

 <select id="getUser" resultType="com.by.pojo.User">
            SELECT * FROM user
            WHERE id = #{arg0} AND username = #{arg1}
        </select>

        WHERE id=#{param1} AND username=#{param2}

​
 User getUser(Integer id, String username);

​

 <select id="getUser" resultType="com.by.pojo.User">
            SELECT * FROM user
            WHERE id = #{param1} AND username = #{param2} <!--param1 param2 param3 ...-->

        </select>

    2、注解传递多个参数---【推荐】
        User getUser2(@Param("id") Integer id, @Param("username") String username);
        select * from user where id=#{id} and username=#{username}

​
    User getUser1(@Param("id")Integer id,
                  @Param("username")String username);
​

      <select id="getUser1" resultType="com.by.pojo.User">
            SELECT * FROM user
            WHERE id = #{id} AND username = #{username}

        </select>

    3、pojo传递多个参数---【推荐】
        User getUser3(User user);
        select * from user where id=#{id} and username=#{username}

 User getUser2(User user);

    <select id="getUser2" resultType="com.by.pojo.User" parameterType="com.by.pojo.User">
        SELECT * FROM user
        WHERE id = #{id} AND username = #{username}

    </select>

    4、map传递多个参数
        User getUser3(Map user);
        select * from user where id=#{

  User getUser3(Map<String, Object>map);

 

       <select id="getUser3" resultType="com.by.pojo.User" parameterType="java.util.Map">
            SELECT * FROM user
            WHERE id = #{id} AND username = #{username}

        </select>