我可以获取准备执行的完整查询吗?

本文介绍了我可以获取准备执行的完整查询吗?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在使用PreparedStatement和MySQL服务器.

I'm working with PreparedStatement with MySQL server.

示例:

String myQuery = "select id from user where name = ?";
PreparedStatement stmt  = sqlConnection.prepareStatement(myQuery);
stmt.setString(1, "test");
stmt.executeQUery();
ResultSet rs = stmt.getResultSet();

如何接收将在MySQL服务器上执行的完整SQL查询?

How can I receive the full SQL query that is about to be executed on the MySQL server?

谢谢！

推荐答案

JDBC规范没有对此进行强制规定，但是一些JDBC驱动程序使PreparedStatement的toString返回将要运行的查询的排序，而MySQL的Connector/J恰好具有这种行为(或者至少是几年前).

It's not mandated by the JDBC spec, but several JDBC drivers let the toString of a PreparedStatement return sort-of the query that will be run, and MySQL's Connector/J happens to have this behavior (or at least it did a few years ago).

String myQuery = "select id from user where name = ?";
PreparedStatement stmt  = sqlConnection.prepareStatement(myQuery);
stmt.setString(1, "test");
System.out.println(stmt); // May do what you want!