mysql - spring上下文初始化时如何创建数据库

Question

我需要在本地 mysql 服务器中创建一个名为 test 的数据库，我将用它来设置我的数据源 bean。我使用以下 spring 配置来设置数据源和 jdbctemplate 以进行测试

@Configuration
class Config {
        @Bean(initMethod = "setupDatabase")
      public DataSource getDataSource() {
        String url = "jdbc:mysql://localhost:3306/test";
        DriverManagerDataSource dataSource = new DriverManagerDataSource(
                url, settings.getUsername(), settings.getPassword());
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        return dataSource;
      }

      @Bean
      public JdbcTemplate getJdbcTemplate() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate();
        jdbcTemplate.setDataSource(((DataSourceTransactionManager)transactionManager()).getDataSource());
        return jdbcTemplate;
      }

      @Bean
      public PlatformTransactionManager transactionManager() {
        return new DataSourceTransactionManager(getDataSource());
      }

      @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();
        populator.addScript(schemaScript);
        return populator;
      }

      @PostConstruct
      public void setupDatabase() {
        String url = "jdbc:mysql://localhost:3306";
        try {
          Connection connection = DriverManager.getConnection(url, settings.getUsername(), settings.getPassword());
          Statement statement = connection.createStatement();
          statement.execute("create database test");
        } catch (SQLException exception) {
          LOGGER.error("Could not setup database for test", exception);
          throw new RuntimeException(exception);
        }
    }
}

我收到以下错误，原因是:

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'test'
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:46)

有人可以解释一下这个配置出了什么问题吗？

Answer 1

你是否在本地mysql创建了测试数据库？您需要首先创建数据库才能从应用程序连接。如果您想通过执行sql查询来创建数据库，请以root用户连接到数据库并创建数据库。