前端时间插件，后端根据时间段查询

前端页面时间参数，时间插件

在这里插入代码片

        <label class="layui-form-label">创建时间:</label>
        <div class="layui-input-inline">
            <input readonly="readonly" type="text" name="createTime" id="createTime" maxlength="20" value=""
                   placeholder="请选择开始时间" class="layui-input Wdate"
                   onfocus="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss',readOnly:true,maxDate:'#F{$dp.$D(\'createTime\')}'})">
        </div>
        <div class="layui-input-inline">
            <input readonly="readonly" type="text" name="endTime" id="endTime" maxlength="20" value=""
                   placeholder="请选择截止时间" class="layui-input Wdate"
                   onfocus="WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss',readOnly:true,minDate:'#F{$dp.$D(\'endTime\')}'})">
        </div>

后端逻辑层

在这里插入代码片
 @RequestMapping("/patent/listData")
    @RequiresPermissions("patent:list")
    public Result listData(@RequestParam Map<String,Object> map){
        QueryPatentBO queryPatentBO = new QueryPatentBO();
        try {
            BeanUtils.copyProperties(queryPatentBO,map);
        }catch (Exception ex){
            ex.printStackTrace();
        }
        Page<TPatent> objects = PageHelper.startPage(queryPatentBO.getPage(),queryPatentBO.getLimit());
        TPatentExample tPatentExample = new TPatentExample();
        tPatentExample.setOrderByClause("create_time desc");
        TPatentExample.Criteria criteria = tPatentExample.createCriteria();
        if(!StringUtils.isEmpty(queryPatentBO.getUserPhone())){
            criteria.andUserPhoneLike("%"+queryPatentBO.getUserPhone()+"%");
        }
        if(queryPatentBO.getPatentType()!=null){
            criteria.andPatentTypeEqualTo(queryPatentBO.getPatentType());
        }
        if(!StringUtils.isEmpty(queryPatentBO.getCreateTime()) && !StringUtils.isEmpty(queryPatentBO.getEndTime())){
            criteria.andCreateTimeBetween(queryPatentBO.getCreateTime(),queryPatentBO.getEndTime());
        }
        criteria.andPatentTypeEqualTo(1);
        tPatentMapper.selectByExampleWithBLOBs(tPatentExample);

        PageBean<TPatent> pageBean = new PageBean<>(objects);
        return HandleResultUtil.querySuccessResult(pageBean);
    }

及mapper.xml`

在这里插入代码片
  <select id="selectByExampleWithBLOBs" parameterType="com.duxing.vedio.manager.common.model.TPatentExample" resultMap="ResultMapWithBLOBs">
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from t_patent
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>