Processing Dynamic SQL
The
overriding
concept introduced in Example 13-6 is the dynamic SQL
call. Because we do not know whether we will be processing a query or
an update, we need to pass the SQL call through the execute(
)
method. This method returns
true if the statement returned a result set or
false if none was produced. In the example, if it
returns true, the application gets the returned
ResultSet through a call to getResultSet(
)
.
The application can then go on to do normal result set processing.
If, on the other hand, the statement performed some sort of database
modification, you can call getUpdateCount(
)
to find out how many rows were modified by the statement.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
