7. Double click the Alias that you created (MySampleAlias in
this article). A pop-up will appear and present the data (Figure
5) per your configuration. Type in your password. Click OK.
Figure 5.
8. Now you will face a window (Figure 6) that represents the
configured database. On the left-hand pane, you can access the
database of your interest, view the tables in the database, the
schema of the tables and the contents of the tables.
Figure 6.
To execute SQL queries, select the SQL tab, enter your query,
select the query and click on the running- man icon. You will
see the results of your SQL statement in the resulting pane
(illustrated in Figure 7).
Figure 7.
Conclusion:
SQuirrel is a productivity enhancer applicable to most popular
databases. The configuration process, however, varies from
database to database. This article details pertinent information
with regard to MySQL. This is the first in a series that will
provide nuggets of information (for Java/J2EE developers)
currently unavailable on the Net.
Preeti Iyer is
currently a Senior Java/J2EE consultant for DHL. She is
experienced in building standalone, web, and distributed high-
throughput mission critical applications using open-source and
proprietary tools.
New on the Java Boutique:
New Review:
Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling
API boasts simplicity, ease-of-integration, a well-rounded feature
set, and it's free!
New Applet:
Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA
sequences into three useful formats.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.
