spring boot单元测试类的使用.Loading class `com.mysql.jdbc.Driver'. This is deprecated.

以前都是直接连接数据库的，现在我们要搞到单元测试里玩一玩 就是junit这玩意

先说说 我遇到的坑

1.Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'.

 把properties的spring.datasource.driver-class-name=com.mysql.jdbc.Driver

改为 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

 

2.The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
这个需要设置一下mysql的时区

在mysql client中输入 set global time_zone='+8:00';即可成功

 

首先，我们先写一下单元测试的代码 一些注释都在里面了

package com.user.pack;

import javax.annotation.Resource;


import com.user.pack.domain.AyUser;

import java.sql.ResultSet;
import