Java多线程以及单线程查询数据库

编写dome本地测试单线程与多线程查询MySQL数据库性能对比

1.多线程查询调用实体

public class ThredQuery implements Callable {

    private String sql;
    private Object[] parms;
    private List<String> page;
    
    public ThredQuery(String sql, Object[] parms) {
        this.sql = sql;
        this.parms = parms;
    }

    @Override
    public List call() throws Exception {
        page = DruidUtil.executeQuery(sql, parms);
        return page;
    }
}

2.执行方法

public class ThreadTest {

    public static void main(String[] args) throws InterruptedException, ExecutionException {

        //需要查询的次数
        int count = 50000;
        long start = System.currentTimeMillis();
        String sql = "select * from signaling limit ?,?";
        Object[] params = {0, count};

        List<String> list = new ArrayList<>();
        DruidUtil.executeQuery(sql, new DruidUtil.QueryCallback() {
            @