mybatis层 原来的
select count(*) as currentCount from namedate
<where>
<if test="stateOfLastPeriod!= null">
and b.shijian >= #{stateOfLastPeriod}
</if>
<if test="endOfLastPeriod!= null">
and b.shijian <![CDATA[<]]>= #{endOfLastPeriod}
</if>
</where>
如果修改成这样应该如何修改下面的代码
修改之后报错
"nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2"
dao层
![img](https://img-mid.csdnimg.cn/release/static/image/mid/ask/005843598736112.png "#left")
service
NameDate zongshu(ShiJianFuZhu shiJianFuZhu);
serviceinipml
public NameDate zongshu(ShiJianFuZhu shiJianFuZhu){
QueryWrapper<NameDate> wrapper=new QueryWrapper<>();
wrapper.gt("shijian",shiJianFuZhu.getShijiantou())
.lt("shijian",shiJianFuZhu.getShijianwei());
wrapper.gt("shijian",shiJianFuZhu.getStateOfLastPeriod())
.lt("shijian",shiJianFuZhu.getEndOfLastPeriod());
return zhongDuanDao.zongshu(shiJianFuZhu);
}
controller层
@RequestMapping("zongshu")
@ResponseBody
public NameDate zongshu(ShiJianFuZhu shiJianFuZhu){
NameDate nameDate=new NameDate();
nameDate=zhongDuanService.zongshu(shiJianFuZhu);
return nameDate;
}