SSM框架——mybatis批量插入oracle数据库

1、已经配好的SSM框架的，第一个SSM项目自己去学习

 

2、关键代码：  XXX.java接口的代码如下

   public void Add_District_province(@Param("provincelist")List<Districts> provincelist);

	public void Add_District_city(@Param("citylist")List<Districts> citylist);

	public void Add_District_county(@Param("countylist")List<Districts> countylist);

	public void Add_District_town(@Param("townlist")List<Districts> townlist);

3、XXX.xml

代母如下

 useGeneratedKeys="false"属性值记得写上，oracle的批量插入数据

<insert id="Add_District_city" useGeneratedKeys="false">
 BEGIN  
    <foreach collection="citylist" item="item" index="index" separator="">  
        insert into CHINA_ADMINISTRATIVE_REGION  
        (citycode,adcode,c_name,center,c_level) 
        VALUES  
        ( 
        #{item.adcode},#{item.adcode},#{item.name},#{item.center},#{item.level} 
        );  
    </foreach>  
    COMMIT;  
    END;   
</insert>