java 执行mysql的脚本sql脚本，不包含存储过程

@Test
void exceFile() {
String filePath = “C:\Users\Dell\Desktop\001.schema.sql”;
executeSql(filePath);
}

public  void executeSql(String sqlFileName){
    Connection connection = null;
    try {
        File newfile = new File(sqlFileName);
        Resource rc = new FileSystemResource(newfile);
        EncodedResource er = new EncodedResource(rc, "utf-8");
        connection =  dataSource.getConnection();
        ScriptUtils.executeSqlScript(connection, er);
       
    } catch (Exception e) {
        e.printStackTrace();
    }finally {
        if (connection!=null){
            DataSourceUtils.releaseConnection(connection, dataSource);
        }
    }
}