java--自动创建数据库，并执行sql脚本文件

JAVA_XJN

于 2023-02-24 16:10:23 发布

阅读量492

点赞数

分类专栏：开发中遇到的问题文章标签： java 数据库 sql

本文链接：https://blog.youkuaiyun.com/bpdwg888/article/details/129203136

版权

开发中遇到的问题专栏收录该内容

20 篇文章

订阅专栏

 		//创建数据库
        Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306?serverTimezone=UTC", "root", "root");
        Statement statement = connection.createStatement();
        statement.executeUpdate("create database if not exists `forum` default character set utf8mb4 COLLATE utf8mb4_general_ci");
        statement.close();
        connection.close();

        //执行sql文件
        Connection connectionSql = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/forum?serverTimezone=UTC", "root", "root");
        ScriptRunner runner = new ScriptRunner(connectionSql);
        Resources.setCharset(StandardCharsets.UTF_8);
        runner.setLogWriter(null);

        ClassPathResource classPathResource = new ClassPathResource("sql/forum.sql");
        InputStream inputStream = classPathResource.getInputStream();

        runner.runScript(new InputStreamReader(inputStream, StandardCharsets.UTF_8));
        connectionSql.close();