Mybatis-Plus报错:报错信息如下
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.auth.car.mapper.TbCarInformationMapper.selectCars
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:50)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedMapperMethod$0(MybatisMapperProxy.java:101)
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedMapperMethod(MybatisMapperProxy.java:100)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:95)
at com.sun.proxy.$Proxy98.selectCars(Unknown Source)
这里使用的mybatis-puls,我想把xml文件放入src目录下,但是却报了这个错误,然后我在yml中添加了如下配置正常来说是可以行得通的,但还是不起作用,
mybatis-plus:
mapper-locations: classpath*:com/auth/**/mapper/xml/*.xml
添加了以下maven依赖即可得以解决问题
<build>
<resources>
<resource>
<directory>src/main/resources</directory>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
</build>
还有以上解决办法仅限于mybatis-plus中使用,并且在如下问题之外,
因为以下问题也可能存在这种报错!
紧接着我从数据库查 出来的时间比正常时间多出了8个小时,这与时差有关系,
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/db_project?serverTimezone= GMT%2B8
username: root
password: 123
#配置初始化大小
initialSize: 5
#最小空闲连接
minIdle: 5
#最大连接数量
maxActive: 100
#配置获取连接等待超时的时间
maxWait: 60000
jackson:
time-zone: GMT+8
jackson:
time-zone: GMT+8即是解决方法。