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

Procedures in the PERSNL Schema
The Payroll class contains these SPJ methods, which are useful for managing personnel data:
• “ADJUSTSALARY Procedure” (page 93)
• “EMPLOYEEJOB Procedure” (page 95)
• “PROJECTTEAM Procedure” (page 97)
• “TOPSALESREPS Procedure” (page 98)
Those methods are registered as stored procedures in the PERSNL schema. Example A-8 shows
part of the code of the Payroll.java source file. The rest of the code appears in the following
procedure sections.
Example A-8 Payroll.java—The Payroll Class
import java.sql.*;
import java.math.*;
public class Payroll
{
public static void adjustSalary...
{
...
}
public static void employeeJob...
{
...
}
public static void projectTeam...
{
...
}
public static void topSalesReps...
{
...
}
}
The following procedure sections show the code of each SPJ method.
92 Sample SPJs