发布时间： 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}基础事件-复合事件
微信
公众号
