Invalid bound statement (not found) 错误

原xml配置

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="mapperLocations" value="classpath:/META-INF/mapper/*.xml"/>
        <property name="configLocation" value="classpath:/META-INF/mybatis.xml"/>
        <property name="typeAliasesPackage" value="com.huobi.local.domain"/>
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.huobi.local.dao,com.huobi.local.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

构建SqlSessionFactory必须使用MybatisPlust实现的MybatisSqlSessionFactoryBean对象,否则mybatisPlus的一些特性会丢失, 自带的增删改查方法用不了。

替换为

<bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
        <property name="mapperLocations">
        <array>
            <value>classpath:/META-INF/mapper/*.xml</value>
            <value>classpath*:/mapper/**Mapper.xml</value>
        </array>
        </property>
        <property name="configLocation" value="classpath:/META-INF/mybatis.xml"/>
        <property name="typeAliasesPackage" value="com.huobi.local.domain"/>
        <property name="dataSource" ref="dataSource"/>
        <!--分页插件配置-->
        <property name="plugins">
            <array>
                <ref bean="mybatisPlusInterceptor"/>
            </array>
        </property>
    </bean>
    
    <bean id="mybatisPlusInterceptor" class="com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor">
        <property name="interceptors">
            <list>
                <ref bean="paginationInnerInterceptor"/>
            </list>
        </property>
    </bean>

    <bean id="paginationInnerInterceptor" class="com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor">
        <constructor-arg name="dbType" value="MYSQL"/>
        <property name="dbType" value="MYSQL" />
        <property name="maxLimit" value="-1" />
        <property name="optimizeJoin" value="true" />
    </bean>

    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.huobi.local.dao,com.huobi.local.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐