import  java.sql.*;

 public   class  ViewQuery {
	 public  ViewQuery() {
	}

	 public   static   void  main(String[] args) {
		String p_SQL = "select t.* from test t";
		String con_classname = "org.firebirdsql.jdbc.FBDriver";
                String con_url = "jdbc:firebirdsql:localhost/3050:test";
                String username = "sysdba";
                String password = "masterkey";

         	Connection con;
		Statement statement;
		 try  {
		         Class .forName(con_classname);
   		        con = DriverManager.getConnection(con_url, username, password);
			statement = con.createStatement();

			// Get Resultset
			ResultSet resultset = statement.executeQuery(p_SQL);
			 int  field_count = resultset.getMetaData().getColumnCount();
			
			// Fetch data
			 while  (resultset.next()) {
			    System.out.print("\n");
			    // Read columns
				 for ( int  i= 0 ; i<field_count; i++) {
					Object o = resultset.getObject(i+ 1 );
					 if  (o !=  null ) 
   					    System.out.print(o.toString());
					System.out.print("\t||");
				}
			}
		}  catch  (Exception e) {
			e.printStackTrace();
		}
	}
}