springBoot、Mybatis增删改查全过程

1、新建JavaBean及返回的AO类和JSR303校验Param类（接收前端传过来的查询参数）

@Getter
@Setter
@Accessors(chain = true)
@TableName("t_role")
public class EntityRole extends Model<EntityRole> {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.ASSIGN_UUID)
    private String id;

    /**
     * 机构ID
     */
    @TableField("institution_id")
    private String institutionId;

    /**
     * 角色名称
     */
    @TableField("role_name")
    private String roleName;


    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField(value = "create_time", fill = FieldFill.INSERT)
    private Date createTime;


    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField("modify_time")
    private Date modifyTime;

}

@Data
@TableName("t_role")
@JsonInclude(value = JsonInclude.Include.NON_EMPTY)
public class EntityRoleAO extends EntityRole {

}

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class RoleParam extends BaseParam {

    /**
     * 角色id
     */
    @NotBlank(message = "角色Id不能为空", groups = {delete.class})
    private String roleId;

    /**
     * 角色名称
     */
    @NotBlank(message = "角色名称不能为空", groups = {edit.class, add.class})
    @Length(max = 100, message = "角色名称长度超长", groups = {add.class, edit.class})
    private String roleName;

}


2、新建Controller

@RepeatSubmit(interval = 5, message = "操作太频繁请稍后再试")
@PostMapping(value = "DutyNew")
public ServiceResult<Boolean> majorNew(@RequestBody @Validated({DutyParam.add.class,DutyParam.edit.class}) DutyParam param) {
    EntityDutyAO dutyAo = new EntityDutyAO();
    BeanUtil.copyProperties(param, dutyAo);
    return dutyService.creatDuty(dutyAo);
}


3、新建Service继承BaseServiceImpl

@Service("sysDeptServiceImpl")
@Transactional
public class SysDeptServiceImpl extends BaseServiceImpl implements SysDeptService {}

使用LambdaQueryWrapper条件构造器增删改查

public ServiceResult<Page<EntityMajorAO>> getAllMajorList(MajorParam param) {
    ServiceResult<Page<EntityMajorAO>> result = new ServiceResult<>();
    result.setSucceed(false);

    LambdaQueryWrapper<EntityMajorAO> lambdaQueryWrapper = new LambdaQueryWrapper<>();
    lambdaQueryWrapper.eq(EntityMajorAO::getIsValid, true).orderByAsc(EntityMajorAO::getSort);
    if (StringUtil.isNotEmpty(param.getName())) {
        lambdaQueryWrapper.eq(EntityMajorAO::getName, param.getName());
    }

    Page page = new Page(param.getPageNo(), param.getPageSize());
    Page<EntityMajorAO> majorList = entityMajorGeneratedMapper.selectPage(page,lambdaQueryWrapper);
    result.setData(majorList);
    result.setSucceed(true);
    return result;
}


4、新建Mapper继承BaseMapper

@Mapper
public interface EntityRoleGeneratedMapper extends BaseMapper<EntityRoleAO> {

}