This section shows how to create an application that updates the database.
This
tutorial demonstrates using connection cache to sampledb when creating
database elements. An alternate approach is to use a direct JDBC connection
to sampledb, as demonstrated in “Multipage mobile application tutorial”.
Creating the update application
From Mobile Web Studio, select Applications in the left pane, select New in the Application Manager Status menu, and click New. The Application Builder launches.
Create a database element:
Click the down arrow to the right of Add, and select Database Element.
On the Database Element Definition window, make sure the Connection Cache option is selected.
In Conn Cache Name, select sampledb from
the drop-down list.
In SQL Query String, enter this query for update (you can copy and paste this code from an electronic source):
update sales_order_items set quantity = @OP["quantity"="13"]where id = @OP["id"="-1"] and prod_id = @OP["prod_id"="-1"]
This SQL code updates the database, so no preview is
available.
Click Next. The Define window displays.
Click Next. The Filter window displays.
Click Next. The Configure Parameters window displays, with a list of the parameters used to create the database table.
On the Configure Parameters window, make these modifications (accept the defaults for all others):
Quantity – click the Variable box, and from the Kind drop-down list, select Update.
Click the Variable box next to the other two parameters and accept the defaults.
Click Next. The Window Preview window displays.
In Element Name, enter updateOrder,
and click Finish.
In Application Builder, click Save.
In the Finish window, click the Data Validation tab and make these changes to set up data validation for the Quantity field:
Common Expressions – select
Number Only from the drop-down list. The expression ^[0-9]*$ displays
in the Validation Expression box.
Click Test to test the expression you entered. The Regular Expression Tester window displays.
In Test Value, enter 10,
then click Test. The Test Result field displays Valid.
Click Save to close the window.
Detailed Instructions – optionally enter
instructions for the user, such as Enter the quantity.
Error Message – optionally enter a brief error
message, such as You must enter a number.
Figure 4-1: Data validation tab
Click Finish to save the application.
Click OK in the confirmation pop-up window.
Click Close to exit the Application Builder.
When you return to the Mobile Web Studio main window, select New from the Application Builder Status menu. The updateOrder application displays in the detail pane.
In Mobile Web Studio, right-click the updateOrder application in the detail pane, and select Approval Status | Approved.
Click OK.
Select Approved from the Application Manager Status menu. You see the newly approved updateOrder application in the detail pane.
