KerifТем что при выполнении запроса с выборкой данных (SELECT) не возвращается ResultSet, я не могу получить доступ к даннм, которые были сформированы после выполнения запроса в программе
- а читать документацию не пробовали?
JDK
boolean execute(String sql)
throws SQLException
Executes the given SQL statement, which may return multiple results. In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).
Parameters:
sql - any SQL statement
Returns:
true if the first result is a ResultSet object; false if it is an update count or there are no results
Throws:
SQLException - if a database access error occurs
See Also:
getResultSet(), getUpdateCount(), getMoreResults()
1.
2.
3.
4.
boolean b=statement.execute("SQL-query");
if (b){
ResultSet result=statement.getResultSet();
}
