多线程条件下插入Mysql数据库,根据时间戳判断处理数据
mybatis的写法
insert into table_name ( colume1,f_updated_at) values (#{colume1},#{updateAt})
ON DUPLICATE KEY UPDATE colume1 = IF(f_updated_at IS NULL OR VALUES(f_updated_at) > f_updated_at, VALUES(colume1), colume1)
主要通过修改时间去判断是否满足入库条件。否则不触发修改。
前提是要有unique Key
多线程主要就是
public static ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
static {
executor.setCorePoolSize(10);
executor.setMaxPoolSize(10);
executor.setQueueCapacity(100000);
executor.setThreadNamePrefix("hkex-async-slaOrder-");
executor.setRejectedExecutionHandler(new ThreadPoolExecutor.CallerRunsPolicy());
executor.initialize();
}
CompletableFuture
.runAsync(() -> insert(msg), executor);//执行多线程任务