criteria两个 判断

if (StringUtils.isEmpty(date)) {
date = DateUtil.Date2String(new Date(), DateUtil.YYYYMMDD);
}
StkInnerStockInfoExample example = new StkInnerStockInfoExample();
StkInnerStockInfoExample.Criteria createCriteria = example.createCriteria();
createCriteria.andDelistDateIsNull();
createCriteria.andContractTypeEqualTo(0);
createCriteria.andListDateLessThanOrEqualTo(date);

StkInnerStockInfoExample.Criteria createCriteria2 = example.createCriteria();
//createCriteria2.andDelistDateGreaterThanOrEqualTo(date);
createCriteria2.andDelistDateGreaterThan(date);//不能等于,退市那个日期是摘牌日
createCriteria.andContractTypeEqualTo(0);
createCriteria2.andListDateLessThanOrEqualTo(date);

example.or(createCriteria2);
return stkInnerStockInfoMapper.selectByExample(example);
posted on 2020-05-25 14:39  RedBackIce  阅读(933)  评论(0编辑  收藏  举报