SpringBoot入门之SpringBoot整合Mybatis 07

待我称王封你为后i 2021-11-11 10:02 484阅读 0赞

# 7. SpringBoot整合Mybatis #

## 7.1 pom依赖导入Mybatis启动器 ##

**Mybatis依赖一定要有版本号,而且Mybatis版本一定要导入1.1.1, 否则Mapper上的@Mapper注解会报红报错**

<dependency>
          <groupId>org.mybatis.spring.boot</groupId>
          <artifactId>mybatis-spring-boot-starter</artifactId>
          <version>1.1.1</version>
    </dependency>

## 7.2 dao包下创建UserMapper接口 ##

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

package com.acece.dao;
    
    import com.acece.domain.User;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    /** * @author 啊策策 * @date 2019-08-05 15:54 */
    @Mapper
    public interface UserMapper { 
    
        @Select("select id as userId, user_name as userName, password, name from user where name like '%${value}%'")
        public List<User> queryUserByName(String name);
    }

## 7.3 service包下UserService接口中添加findUserByName()方法 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 1]

package com.acece.service;
    import com.acece.domain.User;
    import java.util.List;
    
    public interface UserService { 
    
        /** * 验证SpringBoot整合SpringDataJPA的方法 * @return */
        List<User> findAll();
    
        /** *验证SpringBoot整合Mybatis的方法 * @param name * @return */
        List<User> findUserByName(String name);
    }

## 7.4 service.impl包下,UserServiceImpl实现类中重写findUserByName()方法 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 2]

package com.acece.service.impl;
    
    import com.acece.dao.UserDao;
    import com.acece.dao.UserMapper;
    import com.acece.domain.User;
    import com.acece.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class UserServiceImpl implements UserService { 
    
        @Autowired
        private UserDao userDao;
    
        @Autowired
        private UserMapper userMapper;
    
        /** * 验证SpringBoot整合SpringDataJPA的方法 * @return */
        @Override
        public List<User> findAll() { 
            return userDao.findAll();
        }
    
        /** * 验证SpringBoot整合Mybatis的方法 * @param name * @return */
        @Override
        public List<User> findUserByName(String name) { 
            return userMapper.queryUserByName(name);
        }
    }

## 7.5 controller包下, UserController新增findUserByName()方法 ##

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

package com.acece.controller;
    
    
    import com.acece.domain.User;
    import com.acece.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.List;
    
    @RestController
    @RequestMapping("/user")
    public class UserController { 
    
        @Autowired
        private UserService userService;
    
        /** * 整合SpringDataJPA * @return */
        @RequestMapping("/findAll")
        public List<User> findAll(){ 
            return userService.findAll();
        }
    
        /** * 整合Mybatis * @param name * @return */
        @RequestMapping("/findUserByName/{name}")
        public List<User> findUserByName(@PathVariable String name){ 
            return userService.findUserByName(name);
        }
    }

## 7.6 启动项目,浏览器查询数据 ##

**url为localhost:8080/findUserByName/张**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 4]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70]: /images/20211109/62b3229a1370410da0e2ddfdac4cb118.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 1]: /images/20211109/ed404bf83316479d8cf9f6e52255a1a9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 2]: /images/20211109/ee86ea10388d4edf9b371733219dc194.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 3]: /images/20211109/936ea04278e4447faf38221efc66a09a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70 4]: /images/20211109/2c946b473934420b97eb7371db16a758.png