SpringBoot整合mybatisPlus（2）

之前文章Springboot整合和mybatisplus测试成功，接下来测试我们写的sql是否成功。

在resources目录下新建mapper文件夹，新建UserMapper.xml文件：（.xml中写数据库查询语句，使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.example.mapper.auto.UserMapper">

    <!-- 查找用户信息 -->
    <select id="findAllUser" resultType="com.example.model.auto.User">
       select * from user
    </select>

</mapper>

UserMapper.java（mapper数据持久化层：在UserMapper.java中定义查询全部方法）

package com.example.mapper.auto;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.model.auto.User;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author astupidcoder
 * @since 2020-05-13
 */
public interface UserMapper extends BaseMapper<User> {

    public List<User>findAllUser();
}

IUserService:（service服务层，只定义查询全部方法的接口供controller层控制器调用，不实现方法）

package com.example.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.model.auto.User;

import java.util.List;

/**
 * <p>
 *  服务类
 * </p>
 *
 * @author astupidcoder
 * @since 2020-05-13
 */
public interface IUserService extends IService<User> {

    public List<User> findAllUser();
}

UseServiceImpl.java:（注入mapper，实现service中定义的方法）

package com.example.service.impl;

import com.example.model.auto.User;
import com.example.mapper.auto.UserMapper;
import com.example.service.IUserService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <p>
 *  服务实现类
 * </p>
 *
 * @author astupidcoder
 * @since 2020-05-13
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {

    @Autowired
    private UserMapper userMapper;
    @Override
    public List<User> findAllUser() {
        return userMapper.findAllUser();
    }
}

UserController.java:（控制器，接收前端发来的请求，进行流程控制，将结果返回给前台）

package com.example.controller;


import com.example.model.auto.User;
import com.example.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * <p>
 *  前端控制器
 * </p>
 *
 * @author astupidcoder
 * @since 2020-05-13
 */
@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private IUserService userService;
    @PostMapping("/getUser")
    public User getUser(){
        return userService.getById(1);
    }


    @PostMapping("/findAllUser")
    public List<User> findAllUser(){
        return userService.findAllUser();
    }
}

postman请求测试findAllUser接口：

post     http://127.0.0.1:8081/user/findAllUser

测试结果，数据全部取出测试成功：

[
    {
        "id": 1,
        "userName": "小儿",
        "password": "123"
    },
    {
        "id": 2,
        "userName": "大三",
        "password": "456"
    }
]