mapper 映射 及相关问题

xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="ProcessFault.mapper.testdctdb.DctdbMapper">
  <resultMap id="BaseResultMap" type="ProcessFault.entity.dctdb.BarCodes">
    <result column="Sequence" jdbcType="INTEGER" property="sequence" />
    <result column="TerminalID" jdbcType="NVARCHAR" property="terminalid" />
  </resultMap>
  <sql id="Base_Column_List">
    t.Sequence, t.TerminalID
  </sql>
  
    <select id="getAll" resultType="map">
        select top 1000 t.*
        from GDCT.BarCodes t
    </select>

</mapper>

 启动类：

@MapperScan({"com.xxx.mapper.*"})

Pom文件：配置resource

<build>

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

注意：

1、xml和mapper文件名一致

2、xml的namespace导向mapper要可行

3、mapper方法名和xml中的id一致

4、如果想吧mapper.xml文件写在resources下的话，新建的包要用 “ / ” 分开 而不是用 “ . ”。eg：com/xxx/xxx。如果是“.”会导致方法名找不到。

出现Invalid bound statement (not found)错误。