控制台打印hibernate执行的语句

本是古典何须时尚 2022-08-14 04:39 200阅读 0赞

1、将log4jdbc的jar包放到webroot下的lib文件夹中；

--------------------

2、 修改log4j.properties文件

<table style=""> 
 <tbody style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <td style=""> 
    <div style="min-width:2px; background-color:inherit"> 
     <div style="background-color:rgb(255,255,255)">
       ### 输出到控制台 ### 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.org.hibernate.type=debug 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.jdbc.sqlonly=off 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.jdbc.sqltiming=on 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.jdbc.audit=off 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.jdbc.resultset=off 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       log4j.logger.jdbc.connection=off 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

--------------------

3、修改jdbc.properties文件

<table style=""> 
 <tbody style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <td style=""> 
    <div style="min-width:2px; background-color:inherit"> 
     <div style="background-color:rgb(255,255,255)">
       hibernate.dialect=org.hibernate.dialect.MySQL5Dialect 
     </div> 
     <div style="background-color:inherit"> 
      <span style="background-color:rgb(255,255,255)">jdbc.driverClassName=</span> 
      <span style="background-color:orange">net.sf.log4jdbc.DriverSpy</span> 
     </div> 
     <div style="background-color:inherit"> 
      <span style="background-color:rgb(255,255,255)">jdbc.url=</span> 
      <span style="background-color:orange">jdbc:log4jdbc</span> 
      <span style="background-color:rgb(255,255,255)">:mysql://127.0.0.1:3306/test?useUnicode=true&amp;characterEncoding=utf8</span> 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       jdbc.username=ce8839cbab20d317 
     </div> 
     <div style="background-color:rgb(255,255,255)">
       jdbc.password=c6068f66f4846a14 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

原：

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8

--------------------

4、修改applicationContext-hibernate.xml文件

<table style="width:600px; font-size:undefined; margin-top:10px; margin-bottom:10px; display:table; border-collapse:collapse; background-color:inherit"> 
 <tbody style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <td style=""> 
    <div style="min-width:2px; background-color:inherit">
      &lt;prop key="hibernate.show_sql"&gt; 
     <span style="background-color:orange">true</span>&lt;/prop&gt;&nbsp; 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

true：表示在控制台显示sql语句，默认为false

[http://dl2.iteye.com/upload/attachment/0060/1887/4eb7b9ed-71fe-32f2-8668-d5dae61ffa20.jar][http_dl2.iteye.com_upload_attachment_0060_1887_4eb7b9ed-71fe-32f2-8668-d5dae61ffa20.jar]

[http_dl2.iteye.com_upload_attachment_0060_1887_4eb7b9ed-71fe-32f2-8668-d5dae61ffa20.jar]: http://dl2.iteye.com/upload/attachment/0060/1887/4eb7b9ed-71fe-32f2-8668-d5dae61ffa20.jar