SpringBoot3.2.x整合MyBatis-Plus3.x报错

闻音麻花

已于 2024-01-21 13:51:30 修改

阅读量826

点赞数 10

分类专栏： SpringBoot 文章标签： mybatis springboot java

于 2023-12-31 11:54:10 首次发布

本文链接：https://blog.youkuaiyun.com/m0_61591135/article/details/135314442

版权

SpringBoot 专栏收录该内容

7 篇文章

订阅专栏

文章讲述了在SpringBoot3.2.1中整合MyBatis-Plus时遇到的两个常见问题：依赖错误和类型不匹配，提供了解决方案，包括正确引入依赖和配置mapper接口。还提及了SQL日志设置和驼峰命名转下划线的配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SpringBoot3整合MyBatis-Plus报错挺折磨人的。。。好好看官方文档

MyBatis-Plus 官方文档地址：https://baomidou.com/
报错1：

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.xxx.xxx.mapper.UserMapper.selectList

出现这种错误的话，应该是你的MyBatis-Plus引入的依赖错误

官方文档要求引入的依赖如下图：

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
    <version>最新版本</version>
</dependency>

报错2:

Bean named 'ddlApplicationRunner' is expected to be of type 'org.springframework.boot.Runner' but was actually of type 'org.springframework.beans.factory.support.NullBean'

SpringBoot3.2.1整合MyBatis-Plus出现了这种错误；请将MyBatis-Plus依赖的版本换成最新版本

解决方案：

   <dependency>
       <groupId>com.baomidou</groupId>
       <artifactId>mybatis-plus-spring-boot3-starter</artifactId>
       <version> 3.5.5</version>
   </dependency>

一般来说就这两个问题

如果出现了

Failed to load ApplicationContext for [WebMergedContextConfiguration@49e2b3c5 testClass = com.mahua.juanjucenter.JuanjuCenterApplicationTests, locations = [], classes = [com.xxx.xxxx.xxxApplication], contextInitializerClasses = [], activeProfiles = [], propertySourceDescriptors = [], propertySourceProperties = ["org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true"], contextCustomizers = [org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@e350b40, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@13e344d, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@740cae06, org.springframework.boot.test.autoconfigure.actuate.observability.ObservabilityContextCustomizerFactory$DisableObservabilityContextCustomizer@1f, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizer@75d3a5e0, org.springframework.boot.test.context.SpringBootTestAnnotation@62e60f77], resourceBasePath = "src/main/webapp", contextLoader = org.springframework.boot.test.context.SpringBootContextLoader, parent = null]
	at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:180) ~[spring-test-6.1.2.jar:6.1.2]
	at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:130) ~[spring-test-6.1.2.jar:6.1.2]
	at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:191) ~[spring-test-6.1.2.jar:6.1.2]
	at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:130) ~[spring-test-6.1.2.jar:6.1.2]
	at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:260) ~[spring-test-6.1.2.jar:6.1.2]
	at org.springframework.test.context.junit.jupiter.SpringExtension.postProcessTestInstance(SpringExtension.java:163) ~[spring-test-6.1.2.jar:6.1.2]
	at org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.lambda$invokeTestInstancePostProcessors$10(ClassBasedTestDescriptor.java:378) ~[junit-jupiter-engine-5.10.1.jar:5.10.1]
	at org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.executeAndMaskThrowable(ClassBasedTestDescriptor.java:383) ~[junit-jupiter-engine-5.10.1.jar:5.10.1]
	at org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.lambda$invokeTestInstancePostProcessors$11(ClassBasedTestDescriptor.java:378) ~[junit-jupiter-engine-5.10.1.jar:5.10.1]
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) ~[na:na]
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[na:na]
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625) ~[na:na]
	at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
	at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[na:na]
	at java.base/java.util.stream.StreamSpliterators$WrappingSpliterator.forEachRemaining(StreamSpliterators.java:310) ~[na:na]
//以及

 Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]:

这种错误，读不了dataSource说明一个application.yml文件出现了错误，请确保数据库配置信息缩进恰当
application.yml文件配置错误

报错3：

 Error creating bean with name 'userServiceImpl': Unsatisfied dependency expressed through field 'baseMapper': No qualifying bean of type 'com.xxx.xxxx.mapper.UserMapper' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:787) ~[spring-beans-6.1.2.jar:6.1.2]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:767) ~[spring-beans-6.1.2.jar:6.1.2]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:145) ~[spring-beans-6.1.2.jar:6.1.2]

这种一般是mapper层的mapper接口没有加上@Mapper注解

补充内容：开始MyBatis-Plus的SQL日志

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

驼峰命名转换为下划线
官方文档所示MyBatis-Plus是默认开启转换的，而MyBatis则是默认关闭转换的，当集成MyBatis-Plus框架时，不需要再开启驼峰命名转换为下划线。

mybatis-plus:
  configuration:
    map-underscore-to-camel-case: false