mybatis sql批量插入

標籤：off   rom   int   rpo   col   jdb   pos   sep   get   

 insert into jrqf_officialcard   (id, budget_unit, money_purpose, economic_type, money, func_subject_name,   treasury_accountbank, merchant_name)  select t.* from(   <foreach collection ="myList" item="fb" separator ="UNION ALL">   select    #{fb.id},   #{fb.budget_unit} ,   #{fb.money_purpose} ,    #{fb.economic_type} ,   #{fb.money,jdbcType=FLOAT},      #{fb.func_subject_name} ,    #{fb.treasury_accountbank} ,   #{fb.merchant_name}     FROM DUAL   </foreach >)t

　　

mybatis sql批量插入