<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- oracle -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
package com.sunyard.monitor.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import javax.sql.DataSource;
@RestController
@RequestMapping("/test")
public class TestController {
@Autowired
private DataSource dataSource;
//method如果不写的话,那么get,post方式都能进入方法,但是不安全
@RequestMapping(value = {"/say"},method = RequestMethod.GET)
public String say(@RequestParam(value = "id",required = false,defaultValue = "0")String id){
return dataSource.toString();
}
}
pring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@10.1.85.243:1521/ccbase
username: webagent
password: webagent
如下是补充,我写了一个配置类,该配置类起的作用是不是就相当于在yml文件中
添加type: com.alibaba.druid.pool.DruidDataSource?
*/
@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource dataSource(){
return new DruidDataSource();
}
}