mybatis参数绑定

1、mapper方法多个参数，@Param注解

List<InvestmentAnalysis> queryGSManagers(@Param("dto")InvestmentAnalysisDto dto, @Param("managers")List<String> managers) throws Exception;

<select id="queryQYManagers" resultMap="BaseResultMap">
    WITH
    T1 AS
    (
    SELECT
    A.VC_MANAGER,
    A.D_DATE,
    A.F_SYL_Y,
    A.VC_MANAGER_TYPE
    FROM TPP_DW.RT_ANALYSIS_MANAGER_RETURN   A
    WHERE  (
    A.D_DATE >= TRUNC(TO_DATE(#{dto.dDate},'yyyy-mm-dd'),'Y')
    OR
    A.D_DATE >= TRUNC(TO_DATE(#{dto.startDate},'yyyy-mm-dd'),'Y')
    )
    )
    SELECT
    A.VC_MANAGER,
    A.D_DATE,
    ROUND(A.F_SYL_Y,4)   F_SYL_Y
    FROM T1   A
    WHERE   (CASE WHEN A.VC_MANAGER_TYPE = 1 THEN 'QY'
    ELSE                            'GS'
    END ) = 'QY'
    AND  A.VC_MANAGER IN
    <foreach collection="managers" item="manager" open="(" close=")" separator=",">
      #{manager}
    </foreach>
    ORDER BY A.VC_MANAGER,A.D_DATE
</select>