当前位置:主页 > 软件编程 > JAVA代码 >

详解Mybatis中的select方法

时间:2021-05-10 08:48:24 | 栏目:JAVA代码 | 点击:

selectById方法

根据id,查询记录

public void updateRecycleAssayBusinessItemCharge(String Id) {
  AssayBusinessItemCharge assayBusinessItemCharge = assayBusinessItemChargeService.selectById(Id);
  assayBusinessItemCharge.setRecordStatus(RecordStatusEnum.VALID.getValue());
  assayBusinessItemChargeService.update(assayBusinessItemCharge);
}

selectByExample方法

根据实体字段,查询记录

public Account findByAccountName(String accountName) {
  AccountExample accountExample = new AccountExample();
  AccountExample.Criteria criteria = accountExample.createCriteria();
  criteria.andAccountNameEqualTo(accountName);
  List<Account> accountList = accountService.selectByExample(accountExample);
  if (accountList == null || accountList.size() != 1)
    return null;
  else
    return accountList.get(0);
}

查询所有list

传一个空的实体,不要给赋字段值

public Account findByAccountName(String accountName) {
  AccountExample accountExample = new AccountExample();
  AccountExample.Criteria criteria = accountExample.createCriteria();
  List<Account> accountList = accountService.selectByExample(accountExample);
  if (accountList == null || accountList.size() != 1)
    return null;
  else
    return accountList.get(0);
}

总结

您可能感兴趣的文章:

相关文章