//创建数据库
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();
java--自动创建数据库,并执行sql脚本文件
最新推荐文章于 2023-11-06 14:21:28 发布