SpringBoot和Mybatis整合二(基于配置文件)

迈不过友情╰ 2022-05-11 05:54 198阅读 0赞

### ps:可先看[SpringBoot和Mybatis整合一(基于注解)][SpringBoot_Mybatis]，再看整合二 ###

项目结构：

![70][]

**EmployeeMapper:**

package com.lucifer.springboot.mapper;
    
    import com.lucifer.springboot.bean.Employee;
    
    public interface EmployeeMapper {
        public Employee getEmployee(Integer id);
    
        public void insertEmp(Employee employee);
    }

**EmployeeMapper.xml:    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.lucifer.springboot.mapper.EmployeeMapper">
        <select id="getEmployee" resultType="com.lucifer.springboot.bean.Employee">
          select * from employee where id=#{id}
      </select>
    
        <insert id="insertEmp" >
          insert into employee(lastName,email,gender,d_id) values (#{lastName},#{email},#{gender},#{dId})
        </insert>
    </mapper>

**mybatis-config.xml： mybatis配置文件，mapUnderscoreToCamelCase设置为true，就可以开启驼峰命名规则。**

[参考：mybatis官方文档][mybatis]

![70 1][]

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <settings>
            <setting name="mapUnderscoreToCamelCase" value="true"/>
        </settings>
    </configuration>

**application.yml： 增加两行配置 **

![70 2][]

**EmployeeController：**

package com.lucifer.springboot.controller;
    
    import com.lucifer.springboot.bean.Employee;
    import com.lucifer.springboot.mapper.EmployeeMapper;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RestController;
    
    /**
     * @author: Lucifer
     * @create: 2018-09-20 15:00
     * @description:
     **/
    @RestController
    public class EmployeeController {
    
        @Autowired
        EmployeeMapper employeeMapper;
    
        @GetMapping("/emp/{id}")
        public Employee getemployee(@PathVariable("id") Integer id){
            return employeeMapper.getEmployee(id);
        }
    
    }

**浏览器输入路径:**

![70 3][]

**ps：如果did对应的value是null的话，看数据库中表中该字段数据是否为空，再看是否开启了驼峰命名规则。**

[SpringBoot_Mybatis]: https://blog.csdn.net/qq_37495786/article/details/82784724
[70]: /images/20220511/ce2a39e852174b2a96845e3d26d61151.png
[mybatis]: http://www.mybatis.org/mybatis-3/zh/configuration.html
[70 1]: /images/20220511/d94bd4d7122d49c3a699d284f2060b81.png
[70 2]: /images/20220511/eafb7e0b637a4f2990af019546d14896.png
[70 3]: /images/20220511/f44e244de821495ab8a8e713305936a3.png