SelectTest.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SelectTest {
	public static void main(String[] args) {
		
		try 
		{
			System.out.println("");
			DriverManager.registerDriver(new org.hsqldb.jdbc.JDBCDriver());
			System.out.println("driver registered");
			
			Connection con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/xdb", "SA", "");
			Statement statement = con.createStatement();
			System.out.println("statement created");
			
			ResultSet rs = statement.executeQuery("select * from employee");
			
			while(rs.next())
			{
				System.out.println("Emp no: "+rs.getInt(1));
				System.out.println("Emp name: "+rs.getString(2));
				System.out.println("Emp salary: "+rs.getInt(3));
				System.out.println("----------------------");
			}
			rs.close();
			statement.close();
			con.close();
			
		} 
		catch (SQLException e) 
		{
		
			e.printStackTrace();
		}
		
	}
}