MybatisPlus基本使用

//实体类
@Data
@TableName("asset_merge")
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="资产合并记录表", description="资产合并记录表")
public class AssetMerge implements Serializable {

  private static final long serialVersionUID = 1L;

  /**自增ID*/
  @Excel(name = "ID", width = 15)
  @ApiModelProperty(value = "ID")
  @TableId(type = IdType.AUTO)
  private Long id;
}

@Data
public class AssetMergeReq extends Page {
  /**合并编号*/
  private String assetMergeNo;
  /**合并后资产编号*/
  private String afterMergeAssetNo;
}

//Mapper
public interface AssetMergeMapper extends BaseMapper<AssetMerge> {
  IPage<AssetMergeVO> getAssetMergePage(AssetMergeReq req);
  List<AssetMerge> selectByAssetNo(String assetNo);
}

//Service
public interface IAssetMergeService extends IService<AssetMerge> {
...
}

@Service
@Slf4j
public class AssetMergeServiceImpl extends ServiceImpl<AssetMergeMapper, AssetMerge> implements IAssetMergeService {
    ...
}

//Controller
@AutoLog(value = "资产合并-导出")
@ApiOperation(value = "资产合并-导出", notes = "资产合并-导出")
@RequestMapping(value = "/exportAssetMergeXls")
public ModelAndView exportAssetMergeXls(AssetMergeReq req, HttpServletRequest request) {
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    List<AssetMergeVO> assetMergeVOList = iAssetMergeService.getAssetMergeList(req);
    //导出文件名称
    mv.addObject(NormalExcelConstants.FILE_NAME, "资产合并列表");
    mv.addObject(NormalExcelConstants.CLASS, AssetMergeVO.class);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("资产合并列表", "导出人:" + user.getRealname(), "导出信息"));
    mv.addObject(NormalExcelConstants.DATA_LIST, assetMergeVOList);
    return mv;
}