如何在应用程序启动加载期间执行SQL插入查询以填充数据库？

如何在应用程序启动/加载期间执行SQL插入查询以填充数据库？

您还可以利用Spring的

DataSourceInitializer

。以下是针对它的Java Config的示例。

@Beanpublic DataSourceInitializer dataSourceInitializer() {    ResourceDatabasePopulator resourceDatabasePopulator = new ResourceDatabasePopulator();    resourceDatabasePopulator.addscript(new ClassPathResource("/data.sql"));        DataSourceInitializer dataSourceInitializer = new DataSourceInitializer();        dataSourceInitializer.setDataSource(dataSource());        dataSourceInitializer.setDatabasePopulator(resourceDatabasePopulator);        return dataSourceInitializer;    }