2021/3/10学习笔记
- @Min(value=1) //定义最小为1
private Long page; - 模糊查询
1.risk_refuse_msg like concat("%",#{riskRefuseMsg},"%")
2.risk_refuse_msg like ‘${riskRefuseMsg}%’
- 求状态为成功的数量,状态为成功的总金额,总数量(用一个sql查出)
select
sum(IF(credit_status='SUCCESS',apply_amount,0)) as applyAmount,count(1) as num,SUM(IF(credit_status='SUCCESS',1,0)) as numSC
from credit_info
<where>
<include refid="Base_Where_Qurey"/>
</where>
sum(IF(credit_status=‘SUCCESS’,apply_amount,0)):如果状态为成功这取apply_amount这个字段下的值,否则为0
- 集合的流操作
list<UserObject> objects=Lists.newArrayList();
//并行流User
objects.parallelStream()
//串行流
objects.stream()
//对于某个字段求和
objects.stream().mapToLong(UserObject::getAge