Hibernate输出SQL附加参数

参考文章

https://blog.csdn.net/xinqinglhj/article/details/50971108 
让Hibernate输出SQL语句参数配置 
https://www.cnblogs.com/cglWorkBook/p/4801641.html
Hibernate打印SQL及附加参数
https://www.cnblogs.com/xiaohui123-com/p/6547079.html
Hibernate打印SQL及附加参数

自己实际配置

applicationContext.xml

<!-- 2.配置Hibernate属性 -->
<property name="hibernateProperties">
	<value>
		hibernate.show_sql=true
		hibernate.format_sql=true
		hibernate.use_sql_comments=true    
	</value>
</property>

log4j.properties

#为了显示参数
log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
log4j.loggerorg.hibernate.type.descriptor.sql.BasicExtractor=TRACE

log4j.logger.org.hibernate.SQL=TRACE

#查看查询中命名参数的值
log4j.logger.org.hibernate.engine.QueryParameters=DEBUG
log4j.logger.org.hibernate.engine.query.HQLQueryPlan=DEBUG

log4j.appender.STDOUT.Threshold=trace
log4j.category.org.hibernate.SQL=trace
log4j.category.org.hibernate.type=trace

自己的注释

D:\workspace\oxygen\itcast0820Project  生效的
D:\workspace\oxygen\yhcms  失效的