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

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

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

Example.createCriteria介绍

暂无

代码示例

代码示例来源: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 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 User findByName(String userName) {
  Example example = new Example(User.class);
  example.createCriteria().andCondition("lower(username)=", userName.toLowerCase());
  List<User> list = this.selectByExample(example);
  return list.isEmpty() ? null : list.get(0);
}

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

@Override
public Menu findByNameAndType(String menuName, String type) {
  Example example = new Example(Menu.class);
  example.createCriteria().andCondition("lower(menu_name)=", menuName.toLowerCase())
      .andEqualTo("type", Long.valueOf(type));
  List<Menu> list = this.selectByExample(example);
  return list.isEmpty() ? null : list.get(0);
}

代码示例来源: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
@Transactional
public void updateLoginTime(String userName) {
  Example example = new Example(User.class);
  example.createCriteria().andCondition("lower(username)=", userName.toLowerCase());
  User user = new User();
  user.setLastLoginTime(new Date());
  this.userMapper.updateByExampleSelective(user, example);
}

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

@Override
@Transactional
public int updateBatch(String jobIds, String status) {
  List<String> list = Arrays.asList(jobIds.split(","));
  Example example = new Example(Job.class);
  example.createCriteria().andIn("jobId", list);
  Job job = new Job();
  job.setStatus(status);
  return this.jobMapper.updateByExampleSelective(job, 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: 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
@Transactional
public void updateTheme(String theme, String userName) {
  Example example = new Example(User.class);
  example.createCriteria().andCondition("username=", userName);
  User user = new User();
  user.setTheme(theme);
  this.userMapper.updateByExampleSelective(user, example);
}

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

@Override
@Transactional
public void updatePassword(String password) {
  User user = (User) SecurityUtils.getSubject().getPrincipal();
  Example example = new Example(User.class);
  example.createCriteria().andCondition("username=", user.getUsername());
  String newPassword = MD5Utils.encrypt(user.getUsername().toLowerCase(), password);
  user.setPassword(newPassword);
  this.userMapper.updateByExampleSelective(user, example);
}

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

@Override
@Transactional
public void updateRole(Role role, Long[] menuIds) {
  role.setModifyTime(new Date());
  this.updateNotNull(role);
  Example example = new Example(RoleMenu.class);
  example.createCriteria().andCondition("role_id=", role.getRoleId());
  this.roleMenuMapper.deleteByExample(example);
  setRoleMenus(role, menuIds);
}

代码示例来源: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
@Transactional
public void updateUser(User user, Long[] roles) {
  user.setPassword(null);
  user.setUsername(null);
  user.setModifyTime(new Date());
  this.updateNotNull(user);
  Example example = new Example(UserRole.class);
  example.createCriteria().andCondition("user_id=", user.getUserId());
  this.userRoleMapper.deleteByExample(example);
  setUserRoles(user, roles);
}

代码示例来源: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<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<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: coder-yqj/springboot-shiro

@Override
public User selectByUsername(String username) {
  Example example = new Example(User.class);
  Example.Criteria criteria = example.createCriteria();
  criteria.andEqualTo("username",username);
  List<User> userList = selectByExample(example);
  if(userList.size()>0){
    return userList.get(0);
  }
    return null;
}

相关文章