Springboot配置mybatis出现异常：java.io.FileNotFoundException: class path resource [classpath:/mapper/*.xml]

Bertha 。 2021-11-05 05:46 875阅读 0赞

一. 由于项目采用springboot框架开发，配置mybatis时，启动之后，控制报错主要信息如下：

java.io.FileNotFoundException: class path resource \[classpath:mapper/\*.xml\] cannot be opened because it does not exist

经过耐心，查找，最后发现时配置问题 mybatis配置没对。

二.application.properties配置方式如下：

server.port=8088
    mybatis.mapper-locations=classpath:mapping/*.xml
    mybatis.type-aliases-package=com.recharge.componet.dataobject
    
    # 分页配置
    #pagehelper.helper-dialect=mysql
    #pagehelper.reasonable=true
    #pagehelper.support-methods-arguments=true
    #pagehelper.params=count=countSql
    
    spring.datasource.name=qjyrecharge
    spring.datasource.username=root
    spring.datasource.password=123
    useUnicode=true&characterEncoding=UTF-8&useSSL=false&zeroDateTimeBehavior=convertToNull
    spring.datasource.url=jdbc:mysql://localhost:3306/rechargecard?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    #数据库连接池
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    
    #redis配置
    spring.redis.database=3
    spring.redis.host=xxxx
    spring.redis.port=xxxx
    spring.redis.password=xxxx
    spring.redis.pool.max-idle=10
    spring.redis.pool.min-idle=5
    spring.redis.pool.max-active=10
    spring.redis.pool.max-wait=-60
    spring.redis.timeout=20000