实体类定义:
@Data
@AllArgsConstructor //有参构造器
@NoArgsConstructor //无参构造器
@TableName("tb_order")
public class Order {
@TableId(type= IdType.AUTO)
@TableField("order_id")
private Integer orderId;
private Integer userid;
private String number;
@TableField(fill= FieldFill.INSERT)
private LocalDateTime ordertime;
@TableField(fill=FieldFill.INSERT_UPDATE)
private LocalDateTime updatetime;
private String productName;
@TableLogic //逻辑删除
private boolean deleted;
}
@Data
@TableName("user")
public class User {
@TableId(type= IdType.AUTO)
private Integer id;
private String userName;
private String address;
private String role;
@TableLogic //逻辑删除
private boolean deleted;
}
Mapper接口定义:
@Repository
public interface OrderMapper extends BaseMapper<Order> {
}
@Repository//代表持久层
public interface UserMapper extends BaseMapper<User> {
}
Controller层实现:
@RestController
@RequestMapping("/order")
public class OrderController {
@Autowired
private OrderServiceImpl orderSeriveImpl;
@Autowired
private OrderMapper orderMapper;
@Autowired
private UserMapper userMapper;
@DeleteMapping("/userdelete/{id}")
public void delete(@PathVariable Integer id)
{
userMapper.deleteById(id);
orderMapper.deleteById(id);
}
#配置逻辑删除
global-config:
db-config:
logic-delete-value: 1
logic-not-delete-value: 0