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);
}
```
总结