發布時間： 2019-03-27 23:59:58
?導入必須的依賴
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency>
spring: datasource: username: root password: 123456 url: jdbc:mysql://192.168.15.22:3306/jdbc driver-class-name: com.mysql.jdbc.Driver 相關配置在DataSourceProperties內 自動配置DataSourceConfiguration默認使用：dataSource = class org.apache.tomcat.jdbc.pool.DataSource（springboot1.x） 默認使用：dataSource = class com.zaxxer.hikari.HikariDataSource （springboot2.x）SpringBoo支持的數據源 org.apache.tomcat.jdbc.pool.DataSource、HikariDataSource、BasicDataSource、
//jdbc測試
@Controller
public class jdbcController {
@Autowired
JdbcTemplate jdbcTemplate;
@ResponseBody
@RequestMapping("/list")
public Map<String,Object> map(){
List<Map<String,Object>> list = jdbcTemplate.queryForList("select * from department");
return list.get(0);
}
上一篇： {HTML5}事件對象-事件對象
下一篇： {HTML5}基礎事件-復合事件
18922156670
