--[ [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());
```
添加回复
请先登陆