spring boot3整合mybatis-plus

Java_Study_GitCode

已于 2024-01-05 19:40:26 修改

阅读量4.9k

点赞数 31

于 2023-12-18 13:42:28 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_38716921/article/details/135060609

版权

本文详细介绍了如何在SpringBoot3项目中整合mybatis-plus，包括添加依赖、配置属性信息、编写测试代码以及配置mybatis-plus的分页插件和属性自动填充功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

添加依赖

         <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3.2</version>
            <exclusions>
                <exclusion>
                    <groupId>org.mybatis</groupId>
                    <artifactId>mybatis-spring</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <!--解决【Invalid value type for attribute 'factoryBeanObjectType': java.lang.String】-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>3.0.3</version>
        </dependency>

        <!--<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.32</version>
        </dependency>-->

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

配置属性信息

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: XXX
    password: XXX
    url: jdbc:mysql://localhost:3306/XXX?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC&serverTimezone=Asia/Shanghai

mybatis-plus:
  mapper-locations: classpath:/mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

编写业务逻辑测试代码

package org.coding.java.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.annotation.Resource;
import org.coding.java.api.CommonResult;
import org.coding.java.domain.user.UserDO;
import org.coding.java.query.PageQueryVO;
import org.coding.java.service.UserService;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@Tag(name = "用户管理")
@RestController
@RequestMapping("api/v1/user")
public class UserController {
    @Resource
    private UserService userService;

    @PostMapping("/saveUser")
    @Operation(summary = "新增用户")
    public CommonResult<Integer> saveUser(@RequestBody UserDO userDO) {
        return userService.saveUser(userDO);
    }

    @DeleteMapping("/deleteUser/{id}")
    @Operation(summary = "根据ID删除用户")
    public CommonResult<Integer> deleteUser(@PathVariable("id") Long id) {
        return userService.deleteUserById(id);
    }

    @GetMapping("/selectList")
    @Operation(summary = "查询用户信息")
    public CommonResult<List<UserDO>> selectList() {
        return userService.selectList();
    }

    @PostMapping("/selectPage")
    @Operation(summary = "分页查询用户信息")
    public CommonResult<IPage<UserDO>> selectPage(@RequestBody PageQueryVO queryVO) {
        return userService.selectPage(queryVO);
    }

    @PutMapping("/updateUser")
    @Operation(summary = "更新用户信息")
    public CommonResult<Integer> updateUser(@RequestBody UserDO userDO) {
        return userService.updateUser(userDO);
    }
}

package org.coding.java.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import jakarta.annotation.Resource;
import org.coding.java.api.CommonResult;
import org.coding.java.

最低0.47元/天解锁文章