【SpringBoot__Mybatis】整合MyBatis 配置文件版

【SpringBoot__Mybatis】整合MyBatis注解版

application.yml增加

mybatis:
  config-location: classpath:mybatis/mybatis-config.xml   #指定全局配置文件的位置
  mapper-locations: classpath:mybatis/mapper/*.xml    #指定sql映射文件的位置

mybatis-config.xml

<?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>

mybatis/mapper/EmployeeMapper.xml

<?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="k.mapper.EmployeeMapper">
<!--    public Employee getEmpById(Integer id);

 public void insertEmp(Employee employee);-->
<select id="getEmpById" resultType="k.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>

EmployeeMapper

package k.mapper;

import k.bean.Employee;

public interface EmployeeMapper {

    public Employee getEmpById(Integer id);

    public void insertEmp(Employee employee);
}