SpringBoot配置自定义线程池的数据源

加载maven架包支持

pom.xml

!-- 操作数据源配置oracle数据库然后再加载四要素 --><dependency>    <groupId>org.springframework.boot</groupId>    <!-- spring-boot-starter-jdbc or spring-boot-starter-data-jpa -->    <artifactId>spring-boot-starter-data-jpa</artifactId></dependency><dependency>  <groupId>oracle</groupId>  <artifactId>orcale</artifactId>  <version>3.2.8</version><scope>system</scope><systemPath>C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar</systemPath></dependency><!-- 新的数据库连接池架包dbcp --><dependency>  <groupId>commons-dbcp</groupId>  <artifactId>commons-dbcp</artifactId>  <version>1.4</version></dependency>

创建数据源

BeanContainer

package cn.et.boot.lesson01.source;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSource;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;/** * 相当于标示该类是一个bean容器 * @author Administrator */@Configurationpublic class BeanContainer {/** * @Bean * 表示该方法是创建一个bean * 方法名是bean的id *  * @ConfigurationProperties * 读取application.properties文件 * 设置前缀，自动读取application.properties文件中的属性 */@ConfigurationProperties(prefix="mysource")@Beanpublic DataSource dataSource(){BasicDataSource dataSource = new BasicDataSource();//dataSource.setDriverClassName(driverClassName)return dataSource;}}

application.properties

#数据源的四要素mysource.url=jdbc:oracle:thin:@localhost:1521:orclmysource.username=scottmysource.password=tigermysource.driverClassName=oracle.jdbc.OracleDriver

程序入口

IocController

package cn.et.boot.lesson01.source;import javax.sql.DataSource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;/** *@RestController *配置消息转换器 Jackson *同时在Action上添加了@ResponseBody */@RestController/** * 自动增加spring.xml文件，并且配置自动扫描 * 自动增加web.xml 同时在web.xml过滤器、拦截器... *  * @EnableAutoConfiguration要替换成@SpringBootApplication * 不然扫描不到dao层，装配不了EmpDaoImpl * 要装配的对象必须位于HelloController类共一个包或它的子包下才可以扫描的到 */@SpringBootApplicationpublic class IocController {@AutowiredDataSource dataSource;/** * 这里是可以直接返回List，@RestController会自动帮我们转换到json * @return */@RequestMapping("/dataSource")public String hello(){return "bean";}public static void main(String[] args) {//发布程序的方法入口SpringApplication.run(IocController.class, args);}}