db.driverClass=com.mysql.jdbc.Driver

db.url=jdbc:mysql://localhost:3306/exercise

db.username=root

db.password=123456

db.initialSize=100

db.maxTotal=95

db.maxIdle=60

db.minIdle=55

package cn.devil.configs;

import org.apache.commons.dbcp2.BasicDataSource;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.PropertySource;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

@Configuration

@PropertySource(encoding="UTF-8", value = { "classpath:databaseinfo.properties" })

public class SpringJdbcConfig {

	@Value("${db.driverClass }")

	private String driverClass;

	@Value("${db.url }")

	private String url;

	@Value("${db.username }")

	private String username;

	@Value("${db.password }")

	private String password;

	@Value("${db.initialSize }")

	private Integer initialSize;

	@Value("${db.maxTotal }")

	private Integer maxTotal;

	@Value("${db.maxIdle }")

	private Integer maxIdle;

	@Value("${db.minIdle }")

	private Integer minIdle;

	@Bean("dataSource")

	public BasicDataSource getDataSource() {

		BasicDataSource dataSource = new BasicDataSource();

		dataSource.setDriverClassName(driverClass);

		dataSource.setUrl(url);

		dataSource.setUsername(username);

		dataSource.setPassword(password);

		dataSource.setInitialSize(initialSize);

		dataSource.setMaxTotal(maxTotal);

		dataSource.setMaxIdle(maxIdle);

		dataSource.setMinIdle(minIdle);

		return dataSource;

	}

	@Bean("jdbcTemplate")

	public JdbcTemplate getJdbcTemplate(@Autowired BasicDataSource dataSource) {

		JdbcTemplate jdbcTemplate = new JdbcTemplate();

		jdbcTemplate.setDataSource(dataSource);

		return jdbcTemplate;

	}

	@Bean("transactionManager")

	public DataSourceTransactionManager getDataSourceTransactionManager(@Autowired BasicDataSource dataSource){

		DataSourceTransactionManager tx = new DataSourceTransactionManager();

		tx.setDataSource(dataSource);

		return tx;

	}

}

信息: Found 3 annotated classes in package [cn.devil.configs]

四月 22, 2019 6:29:57 下午 org.springframework.web.context.support.AnnotationConfigWebApplicationContext refresh

警告: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'springJdbcConfig': Unsatisfied dependency expressed through field 'initialSize'; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert value of type 'java.lang.String' to required type 'java.lang.Integer'; nested exception is java.lang.NumberFormatException: For input string: "${db.initialSize}"

四月 22, 2019 6:29:57 下午 org.springframework.web.servlet.DispatcherServlet initServletBean

严重: Context initialization failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'springJdbcConfig': Unsatisfied dependency expressed through field 'initialSize'; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert value of type 'java.lang.String' to required type 'java.lang.Integer'; nested exception is java.lang.NumberFormatException: For input string: "${db.initialSize}"

	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:588)

	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)