【MybatisPlus】的使用

一.MybatisPlus的使用

1.定义实体类

package com.example.entity;

import java.io.Serializable;
import java.util.Date;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.TableName;
import com.example.Converter.EquipmentMStatusConverter;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

/**
 * @TableName eq_equipment
 */
@TableName(value ="eq_maintenance_warning_manager")
@Data
public class MaintenanceWarningManager implements Serializable {

    private Integer id;

    private String equipmentId;

    private Integer maintenanceStatus;

    private String createUser;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;

    private String updateUser;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date updateTime;

    private Integer isDeleted;


}

2.Mapper (Dao)层中需要添加@Mapper注解并继承BaseMapper<T>泛型接口

package com.example.dao;

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

@Mapper
public interface MaintenanceWarningManagerDao extends BaseMapper<MaintenanceWarningManager> {
    
}

3.Service层接口

package com.example.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.example.entity.MaintenanceWarningManager;

public interface MaintenanceWarningManagerService extends IService<MaintenanceWarningManager> {
}

4.Service层实现类

package com.example.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.dao.MaintenanceWarningManagerDao;
import com.example.entity.MaintenanceWarningManager;
import com.example.service.MaintenanceWarningManagerService;
import org.springframework.stereotype.Service;

@Service("MaintenanceWarningManagerService")
public class MaintenanceWarningManagerServiceImpl extends ServiceImpl<MaintenanceWarningManagerDao, MaintenanceWarningManager>
        implements MaintenanceWarningManagerService {
}

二.MybatisPlus所提供操作数据库的方法

        在controller层中先导入了maintenanceWarningManagerService对象，若直接在实现类当中调用可以将maintenanceWarningManagerService这个对象名替换为this.方法();

    @Autowired
    public MaintenanceWarningManagerService maintenanceWarningManagerService;

        // 1.list()方法可以用于查询表中所有数据
        List<MaintenanceWarningManager> list = maintenanceWarningManagerService.list();
        // 2.getById()方法可以用于获取表中对应主键id的数据
        MaintenanceWarningManager byId = maintenanceWarningManagerService.getById(1);
        // 3.getOne()方法可以用于获取与查询条件匹配的第一条数据
        MaintenanceWarningManager one = maintenanceWarningManagerService.getOne(new QueryWrapper<>());
        // 4.save()方法可以用于对单条数据的插入
        maintenanceWarningManagerService.save(new MaintenanceWarningManager());
        // 5.update()方法用于更新单条数据，需要传入一个实体类对象，以及UpdateWrapper对象
        maintenanceWarningManagerService.update(new MaintenanceWarningManager(),new UpdateWrapper<>());
        // 6.saveOrUpdate()方法可以用于对单条数据的插入或更新，若表中有该对象中的主键则为更新操作，反之亦然
        maintenanceWarningManagerService.saveOrUpdate(new MaintenanceWarningManager());
        // 7.通过QueryWrapper所构建的条件对数据进行删除
        maintenanceWarningManagerService.remove(new QueryWrapper<>());
        // 8.通过主键id删除单条数据
        maintenanceWarningManagerService.removeById(1);
        // 9.通过一个存放主键id的集合进行批量删除数据
        List<Integer> integerList = new ArrayList<>();
        maintenanceWarningManagerService.removeByIds(integerList);