MybatisPlus基础使用

 以下是用到的依赖（lombok是简化部分代码的，在此处为省略get,set方法）

        <!-- lombok依赖 -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!-- lombok依赖 -->

        <!-- Mybatis Plus驱动-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!-- Mybatis Plus驱动-->

        <!-- MySql驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!-- MySql驱动包 -->

 以下是配置文件，用于配置数据库连接的信息

# 应用服务 WEB 访问端口
server.port=8084

#Swagger3和Spring boot 2.6.1版本添加Spring mvc解决报错
spring.mvc.pathmatch.matching-strategy=ant_path_matcher

#Mysql数据库配置
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=luo980902
spring.datasource.url=jdbc:mysql://localhost:3306/hecen?serverTimezone=UTC



#系统自定义配置
hecen.system.swaggerEnabled=true

以下是数据库实体类（测试就填写了一个id字段）

package com.example.hecen.entity;

import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName(value = "user")
public class User {

    @TableId
    private Integer id;

}

以下是Mapper文件（如果不需要自己实现Sql语句xml文件在mybatisplus中可以省略）

package com.example.hecen.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.hecen.entity.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper extends BaseMapper<User> {

}

以下是Service文件

package com.example.hecen.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.hecen.entity.User;

public interface UserService extends IService<User> {
}

package com.example.hecen.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.hecen.entity.User;
import com.example.hecen.mapper.UserMapper;
import com.example.hecen.service.UserService;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}

以下是Controller文件（调用MybatisPlus的list()方式查询所有数据）

package com.example.hecen.controller;

import com.example.hecen.entity.User;
import com.example.hecen.service.UserService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Api(tags = "标准服务信息")
@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @ApiOperation(value = "测试")
    @PostMapping("/info/test")
    public String test() {
        List<User> users=userService.list();
        return "";
    }

}