SELECT
        c.commodity_code AS commodityCode,
        CONCAT(tc.cate_name,',',tc1.cate_name, ',', tc2.cate_name) AS cateName
    FROM
       t_commodity c LEFT JOIN t_category tc ON c.commodity_first_id = tc.id
              LEFT JOIN t_category tc1 ON c.commodity_second_id = tc1.id
              LEFT JOIN t_category tc2 ON c.commodity_third_id = tc2.id
    WHERE
      c.commodity_code IN
        
          #[code]
        
  

package org.linuxsogood.es.statistical.handler;
 
import org.apache.ibatis.session.ResultContext;
import org.apache.ibatis.session.ResultHandler;
 
import java.util.HashMap;
import java.util.Map;
 
/**
 * @author honway
 * @date 2018/10/22 11:49.
 * @blog http://linuxsogood.org
 */
public class MapResultHandler implements ResultHandler {
 
  private final Map mappedResults = new HashMap();
 
  @Override
  public void handleResult(ResultContext resultContext) {
    Map m = (Map) resultContext.getResultObject();
    mappedResults.put(m.get("key"), m.get("value"));
  }
 
  public Map getMappedResults() {
    return mappedResults;
  }
}

@Service
public class GoodsSalesServiceImpl implements IGoodsSalesService {
 
  private final GoodsSalesMapper goodsSalesMapper;
  private final SqlSession sqlSession;
 
  @Autowired
  public GoodsSalesServiceImpl(GoodsSalesMapper goodsSalesMapper, SqlSession sqlSession) {
    this.goodsSalesMapper = goodsSalesMapper;
    this.sqlSession = sqlSession;
  }
 
  /**
   * 根据商品code查询商品的一二三级分类
   * @param commodityCodeList 商品code
   * @return 返回商品和分类的映射, key为商品code, value为商品的一二三级分类,用逗号隔开
   */
  @Override
  public Map processCateNameMappingByGoodsCodes(List commodityCodeList) {
    MapResultHandler handler = new MapResultHandler();
    sqlSession.select("com.tramy.es.statistical.dao.GoodsSalesMapper.processCateNameMappingByGoodsCodes",commodityCodeList ,handler);
    return handler.getMappedResults();
  }
}