我的代码:
List<Infomation> newInfo = infomationDao.query(Cnd.where(Infomation.TYPE_NAME,"=",Infotype.NEWS).orderBy().desc(Infomation.CREATE_TIME), new Pager().setPageSize(2));//最新资讯,两个带图的
List<Infomation> newInfo2 = infomationDao.query(Cnd.where(Infomation.TYPE_NAME,"=",Infotype.NEWS).orderBy().desc(Infomation.CREATE_TIME), new Pager().setPageSize(4));//最新资讯,四个
List<Infomation> tongzhi = infomationDao.query(Cnd.where(Infomation.TYPE_NAME,"=",Infotype.TONGZHI).orderBy().desc(Infomation.CREATE_TIME), new Pager().setPageSize(4));//最新资讯,四个
//微商观察
List<Infomation> guancha = infomationDao.query(Cnd.where(Infomation.TYPE_NAME,"=",Infotype.JIEDU).orderBy().desc(Infomation.CREATE_TIME), new Pager().setPageSize(3));//微商观察,3个
明明指定了按类型查,然后再排序,但是执行的sql是:
[DEBUG] 11:13:14.576 org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:192) - SELECT * FROM infomation ORDER BY create_time DESC LIMIT 0, 2
[DEBUG] 11:13:31.621 org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:276) - batch acquisition of 0 triggers
[DEBUG] 11:13:31.626 org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:192) - SELECT * FROM infomation ORDER BY create_time DESC LIMIT 0, 4
[DEBUG] 11:13:33.726 org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:192) - SELECT * FROM infomation ORDER BY create_time DESC LIMIT 0, 4
[DEBUG] 11:13:35.878 org.nutz.dao.impl.sql.run.NutDaoExecutor._runSelect(NutDaoExecutor.java:192) - SELECT * FROM infomation ORDER BY create_time DESC LIMIT 0, 3
为什么我的where没了呢....