Cnd 怎么拼接时间条件语句呢

 int sendCount = smsRecordService.count(Cnd.where("sendPhone", "=", phone));

然后我在接一个语句判断发送时间是否在今天，这样子要怎么写啊，大佬

wendal

1楼•2575天前

用between比较好

lalala(wx_g9hej6qr60c9sgh4g6dv) 2楼•2575天前

好了嘻嘻嘻

 int sendCount = smsRecordService.count(Cnd.where("sendPhone", "=", phone).
                    and("sendTime","between",new Object[]{DateUtil.getQueryTimeByStart(),DateUtil.getQueryTimeByEnd()}));

public  static String getQueryTimeByStart(){
        return  getDate()+" 00:00:00";
    }

    public  static String getQueryTimeByEnd(){
        return  getDate()+" 23:59:59";
    }

    public static String getDate() {
        return getDate("yyyy-MM-dd");
    }

请先登陆