java实现数据库批量插入

1、mysql批量插入写法

    insert into app_monitor_result (id,monitor_id,app_id,abstracts,keywords,content,exception_type,file_path,media_type,create_time) values
    
      	(nextval("seq_appmonitorresult"),#{MonitorResult.monitorId}, #{MonitorResult.appId}, #{MonitorResult.abstracts}, #{MonitorResult.keywords}, #{MonitorResult.content}, #{MonitorResult.exceptionType}, 
     	 #{MonitorResult.filePath},#{MonitorResult.mediaType},#{MonitorResult.createTime})
    

2、ora批量插入数据

	
		INSERT INTO VIRES_LIBRARY 
		(ID,BIG_TYPE,SMALL_TYPE,SHOW,DESCRIPTION,TYPE,DELETED,CREATE_TIME,CHARACTERISTIC_VALUE,USER_ID,REMARKS)
		SELECT SEQ_VIRES_LIBRARY.NEXTVAL ID, A.*
		FROM(
		
			SELECT 
			#{item.bigType,jdbcType=INTEGER} BIG_TYPE ,
			#{item.smallType,jdbcType=VARCHAR} SMALL_TYPE,
			#{item.show,jdbcType=VARCHAR} SHOW,
			#{item.description,jdbcType=VARCHAR} DESCRIPTION,
			#{item.type,jdbcType=INTEGER} TYPE,
			#{item.deleted,jdbcType=VARCHAR} DELETED,
			#{item.createTime} CREATE_TIME,
			#{item.characteristicValue,jdbcType=VARCHAR} CHARACTERISTIC_VALUE ,
			#{item.userId,jdbcType=INTEGER} USER_ID ,
			#{item.remarks,jdbcType=INTEGER} REMARKS 
			FROM dual
		
		)A