mybatis-mapper / mapper

MyBatis Mapper
https://mapper.mybatis.io
Apache License 2.0
325 stars 47 forks source link

请问怎样在实体中定义默认的排序字段及多排序字段的顺序 #20

Closed woochanglin closed 2 years ago

woochanglin commented 2 years ago

在原4.0中可以通过注解 @Order(priority = 3, value = "DESC") 在实体中定义默认的排序字段及多排序字段的顺序,在5.0中没有看到相应的注解,请问可以怎样实现?

abel533 commented 2 years ago

增加了 orderByPriority 设置排序,值越小优先级越高。

@Entity.Table(value = "sys_user", remark = "系统用户", autoResultMap = true)
public class UserMore {
  @Entity.Column(id = true, remark = "主键", updatable = false, insertable = false)
  private Long    id;
  @Entity.Column(value = "name", remark = "帐号", orderBy = "ASC", orderByPriority = 2)
  private String  name;
  @Entity.Column(value = "is_admin", remark = "是否为管理员", updatable = false)
  private boolean admin;
  @Entity.Column(remark = "顺序号", orderBy = "DESC", orderByPriority = 1)
  private Integer seq;

对应排序字段:seq DESC,name ASC