springboot2.0与mybatis整合

最新推荐文章于 2021-02-05 22:58:05 发布

cax2017

最新推荐文章于 2021-02-05 22:58:05 发布

阅读量143

点赞数

CC 4.0 BY-SA版权

分类专栏： springboot java 文章标签： spring boot mybatis

本文链接：https://blog.youkuaiyun.com/cax2017/article/details/105239229

java 同时被 2 个专栏收录

12 篇文章

订阅专栏

springboot

4 篇文章

订阅专栏

本文介绍如何在SpringBoot项目中集成MyBatis，包括使用依赖包mybatis-spring-boot-starter，通过注解和配置文件两种方式实现数据访问层的开发。详细解释了@Mapper注解的使用及XML配置的指定。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis为了自动适配springboot开发适配包，需要引入

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis‐spring‐boot‐starter</artifactId>
    <version>2.1.2</version>
</dependency>

可以使用2种方式整合

一、注解方式，直接在dao上注解

@Mapper
public interface DepartmentMapper {
    @Select("select * from department where id=#{id}")
    public Department getDeptById(Integer id);

    @Delete("delete from department where id=#{id}")
    public int deleteDeptById(Integer id);

    @Options(useGeneratedKeys = true, keyProperty = "id")
    @Insert("insert into department(departmentName) values(#{departmentName})")
    public int insertDept(Department department);

    @Update("update department set departmentName=#{departmentName} where id=#{id}")
    public int updateDept(Department department);
}

备注：需要加入@Mapper才能被扫描到或者在全局（SpringbootmybatisApplication）上进行配置@MapperScan(value = "com.cax.springboot.mapper")

二、使用配置文件方式

使用该方式实现需要指定xml实现文件

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

@Mapper
public interface EmployeeMapper {

    public Employee getEmployeeById(Integer id);
    
}

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="com.cax.springboot.mapper.EmployeeMapper">
    <select id="getEmployeeById" parameterType="Integer" resultType="com.cax.springboot.entry.Employee">
        select * from employee where id = #{id}
    </select>
</mapper>