pQuery.getParsedQuery¶

Signature: pQuery.getParsedQuery()

Returns: String queryString - the query to be used in a java.sql.PreparedStatement

Return the query.

Note

Use this functions to see the query that will be used in a java.sql.PreparedStatement after evaluating Node Tags, parsing, indexing and replacing the named parameters with question mark ('?') parameter place holders.

Parameters¶

None

Example¶

// Create the pQuery object with the query to be executed
var pQuery = qie.getParameterizedQuery(
   "insert into patient (name, balance) values (:name, :balance)");

pQuery.setString("name", "Ada Lovelace");
pQuery.setDouble("balance", 96.25);

var parsedQuery = pQuery.getParsedQuery(); // parsedQuery contains the query and all parameters.