Spring执行sql脚本文件的方法

//Schema 处理器@Componentpublic class SchemaHandler {  private final String SCHEMA_SQL = "classpath:schema.sql";  @Autowired  private DataSource datasource;  @Autowired  private SpringContextGetter springContextGetter;  public void execute() throws Exception {    Resource resource = springContextGetter.getApplicationContext().getResource(SCHEMA_SQL);    ScriptUtils.executeSqlScript(datasource.getConnection(), resource);  }}// 获取 ApplicationContext@Componentpublic class SpringContextGetter implements ApplicationContextAware {  private ApplicationContext applicationContext;  public ApplicationContext getApplicationContext() {    return applicationContext;  }  @Override  public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {    this.applicationContext = applicationContext;  }}

private void runSchemaScripts() {    List<Resource> scripts = getScripts("spring.datasource.schema",        this.properties.getSchema(), "schema");    if (!scripts.isEmpty()) {      String username = this.properties.getSchemaUsername();      String password = this.properties.getSchemaPassword();      runScripts(scripts, username, password);      try {        this.applicationContext            .publishEvent(new DataSourceInitializedEvent(this.dataSource));        // The listener might not be registered yet, so don't rely on it.        if (!this.initialized) {          runDataScripts();          this.initialized = true;        }      }      catch (IllegalStateException ex) {        logger.warn("Could not send event to complete DataSource initialization ("            + ex.getMessage() + ")");      }    }  }/** * 默认拿 classpath*:schema-all.sql 和 classpath*:schema.sql */private List<Resource> getScripts(String propertyName, List<String> resources,      String fallback) {    if (resources != null) {      return getResources(propertyName, resources, true);    }    String platform = this.properties.getPlatform();    List<String> fallbackResources = new ArrayList<String>();    fallbackResources.add("classpath*:" + fallback + "-" + platform + ".sql");    fallbackResources.add("classpath*:" + fallback + ".sql");    return getResources(propertyName, fallbackResources, false);  }