查询两个日期之间的时间出现的问题

错误：

 代码：StringBuilder hql = new StringBuilder();
  hql.append("from UserLog where 1=1");
  //select * from tabname where yourdate between '20110301' and '20110430
  List<Object> params = new ArrayList<>();
  if (beginTime != null || endTime != null ){
   hql.append(" and logTime BETWEEN '");
   params.add( beginTime + "'  AND '" + endTime+ "' " );
  }
  if(logUser != null && logUser > 0){
   hql.append(" and logUserId = ? ");
   params.add(logUser);
  }
  if (StringUtils.hasText(userName) ){
   hql.append(" and userName like ?");
   params.add("%" + userName +"%");
  }
  return this.findByPage(hql.toString(), pageModel, params);

 

到底是什么原因呢？？？？？

 

操，是hql语句写错了，，between ? and ? 少  了两个问号，