springboot整合MybatisPlus

小僵123456

已于 2024-08-12 21:10:28 修改

阅读量213

点赞数 2

分类专栏： SpringBoot 文章标签： spring boot 后端 java

于 2024-08-12 21:09:56 首次发布

本文链接：https://blog.csdn.net/weixin_45476535/article/details/141142252

版权

SpringBoot 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

1、创建springboot项目，勾选Spring web

当前springboot选择的是2.6.13版本，jdk1.8
尽量选2.几的springboot

2、在pom.xml中导入相应的MybatisPlus坐标

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.17</version>
        </dependency>

3、配置application.properties

spring.datasource.url=jdbc:mysql://192.168.29.71:3306/uacs?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC  
spring.datasource.username=root
spring.datasource.password=uacsapp
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

4、创建实体类Book

import lombok.Data;
import java.util.Date;
@Data
public class Book  {

    private Integer id;
    private String picture;
    private String name;
    private String introduce;
    private String publish;
    private String auth;
    private Double price;
    private Integer isDeleted;
    private Date gmtCreate;
    private Date gmtModified;
}

5、新建接口BookMapper

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface BookMapper extends BaseMapper<Book> {
}

6、对应建表sql

CREATE TABLE `book` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
  `picture` varchar(2000) DEFAULT NULL COMMENT '图片',
  `name` varchar(200)  DEFAULT NULL COMMENT '书本名称',
  `introduce` varchar(200)  DEFAULT NULL COMMENT '介绍',
  `publish` varchar(200)  DEFAULT NULL COMMENT '出版社',
  `auth` varchar(200)  DEFAULT NULL COMMENT '作者',
  `price` double DEFAULT NULL COMMENT '价格',
  `is_deleted` tinyint unsigned DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 COMMENT='书本信息表';

7、SpringBootTest测试类中进行测试

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class SpringbootMbpApplicationTests {

    @Autowired
    private BookMapper bookMapper;

    // 增
    @Test
    void testSave(){
        // 添加一条数据
        Book book=new Book();
        book.setId(1);
        book.setAuth("小虎");
        book.setPrice(100.0);
        bookMapper.insert(book);
        System.out.println("成功执行添加操作！");
    }
    @Test
    void testSelect() {
        System.out.println("bookMapper="+bookMapper.selectById(8));
    }
}