网站配色简历在哪里制作免费

 条件查询按时间段  如果时间段是起始时间相同name查出来的数据为空

原来的代码 

mapper

 mapper.xml

 修改之后的代码

mapper.xml

 

<select id="getList" resultType="io.renren.modules.kt.dto.NjktDTO">select * from tb_njkt  where 1=1<if test="name != null and name.trim() != ''">and name like #{name}</if><if test="startDate != null and startDate.trim() != ''"><![CDATA[   and DATE_FORMAT(tb_njkt.create_date, '%Y-%m-%d') >=  DATE_FORMAT(#{startDate}, '%Y-%m-%d')   ]]></if><if test="endDate != null and endDate.trim() != ''"><![CDATA[  and DATE_FORMAT(tb_njkt.create_date, '%Y-%m-%d') <= DATE_FORMAT(#{endDate}, '%Y-%m-%d')    ]]></if>order by `tb_njkt`.create_date desc</select>

 再次查询不会出现问题了

 mybatis-plus也可以进行解决

 

 @Overridepublic QueryWrapper<NjktEntity> getWrapper(Map<String, Object> params){QueryWrapper<NjktEntity> 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;}