在Log4j中配置
在log4j.properties中配置:
# set root logger level to DEBUG
log4j.rootLogger=DEBUG,CONSOLE
# CONSOLE
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.Threshold=DEBUG
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern= %d{yyyy-MM-dd HH:mm:ss} [%-5p] -%c{1} -[%t]-%m%n
# hibernate
log4j.logger.org.hibernate=DEBUG
log4j.logger.org.hibernate.SQL=DEBUG
log4j.logger.org.springframework=DEBUG
在applicationContent.xml中配置
<!-- 本地定义Hibernate、以及simpleJdbcTemplete访问数据库 -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="namingStrategy">
<bean class="org.hibernate.cfg.ImprovedNamingStrategy" />
</property>
<property name="hibernateProperties">
<props>
<!-- 连接池相关配置 -->
<!-- 日志中打印SQL -->
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.use_sql_comments">true</prop>
</props>
</property>
<property name="packagesToScan" value="com.st.lock.*.entity" />
</bean>