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>