package com.whyc.service;
|
|
import com.whyc.mapper.AnalysisMonFieldMapper;
|
import com.whyc.dto.AnalysisMonFieldDTO;
|
import com.whyc.mapper.DBMapper;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.annotation.Resource;
|
import java.util.List;
|
|
@Service
|
public class AnalysisMonFieldService {
|
|
@Resource
|
private AnalysisMonFieldMapper mapper;
|
|
@Resource
|
private DBMapper dbMapper;
|
|
@Transactional
|
public void updateBatch(String tableName, List<AnalysisMonFieldDTO> analysisMonFieldList) {
|
//删除原来记录
|
dbMapper.deleteAll("db_analysis",tableName);
|
//插入行记录
|
String[] tableSplit = tableName.split("_");
|
String filedStr = tableSplit[tableSplit.length-1];
|
String fieldFirst = filedStr.substring(0,1).toUpperCase();
|
String fieldStrNew = fieldFirst + filedStr.substring(1);
|
mapper.insertBatch(tableName,analysisMonFieldList,fieldStrNew);
|
}
|
}
|
