如何解决框架集成Mybatis Plus中未找到绑定语句的问题

这篇文章给大家介绍如何解决框架集成Mybatis Plus中未找到绑定语句的问题，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

1.引入jar包，我就是没引入mybatis-plus-extension jar包报 invalid bound statement (not found)错误，具体的可以查看官方文档http://doc.ruoyi.vip/ruoyi/document/cjjc.html#%E9%9B%86%E6%88%90mybatis-plus%E5%AE%9E%E7%8E%B0mybatis%E5%A2%9E%E5%BC%BA

<!-- mybatis-plus --><dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-boot-starter</artifactId>
   <version>3.4.2</version></dependency><dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-extension</artifactId>
   <version>3.4.2</version></dependency><dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus-core</artifactId>
   <version>3.4.2</version></dependency><dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>mybatis-plus</artifactId>
   <version>3.4.2</version></dependency>

2.需要替换原来的MybatisConfig

package com.ruoyi.framework.config;import com.baomidou.mybatisplus.annotation.DbType;import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;import com.baomidou.mybatisplus.extension.plugins.inner.BlockAttackInnerInterceptor;import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;import org.mybatis.spring.annotation.MapperScan;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.transaction.annotation.EnableTransactionManagement;/** * Mybatis Plus 配置 * * @author ruoyi */@EnableTransactionManagement(proxyTargetClass = true)@Configuration@MapperScan({"com.ruoyi.project.**.mapper","com.ruoyi.business.**.mapper"})public class MybatisPlusConfig
{@Bean    public MybatisPlusInterceptor mybatisPlusInterceptor()
    {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();// 分页插件        interceptor.addInnerInterceptor(paginationInnerInterceptor());// 乐观锁插件        interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor());// 阻断插件        interceptor.addInnerInterceptor(blockAttackInnerInterceptor());return interceptor;
    }/**     * 分页插件，自动识别数据库类型 https://baomidou.com/guide/interceptor-pagination.html     */    public PaginationInnerInterceptor paginationInnerInterceptor()
    {
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();// 设置数据库类型为mysql        paginationInnerInterceptor.setDbType(DbType.MYSQL);// 设置最大单页限制数量，默认 500 条，-1 不受限制        paginationInnerInterceptor.setMaxLimit(-1L);return paginationInnerInterceptor;
    }/**     * 乐观锁插件 https://baomidou.com/guide/interceptor-optimistic-locker.html     */    public OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor()
    {return new OptimisticLockerInnerInterceptor();
    }/**     * 如果是对全表的删除或更新操作，就会终止该操作 https://baomidou.com/guide/interceptor-block-attack.html     */    public BlockAttackInnerInterceptor blockAttackInnerInterceptor()
    {return new BlockAttackInnerInterceptor();
    }
}

关于如何解决框架集成Mybatis Plus中未找到绑定语句的问题就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。