# ItemsDBControl.jcx Sample

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

## Sample Location

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

BEA_HOME/weblogic81/samples/workshop/SamplesApp/WebApp/tagSamples/netui_databinding/declarePageInput/

## Sample Source Code

`01 package tagSamples.netui_databinding.declarePageInput; 02 03 import com.bea.control.*; 04 import java.sql.SQLException; 05 06 /** 07 * Defines a new database control. 08 * 09 * The @jc:connection tag indicates which WebLogic data source will be used by 10 * this database control. Please change this to suit your needs. You can see a 11 * list of available data sources by going to the WebLogic console in a browser 12 * (typically http://localhost:7001/console) and clicking Services, JDBC, 13 * Data Sources. 14 * 15 * @jc:connection data-source-jndi-name="cgDataSource" 16 */ 17 public interface ItemsDBControl extends DatabaseControl, com.bea.control.ControlExtension 18 { 19 static public class Item 20 { 21 public int itemnumber; 22 public String itemname; 23 public int quantityavailable; 24 public double price; 25 } 26 27 static final long serialVersionUID = 1L; 28 29 /** 30 * @jc:sql statement="SELECT ITEMNUMBER, ITEMNAME, QUANTITYAVAILABLE, PRICE FROM ITEMS" 31 */ 32 Item[] getAllItems() throws SQLException; 33 }`