SpringBoot-Mybatis

SpringBoot

1.注意点：

<mapper namespace="cn.pheker.springbootdemo.dao.UserMapper">
  <resultMap id="BaseResultMap" type="cn.pheker.springbootdemo.model.User">
    <id column="id" jdbcType="VARCHAR" property="id" />
    <result column="login_name" jdbcType="VARCHAR" property="loginName" />
    <result column="real_name" jdbcType="VARCHAR" property="realName" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="email" jdbcType="VARCHAR" property="email" />
    <result column="telephone" jdbcType="VARCHAR" property="telephone" />
    <result column="address" jdbcType="VARCHAR" property="address" />
  </resultMap>
  <select id="selectAll" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from t_user
  </select>
</mapper>

1. namespace是Mapper接口的全路径名

2. resultMap的type一般是对应的实体类全路径名

3. id名须与Mapper接口中的方法名一致

4. 须在Mapper接口上添加注解@Mapper

5. 须在启动类上添加注解

@MapperScan("cn.pheker.springbootdemo.mapper")
用来扫描*Mapper.xml这样的文件,参数是xml的basePackage,可配置多个

6. application.yml配置文件中配置

mybatis:
  mapperLocations: classpath*:cn/pheker/springbootdemo/mapper/*.xml
  typeAliasesPackage: cn.pheker.springbootdemo.model

7.BindingException异常

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): cn.pheker.demo.springbootdemo.dao.TUserMapper.queryAll

发生此异常时须仔细检查上面注意事项,如果还是有问题，则在pom文件的build下添加

<!--打包时包含源代码包下的资源文件-->
<resources>
    <resource>
        <directory>src/main/java</directory>
        <includes>
            <include>**/*.properties</include>
            <include>**/*.xml</include>
        </includes>
    </resource>
</resources>

2.网上文章

SpringBoot集成Mybatis