Oracle 5.0, Справочное руководство

Страница: 2109 / 3232

JDBC Concepts
2089
Example 20.2. Connector/J: Using java.sql.Statement to execute a
SELECT
query
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
// assume that conn is an already created JDBC connection (see previous examples)
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT foo FROM bar");
// or alternatively, if you don't know ahead of time that
// the query will be a SELECT...
if (stmt.execute("SELECT foo FROM bar")) {
rs = stmt.getResultSet();
}
// Now do something with the ResultSet ....
}
catch (SQLException ex){
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
finally {
// it is a good idea to release
// resources in a finally{} block
// in reverse-order of their creation
// if they are no-longer needed
if (rs != null) {
try {
rs.close();
} catch (SQLException sqlEx) { } // ignore
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqlEx) { } // ignore
stmt = null;
}
}
20.3.6.3. Using JDBC
CallableStatements
to Execute Stored Procedures
Starting with MySQL server version 5.0 when used with Connector/J 3.1.1 or newer, the
java.sql.CallableStatement
interface is fully implemented with the exception of the
getParameterMetaData()
method.
For more information on MySQL stored procedures, please refer to http://dev.mysql.com/doc/mysql/en/
stored-routines.html .
Connector/J exposes stored procedure functionality through JDBC's
CallableStatement
interface.
Note
Current versions of MySQL server do not return enough information for the
JDBC driver to provide result set metadata for callable statements. This means