tk.mybatis.mapper.entity.Example.setOrderByClause()方法的使用及代码示例

x33g5p2x  于2022-01-19 转载在 其他  
字(8.7k)|赞(0)|评价(0)|浏览(176)

本文整理了Java中tk.mybatis.mapper.entity.Example.setOrderByClause()方法的一些代码示例，展示了Example.setOrderByClause()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Example.setOrderByClause()方法的具体详情如下：
包路径：tk.mybatis.mapper.entity.Example
类名称：Example
方法名：setOrderByClause

Example.setOrderByClause介绍

暂无

代码示例

代码示例来源：origin: abel533/Mapper

public OrderBy desc() {
  if (isProperty) {
    example.setOrderByClause(example.getOrderByClause() + " DESC");
    isProperty = false;
  }
  return this;
}

代码示例来源：origin: abel533/Mapper

public OrderBy asc() {
    if (isProperty) {
      example.setOrderByClause(example.getOrderByClause() + " ASC");
      isProperty = false;
    }
    return this;
  }
}

代码示例来源：origin: abel533/Mapper

public OrderBy asc() {
    if (isProperty) {
      example.setOrderByClause(example.getOrderByClause() + " ASC");
      isProperty = false;
    }
    return this;
  }
}

代码示例来源：origin: abel533/Mapper

public OrderBy desc() {
  if (isProperty) {
    example.setOrderByClause(example.getOrderByClause() + " DESC");
    isProperty = false;
  }
  return this;
}

代码示例来源：origin: abel533/Mapper

public OrderBy orderBy(String property) {
  String column = property(property);
  if (column == null) {
    isProperty = false;
    return this;
  }
  if (StringUtil.isNotEmpty(example.getOrderByClause())) {
    example.setOrderByClause(example.getOrderByClause() + "," + column);
  } else {
    example.setOrderByClause(column);
  }
  isProperty = true;
  return this;
}

代码示例来源：origin: abel533/Mapper

public OrderBy orderBy(String property) {
  String column = property(property);
  if (column == null) {
    isProperty = false;
    return this;
  }
  if (StringUtil.isNotEmpty(example.getOrderByClause())) {
    example.setOrderByClause(example.getOrderByClause() + "," + column);
  } else {
    example.setOrderByClause(column);
  }
  isProperty = true;
  return this;
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<Dept> findAllDepts(Dept dept) {
  try {
    Example example = new Example(Dept.class);
    if (StringUtils.isNotBlank(dept.getDeptName())) {
      example.createCriteria().andCondition("dept_name=", dept.getDeptName());
    }
    example.setOrderByClause("dept_id");
    return this.selectByExample(example);
  } catch (Exception e) {
    log.error("获取部门列表失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<Role> findAllRole(Role role) {
  try {
    Example example = new Example(Role.class);
    if (StringUtils.isNotBlank(role.getRoleName())) {
      example.createCriteria().andCondition("role_name=", role.getRoleName());
    }
    example.setOrderByClause("create_time");
    return this.selectByExample(example);
  } catch (Exception e) {
    log.error("获取角色信息失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<Menu> findAllMenus(Menu menu) {
  try {
    Example example = new Example(Menu.class);
    Criteria criteria = example.createCriteria();
    if (StringUtils.isNotBlank(menu.getMenuName())) {
      criteria.andCondition("menu_name=", menu.getMenuName());
    }
    if (StringUtils.isNotBlank(menu.getType())) {
      criteria.andCondition("type=", Long.valueOf(menu.getType()));
    }
    example.setOrderByClause("menu_id");
    return this.selectByExample(example);
  } catch (NumberFormatException e) {
    log.error("error", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public Tree<Menu> getMenuTree() {
  List<Tree<Menu>> trees = new ArrayList<>();
  Example example = new Example(Menu.class);
  example.createCriteria().andCondition("type =", 0);
  example.setOrderByClause("create_time");
  List<Menu> menus = this.selectByExample(example);
  buildTrees(trees, menus);
  return TreeUtils.build(trees);
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<SysLog> findAllLogs(SysLog log) {
  try {
    Example example = new Example(SysLog.class);
    Criteria criteria = example.createCriteria();
    if (StringUtils.isNotBlank(log.getUsername())) {
      criteria.andCondition("username=", log.getUsername().toLowerCase());
    }
    if (StringUtils.isNotBlank(log.getOperation())) {
      criteria.andCondition("operation like", "%" + log.getOperation() + "%");
    }
    if (StringUtils.isNotBlank(log.getTimeField())) {
      String[] timeArr = log.getTimeField().split("~");
      criteria.andCondition("date_format(CREATE_TIME,'%Y-%m-%d') >=", timeArr[0]);
      criteria.andCondition("date_format(CREATE_TIME,'%Y-%m-%d') <=", timeArr[1]);
    }
    example.setOrderByClause("create_time desc");
    return this.selectByExample(example);
  } catch (Exception e) {
    logger.error("获取系统日志失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<Job> findAllJobs(Job job) {
  try {
    Example example = new Example(Job.class);
    Criteria criteria = example.createCriteria();
    if (StringUtils.isNotBlank(job.getBeanName())) {
      criteria.andCondition("bean_name=", job.getBeanName());
    }
    if (StringUtils.isNotBlank(job.getMethodName())) {
      criteria.andCondition("method_name=", job.getMethodName());
    }
    if (StringUtils.isNotBlank(job.getStatus())) {
      criteria.andCondition("status=", Long.valueOf(job.getStatus()));
    }
    example.setOrderByClause("job_id");
    return this.selectByExample(example);
  } catch (Exception e) {
    log.error("获取任务失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<JobLog> findAllJobLogs(JobLog jobLog) {
  try {
    Example example = new Example(JobLog.class);
    Criteria criteria = example.createCriteria();
    if (StringUtils.isNotBlank(jobLog.getBeanName())) {
      criteria.andCondition("bean_name=", jobLog.getBeanName());
    }
    if (StringUtils.isNotBlank(jobLog.getMethodName())) {
      criteria.andCondition("method_name=", jobLog.getMethodName());
    }
    if (StringUtils.isNotBlank(jobLog.getStatus())) {
      criteria.andCondition("status=", Long.valueOf(jobLog.getStatus()));
    }
    example.setOrderByClause("log_id desc");
    return this.selectByExample(example);
  } catch (Exception e) {
    log.error("获取调度日志信息失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: wuyouzhuguli/FEBS-Shiro

@Override
public List<Dict> findAllDicts(Dict dict, QueryRequest request) {
  try {
    Example example = new Example(Dict.class);
    Criteria criteria = example.createCriteria();
    if (StringUtils.isNotBlank(dict.getKeyy())) {
      criteria.andCondition("keyy=", Long.valueOf(dict.getKeyy()));
    }
    if (StringUtils.isNotBlank(dict.getValuee())) {
      criteria.andCondition("valuee=", dict.getValuee());
    }
    if (StringUtils.isNotBlank(dict.getTableName())) {
      criteria.andCondition("table_name=", dict.getTableName());
    }
    if (StringUtils.isNotBlank(dict.getFieldName())) {
      criteria.andCondition("field_name=", dict.getFieldName());
    }
    example.setOrderByClause("dict_id");
    return this.selectByExample(example);
  } catch (Exception e) {
    log.error("获取字典信息失败", e);
    return new ArrayList<>();
  }
}

代码示例来源：origin: tk.mybatis/mapper-core

public OrderBy desc() {
  if (isProperty) {
    example.setOrderByClause(example.getOrderByClause() + " DESC");
    isProperty = false;
  }
  return this;
}

代码示例来源：origin: tk.mybatis/mapper-core

public OrderBy asc() {
    if (isProperty) {
      example.setOrderByClause(example.getOrderByClause() + " ASC");
      isProperty = false;
    }
    return this;
  }
}

代码示例来源：origin: AlreadyGo/springboot-simple

public Example createDateRangeExample(Class clazz, String order, String sort, Integer dateRange, String... conditions) {
    Example example = new Example(clazz);
    if (!StringUtils.isEmpty(sort) && !"null".equals(sort) && !"undefined".equals(sort) && !StringUtils.isEmpty(order) && !"null".equals(order) && !"undefined".equals(order))
      example.setOrderByClause(String.format("%s %s", sort, order));

    if (dateRange == null) dateRange = 3;
    Example.Criteria criteria = example.createCriteria();
    criteria.andCondition(String.format("create_date>DATE_ADD(now(),INTERVAL -%d MONTH)", dateRange));
    for (String condition : conditions) {
      if (!StringUtils.isEmpty(condition)) criteria.andCondition(condition);
    }
    return example;
  }
}

代码示例来源：origin: AlreadyGo/springboot-simple

public List<City> getAll(City city) {
//        if (city.getPage() != null && city.getRows() != null) {
//            PageHelper.startPage(city.getPage(), city.getRows());
//        }
    Example example = new Example(City.class);
    example.setOrderByClause("");
    return cityMapper.selectAll();
  }

代码示例来源：origin: ustcwudi/springboot-seed

/**
 * 根据页数获取实例列表
 *
 * @param page 页数
 * @return 实例列表
 */
public List<T> selectAll(int page) {
  Example example = new Example(getActualClass());
  example.setOrderByClause("id desc");
  PageHelper.startPage(page, Constant.PAGE_SIZE);
  return mapper.selectByExample(example);
}

代码示例来源：origin: ustcwudi/springboot-seed

/**
   * 根据用户ID获取用户关联信息列表（限制用户关联表使用）
   *
   * @param userId 用户ID
   * @return 实例列表
   */
  public List<T> selectAllByUserId(Long userId) {
    Example example = new Example(getActualClass());
    example.setOrderByClause("id desc");
    Example.Criteria criteria = example.createCriteria();
    criteria.andEqualTo("userId", userId);
    return mapper.selectByExample(example);
  }
}

内容来源于网络，如有侵权，请联系作者删除！

Example

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com