SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

Sales Class
The Sales class contains these SPJ methods, which are useful for tracking orders and managing
sales:
• The lowerPrice()method determines which items are selling poorly (that is, have less than
50 orders) and lowers the price of these items in the database by 10 percent.
• The numDailyOrders() method accepts a date and returns the number of orders on that
date to an output parameter.
• The numMonthlyOrders() method accepts an integer representing the month and returns
the number of orders during that month to an output parameter.
• The totalPrice() method accepts the quantity, shipping speed, and price of an item,
calculates the total price, including tax and shipping charges, and returns the total price to
an input/output parameter.
The Sales.java source file in SampleSPJs.jar contains the code shown in Example 1
(page 108).
Class Files and Java Methods 107