Package generalDatabase

Class MSAccessSystem

java.lang.Object
generalDatabase.DBSystem
generalDatabase.BaseAccessSystem
generalDatabase.MSAccessSystem
All Implemented Interfaces:
PamSettings, SettingsNameProvider
public class MSAccessSystem extends BaseAccessSystem implements PamSettings

  • Field Details

  • Constructor Details

    • MSAccessSystem

      public MSAccessSystem(DBControl dbControl, int settingsStore)

  • Method Details

    • getRecentDatabases

      public ArrayList<File> getRecentDatabases()
      Specified by:
      getRecentDatabases in class BaseAccessSystem
      Returns:
      the recentDatabases

    • browseDatabases

      public String browseDatabases(Component parent)
      Specified by:
      browseDatabases in class DBSystem

    • canCreate

      public boolean canCreate()
      Specified by:
      canCreate in class DBSystem
      Returns:
      true if the system can create new databases.

    • create

      public boolean create()
      Description copied from class: DBSystem
      Create a new database

      The underlying DBSystem will be responsible for any dialogs to chose database names, etc.

      Specified by:
      create in class DBSystem
      Returns:
      true if successful.

    • createPamCursor

      public PamCursor createPamCursor(EmptyTableDefinition tableDefinition)
      Specified by:
      createPamCursor in class DBSystem

    • exists

      public boolean exists()
      Specified by:
      exists in class DBSystem
      Returns:
      true if the database exists

    • getConnection

      public PamConnection getConnection(String dbName)
      Description copied from class: DBSystem
      Open new database connection with a specific name
      Specified by:
      getConnection in class DBSystem
      Returns:

    • getMDBConnection

      public static PamConnection getMDBConnection(DBSystem dbSystem, String dbName) throws Exception
      Throws:
      Exception

    • getACCDBConnection

      public static PamConnection getACCDBConnection(DBSystem dbSystem, String dbName) throws Exception
      Throws:
      Exception

    • closeConnection

      public void closeConnection(PamConnection connection)
      Description copied from class: DBSystem
      Close the database connection
      Overrides:
      closeConnection in class DBSystem

    • hasDriver

      public boolean hasDriver()
      Specified by:
      hasDriver in class DBSystem
      Returns:
      true if the driver for this database system is available on this computer. the availability of database system will depend both on the OS and whether software are installed.

    • getDatabaseName

      public String getDatabaseName()
      Specified by:
      getDatabaseName in class DBSystem
      Returns:
      the name of the currently open database.

    • getShortDatabaseName

      public String getShortDatabaseName()
      Description copied from class: DBSystem
      Get a shorter version of the currently open database name (e.g. without the file path name)
      Overrides:
      getShortDatabaseName in class DBSystem
      Returns:
      a shorter name

    • getDialogPanel

      public SystemDialogPanel getDialogPanel(Component parent)
      Description copied from class: DBSystem
      Get a database specific dialog panel to include in the database select dialog.
      Specified by:
      getDialogPanel in class DBSystem
      Parameters:
      parent - parent component
      Returns:
      dialog panel

    • getSqlTypes

      public SQLTypes getSqlTypes()
      Description copied from class: DBSystem
      Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.
      Specified by:
      getSqlTypes in class DBSystem
      Returns:

    • getSystemName

      public String getSystemName()
      Specified by:
      getSystemName in class DBSystem
      Returns:
      The name of the database system

    • getUnitName

      public String getUnitName()
      Specified by:
      getUnitName in interface SettingsNameProvider
      Returns:
      A Name specific to this instance of the particular class, e.g. Sperm whale detector, Beaked whale detector, etc.

    • getUnitType

      public String getUnitType()
      Specified by:
      getUnitType in interface PamSettings
      Returns:
      A Name specific to the type, e.g. Click detector

    • getSettingsReference

      public Serializable getSettingsReference()
      Specified by:
      getSettingsReference in interface PamSettings
      Returns:
      The serialisable object that will be stored

    • getSettingsVersion

      public long getSettingsVersion()
      Specified by:
      getSettingsVersion in interface PamSettings
      Returns:
      An integer version number for the settings

    • restoreSettings

      public boolean restoreSettings(PamControlledUnitSettings pamControlledUnitSettings)
      Specified by:
      restoreSettings in interface PamSettings
      Returns:
      true if successful The object performs final checks (if needed) and then casts the settings data pamcontrolledunitSettings.settings into the correct type and uses as required

    • getKeywords

      public String getKeywords()
      Description copied from class: DBSystem
      Get a list of keywords which potentially may not be used for column names in an SQL statement. In reality, this list is complete overkill. Override for each system and try to reduce the list as much as possible.
      Overrides:
      getKeywords in class DBSystem
      Returns:
      list of restricted keywords.

    • canOpenDatabase

      public boolean canOpenDatabase()
      Description copied from class: DBSystem
      find out if it's possible to open the current databse with a host application (e.g. MS Access).
      Overrides:
      canOpenDatabase in class DBSystem
      Returns:
      true if it's possible.

    • openCurrentDatabase

      public boolean openCurrentDatabase()
      Description copied from class: DBSystem
      Open the database with it's host application if available (e.g. open MS access database with Access).
      Overrides:
      openCurrentDatabase in class DBSystem
      Returns:
      true if opened sucessfully.

    • getDialogPaneFX

      public SystemDialogPaneFX getDialogPaneFX()
      Description copied from class: DBSystem
      Get the FX pane for the database system
      Specified by:
      getDialogPaneFX in class DBSystem
      Returns:
      the FX settings pane for the database system.

    • browseDatabasesFX

      public String browseDatabasesFX(int type)
      Description copied from class: DBSystem
      Browse for databases using an FX dialog.
      Specified by:
      browseDatabasesFX in class DBSystem
      Returns: