Mysql传参list类型并且为空判断

前端传参source类型有空和weibo.com,qq.com两种类型，当source为空时默认查询所有的平台，有值时，查询带有值的平台；
后台接收参数：

@GetMapping("analysiSearch")
    public Object detailAnalysiSearch( @RequestParam(value = "id")String id, @RequestParam(value = "source",required = false)List<String> source){
        return yumcApiService.getSearchAnalysi(id,source);
    }

required = false，当source为空时则不接收。

 /**
     * 
     * @param tasteId 输入的规则ID
     * @param source 平台选择，不填或者为空默认所有平台；如果多个平台，则平台之间用英文逗号隔开，例如：xiaohongshu.com,qq.com
     * @return
     */
    List<MvTasteSource> volumeAll(@Param("tasteId") String tasteId,@Param("list") List<String> source);

@Param(“list”)为source传入的类型

<select id="hotList" resultMap="BaseResultMap">
    SELECT SUM
             ( taste_count ) AS tasteSum,
           taste_id
    FROM
    mv_taste_source
    WHERE
      data_time BETWEEN #{firstDay}::date
      AND #{lastDay}::date
    <if test="list != null">
      and data_source in
      <foreach collection="list" item="item" open="(" separator="," close=")" >
        #{item}
      </foreach>
    </if>
    GROUP BY
      taste_id
    ORDER BY
      tasteSum DESC
      limit 10
  </select>

list为mapper里面的传参，collection="list"为source类型，item="item"起的别名