public Object queryAllByType(@Param("type") String type) {
try {
Pager pager = dao.createPager(0, 500);
List<Leavemessage> resultList = super.dao.query(Leavemessage.class,
Cnd.where("type", "=", type).desc("leavetime"), pager);
return super.nutzRet(0, "数据查询成功!", resultList);
} catch (Exception e) {
e.printStackTrace();
return super.nutzRet(-1, "数据查询失败!请稍后重试!", e.getMessage());
}
}
2019-07-01 19:56:11,423 org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388) DEBUG - SELECT * FROM bs_leavemessage WHERE type=? ORDER BY leavetime DESC
| 1 |
|----|
| 个人 |
For example:> "SELECT * FROM bs_leavemessage WHERE type='个人' ORDER BY leavetime DESC "
2019-07-01 19:56:11,454 cn.core.mvc.LogTimeProcessor.process(LogTimeProcessor.java:28) DEBUG - [POST]URI=/bmpt/leavemessage/queryAllByType 69ms