Oracle XSQL combining sql oracle text xslt and java to publish dynamic web content phần 8

Tài liệu tham khảo về công nghệ thông tin dành cơ sở dữ liệu máy tính cho các bạn ngành tin học tham khảo. Bạn khai báo này bằng cách sử dụng sau đây ở trên cùng của tài liệu của bạn: | 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 .