| | |
| | | |
| | | import com.google.common.collect.Lists; |
| | | import com.yssh.dao.VocValsMapper; |
| | | import com.yssh.entity.VocCoords; |
| | | import com.yssh.entity.VocVals; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<VocCoords> selectCoords(Integer x, Integer y) { |
| | | return vocValsMapper.selectCoords(x, y); |
| | | } |
| | | |
| | | @Override |
| | | public int insert(VocVals vv) { |
| | | return vocValsMapper.insert(vv); |
| | | } |
| | |
| | | return vocValsMapper.deleteByTime(time); |
| | | } |
| | | |
| | | public void insertVocSync(List<VocVals> list) { |
| | | List<List<VocVals>> subLists = Lists.partition(list, 100); |
| | | for (List<VocVals> sub : subLists) { |
| | | vocValsMapper.inserts(sub); |
| | | } |
| | | |
| | | logger.info("------ VOC.csv," + list.size() + " 条数据已入库 ------"); |
| | | } |
| | | |
| | | @Async("threadPoolTaskExecutor") |
| | | public void insertVocVals(List<VocVals> list) throws InterruptedException { |
| | | List<List<VocVals>> lists = Lists.partition(list, IAsyncService.BATCH_INSERT_500); |