DataSourceInitializer and Spring MVC

Question

我正在学习java和spring，并尝试制作我的第一个springmvc应用程序。起初，我制作了没有springmvc的控制台应用程序，我只使用了带有JdbcTemplate的dao和服务层。我有一个配置文件，我在其中为DataSource创建Beans，为初始化数据库创建DataSourceInitializer。

@EnableWebMvc
@EnableTransactionManagement
@ComponentScan("ru.stepev")
@PropertySource("classpath:config.properties")
public class UniversityConfig implements WebMvcConfigurer {
@Value("${driver}")
private String driver;
@Value("${url}")
private String url;
@Value("${user}")
private String user;
@Value("${pass}")
private String pass;
@Value("${schema}")
private Resource schema;
@Value("${data}")
private Resource data;
@Bean
public JdbcTemplate jdbcTamplate(DataSource dateSourse) {
return new JdbcTemplate(dateSourse);
}
@Bean
public DataSource dataSource() {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(driver);
dataSource.setUrl(url);
dataSource.setUsername(user);
dataSource.setPassword(pass);
return dataSource;
}
@Bean
public PlatformTransactionManager transactionManager(DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean
public DataSourceInitializer dataSourceInitializer(DataSource dataSource) {
ResourceDatabasePopulator resourceDatabasePopulator = new ResourceDatabasePopulator();
resourceDatabasePopulator.addScript(schema);
resourceDatabasePopulator.addScript(data);
DataSourceInitializer dataSourceInitializer = new DataSourceInitializer();
dataSourceInitializer.setDataSource(dataSource);
dataSourceInitializer.setDatabasePopulator(resourceDatabasePopulator);
return dataSourceInitializer;
}

private final ApplicationContext applicationContext;
public UniversityConfig(ApplicationContext applicationContext) {
this.applicationContext = applicationContext;
}

@Bean
public SpringResourceTemplateResolver templateResolver() {
SpringResourceTemplateResolver templateResolver = new SpringResourceTemplateResolver();
templateResolver.setApplicationContext(applicationContext);
templateResolver.setPrefix("/WEB-INF/view/");
templateResolver.setSuffix(".jsp");
return templateResolver;
}

@Bean
public SpringTemplateEngine templateEngine() {
SpringTemplateEngine templateEngine = new SpringTemplateEngine();
templateEngine.setTemplateResolver(templateResolver());
templateEngine.setEnableSpringELCompiler(true);
return templateEngine;
}
@Override
public void configureViewResolvers(ViewResolverRegistry registry) {
ThymeleafViewResolver resolver = new ThymeleafViewResolver();
resolver.setTemplateEngine(templateEngine());
registry.viewResolver(resolver);
}
@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
registry.addResourceHandler("/resources/**").addResourceLocations("/resources/");
}
}

我存储在resources文件夹中的所有shemes和数据。没有mvc，一切都可以。但当我添加了mvc后，我得到了java.io.FileNotFoundException org.springframework.jdbc.datasource.init.CannotReadScriptException：无法从ServletContext资源[/schema.SQL]读取SQL脚本；嵌套异常为java.io.FileNotFoundException：无法打开Servlet上下文资源[/schema.sql]。当我创建数据库时，DataSourceInitializer找不到schema.sql。我试图解决这个问题，但我做不到。我有项目的下一个结构。在这里输入图像描述

我将非常感谢你帮我解决这个问题，并为我糟糕的英语感到抱歉。

Answer 1

我发现了我的错误。我遇到了一个异常，因为我没有在属性文件的文件名之前放单词classpath。

schema=classpath:schema.sql
data=classpath:data.sql