SpringBoot整合Mybatis -- 配置文件版

1、项目资源结构目录

2、创建mybatis-config.xml

<configuration>
    <!--驼峰命名-->
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <typeAliases>
        <package name="com.dhu.pojo"/>
    </typeAliases>

    <!--需要将mapper接口类名和mapper.xml映射文件名称保持一致，且在一个目录-->
    <mappers>
        <package name="com.dhu.mapper"/>
    </mappers>
</configuration>

3、创建EmployeeMapper.xml

<mapper namespace="com.dhu.mapper.EmployeeMapper">
     <select id="queryById" parameterType="Integer" resultType="employee">
         select * from employee where id = #{id}
     </select>

    <insert id="insert" parameterType="employee">
        insert into employee(lastName, email, gender, d_id) values(#{lastName}, #{email}, #{gender}, #{dId})
    </insert>
</mapper>

4、application.yml文件中配置，指定全局配置文件的位置

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

5、编写controller

  @ResponseBody
    @GetMapping("/emp/{id}")
    public Employee findEmpById(@PathVariable("id") Integer id){ //@PathVariable接收请求路径中占位符的值
        Employee employee = employeeMapper.queryById(id);
        return employee;
    }