Java/Database SQL JDBC/Cloudscape

Connect to cloudscape

   <source lang="java">

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; public class MainClass{

 public MainClass() {
   try {
     Class.forName("COM.cloudscape.core.RmiJdbcDriver");
     Connection connection = DriverManager.getConnection("jdbc:cloudscape:rmi:books");
     Statement statement = connection.createStatement();
     ResultSet resultSet = statement.executeQuery("SELECT * FROM authors");
     ResultSetMetaData metaData = resultSet.getMetaData();
     int numberOfColumns = metaData.getColumnCount();
     for (int i = 1; i <= numberOfColumns; i++) {
       System.out.println(metaData.getColumnName(i) + "\t");
     }
     while (resultSet.next()) {
       for (int i = 1; i <= numberOfColumns; i++) {
         System.out.println(resultSet.getObject(i) + "\t");
       }
       System.out.println("\n");
     }
     statement.close();
     connection.close();
   } catch (SQLException sqlException) {
     System.out.println(sqlException.getMessage());
   } catch (ClassNotFoundException classNotFound) {
     System.out.println( "Driver Not Found");
     System.exit(1);
   }
 }
 public static void main(String args[]) {
   new MainClass();
 }

}

      </source>