springboot问题

最新推荐文章于 2024-10-08 17:06:19 发布

不带刺仙人球

最新推荐文章于 2024-10-08 17:06:19 发布

阅读量243

点赞数

分类专栏： springboot 文章标签： springboot问题

本文链接：https://blog.csdn.net/zyzn1425077119/article/details/104271255

版权

springboot 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

本文解析了SpringBoot中常见的三个问题：警告信息提示@ComponentScan扫描默认包，解决方法是创建controller包；Mapper创建失败，需手动配置sqlSessionFactory或sqlSessionTemplate；MySQL时区配置错误，需在连接字符串中指定时区。

摘要由CSDN通过智能技术生成

代码参考：https://github.com/zyzn123/springboot_test/tree/master/%E6%B3%A8%E8%A7%A3%E7%89%88%E6%9C%AC/springboot1

1 出现：

** WARNING ** : Your ApplicationContext is unlikely to start due to a @ComponentScan of the default package.

此为应用直接放到src下面，需要建立一个controller包，放到该下面进行启动即可。如

package com.demo.controller;

@MapperScan(value="com.demo.mapper")
@SpringBootApplication
public class DemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

2、Mapper创建失败，如

nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'departmentMapper' defined in file [C:\xxxsscom\demo\mapper\DepartmentMapper.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required

springBoot+mybatis报错Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required

因为1.2.0版本后，去掉了sqlSessionFactory和sqlSessionTemplate的自动注解，需要手动。

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.3.2</version>
</dependency>

添加：完成自动注解

<groupId>org.mybatis.spring.boot</groupId>

<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

3、出现

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException:
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.

解决办法;

在连接字符串后面加上?serverTimezone=UTC

其中UTC是统一标准世界时间。

完整的连接字符串示例：jdbc:mysql://localhost:3306/test?serverTimezone=UTC

或者还有另一种选择：jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8，这个是解决中文乱码输入问题，当然也可以和上面的一起结合：jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC