190 likes | 338 Views
XML within Websites. Philipp Glogowski - Stefan Mohr - Julia Wenzel University of Applied Sciences FHTW Berlin. Index. 1. Introduction 2. Overview about XML 3. Website vs. PDA-View with an example 4. Conclusions. 1. Introduction. targets: dynamic web site for www PDA view
E N D
XML within Websites • Philipp Glogowski - Stefan Mohr - Julia Wenzel • University of Applied Sciences FHTW Berlin
Index • 1. Introduction • 2. Overview about XML • 3. Website vs. PDA-View with an example • 4. Conclusions
1. Introduction • targets: • dynamic web site for www • PDA view • print version (pdf-format)
2. Overview about XML (1) • Extensible Markup Language • standard for creating documents • tree structure • readible by people & machines
2. Overview about XML (2) • data exchange format • generate any other formats • universally valid language • xml ≠ programming language ≠ database
2. Overview about XML (3) Content browser.html pda.html printer.html
2. Overview about XML (4) XML- File Content one xml file that is used to generate different website versions for a desktop-pc, a pda and a printer XML-FO
3. Website vs. PDA-View • website view - general view with internet browser • pda view - mobile devices • shortened version
<?xml version="1.0" encoding="utf-8"?> <xsp:page xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" xmlns:xsp-request="http://apache.org/xsp/request/2.0" language="java"> ... <content> <esql:execute-query> <esql:query> select id, spieler, tore, spiele, gelb, 2min, rot from mis_torschuetzen </esql:query> <esql:results> <rowset> <!-- für jede einzelene Ergebniszeile --> <esql:row-results> <row> <!-- damit holt man einen bestimmten Datensatz aus der Zeile der Tabelle --> <id><esql:get-int column="id"/></id> <spieler><esql:get-string column="spieler"/></spieler> <tore><esql:get-string column="tore"/></tore> <spiele><esql:get-string column="spiele"/></spiele> <gelb><esql:get-int column="gelb"/></gelb> <min2><esql:get-int column="2min"/></min2> <rot><esql:get-int column="rot"/></rot> </row> </esql:row-results> </rowset> </esql:results> </esql:execute-query> </content> ... </xsp:page>
Header of the XML - File <?xml version="1.0" encoding="utf-8"?> <xsp:page xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" xmlns:xsp-request="http://apache.org/xsp/request/2.0" language="java"> ...
Database SQL Query <content> <esql:execute-query> <esql:query> select id, spieler, tore, spiele, gelb, 2min, rot from mis_torschuetzen </esql:query> ...
Database SQL Values <esql:results> <rowset> <esql:row-results> <row> <id><esql:get-int column="id"/></id> <spieler><esql:get-string column="spieler"/></spieler> <tore><esql:get-string column="tore"/></tore> <spiele><esql:get-string column="spiele"/></spiele> <gelb><esql:get-int column="gelb"/></gelb> <min2><esql:get-int column="2min"/></min2> <rot><esql:get-int column="rot"/></rot> </row> </esql:row-results> </rowset> </esql:results> </esql:execute-query> </content> ... </xsp:page>
4. Conclusions • one file for different devices • platform independency • quick & easy changes
Questions ??? Thank you for your attention.