ibatis 批量插入oracle 数据库

最新推荐文章于 2021-04-11 21:31:42 发布

下一次是什么时候

最新推荐文章于 2021-04-11 21:31:42 发布

阅读量940

点赞数

文章标签： ibatis

	java代码:
	@Override
	public void insertBatch(List<Map<String, Object>> list) {
		Map<String,List<Map<String, Object>>> map = new HashMap<String,List<Map<String, Object>>>() ;
		map.put("ragrouppreinsert", list);
		this.getSqlMap().insert("excelImport.insertAwOrganizationsTemp", list) ;
	}
	
	xml配置：
	<insert id="insertintoragroupra" parameterClass="map">
		insert all
		<iterate conjunction=" " property="ragrouppreinsert">
			into t_user
			(ISSUER_CODE, ISSUER_NAME,CARD_NO_LEN)
			values
			(
			 nvl(#ragrouppreinsert[].ISSUER_CODE#,''),
			 nvl(#ragrouppreinsert[].ISSUER_NAME#,''),
			 nvl(#ragrouppreinsert[].CARD_NO_LEN#,'')
			)
		</iterate>
		select * from dual
	</insert>

	<insert id="insertAwOrganizationsTemp" parameterClass="java.util.ArrayList">
		insert all
		<iterate conjunction=" ">
			into t_user (
				ISSUER_CODE, ISSUER_NAME,CARD_NO_LEN
			) values  
            <![CDATA[  
        	(  
				nvl(#list[].ISSUER_CODE#,''),
				nvl(#list[].ISSUER_NAME#,''),
				nvl(#list[].CARD_NO_LEN#,'')
			) ]]>
		</iterate>
		select * from dual
	</insert>
	
	注:其中传入map时，可以往map里添加别的值,如：map.put("id","1");在xml取值时nvl(#id#,'')：
	
	参考:
	     https://blog.csdn.net/xusongsong520/article/details/8284979
             https://blog.csdn.net/weixin_36892130/article/details/58616896