springboot项目启动时初始化数据库（只执行一次）

　　先说结论。

　　cloud项目中spring.data.sql属性可以做到项目每次启动时，都执行相应的sql，但这不够个性化。

　　通过DataSourceInitializer自定义来实现，具体代码：

@Configuration
@Slf4j
public class DataSourceInitializer {
 
 
    @javax.annotation.Resource(name = "dataSourceFirst")
    private DataSource dataSource;
 
    @Value("classpath:db/xx.sql")
    private Resource ddl;
    @Value("classpath:db/data.sql")
    private Resource dml;
 
    @Bean
    public 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();
 
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
 
        try {
            Map map = jdbcTemplate.queryForMap("select count(1) from xx");
        } catch (DataAccessException e) {
            log.warn("初始化脚本报错:" + e.getMessage());
            // 报错,表不存在,初次导入，执行相关脚本
            populator.addScripts(ddl);
//            populator.addScripts(dml);
        } catch (Exception e) {
            log.warn("初始化脚本报错:" + e.getMessage());
        }
 
 
        return populator;
    }
 
 
 
 
 
 
}