Cnd cnd = Cnd.NEW();
cnd.where().andEquals("DELFLAG","0") ;
Pagination pagination = weixinMsgService.listPage(pageNumber, pageSize, cnd);
sql日志如下
For example:> "SELECT * FROM (SELECT T.*, ROWNUM RN FROM ( SELECT * FROM weixin_msg WHERE DELFLAG='0') T WHERE ROWNUM <= 10) WHERE RN > 0 "
[DEBUG] 2018-10-23 17:24:45,941 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) - SELECT COUNT(*) FROM weixin_msg WHERE DELFLAG=?
| 1 |
|---|
| 0 |
For example:> "SELECT COUNT(*) FROM weixin_msg WHERE DELFLAG='0'"
放到oracle数据库中查询结果正常,如图