Hibernate打印SQL及附加参数(转载) (二)

2014-11-24 11:54:48 · 作者: · 浏览: 51
.engine.QueryParameters=DEBUG
log4j.logger.org.hibernate.engine.query.HQLQueryPlan=DEBUG
这样修改之后,可以得到如下的结果:
Console代码:
[html]
01 20:13:40.710 [http-8080-1] org.hibernate.engine.query.HQLQueryPlan - find: from User where email = :email
02 20:13:40.710 [http-8080-1] org.hibernate.engine.QueryParameters - named parameters: {email=fantasia@sina.com}
03 20:13:40.726 [http-8080-1] org.hibernate.SQL -
04 /* named HQL query findUserByEmail */ select
05 user0_.id as id0_,
06 user0_.email as email0_,
07 user0_.enabled as enabled0_,
08 user0_.encodedPassword as encodedP8_0_
09 from
10 User user0_
11 where
12 user0_.email=

01 20:13:40.710 [http-8080-1] org.hibernate.engine.query.HQLQueryPlan - find: from User where email = :email
02 20:13:40.710 [http-8080-1] org.hibernate.engine.QueryParameters - named parameters: {email=fantasia@sina.com}
03 20:13:40.726 [http-8080-1] org.hibernate.SQL -
04 /* named HQL query findUserByEmail */ select
05 user0_.id as id0_,
06 user0_.email as email0_,
07 user0_.enabled as enabled0_,
08 user0_.encodedPassword as encodedP8_0_
09 from
10 User user0_
11 where
12 user0_.email= ++++++++++++++++++++++++++++++++++++++++++++++++++++++

1、hibernate配置文件中:
show_sql=true
2、log4j.properties 文件中添加:
log4j.logger.org.hibernate.SQL=trace
log4j.logger.org.hibernate.type=trace