<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Using HSQLDB for Zaurus</title> </head> <body bgcolor=#FFFFFF> <pre> <a href="index.html">Index</a></pre> <a name=top></a> <font face="Arial, Helvetica" size="2"> <table border=0 cellspacing=10 cellpadding=0 > <tr> <td valign=CENTER> <img src="images/hsqldb.gif"></td> <td><h2><font face="Arial">Using HSQL Database Manager for Sharp </font></h2></td> <td align=CENTER><img src="images/zaurus.jpeg"></td> </tr> </table> <hr> <p>The main functions of the HSQL DatabaseManager for Zaurus are</p> <ul> <li><a href=#starting>Starting HSQLDB.</a> <li><a href=#connecting>Connecting to a database.</a> <li><a href=#executing>Executing scripts.</a> </ul> <p>There are four different panels which may be chosen from the 'View' menu or with one of the four buttons under the menu:</p> <ol> <li><a href=#tree><img src=images/treeBut.png alt=Tree panel border=0></a> <li><a href=#command><img src=images/commandBut.png alt=Command panel border=0></a> <li><a href=#result><img src=images/resultBut.png alt=Result panel border=0></a> <li><a href=#editor><img src=images/editorBut.png alt=Editor panel border=0></a> </ol> <hr> <h3><a name=starting><font face=Arial>Starting HSQLDB.</font></a> <a href=#top><img src=images/red_up.gif border=0></a> </h3> <p>HSQLDB for Zaurus is started with the appropriate icon , usally located under the Jeode tab. By default, a database called 'test' is opened and the tables in this database are displayed in the <a href=#tree>tree panel.</a></p> <p>To get an impression of the functionalty, insert some test data by selecting the appropriate point in the 'Options' menu.</p> <h3><a name=connecting><font face=Arial>Connecting to a database</font></a> <a href=#top><img src=images/red_up.gif border=0></a> </h3> <p>To open a different database, select 'Connect' from the 'File' menu. Select 'HSQL Standalone' as type, and replace the database name 'test' in the URL with a different name.</p> <p>If you want to use a different database system (usually on your desktop) you need the appropriate JDBC driver for that system.</p> <h3><a name=executing><font face=Arial>Executing scripts</font></a> <a href=#top><img src=images/red_up.gif border=0></a> </h3> <p>You may save and open scripts with the appropriate functions in the 'File' menu. A script consists of one or more valid SQL statements. For example, you may save often-used SQL queries on your tables. If a script is opened, it is shown in the <a href=#command>command panel</a> and can be executed from there.</p> <h3><a name=tree><font face=Arial>Tree panel</font></a> <a href=#top><img src=images/red_up.gif border=0></a> </h3> <p>The tree panel shows all the tables in the connected database. Use the plus signs to expand the tree. For each table there is a list of the columns with their data type.</p> <h3><a name=command><font face="Arial">Command panel</font></a> <a href=#top><img src=images/red_up.gif border=0></a></h3> <p>The command panel is used to edit any SQL statement. Use 'Save Script' in the 'File' menu to save the SQL statement.</p> <p>The SQL command is executed by clicking on the 'Execute' button at the bottom of the command panel, or by pressing Shift+Enter or Ctrl+Enter. The result is shown in the result panel.</p> <p>Any executed SQL statement may be re-loaded to the command panel by selecting from the 'Recent' menu.</p> <h3><a name=result><font face="Arial">Result panel</font></a> <a href=#top><img src=images/red_up.gif border=0></a></h3> <p>The result of an executed SQL statement is shown in the result panel. In the 'View' menu, you can choose between a text view or a grid view of the result rows.</p> <p>If you select an SQL statement from the 'SQL' menu, the keyword is pasted into the command panel and the syntax of that SQL statement is shown in the result panel.</p> <h3><a name=editor><font face="Arial">Editor panel</font></a> <a href=#top><img src=images/red_up.gif border=0></a></h3> <p>The editor shows different forms:</p> <ul> <li>a search form <li>an entry form for every table in the database </ul> <h4>Search form</h4> <p>The editor comes up with a search form where you can select</p> <ul> <li>the table that should be searched through, <li>one or more words (or numbers) that should be searched for, <li>whether the rows that are searched contain all or just one search word, <li>whether the case of the search word should be respected, <li>whether the search words can be a part of a column or should match the whole column. </ul> <p>When clicking on the 'Search Rows' button, all rows of the chosen table that meet the search criteria are identified and the first row is shown in a table form.</p> <p>When clicking on the 'Insert New Row' button, an empty table form is shown and one may type a new row for the selected table.</p> <h4>Table form</h4> <p>For each table <b>that has a primary key</b> in the database there is a specific table form which shows the column names to the left and entry fields to the right.</p> <p>For each reference to another table, a choice field is generated which holds the values of all the rows of the referenced table.</p> <p>The entry fields for columns that belong to the primary key of the table are not editable. If you want to update a part of the primary key, you have to delete the row and insert a new row.</p> <hr> <address><a href="mailto:hsqldb@ulrivo.de">Ulrich Vollert</a></address> <!-- Created: Mon Oct 7 11:31:16 CEST 2002 --> </html>