TAILIEUCHUNG - Oracle XSQL- P22
Oracle XSQL- P22Welcome to the exciting world of eXtended Structured Query Language (XSQL) development! What’s so exciting? Efficiency and ease of use. XSQL isn’t some razzle-dazzle technology to wow your users. It also isn’t the latest X standard du jour that no one can stop talking about until you ask, “But what does it do for me today?” The problem with all of the great stuff out there is that no one technology does it all. | 400 Chapter 14 name and price while the xsql include-owa action is used to return the XML document using the get_product_xml procedure used earlier. xml version prod-details connection momnpup xmlns xsql urn oracle-xsql xsql include-xsql href xsql query rowset-element PRODUCT-SET row-element DETAILS product_id 0 bind-params product_id SELECT id name price FROM product WHERE id xsql query xsql include-owa product_id 0 bind-params product_id get_product_xml xsql include-owa prod-details The last page for the public interface is the search results page. It uses the query developed earlier and like our other subordinate pages includes the navigational element on the left. xml version prod-search connection momnpup xmlns xsql urn oracle-xsql xsql include-xsql href xsql query rowset-element PRODUCT_SEARCH row-element PRODUCT SELECT id name product summary text .getStringVal AS summary FROM product a WHERE contains doc @search_terms 0 ORDER BY contains doc @search_terms xsql query prod-search You have three XSQL pages for the price editor interface. The first displays the necessary information in response to a lookup xml version prod-search connection momnpup xmlns xsql urn oracle-xsql xsql query rowset-element PRICE_EDITOR_SEARCH row-element PRICE_EDITOR_PRODUCT SELECT AS product_name AS product_cat_name FROM product p prod_cat_joiner pcj product_category pc WHERE AND Building XSQL Web Applications 401 AND like @terms xsql query prod-search Your second XSQL page is very similar to the product details page. The information for this page will be used to fill the values for the fields of a particular editor. xsql query connection momnpup xmlns xsql urn oracle-xsql rowset-element PRODUCT-SET row-element DETAILS product_id 0 bind-params product_id SELECT id name price FROM product WHERE id xsql query The last page to create is the page that handles .
đang nạp các trang xem trước