01 package localControls.tags;
02
03 import com.bea.control.DatabaseControl;
04 import java.sql.SQLException;
05
06 /**
07 * This Database control provides access to a database for the
08 * POVerify Java control.
09 *
10 * @jc:connection data-source-jndi-name="cgSampleDataSource"
11 */
12 public interface ItemsDatabaseControl
13 extends DatabaseControl, com.bea.control.ControlExtension
14 {
15 /**
16 * @jc:sql statement::
17 * INSERT INTO po_customers (orderid, customerid)
18 * VALUES ({poNumber}, {customerID})::
19 */
20 void insertItemCustomer(int poNumber, int customerID);
21
22 /**
23 * @jc:sql statement::
24 * INSERT INTO po_items (orderid, itemnumber, quantity)
25 * VALUES ({poNumber}, {itemNumber}, {quantity})::
26 */
27 void insertPOItem(int poNumber, int itemNumber, int quantity);
28
29 /**
30 * @jc:sql statement="SELECT quantityAvailable FROM items WHERE itemNumber = {itemNumber}"
31 */
32 int checkInventory(int itemNumber);
33 }
|