select a.*
from t_activating_quantity AS a
where not exists(select 1
from t_activating_quantity AS b
where b.q_createtime>a.q_createtime AND b.q_apkId=39 AND b.q_deviceId=100);
7 回复
Sql sql=Sqls.create("select a.* from t_activating_quantity AS a where not exists"
+ " (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()') ");
dao.execute(sql);
2017-11-20 13:31:37,481 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,496 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,513 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,537 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,574 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,595 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,611 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,627 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,642 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,657 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,677 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,696 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,717 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,734 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,751 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,767 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,785 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,801 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,818 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,839 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,862 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,881 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,900 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,916 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,934 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,951 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,967 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,981 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:37,998 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,012 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,026 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,047 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,063 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,078 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,093 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,106 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,120 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,135 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,148 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,164 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,180 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,195 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,208 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,224 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,239 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,255 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,281 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,297 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,311 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,326 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,341 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,358 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,377 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,390 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,404 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,419 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,434 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,450 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,468 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,482 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,496 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,510 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,526 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,540 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,555 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,569 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,583 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,602 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,618 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,633 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,648 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,662 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,677 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,691 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,704 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,718 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,735 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,751 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,765 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,780 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,794 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,810 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,829 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,847 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,866 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,883 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,899 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,915 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,931 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,947 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,963 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,978 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:38,995 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,010 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,030 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,050 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,068 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,084 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,098 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,114 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,132 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,147 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,164 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,180 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,195 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,209 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,222 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,237 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,250 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,264 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,280 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,294 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,310 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,326 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,339 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,355 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,369 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,384 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,398 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,413 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,430 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,446 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,461 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,474 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,488 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,502 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,517 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,537 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,554 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,571 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,588 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,652 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,667 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,683 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,702 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,718 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,744 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,762 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,779 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,795 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,815 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,832 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,847 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,862 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,876 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,893 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,908 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,924 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,941 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,957 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,972 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:39,987 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,003 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,020 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,036 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,051 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,066 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,082 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,098 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_device WHERE id=?
| 1 |
|-----|
| 122 |
For example:> "SELECT * FROM t_device WHERE id=122"
2017-11-20 13:31:40,100 org.nutz.mvc.impl.NutLoading.load(NutLoading.java:141) INFO - Nutz.Mvc[nutz] is up in 13369ms
十一月 20, 2017 1:31:40 下午 org.apache.catalina.core.StandardContext reload
信息: Reloading Context with name [/woyaofa] is completed
2017-11-20 13:31:40,136 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:173)
2017-11-20 13:31:40,143 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule>
2017-11-20 13:31:40,144 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:177) DEBUG - >> Load definition name=pluginDataModule
2017-11-20 13:31:40,144 org.nutz.ioc.loader.combo.ComboIocLoader.load(ComboIocLoader.java:169) DEBUG - Found IocObject(pluginDataModule) in AnnotationIocLoader(packages=[com.woyaofa])
2017-11-20 13:31:40,145 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:209) DEBUG - >> Make...'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule>
2017-11-20 13:31:40,145 org.nutz.ioc.aop.impl.DefaultMirrorFactory.getMirror(DefaultMirrorFactory.java:70) DEBUG - Load class com.woyaofa.module.api.PluginDataModule without AOP
2017-11-20 13:31:40,146 org.nutz.ioc.impl.ScopeContext.save(ScopeContext.java:64) DEBUG - Save object 'pluginDataModule' to [app]
2017-11-20 13:31:40,149 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'dao'<interface org.nutz.dao.Dao>
------------R [channel=null, brand=Xiaomi, model=MI 4C, IMEI=865687020107973, IMSI=null, OS=null, version=null, number0=null, number1=null, network=null, MAC=null, pluginName=null, pluginVersion=null, pluginKey=null, softwareCount=0, application=0, time=0, apkItems=null, userDate=[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]]
------------[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]
2017-11-20 13:31:40,394 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=?
| 1 |
|-----------------------|
| com.jingdong.app.mall |
For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.jingdong.app.mall'"
2017-11-20 13:31:40,413 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'"
2017-11-20 13:31:40,597 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=?
| 1 | 2 |
|----|-----|
| 39 | 100 |
For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=39 AND q_deviceId=100"
2017-11-20 13:31:40,632 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')
2017-11-20 13:31:40,638 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
2017-11-20 13:31:40,648 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity :
org.nutz.dao.DaoException: !Nutz SQL Error: 'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
PreparedStatement:
'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
... 51 more
2017-11-20 13:32:19,688 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:173)
2017-11-20 13:32:19,689 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule>
------------R [channel=null, brand=Xiaomi, model=MI 4C, IMEI=865687020107973, IMSI=null, OS=null, version=null, number0=null, number1=null, network=null, MAC=null, pluginName=null, pluginVersion=null, pluginKey=null, softwareCount=0, application=0, time=0, apkItems=null, userDate=[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]]
------------[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]
2017-11-20 13:32:19,722 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=?
| 1 |
|-----------------------|
| com.jingdong.app.mall |
For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.jingdong.app.mall'"
2017-11-20 13:32:19,747 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'"
2017-11-20 13:32:19,767 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=?
| 1 | 2 |
|----|-----|
| 39 | 100 |
For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=39 AND q_deviceId=100"
2017-11-20 13:32:19,785 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')
2017-11-20 13:32:19,787 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
2017-11-20 13:32:19,793 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity :
org.nutz.dao.DaoException: !Nutz SQL Error: 'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
PreparedStatement:
'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
... 51 more
2017-11-20 13:32:56,636 org.nutz.mvc.impl.UrlMappingImpl.get(UrlMappingImpl.java:101) DEBUG - Found mapping for [POST] path=/api/advert/quantity : PluginDataModule.ClientInfo(PluginDataModule.java:173)
2017-11-20 13:32:56,636 org.nutz.ioc.impl.NutIoc.get(NutIoc.java:151) DEBUG - Get 'pluginDataModule'<class com.woyaofa.module.api.PluginDataModule>
------------R [channel=null, brand=Xiaomi, model=MI 4C, IMEI=865687020107973, IMSI=null, OS=null, version=null, number0=null, number1=null, network=null, MAC=null, pluginName=null, pluginVersion=null, pluginKey=null, softwareCount=0, application=0, time=0, apkItems=null, userDate=[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]]
------------[ [PackageName=com.jingdong.app.mall, Date_Time=Mon Nov 20 13:29:38 CST 2017, CS_INT=6]]
2017-11-20 13:32:56,663 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_preinstall_apk WHERE c_package_name=?
| 1 |
|-----------------------|
| com.jingdong.app.mall |
For example:> "SELECT * FROM t_preinstall_apk WHERE c_package_name='com.jingdong.app.mall'"
2017-11-20 13:32:56,678 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'"
2017-11-20 13:32:56,694 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM t_activating_quantity WHERE q_apkId=? AND q_deviceId=?
| 1 | 2 |
|----|-----|
| 39 | 100 |
For example:> "SELECT * FROM t_activating_quantity WHERE q_apkId=39 AND q_deviceId=100"
2017-11-20 13:32:56,710 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')
2017-11-20 13:32:56,711 org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:97) DEBUG - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
2017-11-20 13:32:56,713 org.nutz.mvc.impl.processor.FailProcessor.process(FailProcessor.java:28) WARN - Error@/api/advert/quantity :
org.nutz.dao.DaoException: !Nutz SQL Error: 'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
PreparedStatement:
'select a.* from t_activating_quantity AS a where not exists (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime AND b.q_apkId=+ 'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()')'
CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:147)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:114)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:81)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:70)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:239)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:247)
at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:235)
at org.nutz.dao.impl.NutDao.execute(NutDao.java:977)
at com.woyaofa.module.api.PluginDataModule.ClientInfo(PluginDataModule.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:58)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:495)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:767)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1347)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.q_deviceId=+'devices.getId()')' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:246)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:53)
... 51 more
@At(UpdateClientInfo.QUANTITY)
public Result ClientInfo(@Param("json") String json, HttpServletRequest request) throws ParseException {
json = Data.decode(json);
SimpleDateFormat fmt = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
// GSON直接解析成对象
UpdateClientInfo.R updateClientInfo = new Gson().fromJson(json, UpdateClientInfo.R.class);
System.err.println("------------" + updateClientInfo.toString());
// 对象中拿到集合
List<Statistics> statistics = updateClientInfo.getUserDate();
System.err.println("------------" + statistics.toString());
Cnd cn2 = null;
for (Statistics statistic : statistics) {
cn2 = Where.where(cn2, "packageName", "=", statistic.getPackageName());// 通过包名查询软件id询
}
List<PreinstallApk> preinstallApks = dao.query(PreinstallApk.class, cn2);
Cnd cnd = null;
cnd = Where.where(cnd, "IMEI1", "=", updateClientInfo.getIMEI());// 通过唯一值查询手机
List<Device> device = dao.query(Device.class, cnd);
Cnd cnd1 = null;
for (PreinstallApk preinstallApk : preinstallApks) {
cnd1 = Where.where(cnd1, "apkId", "=", preinstallApk.getId());// 通过软件id查询软件
}
for (Device devices : device) {
cnd1 = Where.where(cnd1, "deviceId", "=", devices.getId());// 通过手机id查询软件
}
//cnd1 = Where.where(cnd1, "deviceId", "=", devices.getId());// 通过手机id查询软件
List<ActivatingQuantity> fetch = dao.query(ActivatingQuantity.class, cnd1);
Sql sql=Sqls.create("select a.* from t_activating_quantity AS a where not exists"
+ " (select 1 from t_activating_quantity AS b where b.q_createtime >a.q_createtime "
+ "AND b.q_apkId=+'preinstallApk.getId()'+ AND b.q_deviceId=+'devices.getId()') ");
sql.setCallback(Sqls.callback.entities());
sql.setEntity(dao.getEntity(ActivatingQuantity.class));
dao.execute(sql);
int num = 1;
// 判断手机唯一标示是否一致
for (Statistics statistics2 : statistics) {
for (PreinstallApk preinstallApk : preinstallApks) {
for (Device dev : device)
for (ActivatingQuantity activatingQuantity : fetch) {
if (statistics2.getDate_Time().getTime() > preinstallApk.getUploadDateTime().getTime()) {
if (num <= 4) {
num++;
if (Strings.isBlank(activatingQuantity.getCreatetime())) {
activatingQuantity.setApkId(preinstallApk.getId()); // APK ID
activatingQuantity.setDeviceId(dev.getId()); // 手机 ID
activatingQuantity.setCreatetime(sdf.format(statistics2.getDate_Time())); // 更新时间
activatingQuantity.setTime(num + ""); // 次数
activatingQuantity = dao.insert(activatingQuantity); // 插入数据
System.out.println("-----------新增成功");
} else {
System.err.println("第二次"+num);
System.err.println("-----1--"+statistics2.getDate_Time());
System.err.println("------2-"+fmt.parse(activatingQuantity.getCreatetime()));
activatingQuantity.setApkId(preinstallApk.getId()); // APK ID
activatingQuantity.setCreatetime(sdf.format(statistics2.getDate_Time())); // 更新时间
activatingQuantity.setTime(num + ""); // 次数
boolean isv=statistics2.getDate_Time().getTime()==fmt.parse(activatingQuantity.getCreatetime()).getTime();
System.err.println("---------"+isv);
// 判断客户端发送的日期和数据库表的日期对比是否相同
if (statistics2.getDate_Time().getTime()==fmt.parse(activatingQuantity.getCreatetime()).getTime()) {
break;
}
activatingQuantity = dao.insert(activatingQuantity); // 插入数据
System.out.println("-----------操作成功");
}
}
}
}
}
}
return Result.makeSuccessResult();
}
添加回复
请先登陆