发表于 | 分类于

一、介绍

Swagger2提供了在线文档的查阅和测试功能。利用Swagger2很容易构建阻STful风格的API，在SpringBoot中集成Swagger2。

阅读全文 »

发表于 | 分类于

一、问题由来

SQL经过简化

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
select *
from a
left join b on a.RCheckEIDOne = b.EID
left join c on a.RCheckEIDTwo = c.EID
left join d on a.RCheckEIDThree = d.EID
left join e on a.JobId = e.JobID
where a.IsDelete = 0
and a.RStatus = 3
and a.RIID is null
and a.RGuidangYear is null
and ( (a.JobID = RYJobIDOne and RYJobSystemIDOne='10')
    or (a.JobID = RYJobIDTwo and RYJobSystemIDTwo='10')
    or (a.JobID = RYJobIDThree and RYJobSystemIDThree='10') )
and e.DepartID in ( 1,2,3,4,5,6,7,8,9,10)
order by a.RApplyDateTime
limit 5
阅读全文 »