generalDatabase

Class MSAccessSystem

java.lang.Object

generalDatabase.DBSystem

generalDatabase.BaseAccessSystem

generalDatabase.MSAccessSystem

All Implemented Interfaces:

PamSettings

public class MSAccessSystem
extends BaseAccessSystem
implements PamSettings

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SYSTEMNAME

Constructor Summary

Constructors

Constructor and Description
MSAccessSystem(DBControl dbControl, int settingsStore)

Method Summary

Methods

Modifier and Type	Method and Description
boolean	canOpenDatabase() find out if it's possible to open the current databse with a host application (e.g.
PamCursor	createPamCursor(EmptyTableDefinition tableDefinition)
static java.sql.Connection	getACCDBConnection(java.lang.String dbName)
java.lang.String	getDatabaseName()
SystemDialogPanel	getDialogPanel(java.awt.Component parent) Get a database specific dialog panel to include in the database select dialog.
java.lang.String	getKeywords() Get a list of keywords which potentially may not be used for column names in an SQL statement.
static java.sql.Connection	getMDBConnection(java.lang.String dbName)
java.util.ArrayList<java.io.File>	getRecentDatabases()
java.io.Serializable	getSettingsReference()
long	getSettingsVersion()
java.lang.String	getShortDatabaseName() Get a shorter version of the currently open database name (e.g.
SQLTypes	getSqlTypes() Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.
java.lang.String	getUnitName()
java.lang.String	getUnitType()
boolean	hasDriver()
boolean	openCurrentDatabase() Open the database with it's host application if available (e.g.
boolean	restoreSettings(PamControlledUnitSettings pamControlledUnitSettings)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SYSTEMNAME

public static final java.lang.String SYSTEMNAME

See Also:

Constant Field Values

Constructor Detail

MSAccessSystem

public MSAccessSystem(DBControl dbControl,
              int settingsStore)

Method Detail

getRecentDatabases

public java.util.ArrayList<java.io.File> getRecentDatabases()

Specified by:

getRecentDatabases in class BaseAccessSystem

Returns:

the recentDatabases

createPamCursor

public PamCursor createPamCursor(EmptyTableDefinition tableDefinition)

Specified by:

createPamCursor in class DBSystem

getMDBConnection

public static java.sql.Connection getMDBConnection(java.lang.String dbName)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

getACCDBConnection

public static java.sql.Connection getACCDBConnection(java.lang.String dbName)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

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 java.lang.String getDatabaseName()

Returns:

the name of the currently open database.

getShortDatabaseName

public java.lang.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(java.awt.Component parent)

Description copied from class: DBSystem

Get a database specific dialog panel to include in the database select dialog.

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:

getUnitName

public java.lang.String getUnitName()

Specified by:

getUnitName in interface PamSettings

Returns:

A Name specific to this instance of the particular class, e.g. Sperm whale detector, Beaked whale detector, etc.

getUnitType

public java.lang.String getUnitType()

Specified by:

getUnitType in interface PamSettings

Returns:

A Name specific to the type, e.g. Glick detector

getSettingsReference

public java.io.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 java.lang.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 possibe.

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.