浙江网站建设营销,简单详细搭建网站教程,中国黄页企业名录,电子产品开发流程条件查询按时间段 如果时间段是起始时间相同name查出来的数据为空
原来的代码
mapper mapper.xml 修改之后的代码
mapper.xml select idgetList resultTypeio.renren.modules.kt.dto.NjktDTOselect * from tb_njkt where 11if testselect idgetList resultTypeio.renren.modules.kt.dto.NjktDTOselect * from tb_njkt where 11if testname ! null and name.trim() ! and name like #{name}/ifif teststartDate ! null and startDate.trim() ! ![CDATA[ and DATE_FORMAT(tb_njkt.create_date, %Y-%m-%d) DATE_FORMAT(#{startDate}, %Y-%m-%d) ]]/ifif testendDate ! null and endDate.trim() ! ![CDATA[ and DATE_FORMAT(tb_njkt.create_date, %Y-%m-%d) DATE_FORMAT(#{endDate}, %Y-%m-%d) ]]/iforder by tb_njkt.create_date desc/select 再次查询不会出现问题了 mybatis-plus也可以进行解决 Overridepublic QueryWrapperNjktEntity getWrapper(MapString, Object params){QueryWrapperNjktEntity wrapper new QueryWrapper();String name (String)params.get(name);wrapper.like(StringUtils.isNotBlank(name), name, name);String startDate (String) params.get(startDate);String endDate (String) params.get(endDate);wrapper.between(StringUtils.isNotBlank(startDate)StringUtils.isNotBlank(endDate),DATE_FORMAT(create_date,%Y-%m-%d),startDate,endDate);wrapper.orderByDesc(create_date);System.out.println(执行了getwrapper方法);/*String createDate (String)params.get(startDate);wrapper.eq(StringUtils.isNotBlank(createDate), create_date, createDate);*/return wrapper;}