tk.mybatis.mapper.entity.Example类的使用及代码示例

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

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

Example介绍

[英]通用的Example查询对象
[中]通用的实例查询对象

代码示例

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

@Override
public Role findByName(String roleName) {
  Example example = new Example(Role.class);
  example.createCriteria().andCondition("lower(role_name)=", roleName.toLowerCase());
  List<Role> list = this.selectByExample(example);
  return list.isEmpty() ? null : list.get(0);
}

代码示例来源：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: abel533/Mapper

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

代码示例来源：origin: QiuMing/zhihuWebSpider

@RequestMapping(value = "searchByName")
public  @ResponseBody List<UserBaseInfo> searchByName(@RequestParam(value = "name",  required = true)String name){
  Example example1 = new Example(UserBaseInfo.class);
    example1.selectProperties("nickname","location","weiboUrl","headline","description");
    example1.createCriteria().andLike("nickname", name);
    List<UserBaseInfo> result = (List<UserBaseInfo>) userBaseInfoMapper.selectByExample(example1);
    System.out.println("查找昵称为"+name+"结果为 "+JSON.toJSONString(result));
    return result;
}
@RequestMapping("getGenderInfo")

代码示例来源：origin: leechenxiang/imooc-springboot-starter

@Override
@Transactional(propagation = Propagation.SUPPORTS)
public List<SysUser> queryUserListPaged(SysUser user, Integer page, Integer pageSize) {
  // 开始分页
  PageHelper.startPage(page, pageSize);
  
  Example example = new Example(SysUser.class);
  Example.Criteria criteria = example.createCriteria();
  
  if (!StringUtils.isEmptyOrWhitespace(user.getNickname())) {
    criteria.andLike("nickname", "%" + user.getNickname() + "%");
  }
  example.orderBy("registTime").desc();
  List<SysUser> userList = userMapper.selectByExample(example);
  
  return userList;
}

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

public Example build() {
  this.exampleCriterias = new ArrayList<Criteria>();
  for (Sqls.Criteria criteria : sqlsCriteria) {
    Example.Criteria exampleCriteria = new Example.Criteria(this.propertyMap, this.exists, this.notNull);
    exampleCriteria.setAndOr(criteria.getAndOr());
    for (Sqls.Criterion criterion : criteria.getCriterions()) {
      String condition = criterion.getCondition();
      String andOr = criterion.getAndOr();
      String property = criterion.getProperty();
      Object[] values = criterion.getValues();
      transformCriterion(exampleCriteria, condition, property, values, andOr);
    }
    exampleCriterias.add(exampleCriteria);
  }
  if (this.orderByClause.length() > 0) {
    this.orderByClause = new StringBuilder(this.orderByClause.substring(1, this.orderByClause.length()));
  }
  return new Example(this);
}

代码示例来源：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: gem-team/gemframe

/**
 * @Description:查询部门历史变更
 * @param id 部门主键
 * @author: Ryan  
 * @date 2018年11月21日
 */
@Override
public List<GemOrganizationChange> findOrganProfile(Long id) {
  if(id==null) {
    return null;
  }
  Example example = new Example(GemOrganizationChange.class);
  example.selectProperties("id","changeTime","eventName");
  Criteria createCriteria = example.createCriteria();
  createCriteria.andEqualTo("organId", id);
  return organizationChangeMapper.selectByExample(example);
}

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

public Example build() {
  this.exampleCriterias = new ArrayList<Criteria>();
  for (Sqls.Criteria criteria : sqlsCriteria) {
    Example.Criteria exampleCriteria = new Example.Criteria(this.propertyMap, this.exists, this.notNull);
    exampleCriteria.setAndOr(criteria.getAndOr());
    for (Sqls.Criterion criterion : criteria.getCriterions()) {
      String condition = criterion.getCondition();
      String andOr = criterion.getAndOr();
      String property = criterion.getProperty();
      Object[] values = criterion.getValues();
      transformCriterion(exampleCriteria, condition, property, values, andOr);
    }
    exampleCriterias.add(exampleCriteria);
  }
  if (this.orderByClause.length() > 0) {
    this.orderByClause = new StringBuilder(this.orderByClause.substring(1, this.orderByClause.length()));
  }
  return new Example(this);
}

代码示例来源：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: abel533/Mapper

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

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

@Override
@Transactional
public int batchDelete(List<String> list, String property, Class<T> clazz) {
  Example example = new Example(clazz);
  example.createCriteria().andIn(property, list);
  return this.mapper.deleteByExample(example);
}

代码示例来源：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: gem-team/gemframe

Example example = new Example(GemOrganization.class);
example.selectProperties("id","parentId");
Criteria createCriteria = example.createCriteria();
if(GemFrameStringUtlis.isNotBlank(name) && !name.equalsIgnoreCase("null") && name.length()>0) {
  createCriteria.andLike("organName", "%"+name+"%");

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

@Transactional
public boolean deleteAll() {
  Example example = new Example(getActualClass());
  return mapper.deleteByExample(example) > 0;
}

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

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

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

@Override
public Dept findByName(String deptName) {
  Example example = new Example(Dept.class);
  example.createCriteria().andCondition("lower(dept_name) =", deptName.toLowerCase());
  List<Dept> list = this.selectByExample(example);
  return list.isEmpty() ? null : list.get(0);
}

代码示例来源：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: gem-team/gemframe

Example example = new Example(GemOrganization.class);
example.selectProperties("id","parentId");
Criteria createCriteria = example.createCriteria();
if(GemFrameStringUtlis.isNotBlank(name) && !name.equalsIgnoreCase("null") && name.length()>0) {
  createCriteria.andLike("organName", "%"+name+"%");

代码示例来源：origin: coder-yqj/springboot-shiro

@Override
public PageInfo<Resources> selectByPage(Resources resources, int start, int length) {
  int page = start/length+1;
  Example example = new Example(Resources.class);
  //分页查询
  PageHelper.startPage(page, length);
  List<Resources> userList = selectByExample(example);
  return new PageInfo<>(userList);
}

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

Example

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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