通过使用 XML 。
<jdbc:initialize-database data-source="dataSource"> <jdbc:script location="classpath:com/foo/sql/db-schema.sql"/> <jdbc:script location="classpath:com/foo/sql/db-test-data.sql"/></jdbc:initialize-database>
通过使用 注释 （下面的示例应该放在您的
@Configuration类中）
@Value("classpath:com/foo/sql/db-schema.sql")private Resource schemascript;@Value("classpath:com/foo/sql/db-test-data.sql")private Resource datascript;@Beanpublic DataSourceInitializer dataSourceInitializer(final DataSource dataSource) { final DataSourceInitializer initializer = new DataSourceInitializer(); initializer.setDataSource(dataSource); initializer.setDatabasePopulator(databasePopulator()); return initializer;}private DatabasePopulator databasePopulator() { final ResourceDatabasePopulator populator = new ResourceDatabasePopulator(); populator.addscript(schemascript); populator.addscript(datascript); return populator;}
