springboot整合mybatis，详细案例

傷城~ 2023-10-06 11:51 32阅读 0赞

### 1.数据表 ###

user表  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70]

### 2.创建springboot项目添加依赖starter ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][202006231603491.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 2]

### 3.编写相关类和配置文件 ###

**提示：本案例省略了service层。**

### 3.1实体类User ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 3]

package com.kuang.pojo;
    
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    public class User {
        
        private int id;
        private String name;
        private String pwd;
    }

### 3.2 UserMapper接口 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 4]

package com.kuang.mapper;
    
    import com.kuang.pojo.User;
    import org.apache.ibatis.annotations.Mapper;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    @Mapper //@Mapper:表示本类是一个 MyBatis 的 Mapper
    @Repository //交给spring的IOC容器管理
    public interface UserMapper {
        
    
        //查询所有用户
        List<User> listUser();
    
    }

### 3.3 UserController ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 5]

package com.kuang.controller;
    
    import com.kuang.mapper.UserMapper;
    import com.kuang.pojo.User;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    @RestController
    public class UserController {
        
    
        @Autowired
        private UserMapper userMapper;
    
        @GetMapping("/list")
        public List<User> listUser(){
        
    
            return userMapper.listUser();
        }
    
    }

### 3.4 userMapper.xml文件 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 6]

<?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="listUser" resultType="User">
          select * from user;
        </select>
      
    </mapper>

### 4.编写application.properties配置文件 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 7]

# 数据库配置
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.url=jdbc:mysql://localhost:3306/day01?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    
    # 整合mybatis
    mybatis.type-aliases-package=com.kuang.pojo
    mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

### 5.测试 ###

**浏览器输入：localhost://8080/list**  
![在这里插入图片描述][20200623163044416.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200623160105254.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200623160225400.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[202006231603491.png]: https://img-blog.csdnimg.cn/202006231603491.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200623160443279.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2020062316112997.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200623161559624.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200623161737104.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200623162613516.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200623162907732.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMTgyMDM0,size_16,color_FFFFFF,t_70
[20200623163044416.png]: https://img-blog.csdnimg.cn/20200623163044416.png