/**
     * insert into words (word)  values(?)  ->  stopwatch = 66487
     */
    @Test
    @SneakyThrows
    public void testBatch() {
        String connectString = "jdbc:mysql://localhost/test?user=root&password=toor&useLocalSessionState=true&useSSL=false";
        Class.forName("com.mysql.jdbc.Driver")
            .newInstance();
        try (Connection conn = DriverManager.getConnection(connectString)) {
            //插入100000条测试代码
            Stopwatch stopwatch = Stopwatch.createStarted();
            try (PreparedStatement psts = conn.prepareStatement("insert into words (`word`)  VALUES(?)")) {
                for (int i = 0; i < 100000; i++) {
                    psts.setString(1, "123");
                    psts.addBatch();
                }
                psts.executeBatch();
                stopwatch.stop();
                System.out.println("stopwatch = " + stopwatch.elapsed(TimeUnit.MILLISECONDS));
            }
        }
    }