sql查询条件为list数组，在项目中怎么写？

sql查询条件为list数组，在项目中怎么写？

• select
  o.row_id as rowId,
  p.sku_code as skuCode,
  p.sku_name as skuName,
  p.quantity as quantity
  from prm_esc_home_order_t o
  left join prm_esc_home_order_product_t p
  on p.head_id = o.row_id
  where
  <if test='rowIdList != null'>
  	p.head_id in
  	<foreach item='item' index='index' collection='rowIdList' open="(" close=")" separator=",">
  	#{rowIdList}
  	</foreach>
  </if>