Cnd 里面可以添加函数么?

这样的SQL

Select * from recommend where Now() between StartTime and EndTime
StartTime  EndTime  是数据库字段

wendal

1楼•3142天前

用Static

Cnd.where(new Static("Now() between StartTime and EndTime"));

lalala(wx_g9hej6qr60c9sgh4g6dv) 2楼•2288天前

反向解决了，，真是神奇的东西

lalala(wx_g9hej6qr60c9sgh4g6dv) 3楼•2288天前

dao.func2(OutStockGoodsItem.class, "sum", "cktaxe", Cnd.where(new Static("ck in (select ck from t_ckd where yxbz = '1' and status = 0  and shrq >= '" + DateUtil.getQueryTimeByStart(startTime) + "'" +
                " and shrq <= '" + DateUtil.getQueryTimeByEnd(endTime) + "')")));

请先登陆