批量处理数据:
@Test void testDelete(){ //批量按id删除 List<Long> list = new ArrayList<>(); list.add(1626917366924050434L); list.add(1626917108852797441L); list.add(1626916464192487425L); list.add(1626914551753371650L); userDao.deleteBatchIds(list); //按id批量查询 List<Long> lists = new ArrayList<>(); lists.add(1l); lists.add(2l); lists.add(3l); userDao.selectBatchIds(lists); }
逻辑删除:
(1)删除操作业务问题:业务数据从数据库中丢弃
(2)逻辑删除:为数据设置是否可用状态字段,删除时设置状态字段为不可用状态,数据保留在数据库中。
首先在数据库表中添加deleted字段(默认值为0:可用状态)
package com.itheima.domain; import com.baomidou.mybatisplus.annotation.*; import lombok.Data; @Data //@TableName("tbl_user") public class User { // @TableId(type = IdType.ASSIGN_ID) private Long id; private String name; @TableField(value = "pwd", select = false) private String password; private Integer age; private String tel; @TableField(exist = false) private Integer online; //逻辑删除字段,标记当前记录是否被删除 @TableLogic(value = "0", delval = "1") private Integer deleted; }
或者在属性文件中进行全局中配置,不需要 @TableLogic(value = "0", delval = "1")
spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/mybatisplus_db?serverTimezone=UTC username: root password: 130740 type: com.alibaba.druid.pool.DruidDataSource main: banner-mode: off mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl global-config: banner: false db-config: id-type: assign_id table-prefix: tbl_ logic-delete-field: deleted logic-not-delete-value: 0 logic-delete-value: 1
标签:value,Mybatisplus,list,DML,private,---,add,lists,id From: https://www.cnblogs.com/fxzm/p/17133623.html