Optimizing Application Design - Oracle Database 11gR2 Performance Tuning - page 50

4. Create a OraclePerformanceTuningCookbook directory and a chapter02

directory inside it.

5. Open your preferred text editor. Create a class StoredProcedure in the

package chapter02 using the following code and save it in a file named
StoredProcedure.java in the previously created chapter02 directory:
package chapter02;

import java.sql.*;
import oracle.jdbc.*;
import javax.swing.*;

public class StoredProcedure {
private static final String driver =
"oracle.jdbc.driver.OracleDriver";
private static final String connectionString =
"jdbc:oracle:thin:@localhost:1521:TESTDB";
private static final String user = "sys as sysdba";

public static void useQuery(Connection conn)
throws SQLException {
try {
PreparedStatement ps = conn
.prepareStatement("SELECT PROD_ID, SUM(AMOUNT_SOLD) AS
AMOUNT FROM SH.SALES GROUP BY PROD_ID");
ResultSet result = ps.executeQuery();
while (result.next()) {
String row = result.getInt("PROD_ID") + " "
+ result.getDouble("AMOUNT");
System.out.println(row);
}
ps.close();
} catch (Exception e) {
System.out.println(String.format("Error %s",
e.getLocalizedMessage()));
System.exit(1);
}
}

public static void useStoredProcedure(Connection conn)
throws SQLException {
try {
CallableStatement ps = conn
.prepareCall("BEGIN SH.SALES_FOR_PRODUCT(?); END;");