把数组中的数据全部添加到list中
String ids[]=specIds.split(",");List<String> specIdList=new ArrayList<String>();//把数据中的数据全部添加到list中Collections.addAll(specIdList,ids);
通过mybaits拼接字符串
<select id="queryItemsBySpecIds" parameterType="list" resultType="com.imooc.pojo.vo.ShopcartVo">SELECTt_items.id AS itemId,t_items.item_name AS itemName,t_items_img.url AS itemImgUrl,t_items_spec.id AS specId,t_items_spec. NAME AS specName,t_items_spec.price_discount AS priceDiscount,t_items_spec.price_normal AS priceNormalFROMitems_spec t_items_specLEFT JOIN items t_items ON t_items.id = t_items_spec.item_idLEFT JOIN items_img t_items_img ON t_items_img.item_id = t_items.idWHEREt_items_img.is_main = 1AND t_items_spec.id IN<foreach collection="paramsList" index="index" item="specId" open="(" separator="," close=")">#{specId}</foreach><!-- ('1', '3', '5') --></select>