mysql 不写 sql 执行 andNotIn 和 andIn

最新推荐文章于 2023-02-26 22:20:29 发布

土耳其的烧烤

最新推荐文章于 2023-02-26 22:20:29 发布

阅读量451

点赞数

分类专栏：新mybatis

本文链接：https://blog.csdn.net/ywj776199845/article/details/109624966

版权

新mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

mysql 不写 sql 执行 andNotIn 和 andIn 
@Override
public int queryUserNotFinishOrderCount(String userId) {
    Example exp = new Example(OrderLoanInfoDto.class);
    List<Integer> orderStatus = Lists.newLinkedList();
    orderStatus.add(OrderStatusEnum.AdvanceRepay.getCode());
    orderStatus.add(OrderStatusEnum.ClosedOrder.getCode());
    orderStatus.add(OrderStatusEnum.OverdueClosed.getCode());
    orderStatus.add(OrderStatusEnum.LoanRefused.getCode());
    orderStatus.add(OrderStatusEnum.ReviewRefused.getCode());
    orderStatus.add(OrderStatusEnum.Lose.getCode());
    exp.createCriteria().andNotIn("orderStatus",orderStatus).andEqualTo("userId",userId);
    return orderLoanInfoDtoMapper.selectCountByExample(exp);
}

@Override
public OrderRepayBillDto queryRepayBillByUserId(String userId) {
  Example example = new Example(OrderRepayBillDto.class);
  List<Integer> orderList= Lists.newArrayList();
  orderList.add(OrderStatusEnum.WaitRepay.getCode());
  orderList.add(OrderStatusEnum.Repaymenting.getCode());
  orderList.add(OrderStatusEnum.Penaltying.getCode());
  orderList.add(OrderStatusEnum.Extension.getCode());
  example.createCriteria().andEqualTo("userId",userId).andIn("billingStatus", orderList);
  return orderRepayBillDtoMapper.selectOneByExample(example);
}