[news.eclipse.tools.jdt] how to make a query with HSQL

[waves@xxxxxx (Dominik)]

I am not sure if I am in the right group here but I could not find another 
one which fitted better.

I want to call a sql query in my javacode on a HSQL database.
this code creates the hsql database in a flat file on the HD:

Class.forName("org.hsqldb.jdbcDriver");
       Connection c = 
DriverManager.getConnection("jdbc:hsqldb:file:E-Nature/ArchiveDB", "sa", 
"");

I could not find out how to call a query. can someone post an example code 
please?

any help is greatly appreciated.

dominik