Springboot 调用mysql的.sql文件，执行mysql语句

代码:

import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.support.EncodedResource;
import org.springframework.jdbc.datasource.init.ScriptUtils;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
import java.sql.*;

@Component
public class ExecuteSQLUtil {
    @Value("${master.jdbc.url}")
    private String DB_URL;
    @Value("${spring.datasource.druid.username}")
    private String DB_USERNAME;
    @Value("${spring.datasource.druid.password}")
    private String DB_PWD;

    @Scheduled(cron = "0 */1 * * * ?")
    public void test (){
        executeSql("static/test1.sql");
        executeSql("static/test2.sql");
        executeSql("static/test3.sql");
        executeSql("static/test4.sql");
        executeSql("static/test5.sql");
        executeSql("static/test6.sql");
        executeSql("static/testOne.sql");
    }



    public Connection executeSql(String sqlFileName){
        Connection connection = null;
        try {
            String driverClassName = "com.mysql.cj.jdbc.Driver";
// String DB_URL = "jdbc:mysql://127.0.0.1:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=UTF-8&useSSL=true&rewriteBatchedStatements=true";
// String DB_USERNAME = "root";
// String DB_PWD = "123456";
//            Class.forName(driverClassName);
            connection = DriverManager.getConnection(DB_URL, DB_USERNAME , DB_PWD );
        } catch (Exception e) {
            e.printStackTrace();
        }
        ClassPathResource rc = new ClassPathResource(sqlFileName);
        EncodedResource er = new EncodedResource(rc, "utf-8");
        ScriptUtils.executeSqlScript(connection, er);
        return connection;
    }
}

sql文件在: