spring-boot集成mybatis

1.启动类加注解@MapperScan

@SpringBootApplication
@EnableConfigurationProperties({LiquibaseProperties.class })
@MapperScan("com.xxx.mapper")
public class DemoApplication {

   public static void main(String[] args) {
      SpringApplication.run(DemoApplication.class, args);
   }
}

2. EmpMapper.xml文件，放在resources目录下，这里放在resouces/mapper目录下

<?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="com.camelot.mapper.EmpMapper" >

    <resultMap id="empMapping" type="com.camelot.domain.EmpEntity">
        <id column="id" property="id"/>
        <result column="emp_name" property="emp_name"/>
        <result column="emp_id" property="emp_id"/>
        <result column="emp_work" property="emp_work"/>
    </resultMap>

    <select id="selectByName" resultMap="empMapping" parameterType="java.lang.String" >
        select
        *
        from hw_emp
        where emp_name = #{name,jdbcType=VARCHAR}
    </select>
</mapper>

3.application.yml配置

mybatis:
   mapper-locations: classpath:mapper/*.xml  

spring:
   datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://192.168.98.128:3306/hw?useUnicode=true&characterEncoding=utf8
      username: root
      password: root
4. mapper类

public interface EmpMapper {

    public EmpEntity selectByName(String name);

}