Spring Boot+Mybatis集成H2数据库示例

package com.example.dao; import com.example.entity.YmdTrigger; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; import static org.junit.jupiter.api.Assertions.*; @SpringBootTest class YmdTriggerMapperTest { @Autowired YmdTriggerMapper triggerMapper; @Test void insert() { long startTime = System.currentTimeMillis(); int limit = 100000; for (int i = 0; i < limit; i++) { triggerMapper.insert(new YmdTrigger()); } System.out.println("插入"+limit+"条记录耗时："+(System.currentTimeMillis()-startTime)+"ms"); } @Test void insert2() { int startCount = triggerMapper.count(); long startTime = System.currentTimeMillis(); ExecutorService executorService = Executors.newCachedThreadPool(); int limit = 100000; int count = 10; for (int i = 0; i < count; i++) { executorService.submit(()->{ for (int j = 0; j < limit; j++) { triggerMapper.insert(new YmdTrigger()); } }); } executorService.shutdown(); while (executorService.isTerminated()){ try { Thread.sleep(10); } catch (InterruptedException e) { throw new RuntimeException(e); } } long time = System.currentTimeMillis() - startTime; int endCount = triggerMapper.count(); System.out.println(startCount+" "+endCount); System.out.println("插入"+(limit*count)+"条记录耗时："+ time +"ms"+"；共插入:"+(endCount-startCount)+"条记录"); } }