NutzCN Logo
问答 nutz cnd Cnd这么判断条件为空?
发布于 2338天前 作者 少年不再年少 1851 次浏览 复制 上一个帖子 下一个帖子
标签:
--[ [PackageName=com.qihoo.browser, Date_Time=Fri Nov 24 16:07:52 CST 2017, CS_INT=8],  [PackageName=com.UCMobile, Date_Time=Fri Nov 24 14:33:00 CST 2017, CS_INT=20]]
2017-11-24 16:11:18,501 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk  WHERE c_package_name=? AND c_package_name=?
    |                 1 |            2 |
    |-------------------|--------------|
    | com.qihoo.browser | com.UCMobile |
  For example:> "SELECT * FROM t_preinstall_apk  WHERE c_package_name='com.qihoo.browser' AND c_package_name='com.UCMobile'"
---1[]
2017-11-24 16:11:18,528 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device  WHERE c_imei1=?
    |               1 |
    |-----------------|
    | 865687020107973 |
  For example:> "SELECT * FROM t_device  WHERE c_imei1='865687020107973'"
---2[Device [id=109, channelId=1, brand=Xiaomi, model=MI 4C, IMEI1=865687020107973, IMEI2=null, MEID=null, IMSI=null, OS=android, version=6.0.1, number0=null, number1=null, network=null, MAC=null, source=null, pluginName=blackcrow, pluginVersion=1.0.0, pluginKey=null, registerDateTime=Fri Nov 24 16:08:48 CST 2017, firstUpdateDateTime=Tue Nov 21 09:52:37 CST 2017, lastUpdateDateTime=Fri Nov 24 16:08:48 CST 2017, firstIP=192.168.1.119, firstArea=null, lastIP=192.168.1.119, lastArea=null, totalPreinstallApk=0, targetPreinstallApk=0, matchCount=0, IMEIS=-865687020107973-, softwareCount=2, channelName=null, pluginChannelName=null]]
----------select * from t_activating_quantity   where  q_createtime in (select max(q_createtime) from t_activating_quantity   )
2017-11-24 16:11:18,555 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - select * from t_activating_quantity   where  q_createtime in (select max(q_createtime) from t_activating_quantity   )
----------list[ActivatingQuantity [id=1366, apkId=1, deviceId=109, createtime=2017-11-24 14:33:00.0, time=2]]

1 回复

UpdateClientInfo.R updateClientInfo = new Gson().fromJson(json, UpdateClientInfo.R.class);

    List<Statistics> statistics = updateClientInfo.getUserDate();
    Cnd cn2 = null;
    for (Statistics statistic : statistics) {
       cn2 = Where.where(cn2, "c_package_name", "=", statistic.getPackageName());// 通过包名查询软件id询
    }
    System.err.println("---"+statistics.toString());
    List<PreinstallApk> preinstallApks = dao.query(PreinstallApk.class, cn2);
    System.err.println("---1"+preinstallApks.toString());
    ActivatingQuantity Quantity = new ActivatingQuantity();
    Cnd cnd = null;
    cnd = Where.where(cnd, "c_imei1", "=", updateClientInfo.getIMEI());// 通过唯一值查询手机
    List<Device> device = dao.query(Device.class, cnd);
    System.err.println("---2"+device.toString());

```

添加回复
请先登陆
回到顶部