/*
 * DBTest.java
 *
 * Author: Wael Abouelsaadat
 * Email:  t2aboels@cdf.toronto.edu
 * Course: CSC309
 * 
 * This program demonstrated a simple and naive way
 * to check that the database is working fine.
 *
 */
 


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

public class DBTest 
{ 

  /** Creates new DB class */
  public DBTest(  )
  {
  }
    
  
  public void test( )
  {
    Connection con;
    String     strDriver,
               strURL,
               strUserName,
               strPassword;
    
    try 
    { 
      strDriver = "com.pointbase.jdbc.jdbcUniversalDriver";
      Class.forName( strDriver ).newInstance( );

      strURL      = "jdbc:pointbase:embedded:sample";  
      strUserName = "public";  // default username
      strPassword = "public";  // defualt password
      con         = DriverManager.getConnection( strURL, strUserName, strPassword );
      Statement stmt = con.createStatement();
      String query="select tablename from systables";
      System.out.println(query);

      ResultSet rs = stmt.executeQuery(query);

      while(rs.next())
	System.out.println( rs.getString( "TABLENAME" ) );

      rs.close();
      stmt.close();
      con.close(); 
    }
    catch( Exception exp )
    {
      exp.printStackTrace( ); 
    }
  } 

   public static void main( String strarrArgs[] )
   {
      try
      {
         DBTest dbTest;

         dbTest = new DBTest( );
         dbTest.test( );
      }
      catch( Throwable thr )
      {
         thr.printStackTrace( );
      }
   }

     
  /* protected attributes */
  
}