查询条件有null的情况

public JzcdWrongLog getJzcdWrongLog(String branchId, InsuranceInfo info,
    Date pickDate, String pickFlag) {
  log.debug("search JzcdWrongLog instance");
     JzcdWrongLog jzcdWrongLog = null;
  String netId = null;
  String insuranceApplication = null;
  String inputFileName = null;
  String signatureFlag = null;
  String status = new String("0");
  if (null != info) {
   netId = info.getNetId();
   insuranceApplication = info.getInsuranceApplication();
   inputFileName = info.getInputFileName();
   signatureFlag = info.getDataSignature();
  }
  StringBuffer queryString = new StringBuffer();
  queryString.append("from JzcdWrongLog where status=:status");
     queryString.append(" and netId=:netId");
     queryString.append(" and branchId=:branchId");
  queryString.append(" and insuranceApplication=:insuranceApplication");
  queryString.append(" and inputFileName=:inputFileName");
  if(StringUtils.isBlank(signatureFlag)){
   queryString.append(" and signatureFlag is null");
  }else{
   queryString.append(" and signatureFlag=:signatureFlag");
  }
     queryString.append(" and pickFlag=:pickFlag");
  queryString.append(" order by pickDate desc");
        Query query = getSession().createQuery(queryString.toString());
  List<JzcdWrongLog> queryList = null;
  query.setString("status", status);
  query.setString("netId", netId);
  query.setString("branchId", branchId);
  query.setString("insuranceApplication", insuranceApplication);
  query.setString("inputFileName", inputFileName);
  if(StringUtils.isNotBlank(signatureFlag)){
  query.setString("signatureFlag", signatureFlag);
  }
     query.setString("pickFlag", pickFlag);
  queryList = query.list();
  if (null != queryList && queryList.size() != 0) {
   jzcdWrongLog=queryList.get(0);
  }
  return jzcdWrongLog;
 }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值