首先传入一个Map类型数据
Map<String, Object> map = new HashMap<String, Object>();
map.put("questionid", result1);
map.put("labelid", list_labelid);
然后在xml中这样写SQL
<insert id="insert" parameterType="map" >
insert into label_resources (questionid, labelid)values
<foreach collection="labelid" item="item" index="index" separator=",">
(#{questionid,jdbcType=BIGINT},#{item})
</foreach>
</insert>
因为我这里只循环了labelid所以直接就是#{item},记住加上separator=","这句标签,不然循环的语法就错了。