Oracle 批量插入经试验可行的方法
public class Brand {
private static final long serialVersionUID = 1435257830949376842L;
private String uuid; // uuid
private String brand_id; // 品牌id
private String brand_name; // 品牌名称
private String initial; // 首字母
private Date update_time; // 更新日期
getter…
setter…
}
List list = new ArrayList();
list.add…
Dao.insert(“carEval.insertByBatchBrand”, list);
<insert id="insertByBatchBrand" parameterType="list">
<foreach collection="list" item="item" close="end;" open="begin ">
insert into dd_car_brands(
UUID, BRAND_ID, BRAND_NAME, INITIAL_CODE, UPDATE_TIME
)values(
#{item.uuid,jdbcType=VARCHAR},
#{item.brand_id,jdbcType=VARCHAR},
#{item.brand_name,jdbcType=VARCHAR},
#{item.initial,jdbcType=VARCHAR},
#{item.update_time,jdbcType=VARCHAR}
);
</foreach>
</insert>