导入场景
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
配置数据源
spring:
datasource:
url: jdbc:mysql://localhost:3306/repo?serverTimezone=UTC
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
测试
@SpringBootTest
class DemoApplicationTests {
@Autowired
JdbcTemplate template;
@Test
void contextLoads() {
Integer count = template.queryForObject("SELECT count(*) FROM emp", Integer.class);
System.out.println(count);
}
}
结果
14