如何获得PreparedStatement最终执行的sql语句

huiminchen

 
这个是链接地址
http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html
 
自己试了试，成功。
靠谱，推荐大家使用。
 
 
Connection con = DriverManager.getConnection(url);DebugLevel debug = DebugLevel.ON;String sql = "SELECT name,rate FROM EmployeeTable WHERE rate > ?";//Use a factory instead of Connection to get a PreparedStatement.//PreparedStatement ps = con.prepareStatement(sql);  PreparedStatement ps = StatementFactory.getStatement(con,sql,debug);  ps.setInt(1,25);//If ps is a DebuggableStatement, you see the statement,//otherwise, an object identifier is displayed  System.out.println(" debuggable statement= " + ps.toString()); 
 
附件是这段代码中用到的类。