[mybatis] mybatis parameter가 2개 이상일 경우 사용방법

📢 mybatis parameter가 2개 이상일 경우 사용방법

💡 parameterType="map"를 이용하면 된다.

    <select id="findById" parameterType="map" resultType="Member">
        SELECT
        <include refid="memberColumns" />
        FROM member
        WHERE id = #{id, jdbcType=BIGINT}
          and member_id = #{memberId, jdbcType=VARCHAR}
    </select>

✅ @Param 이용 

✔ Controller

memberService.findById(Long id, String memberId)

✔ Service

memberMapper.findById(Long id, String memberId)

✔ Mapper

Member findById(@Param("id") Long id, @Param("memberId") Long memberId);

✅ Map 이용 

✔ Controller

Map<String, Object> param = new HashMap<>();
param.put("id", id);
param.put("memberId", memberId);

memberService.findById(id, memberId);

✔ Service

memberMapper.findById(Map<String, Object> param)

✔ Mapper

Member findById(Map<String, Object> param)