NutzDao中，怎样在控制台打印sql日志？参数也要打印那种。

@Test
    public void t3() {
        Dao dao = new NutDao(dataSource);
        Sql sql = Sqls.create("select * from sunyu_resource t where t.id = @id");
        sql.params().set("id", "21326916-33a1-4d10-a29c-d156a1bc7b76");
        sql.setCallback(Sqls.callback.record());
        Sql s = dao.execute(sql);
        System.out.println(s.getResult());
    }

我想在控制台和log4j日志中，记录这个sql和传递的参数

select * from sunyu_resource t where t.id = ?

id : 21326916-33a1-4d10-a29c-d156a1bc7b76

wendal

1楼•2987天前

默认就有打印，日志级别debug

来自炫酷的 NutzCN

qq_16dd5808 2楼•2987天前

哦，哦，忘记了，以前设置了

log4j.logger.org.nutz=ERROR

所以看不到了。
现在加上这句话可以了。

log4j.logger.org.nutz.dao.impl.sql.run.NutDaoExecutor=DEBUG

打印效果如下：，留给后人。。。。。。

[DEBUG][2016-09-18 09:03:54,793][org.nutz.dao.impl.sql.run.NutDaoExecutor.printSQL(NutDaoExecutor.java:388)]select * from sunyu_resource t where t.id = ?
    |                                    1 |
    |--------------------------------------|
    | 21326916-33a1-4d10-a29c-d156a1bc7b76 |
  For example:> "select * from sunyu_resource t where t.id = '21326916-33a1-4d10-a29c-d156a1bc7b76'"
{
   "id" :"21326916-33a1-4d10-a29c-d156a1bc7b76",
   "name" :"添加用户",
   "remark" :"",
   "seq" :1,
   "pid" :"b7d65527-c0ee-4ffb-b993-bece0481f230",
   "created" :"2016-08-09 20:58:00",
   "modified" :"2016-08-09 20:58:00",
   "visible" :1,
   "permission" :"shiro:user:insert",
   "url" :"/shiro/user/insert",
   "levels" :1
}

请先登陆