SpringBoot 整合Mybatis

最新推荐文章于 2025-03-26 12:44:15 发布

原创最新推荐文章于 2025-03-26 12:44:15 发布 · 101 阅读

0 ·

CC 4.0 BY-SA版权

springboot学习专栏收录该内容

16 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中整合Mybatis，包括添加依赖、配置数据库、创建实体和Mapper、编写SQL映射及Controller测试。从数据库连接到自动化操作，一步步教你搭建Mybatis的SpringBoot应用。

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

1 SpringBoot 整合Mybatis

前言

官方文档：http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

Maven仓库地址：https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter/2.1.1

1 导入依赖

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2 配置数据库连接信息

spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=Asia/Shanghai
mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml
  type-aliases-package: com.kuang.pojo

3 创建实体类 User


@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {

    private Integer id;
    private String name;
    private String pwd;

}

4 创建Mapper 接口 UserMapper


@Mapper
@Repository
public interface UserMapper {
    // 获取所有员工信息
    List<User> getUser();

    // 新增一个员工
    int save(User user);

    // 通过id获得员工信息
    User get(Integer id);

    // 通过id删除员工
    int delete(Integer id);


}

@Mapper 可以自动装配dao层，可替代启动时自动扫描
@Repository 注册bean
上面两个不能少

如果XxxMapper 文件多，可以在使用@MapperScan 代替@Mapper

@SpringBootApplication
@MapperScan("com.kuang.mapper")
public class SpringbootMybatisApplication {

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

}

5 创建Mapper 配置文件，也可以不创建使用注解写Sql
在这里插入图片描述

<?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.kuang.mapper.UserMapper">
    <select id="getUser" resultType="User">
        select *
        from user;
    </select>

    <insert id="save" parameterType="User">
        insert  into user(id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>

    <select id="get" resultType="User" parameterType="int">
        select *
        from user where id=#{id};
    </select>

    <delete id="delete" parameterType="int">
        delete  from user  where id=#{id}
    </delete>
</mapper>

6 在springboot 配置文件中，配置mybatis的相关信息,具体配置可看MybatisProperties类

mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml
  type-aliases-package: com.kuang.pojo

7 编写controller 测试 UserController

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/getUser")
    public List<User> getUser(){
        List<User> user = userMapper.getUser();
        return  user;
    }


    @RequestMapping("/getUserById/{id}")
    public Object getUserById(@PathVariable("id") Integer id){
        User user = userMapper.get(id);
        return user;
    }

}

结果成功访问