stream与mysql_mybatis与stream使用小记

1-mybatis解决limit语句限制

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery异常解决方法

例子1:mybatis-plus 1层子查询嵌套，mysql不支持LIMIT/IN/ANY/SOME

// 查询最近100条数据

List allfeeYopProtocolDTOs = sendNsqMessageMapper.selectList(

new QueryWrapper()

.inSql("id","select id from send_nsq_message order by created_at desc limit 100")

);

解决办法：2层子查询

// 查询最近100条数据

List allfeeYopProtocolDTOs = sendNsqMessageMapper.selectList(

new QueryWrapper()

.inSql("id","select t.id from (select * from send_nsq_message order by created_at desc limit 100) as t")

);

2-stream快速实现求和

目的：结合mybatis查询结果，快速求和

普通解决办法：求出列的List，然后遍历相加，求和

简化版：

int oweQuotaSum = alldebtRecords.stream().mapToInt(t->Math.toIntExact(t.getOweQuota())).sum();

int oweQuotaSnapshotSum = alldebtRecords.stream().mapToInt(t->Math.toIntExact(t.getOweQuotaSnapshot())).sum();

int recoveryQuotaSum = alldebtRecords.stream().mapToInt(t->Math.toIntExact(t.getRecoveryQuota())).sum();