Mybatis的select方法

最新推荐文章于 2024-07-26 08:34:09 发布

量变决定质变

最新推荐文章于 2024-07-26 08:34:09 发布

阅读量2k

点赞数

分类专栏： ————Mybatis

本文链接：https://blog.csdn.net/nangeali/article/details/81278822

版权

————Mybatis 专栏收录该内容

22 篇文章 2 订阅

订阅专栏

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);
}