Mabatis传多个参数

Mabatis传多个参数

方案一：

PublicUser selectUser(String name,String area)

<selectid="selectUser" resultMap="BaseResultMap">

    select *  from user_user_t   whereuser_name = #{0} and user_area=#{1}

</select>

方案二；

PublicUser selectUser(Map paramMap);

<select id="selectUser" resultMap="BaseResultMap">

   select  *  from user_user_t   where user_name =#{userName，jdbcType=VARCHAR} anduser_area=#{userArea,jdbcType=VARCHAR}

</select>

方案三：

PublicUser selectUser(@param(“userName”)Stringname,@param(“userArea”)String area);

<select id="selectUser" resultMap="BaseResultMap">

   select  *  from user_user_t   where user_name =#{userName，jdbcType=VARCHAR} anduser_area=#{userArea,jdbcType=VARCHAR}

</select>