使用SpringBoot找不到Mapper的Bean問(wèn)題及解決

更新時(shí)間：2026年04月26日 10:45:47 作者：人間_過(guò)客

這篇文章主要介紹了使用SpringBoot找不到Mapper的Bean問(wèn)題及解決,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教

SpringBoot找不到Mapper的Bean

記一次令人抓狂的錯(cuò)誤解決經(jīng)歷，先說(shuō)結(jié)果：

數(shù)據(jù)庫(kù)版本使用錯(cuò)誤，沒(méi)有配置pom文件中的版本號(hào)，默認(rèn)使用了本地驅(qū)動(dòng)中的最高6版本。

更改為5版本即可發(fā)生報(bào)錯(cuò)后找了很多的文檔也沒(méi)有符合我這個(gè)樣子的，于是我就把自己的經(jīng)歷寫(xiě)下來(lái)，給和我一樣犯了這個(gè)錯(cuò)的初學(xué)者看。

初期報(bào)錯(cuò)

@Service
public class UserService {

    @Autowired
    private DeptMapper deptMapper;//此處報(bào)錯(cuò)為找不到mapper類型的Bean

檢查啟動(dòng)類中已經(jīng)正確配置路徑。

強(qiáng)行啟動(dòng)程序后

//這句話說(shuō)使用數(shù)據(jù)庫(kù)鏈接應(yīng)該使用帶cj那個(gè)，說(shuō)明使用的驅(qū)動(dòng)版本是6，但是編寫(xiě)的配置文件是5的配置。
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
//這句說(shuō)的是找不到mapper的目錄
Property 'mapperLocations' was not specified.?

如果強(qiáng)行調(diào)用service

就會(huì)出現(xiàn)如下錯(cuò)誤：

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6b3ac131]
2021-06-05 16:43:55.847 ERROR 32732 --- [p-nio-80-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
### The error may exist in top/loveeveryone/mapper/DeptMapper.java (best guess)
### The error may involve top.loveeveryone.mapper.DeptMapper.selectByPrimaryKey
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.] with root cause
//說(shuō)數(shù)據(jù)庫(kù)時(shí)區(qū)有問(wèn)題

綜合檢查，發(fā)現(xiàn)數(shù)據(jù)庫(kù)驅(qū)動(dòng)有問(wèn)題。

在pom文件中加載Mysql數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序時(shí)沒(méi)有添加驅(qū)動(dòng)程序版本，默認(rèn)使用最高版本導(dǎo)致驅(qū)動(dòng)失敗。

將驅(qū)動(dòng)修改至5版本就好了