既然提到 p6spy 的输出，那就有必要说明一下 p6spy 输出日志的格式了。从上一篇 用 p6spy 来观察 Java 程序中执行的所有 SQL 语句（二. Tomcat 下的配置 中把输出的一段内容拿过来，如下：
03-16-09 15:12:06:656|16|4|statement|SELECT * FROM OM_CUSTOMERS WHERE CUSTOMER_ID=? ORDER BY CUSTOMER_ID ASC|SELECT * FROM OM_CUSTOMERS WHERE CUSTOMER_ID=2194 ORDER BY CUSTOMER_ID ASC
03-16-09 15:12:06:671|15|3|statement|SELECT * FROM OM_ORDER_TYPE WHERE TYPE_ID=?|SELECT * FROM OM_ORDER_TYPE WHERE TYPE_ID=25
03-16-09 15:12:06:687|16|1|statement|select * from sys_lookups where lookup_type=? and lookup_code=? |select * from sys_lookups where lookup_type='OM_ORDER_STATUS' and lookup_code='70'
03-16-09 15:12:06:812|-1||resultset|select * from sys_lookups where lookup_type='OM_ORDER_STATUS' and lookup_code='70' |meaning = 已安排生产 阅读全文 >>