Question

spring+struts+hibernate做的项目在控制台不输出SQL语句

我在hibernate.cfg.xml当中配置了<property name="show_sql">true</property>

Answer 1

<!-- SessionFactory -->
<bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dbSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/lovo/epet/po/PetInfoPO.hbm.xml</value>
</list>
</property>
</bean>
检查下你配置的位置是否正确吧

Answer 2

在log4j.properties中设置控制台输出SQL，下述各部分组合后即可实现SSH下在控制台输出SQL
1、设置日志输出级别为INFO
log4j.rootLogger=INFO,A1
其中A1为控制台，如果要同时输出到文件，则：
log4j.rootLogger=INFO,A1,R
2、设置输出Hibernate语句
log4j.logger.org.hibernate.SQL=debug
log4j.additivity.org.hibernate.SQL=true
log4j.logger.org.hibernate.SQL=trace
log4j.logger.org.hibernate.type=trace
3、控制台的输出配置
log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.Target=System.out
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%c]%m%n

Answer 3

<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation">
<value>classpath:hibernate.cfg.xml</value>
</property>
</bean>
spring配置，hibernate.cfg.xml放在源码根目录

Answer 4

项目构建路径中加入以下jar包试试：
slf4j-api-1.6.1.jar
slf4j-log4j12-1.6.1.jar
log4j-1.2.16.jar