Java Hibernate展示真实的SQL

log4j.properties

log4j.logger.org.hibernate=INFO, hblog4j.logger.org.hibernate.SQL=DEBUGlog4j.logger.org.hibernate.type=TRACElog4j.logger.org.hibernate.hql.ast.AST=infolog4j.logger.org.hibernate.tool.hbm2ddl=warnlog4j.logger.org.hibernate.hql=debuglog4j.logger.org.hibernate.cache=infolog4j.logger.org.hibernate.jdbc=debuglog4j.appender.hb=org.apache.log4j.ConsoleAppenderlog4j.appender.hb.layout=org.apache.log4j.PatternLayoutlog4j.appender.hb.layout.ConversionPattern=HibernateLog --> %d{HH:mm:ss} %-5p %c - %m%nlog4j.appender.hb.Threshold=TRACE

hibernate.cfg.xml

<property name="show_sql">true</property><property name="format_sql">true</property><property name="use_sql_comments">true</property>

persistence.xml

一些框架使用

persistence.xml：

<property name="hibernate.show_sql" value="true"/><property name="hibernate.format_sql" value="true"/><property name="hibernate.use_sql_comments" value="true"/>