mybatisPlus2.X版本力条件构造如果实现查询指定时间的字段呢

Question

如果我想增加指端时间段的条件请问如何写呢

EntityWrapper<ShipRelease> wrapper = new EntityWrapper<>();
            wrapper.where("state={0}", id);
            if(uId != null) wrapper.where("uid={0}", uId);

            List<ShipRelease> shipReleaseList =  webShipownerReleaseShowMapper.selectList( wrapper );
            return SysResult.ok(shipReleaseList);

Answer 1

原来有and语法

if(id != null) wrapper.where("state={0}", id );
            if(uId != null) wrapper.where("uid={0}", uId);
            wrapper.where("empty_date >= {0}  ", startdates  );
            wrapper.and(" empty_date <= {0}" ,end_date);