SpringBoot底层统一采用SpringData处理数据库,这一章主要来讲一下SpringBoot整合jdbc、durid、mybatis的方式。
(一)整合jdbc
整合jdbc主要有三步:
1.引入依赖
2.配置数据源
3.访问
引入springdata启动器和mysql连接包
<dependency>
<groupId>org.springframework.bootgroupId>
<artifactId>spring-boot-starter-jdbcartifactId>
dependency>
<dependency>
<groupId>mysqlgroupId>
<artifactId>mysql-connector-javaartifactId>
<scope>runtimescope>
dependency>
在application.yaml或者application.properties中配置spring datasource数据源。在新版本的spring-boot-starter-jdbc,mysql驱动由原先的com.mysql.jdbc.Driver变为了com.mysql.cj.jdbc.Driver
spring:
datasource:
url: jdbc:mysql://localhost:3306/testsql?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
通过jdbc模板访问
@RestController
public class JdbcController {
@Autowired
private JdbcTemplate jdbcTemplate;
@GetMapping("/jdbc")
public ListString, Object>> query(){
String sql="select * from user";
ListString, Object>> maps = jdbcTemplate.queryForList(sql);
return maps