Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

Procedures in the INVENT Schema
The Inventory class contains these SPJ methods, which are useful for tracking parts and
suppliers:
• “SUPPLIERINFO Procedure” (page 101)
• “SUPPLYNUMBERS Procedure” (page 104)
• “PARTLOCS Procedure” (page 106)
Those methods are registered as stored procedures in the INVENT schema. Example A-13 shows
part of the code of the Inventory.java source file. The rest of the code appears in the following
procedure sections.
Example A-13 Inventory.java—The Inventory Class
import java.sql.*;
import java.math.*;
public class Inventory
{
public static void supplierInfo...
{
...
}
public static void supplyQuantities...
{
...
}
public static void partLocations...
{
...
}
}
The following procedure sections show the code of each SPJ method.
100 Sample SPJs