【已解决】SpringBoot2+JDBC连接问题

Pom.xml

<!--		mysql驱动-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!--JDBC连接-->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>

Dependencies如果有红色波浪线不用管
application.yml

spring:
  profiles:
    active: dev #当前环境
  datasource:
    username: root
    password: root
    url: jdbc:mysql://8.129.43.232:5555/jdbc?serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver
  jdbc:
    template:
      query-timeout: 3 #3秒没查到
logging.level.org.springframework.boot.autoconfigure: ERROR

注意：url: jdbc:mysql://8.129.43.232:5555/jdbc?serverTimezone=UTC
高版本都需要?serverTimezone=UTC 不然会报错！！
SpringBoot06DataJdbcApplicationTests测试类

/**
 * @Description TODO
 * @Version 1.0
 * @Author 张璟冰
 * 学号：3187102350
 * @Date 2021/7/10 5:02 下午
 */

@RunWith(SpringRunner.class)
@SpringBootTest
public class SpringBoot06DataJdbcApplicationTests {
    @Autowired
    JdbcTemplate jdbcTemplate;
    Logger logger= LoggerFactory.getLogger(getClass());

    @Test
    public void contextLoads() throws SQLException {
//        jdbcTemplate.queryForList("select * from user");
       Long aLong=jdbcTemplate.queryForObject("select count(*) from user",Long.class);
        logger.info("总数：{}",aLong);
    }
}