<!--批量插入--> <insert id="insertMultiCars" parameterClass="java.util.List"> insert into car( id, carnumber, brand, purchasedate, state, orgid, orgcode, phone, createuser, createdate ) select s_car.NEXTVAL, t.* from ( /* // 使用序列生成主键*/ <iterate conjunction=" union all " > /*// conjunction属性表示每次循环结束添加的字符*/ select #test[].carNumber#,#test[].brand.id#,#test[].purchaseDate#,#test[].state#,#test[].organization.id#, #test[].organization.orgInternalCode#,#test[].phone#,#test[].createUser#,sysdate from dual </iterate> ) t </insert>
ibatis批量插入
最新推荐文章于 2021-02-13 01:40:27 发布