容器启动后执行和执行数据库脚本

package com.jt.mongo.demo.modules.init;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.ApplicationListener;
import org.springframework.context.event.ContextRefreshedEvent;
import org.springframework.core.io.ClassPathResource;
import org.springframework.jdbc.datasource.init.ResourceDatabasePopulator;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;
import javax.sql.DataSource;
import java.sql.SQLException;

@Component
public class SqlScriptInitExecutor implements ApplicationListener<ContextRefreshedEvent> {

    private static final Logger LOGGER = LoggerFactory.getLogger(SqlScriptInitExecutor.class);

    @Resource
    private DataSource mysqlDataSource;

    @Override
    public void onApplicationEvent(ContextRefreshedEvent event) {
        initMySqlTables();
    }
    
    private void initMySqlTables() {
        try {

            ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
            populator.addScript(new ClassPathResource("sql/mysql_pdca_manager.sql"));
            populator.populate(mysqlDataSource.getConnection());

            LOGGER.info("init pdca manager tables success.");

        } catch (SQLException e) {
            LOGGER.error("init pdca manager tables error", e);
        }
    }
}

ContextRefreshedEvent：

Event raised when an {@code ApplicationContext} gets initialized or refreshed.
当容器初始化或者重启之后实例化到容器中，然后监听他的listener就会执行