springboot整合mybatis-plus

一、添加依赖

<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.1</version>
</dependency>
<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
</dependency>
<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
 </dependency>

二、配置数据源

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/jdbctest?useSSL=true&useUnicode=true&characterEncoding=utf-8
    username: root
    password: root

三、测试

pojo

package com.zhmsky.boot.springboot_mybatisplus.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author zhmsky
 * @date 2021/11/18 15:04
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String username;
    private String password;
}

实体类属性对应数据库表的各个字段

3.1 Dao层

package com.zhmsky.boot.springboot_mybatisplus.Dao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhmsky.boot.springboot_mybatisplus.pojo.User;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author zhmsky
 * @date 2021/11/18 15:05
 */
@Mapper
public interface UserMapper extends BaseMapper<User> {

}

每一个mapper接口直接继承mybatis-plus的baseMapper接口，即可直接获得基本的CRUD方法；

3.2 service层

package com.zhmsky.boot.springboot_mybatisplus.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.zhmsky.boot.springboot_mybatisplus.pojo.User;

/**
 * @author zhmsky
 * @date 2021/11/18 15:06
 */
public interface UserService extends IService<User> {
}

每个service接口直接继承mybatis-plus的顶层接口IService<?>，泛型里面直接传数据库表对应的实体类，即可直接获得基本的CRUD方法

3.2.1. service实现类

package com.zhmsky.boot.springboot_mybatisplus.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.zhmsky.boot.springboot_mybatisplus.Dao.mapper.UserMapper;
import com.zhmsky.boot.springboot_mybatisplus.pojo.User;
import com.zhmsky.boot.springboot_mybatisplus.service.UserService;
import org.springframework.stereotype.Service;

/**
 * @author zhmsky
 * @date 2021/11/18 15:07
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}

service实现类直接继承mybatis-plus的所有公共service实现类即可拥有基本的CRUD方法

controller层

package com.zhmsky.boot.springboot_mybatisplus.controller;

import com.zhmsky.boot.springboot_mybatisplus.pojo.User;
import com.zhmsky.boot.springboot_mybatisplus.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

/**
 * @author zhmsky
 * @date 2021/11/18 15:08
 */
@Controller
public class UserController {
    @Autowired
    UserService userService;

    @GetMapping("/getUser")
    @ResponseBody
    public String getUserById(@RequestParam("id") int id){
        User user = userService.getById(id);
        return user.toString();
    }
}

通过/getUser请求携带查询id参数即可实现根据指定id查询数据库用户