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>