Error Records
1.
Description:
Failed to configure a DataSource: no embedded datasource could be configured.
Reason: Failed to determine a suitable driver class
Action:
Consider the following:
If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).
A：
检查application.properties中的数据库相关配置是否有误，pom.xml文件中是否有依赖冲突，
如果都是OK的，那就去pom.xml中添加如下配置，参考出处
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
<include>**/*.yml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
<include>**/*.yml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
2.Field xx in xx required a bean of type 'xxxMapper' that could not be found问题
A：添加@MapperScan("com.xxx.xxx")，检查service的impl类有没有添加@service注解
3.本地数据库连接不上，报错
2003 - Can't connect to MySQL server on '127.0.0.1' (61 "Connection refused")
A：
关闭mysql服务:苹果->系统偏好设置->最下边点mysql 在弹出页面中 关闭mysql服务（点击stop mysql server）或者使用命令：sudo /usr/local/mysql/support-files/mysql.server stop，强制关闭；
进入终端输入：cd /usr/local/mysql/bin
回车后 登录管理员权限 sudo su （输入你电脑的密码）
回车后输入以下命令来禁止mysql验证功能： ./mysqld_safe --skip-grant-tables
回车后mysql会自动重启（偏好设置中mysql的状态会变成running）
输入命令 ./mysql
回车后，输入命令 FLUSH PRIVILEGES;
回车后，输入命令 ALTER user 'root'@'localhost' IDENTIFIED BY '123456'
重启mysql:sudo /usr/local/mysql/support-files/mysql.server restart
4.SpringBoot 查询时间数据 数据库和返回数据相差8个小时，解决办法
public class ArticleListVo {
private Long articleId;
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
private Date createTime;
}
5.springboot中配置addResourceHandler和addResourceLocations，springboot无法读取静态资源
找到继承WebMvcConfigurationSupport的类，配置如下：
@Override
public void addResourceHandlers(ResourceHandlerRegistry registry) {
registry.addResourceHandler("/**").addResourceLocations("classpath:/static/");
registry.addResourceHandler("swagger-ui.html")
.addResourceLocations("classpath:/META-INF/resources/");
registry.addResourceHandler("/webjars/**")
.addResourceLocations("classpath:/META-INF/resources/webjars/");
}
swagger如果没有用到，可以删除
6.接口返回$ref":"$.data.***
FastJson的JSONArray类型作为返回数据，当像JSONArray对象中添加JSONObject对象，而JSONObject对象中包含相同的节点数据时，FastJson会防止返回数据栈溢出的问题，自动将JSONArray中相同的节点数据使用引用方式代替。将返回的List转Object，JSONArray.toJSON。或者在循环里重新new 一个对象，用new 出来的对象放到子list
