Class DBExamples


  • public class DBExamples
    extends java.lang.Object
    The purpose of this class is to provide a series of examples that utilize some of the functionality within the dbutil package
    • Constructor Summary

      Constructors 
      Constructor Description
      DBExamples()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static void example1()
      This example shows how to create a new database from a creation script and perform some simple operations on the database
      static void exampleDbToExcelExport()
      Shows how to make a SP database from scripts and then writes the database to an Excel workbook
      static void exampleExcelDbImport()
      Shows how to create the SP database by importing from an Excel workbook
      static DatabaseIfc exampleSPCreationFromFullScript()
      This example shows how to create a SP database from a creation script and perform a simple operation on the database.
      static void main​(java.lang.String[] args)  
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • DBExamples

        public DBExamples()
    • Method Detail

      • main

        public static void main​(java.lang.String[] args)
                         throws java.io.IOException
        Throws:
        java.io.IOException
      • example1

        public static void example1()
        This example shows how to create a new database from a creation script and perform some simple operations on the database
      • exampleDbToExcelExport

        public static void exampleDbToExcelExport()
                                           throws java.io.IOException
        Shows how to make a SP database from scripts and then writes the database to an Excel workbook
        Throws:
        java.io.IOException - an exception
      • exampleExcelDbImport

        public static void exampleExcelDbImport()
                                         throws java.io.IOException
        Shows how to create the SP database by importing from an Excel workbook
        Throws:
        java.io.IOException - the IO exception
      • exampleSPCreationFromFullScript

        public static DatabaseIfc exampleSPCreationFromFullScript()
        This example shows how to create a SP database from a creation script and perform a simple operation on the database.
        Returns:
        the created database