ItemsDatabaseControl.jcx Sample

This topic inludes the source code for the ItemsDatabaseControl.jcx Sample.

Sample Location

This sample is located in the following directory in your WebLogic Workshop installation:

BEA_HOME/weblogic81/samples/workshop/SamplesApp/WebServices/localControls/tags/

Sample Source Code


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 }