p6使用教程_pwdump7使用

				<!--开发调试使用 -->
				<!--控制台打印sql语句 -->
				<prop key="hibernate.show_sql">false</prop>
				<!--格式化语句 -->
				<prop key="hibernate.format_sql">false</prop>
				<!--如果开启, Hibernate将在SQL中生成有助于调试的注释信息, 默认值为false -->
				<prop key="hibernate.use_sql_comments">false</prop>

		Connection conn = null;
		try {
			// 第一步，注册驱动程序 以mysql驱动为例
			Class.forName("com.mysql.jdbc.Driver");
			// 第二步，获取一个数据库的连接
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123");
			conn.setAutoCommit(false);
			
			
			// 第三步，创建一个会话
			//Statement stmt = conn.createStatement();	
			String sql = "select * from school s where s.id=?";
			PreparedStatement stmt = conn.prepareStatement(sql);
			stmt.setInt(1, 1);
			
			
			// 第四步，执行SQL语句，增加，删除，修改记录 或者查询记录
			// stmt.executeUpdate();
			ResultSet rs = stmt.executeQuery();
			ResultSetMetaData m = rs.getMetaData();

			// 第五步，对查询的结果进行处理
			int columns = m.getColumnCount();
			// 显示列,表格的表头
			for (int i = 1; i <= columns; i++) {
				System.out.print(m.getColumnName(i));
				System.out.print("\t\t");
			}
			System.out.println();
			// 显示表格内容
			while (rs.next()) {
				for (int i = 1; i <= columns; i++) {
					System.out.print(rs.getString(i));
					System.out.print("\t\t");
				}
				System.out.println();
			}
			// 第六步，关闭连接
			conn.commit();
			rs.close();
			stmt.close();
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("进行回滚操作");
			conn.rollback();
		} finally {
			conn.close();
		}

		<!--设置数据库连接 -->
		<property name="driverClass" value="com.p6spy.engine.spy.P6SpyDriver" />

db.jdbcUrl  = jdbc:p6spy:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&rewriteBatchedStatements=true

#配置输出方式
#appender=com.p6spy.engine.spy.appender.Slf4JLogger
#appender=com.p6spy.engine.spy.appender.FileLogger
appender=com.p6spy.engine.spy.appender.StdoutLogger

#配置输出内容格式(此处自定义)
#默认 com.p6spy.engine.spy.appender.SingleLineFormat
logMessageFormat=spring.redis.test.util.MySingleLineFormat

#输出内容选择
#list of categories to exclude: error, info, batch, debug, statement,
#commit, rollback and result are valid values
# (default is info,debug,result,resultset,batch)
excludecategories=info,batch,debug,commit,rollback,result,resultset

package spring.redis.test.util;

import org.hibernate.engine.jdbc.internal.BasicFormatterImpl;

import com.p6spy.engine.spy.appender.SingleLineFormat;

public class MySingleLineFormat extends SingleLineFormat {
	private final static BasicFormatterImpl sqlformat = new BasicFormatterImpl();
	  /**
	   * Formats a log message for the logging module
	   *
	   * @param connectionId the id of the connection
	   * @param now          the current ime expressing in milliseconds
	   * @param elapsed      the time in milliseconds that the operation took to complete
	   * @param category     the category of the operation
	   * @param prepared     the SQL statement with all bind variables replaced with actual values
	   * @param sql          the sql statement executed
	   * @return the formatted log message
	   */
	  @Override
	  public String formatMessage(final int connectionId, final String now, final long elapsed, final String category, final String prepared, final String sql) {
	   return "#token time:" + elapsed + "ms | category:" + category + " | connectionId: " + connectionId + "\n" + "预编译语句"+sqlformat.format(prepared) + "\nread sql" + sqlformat.format(sql)
	  }
}

		//执行打印sql
		hibernateTemplate.get(School.class, 1);
/*		#token time:3ms | category:statement | connectionId: 2
		预编译语句
		    select
		        school0_.id as id1_1_0_,
		        school0_.create_time as create_t2_1_0_,
		        school0_.des as des3_1_0_,
		        school0_.name as name4_1_0_,
		        school0_.update_time as update_t5_1_0_ 
		    from
		        school school0_ 
		    where
		        school0_.id=?
		read sql
		    select
		        school0_.id as id1_1_0_,
		        school0_.create_time as create_t2_1_0_,
		        school0_.des as des3_1_0_,
		        school0_.name as name4_1_0_,
		        school0_.update_time as update_t5_1_0_ 
		    from
		        school school0_ 
		    where
		        school0_.id=1*/