1.使用mapper接口使用@Autowired报错
@Controller
public class MapperController {
@Autowired
private ProductMapper productMapper;
}
在mapper接口添加注解 @Component
@Mapper
@Component
public interface ProductMapper {
public List<Product> findAllProduct();
}
2.java.sql.SQLException: The server time zone报错
java.sql.SQLException: 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.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.19.jar:8.0.19]
时区错误,在配置文件中更改数据库连接配置,添加 serverTimezone=UTC
spring.datasource.url=jdbc:mysql://localhost:3306/java_springboot?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC