Springboot学习(十六) springboot启动使用ScriptRunner执行SQL脚本

最新推荐文章于 2024-07-19 13:34:43 发布

码农-文若书生

最新推荐文章于 2024-07-19 13:34:43 发布

阅读量3k

点赞数 1

分类专栏： spring boot 文章标签： ScriptRunner listener springboot

本文链接：https://blog.csdn.net/u011943534/article/details/86620716

版权

spring boot 专栏收录该内容

87 篇文章 53 订阅

订阅专栏

定义监听并执行（其中schema_data.sql放入resources下）

@Slf4j
public class MyApplicationStartedListener implements ApplicationListener<ApplicationStartedEvent> {
    @Override
    public void onApplicationEvent(ApplicationStartedEvent event) {
        ConfigurableApplicationContext applicationContext = event.getApplicationContext();
        DataSource dataSource = applicationContext.getBean(DataSource.class);
        Connection connection = null;
        try {
            connection = dataSource.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        ScriptRunner runner=new ScriptRunner(connection);
        try {
            Reader resourceAsReader = Resources.getResourceAsReader("schema_data.sql");
            runner.runScript(resourceAsReader);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

添加监听

public class BizApp extends SpringBootServletInitializer {
    public static void main(String[] args) {
        SpringApplication springApplication = new SpringApplication(BizApp.class);
        springApplication.addListeners(new MyApplicationStartedListener());
        springApplication.run(args);
    }
    /**
     *重写configure
     * @param builder
     * @return
     */
    @Override
    protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
        builder.application().addListeners(new MyApplicationStartedListener());
        return builder.sources(BizApp.class);
    }

}

上一篇配置XSS过滤器
 下一篇 springboot下将静态资源路径设置到磁盘的基本目录