# 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 }`