[Mybatis] SQL에서 WHERE 절 안에 in 처리하기

SQL in 조건이니 넘기는 변수는 List 

 

 

Service

  public List<Goods> findGoodsByIds(List<Long> goodsIds) {
    return lookupRepository.findGoodsByIds(goodsIds);
  }

 

 

 

Mybatis Mapper.xml

foreach 돌리기 !!

   <select id="findGoodsByIds"
            parameterType="java.lang.Long"
            resultType="com.musinsa.domain.stock.entity.Goods"
            resultMap="goodsResultMap">
        SELECT
            goods_number,
            goods_name,
            style_number,
            company_id,
            company_name,
            brand_id,
            brand_name
        FROM goods
        WHERE goods_number in
        <foreach collection="goodsIds" item="goodsId" open="(" close=")" separator=",">
            #{goodsId}
        </foreach>
        ;
    </select>