nutz自定义sql查询

关注

原创最新推荐文章于 2026-05-05 10:32:50 发布 861 阅读 AI 写同款· GEO 优化 ›

nutz的框架NutzDao-自定义SQL 1．普通的自定义SQL语句在Nutz中通过org.nutz.dao.sql.Sql接口的实现类org.nutz.dao.Sqls来创建自定义SQL语句。代码如下： Sql sql =Sqls.create("DELETE FROM t_abc WHERE name='Peter'"); 2．支持占位符的自定义SQL语句阅读详情

Cnd cn1 = Cnd.NEW();
        Cnd cn2 = Cnd.NEW();
        if (i == temp - 1) {
            if (special) {
                break;
            }
        } else {
            cutList = statistics.subList(flag * i, flag * (i + 1));
            for (int j = 0; j < cutList.size(); j++) {
                cn1 = Where.where(cn1, "IMEI1", "=", updateClientInfo.getIMEI()); // 查询手机唯一
                Device device = dao.fetch(Device.class, cn1);
                 cn2 = Where.where(cn2, "deviceId", "=",device.getId()); //查询手机id
                 cn2 = Where.where(cn2, "packageName", "=",cutList.get(j).getPackageName()); //查询包名
                DeviceApk deviceApk = dao.fetch(DeviceApk.class, cn2);
                sql = Sqls.create(
                        "select * from t_activating_quantity   where  q_createtime in (select max(q_createtime) from t_activating_quantity  $cnd )");
                sql.setVar("cnd", Cnd.NEW().andEX("t_activating_quantity.q_apkId", "=", deviceApk.getId())
                        .andEX("t_activating_quantity.q_deviceId", "=", device.getId()));
                sql.setCallback(Sqls.callback.entities());
                sql.setEntity(dao.getEntity(ActivatingQuantity.class));
                dao.execute(sql);
                List<ActivatingQuantity> fetch = sql.getList(ActivatingQuantity.class);

收录于