1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
<!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>
|
