springboot jpa SQL in查询

1、参数必须传递List<type>

   @Query(value="select * from trande_product  where trande_form_id in ( :tradeNoIds )", nativeQuery = true)
    List<TrandeProduct> findByTradeNoIds(@Param("tradeNoIds") List<String>  tradeNoIds);