使用IDEA搭建SpringBoot项目整合Mybatis踩的坑。。。。

1.application.yml忘记配置mybatis，或者mybatis配置错误，启动不会报错，运行报错：
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): idea.spring.springboot.Mapper.UserMapper.selectByPrimaryKey] with root cause

2.Mapper接口没有加注解@Mapper，启动报错：
Field userMapper in idea.spring.springboot.Service.Impl.UserServiceImpl required a bean of type 'idea.spring.springboot.Mapper.UserMapper' that could not be found.

3.使用freemarker，swagger2，没有新建view（xxx.ftl），启动不会报错，运行报错：
javax.servlet.ServletException: Circular view path [user1]: would dispatch back to the current handler URL [/User/user1] again. Check your ViewResolver setup! (Hint: This may be the result of an unspecified view, due to default view name generation.)

4.application.yml配置datasource，url: jdbc:mysql://127.0.0.1:3306/springboot 启动不会报错，运行报错：
Failed to obtain JDBC Connection; nested exception is 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.] with root cause
解决方案：url改为  jdbc:mysql://127.0.0.1:3306/springboot?serverTimezone=UTC&characterEncoding=utf-8