基于springboot的mybatisxml配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.EmpMapper">
 <!--resultType 返回值的类型-->
    <select id="list" resultType="pojo.Emp">
        select * from emp where name like concat('%',#{name},'%') and gender =#{gender} and entrydate between #{begin}
        and #{end} order by update_time desc
    </select>
</mapper>

①:XML映射文件的名称与Mapper接口名称一致,并且将XML文件和Mapper接口放在相同包下(同包同名)

②XML映射文件的namespace属性为Mapper接口全限定名一致

③XML映射文件中的sql语句与mapper接口中的方法名一致,并保持返回类型一致