@select注解 where in写法

@Select({

"<script>",

        "SELECT * FROM cpd_list where partner_id=#{partnerId} and package_name in",

        "<foreach collection='packageNames' item='item' open='(' separator=',' close=')'>",

        "#{item}",

        "</foreach>",

        ""

        })

ListgetOnlineCpdList(@Param("partnerId")int partnerId, @Param("packageNames") List packageNames);