WDBC Applet Page (requires Java2 PlugIn)

Installation and Release Notes (not required for on-line demo) Help Documentation

WebDataKit Assistant Applet

If you have the JavaTM Plugin installed, the Applet will appear shortly in a separate window. Please read these instructions, and when you've tried it out you can find out more at WebDataKit Information.

Configuration

The Applet is designed to use internet sites as the data sources for SQL queries. In order to allow connections to the sites used in the examples you must make the following changes:

Launch the Java^TM Plugin Properties Dialog (from the Control Panel if you're using Windows) and type into the Java Runtime Parameters box:

-Djava.security.manager -Djava.security.policy=http://www.btinternet.com/~lotontech/wdbc/jwebdata.policy

Plug-in Dialog

Re-start your browser and return to this page. If you're worried about the content of the jwebdata.policy file, take a look at it here .

Examples

Before trying out these examples please read the Important Copyright Notice at the foot of this page.

Copy and paste the SQL text for each example into the SQL Statement area exactly as shown and then press the Run button. You can experiment by changing the text shown in blue within each statement.

Share Prices from on-line HTML Page

SELECT .table[0].tr[0].td[3].form[0].table[0].tr[0].td[0].text[0] AS symbol, .table[0].tr[0].td[3].form[0].table[1].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[1].td[1].text[0] AS price, .table[0].tr[0].td[3].form[0].table[1].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[10].td[1].text[0] AS yearHigh, .table[0].tr[0].td[3].form[0].table[1].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[0].td[0].table[0].tr[11].td[1].text[0] AS yearLow FROM http://mwprices.ft.com/custom/ft-com/quotechartnews.asp WITHPOST ftsite=FTMW&symb=UK:SGC WITHPOST ftsite=FTMW&symb=UK:MKS WITHPOST ftsite=FTMW&symb=UK:TWT WITHPOST ftsite=FTMW&symb=UK:THUS

Share Example

List of Feature Articles from LOTONtech Web Site

SELECT .table[0].tr[0].td[1].table[0].tr[0].td[0].text[*] AS title FROM http://www.btinternet.com/~lotontech/writing.html WHERE title MATCHES '* 2000' OR title MATCHES '* 2001' OR title MATCHES '* 2002'

Feature Articles Example

Top Ten Books using SQL JOIN

SELECT javabooks.table[1].tr[0].td[1].table[1].tr[1].td[0].table[0].tr[*].td[0].a[0].text[0] AS javabooks.title , javabooks.table[1].tr[0].td[1].table[1].tr[1].td[0].table[0].tr[*].td[1].text[0] AS javabooks.author , javabooks.table[1].tr[0].td[1].table[1].tr[1].td[0].table[0].tr[*].td[2].text[0] AS javabooks.isbn topten.table[1].tr[0].td[2].table[0].tr[8].td[0].table[0].tr[*].td[1].a[0].text[0] AS topten.title FROM http://www.wrox.com/Books/books.asp?sub_section=1&subject_id=13&subject=Java AS javabooks , http://www.wrox.com AS topten WHERE topten.title=javabooks.title

Top Ten Example

Meta Data Selection

SELECT ._key[*] AS key, ._content[*] AS content FROM http://www.btinternet.com/~lotontech/index.html

XML Example (cannot be run from the web site)

SELECT .PLAY[0].ACT[0].SCENE[0].TITLE[0].#pcdata[0] AS scene , .PLAY[0].ACT[0].SCENE[0].SPEECH[*].SPEAKER[0000].#pcdata[0] AS speaker , .PLAY[0].ACT[0].SCENE[0].SPEECH[*].LINE[*].#pcdata[0] AS line FROM http://www.btinternet.com/~lotontech/wdbc/data/xml/two_gent.xml

Help

For help documentation click here then press your browser's the "back" button return to this page. You can find installation instructions for this release, along with a list of new features, in the release history .

Important Notice about Copyright

The WebDataKit Assistant and the SQL Engine allow you to view (as you would with a browser) and search (as you would with a search engine) information that is publicly available via the Internet. Please note that your further use of any extracted information - for example storage, distribution, publication on your site - may be restricted by the copyright holder. LOTONtech Limited does not encourage copyright infringement and responsibility for compliance resides solely with the user(s) of these tools. In no event shall LOTONtech Limited be liable. Where example SQL queries have been provided this does not represent an endorsement of the information provided by the relevant sites nor a guarantee of accuracy. The user applies these demonstration queries for his or her own legal private use.

Disclaimer

This software is provided by LOTONtech Limited "as is" and any express or implied warranties including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall LOTONtech Limited be liable for any direct, indirect, incidental, special, exemplary, or consequential damages however caused and on any theory whether in contract, strict liability or tort (including negligence or otherwise) arising in any way out of the use of this software, even if advised of the possibility of such damage. All software and documentation is (C)opyright LOTONtech Limited 2000-2002. All Rights Reserved.

back to WebDataKit Information