日期:2014-05-16  浏览次数:20564 次

JDBC打印最终执行sql语句
p6SPY.JAR
PreparedStatement stmt = conn.prepareStatement(sql);
				P6PreparedStatement p6stmt = new P6PreparedStatement(null,
						stmt, null, sql);

				Form.setWIN_UID(new SC003A()
						.getSequence("OA_WINDOW", "WIN_UID"));

				p6stmt.setString(1, Form.getWIN_UID());
				p6stmt.setString(2, Form.getWIN_TYPE());
				p6stmt.setString(3, Form.getEMP_ID());
				p6stmt.setString(4, Form.getCOMPANY_ID());
				p6stmt.setString(5, Form.getFIRM_ID());

				p6stmt.setString(6, getUserInfo(request).getUSER_ID());
				p6stmt.setString(7, getUserInfo(request).getUSER_ID());
				loger.debug(p6stmt.getQueryFromPreparedStatement());
				stmt.execute();
				p6stmt.close();
				stmt.close();

				conn.commit();