CustomerDBControl.jcx Sample
This topic inludes the source code for the CustomerDBControl.jcx Sample.
Sample Location
This sample is located in the following directory in your WebLogic Workshop installation:
BEA_HOME/weblogic81/samples/workshop/ExtensionDevKit/ControlDevKit/ControlFeatures/propEditor/
Sample Source Code
01 package propEditor;
02
03 import com.bea.control.*;
04 import java.sql.SQLException;
05 import java.sql.ResultSet;
06
07 /**
08 * @jc:connection data-source-jndi-name="cgSampleDataSource"
09 * @jcs:jc-jar display-in-palette="false"
10 */
11 public interface CustomerDBControl extends com.bea.control.ControlExtension, DatabaseControl
12 {
13 /**
14 * @jc:sql statement="SELECT customername FROM customers WHERE customerid={customerID}"
15 */
16 String selectCustomerName(int customerID);
17
18 /**
19 * @jc:sql statement="SELECT itemnumber FROM po_items WHERE orderid={orderID}" array-max-length="100"
20 */
21 ResultSet selectItemNumbersByOrder(int orderID);
22
23 /**
24 * @jc:sql statement="SELECT itemname FROM items WHERE itemnumber={itemNumber}" array-max-length="100"
25 */
26 ResultSet selectItemNameByItemNumber(int itemNumber);
27
28 /**
29 * @jc:sql statement="SELECT orderid FROM po_customers WHERE customerid={customerID}" array-max-length="100"
30 */
31 ResultSet selectOrdersByCustomer(int customerID);
32 }
|