SQL in 조건이니 넘기는 변수는 List Service public List findGoodsByIds(List goodsIds) { return lookupRepository.findGoodsByIds(goodsIds); } Mybatis Mapper.xml foreach 돌리기 !! SELECT goods_number, goods_name, style_number, company_id, company_name, brand_id, brand_name FROM goods WHERE goods_number in #{goodsId} ;