layui搜索时间段的数据

 前端

 <div class="layui-inline">
                        <label class="layui-form-label">注册时间</label>
                        <div class="layui-input-inline" style="width: 175px;">
                            <input  name="startTime" id="startTime" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input" type="text"/>
                        </div>
                        <div class="layui-form-mid">-</div>
                        <div class="layui-input-inline" style="width: 175px;">
                            <input name="endTime" id="endTime" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input" type="text"/>
                        </div>

js

 //搜索框
    layui.use(['form','laydate'], function(){
        var form = layui.form ,layer = layui.layer
            ,laydate = layui.laydate;
        //日期
        laydate.render({
            elem: '#startTime'
        });
        laydate.render({
            elem: '#endTime'
        });
        //TODO 数据校验
        //监听搜索框
        form.on('submit(registInfo-query)', function(data){
            //重新加载table
            load(data);
            return false;
        });
    })
form.on('submit(registInfo-query)', function(data){
            var formData = data.field;      
            var startTime = formData.startTime;
            var endTime = formData.endTime;
            tableIns.reload({
                page: {
                    curr: 1 //重新从第 1 页开始
                }
                , where: {//这里传参  向后台
                    queryStartTime: startTime,
                    queryEndTime: endTime,
                    //可传多个参数到后台...  ，分隔
                }
                , url: '        /后台做模糊搜索接口路径
                , method: 'get'
            });
            return false;
        });

 后端查询就比较简单不在这贴了把xml贴一下吧

	<select id="getFuzzyRegistInfo"
resultType="com.codermy.myspringsecurityplus.admin.entity.RegistInfo">
		//查询自己表的数据
		<where>

			
			<if test="queryStartTime != null and queryEndTime != ''">
				AND j.createtime between #{queryStartTime} and date_add(#{queryEndTime}, interval 1 day)//这句就是查询时间段内的数据
			</if>


		</where>

	</select>