笔记
1.)Boolean.parseBoolean(isEncryptStr);
2)/queryOverDueSumByOrderId/
SELECT t.* FROM TB_AT_CREDITCARD_INSTALLMENT_REPAYMENT_RECORD t
WHERE TO_DAYS(t.REPAYMENT_TIME) >= TO_DAYS(STR_TO_DATE(@startTime, ‘%Y-%m-%d’))
AND TO_DAYS(t.REPAYMENT_TIME) <= TO_DAYS(STR_TO_DATE(@endTime, ‘%Y-%m-%d’))
AND TIME_TO_SEC(DATE_FORMAT(t.REPAYMENT_TIME, ‘%H:%i:%S’))>=time_to_sec(DATE_FORMAT(@startTime,’%H:%i:%S’))
AND TIME_TO_SEC(DATE_FORMAT(t.REPAYMENT_TIME, ‘%H:%i:%S’))<=time_to_sec(DATE_FORMAT(@endTime,’%H:%i:%S’))
AND IS_OVERDUE = @isOverdue
AND REPAYMENT_TYPE = @repaymentType;
要求:
日期:2018-02-04 ~ 2018-02-11
时间: 12:00:00 ~ 15:00:00
针对double 类型:BigDecimalUtils.lessThan(receiSum, earlyVo.getRepaiedAmount())
BigDecimalUtils.isZeroEx(ovsLeder.getOthersum()
3)两变量的比较使用:Objects.equals(manage.getRepaymentCount(),manage.getBillCycle());能够满足同一数据类型间的大小比较同时判断是否为空