java mysbatis select_java相关：详解Mybatis中的select方法

java相关：详解Mybatis中的select方法

发布于 2020-7-3|

复制链接

摘记: selectById方法根据id，查询记录

```java

public void updateRecycleAssayBusinessItemCharge(String Id) {

AssayBusiness ..

selectById方法根据id，查询记录

```java

public void updateRecycleAssayBusinessItemCharge(String Id) {

AssayBusinessItemCharge assayBusinessItemCharge = assayBusinessItemChargeService.selectById(Id);

assayBusinessItemCharge.setRecordStatus(RecordStatusEnum.VALID.getValue());

assayBusinessItemChargeService.update(assayBusinessItemCharge);

}

```

selectByExample方法根据实体字段，查询记录

```java

public Account findByAccountName(String accountName) {

AccountExample accountExample = new AccountExample();

AccountExample.Criteria criteria = accountExample.createCriteria();

criteria.andAccountNameEqualTo(accountName);

List accountList = accountService.selectByExample(accountExample);

if (accountList == null || accountList.size() != 1)

return null;

else

return accountList.get(0);

}

```

查询所有list传一个空的实体，不要给赋字段值

```java

public Account findByAccountName(String accountName) {

AccountExample accountExample = new AccountExample();

AccountExample.Criteria criteria = accountExample.createCriteria();

List accountList = accountService.selectByExample(accountExample);

if (accountList == null || accountList.size() != 1)

return null;

else

return accountList.get(0);

}

```

总结