P6Spy 是针对数据库访问操作的动态监测框架（为开源项目，项目首 页：www.p6spy.com）它使得数据库数据可无缝截取和操纵，而不必对现有应用程序的代码作任何修改。P6Spy 分发包包括P6Log，它是一 个可记录任何 Java 应用程序的所有JDBC事务的应用程序。其配置完成使用时，可以进行数据访问性能的监测。
我们最需要的功能，查看sql语句，不是预编译的带问号的哦，而是真正的数据库执行的sql，更直观，更简单。
1.依赖jar包
p6spy p6spy 2.2.0
2.修改jdbc驱动为p6spy
datasource.druid.driverClassName=com.p6spy.engine.spy.P6SpyDriver
3.添加配置
#第一：module.log的属性必须配置，如果不配置，P6SPY将不起任何作用，典型配置：module.log=com.p6spy.engine.logging.P6LogFactory#module.outage=com.p6spy.engine.outage.P6OutageFactory #第二：数据库驱动配置# oracle driver# realdriver=oracle.jdbc.driver.OracleDriver # mysql Connector/J driver# realdriver=com.mysql.jdbc.Driver # informix driver# realdriver=com.informix.jdbc.IfxDriver # ibm db2 driver# realdriver=COM.ibm.db2.jdbc.net.DB2Driver # the mysql open source driverrealdriver=org.gjt.mm.mysql.Driver #specifies another driver to userealdriver2=#specifies a third driver to userealdriver3= #第三：appender配置，一般分为三种#specifies the appender to use for logging#appender=com.p6spy.engine.logging.appender.Log4jLogger#控制台#appender=com.p6spy.engine.logging.appender.StdoutLoggerappender=com.p6spy.engine.logging.appender.FileLogger # name of logfile to use, note Windows users should make sure to use forward slashes in their pathname (e:/test/spy.log) (used for file logger only)#日志文件存放路径及文件名logfile = spy.log # append to the p6spy log file. if this is set to false the# log file is truncated every time. (file logger only)append=true #The following are for log4j logging onlylog4j.appender.STDOUT=org.apache.log4j.ConsoleAppenderlog4j.appender.STDOUT.layout=org.apache.log4j.PatternLayoutlog4j.appender.STDOUT.layout.ConversionPattern=p6spy - %m%n log4j.logger.p6spy=INFO,STDOUT