如何解決Maven引入SSM框架出現(xiàn)的異常問(wèn)題

IntelliJ IDEA 開(kāi)發(fā)Spring-mvc +mybits 項(xiàng)目時(shí)，啟動(dòng)tomcat后瀏覽器發(fā)送請(qǐng)求后收到了500服務(wù)器錯(cuò)誤，錯(cuò)誤如下：

HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.creditease.proxymanager.dao.ProxyInfoDAO.getProxyInfo

type Exception report

message Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.creditease.proxymanager.dao.ProxyInfoDAO.getProxyInfo

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.creditease.proxymanager.dao.ProxyInfoDAO.getProxyInfo
    org.springframework.web.servlet.FrameworkServlet.proce***equest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.creditease.proxymanager.dao.ProxyInfoDAO.getProxyInfo

網(wǎng)上搜了一下，問(wèn)題出在沒(méi)找到Mapper XML 文件
經(jīng)過(guò)多次嘗試發(fā)現(xiàn)出現(xiàn)這個(gè)問(wèn)題的原因在于mybatis逆向生成mapper接口和mapper.xml文件放在了同一個(gè)文件夾中，在編譯打包時(shí)沒(méi)法加載mapper.xml文件。

兩種解決方式

• 方式一：

  • mapper接口和mapper.xml文件都在同一個(gè)路徑下時(shí)，在pom.xml文件添加如下內(nèi)容: 問(wèn)題解決

    <build>
        <resources>
                <resource>
                        <directory>src/main/java</directory>
                        <includes>
                                <include>**/*.properties</include>
                                <include>**/*.xml</include>
                        </includes>
                        <filtering>false</filtering>
                </resource>
        </resources>
    </build>

• 方式二：
  • 將逆向生成的mapper和mapper.xml文件分別放在main/java和main/resources下同級(jí)包下，編譯打包時(shí)會(huì)把resources下的文件直接讀取進(jìn)去，就不會(huì)出現(xiàn)找不到mapper.xml的錯(cuò)誤