解决sharding JDBC 不支持批量导入问题

package com.ydmes.service.impl.log;

import com.ydmes.domain.entity.log.BarTraceBackLog;

import org.springframework.beans.BeansException;

import org.springframework.context.ApplicationContext;

import org.springframework.context.ApplicationContextAware;

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import org.springframework.stereotype.Component;

import org.springframework.transaction.TransactionDefinition;

import org.springframework.transaction.TransactionStatus;

import org.springframework.transaction.support.DefaultTransactionDefinition;

import java.util.List;

@Component

public class BarTraceBackLogBatchServiceImpl implements ApplicationContextAware {

private static ApplicationContext applicationContext;

public void batchInsertBarTraceBackLogs(List<BarTraceBackLog> barTraceBackLogs) {

DefaultTransactionDefinition definition = new DefaultTransactionDefinition();

definition.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRES_NEW);

definition.setIsolationLevel(TransactionDefinition.ISOLATION_READ_COMMITTED);

DataSourceTransactionManager transactionManager = (DataSourceTransactionManager)

applicationContext.getBean( "shardingTransactitonManager" );

TransactionStatus transactionStatus = transactionManager.getTransaction(definition);

for (BarTraceBackLog barTraceBackLog : barTraceBackLogs) {

//UserDao有create方法，单条插入

applicationContext.getBean(BarTraceBackLogServiceImpl. class ).insertSelective(barTraceBackLog);

}

transactionManager.commit(transactionStatus);

}

@Override

public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {

this .applicationContext = applicationContext;

}

}

< update id= "batchUpdate" >

<foreach collection= "userList" item= "item" index = "index" separator= ";" >

update t_user_data set `province_id`=#{item.provinceId} where member_id = #{item.memberId}

</foreach>

</ update >

update t_user_data_1 set `province_id`=?,`region_id`=? where member_id = ? ;

update t_user_data set `province_id`=?,`region_id`=? where member_id = ? ;

userData1.setTableName( "t_user_data_" + userData.getMemberId() % 8);

< update id= "batchUpdate" >

<foreach collection= "userList" item= "item" index = "index" separator= ";" >

update ${item.tableName} set `province_id`=#{item.provinceId} where member_id = #{item.memberId}

</foreach>

</ update >

update t_user_data_1 set `province_id`=?,`region_id`=? where member_id = ? ;

update t_user_data_2 set `province_id`=?,`region_id`=? where member_id = ? ;