Package net.simplace.sim.io.interfaces

Class DatabaseInterface

java.lang.Object

net.simplace.sim.io.interfaces.FWSimInterface<Connection>

net.simplace.sim.io.interfaces.DatabaseInterface

Direct Known Subclasses:

DBFInterface

public class DatabaseInterface
extends FWSimInterface<Connection>

implementation of the FWSimInterface using ConnectionPool giving access to resources from and output to Databases use by FWSimInterface.getInterface(FWSimVarMap, CONTENT_TYPE).createStatement(); Make sure to free connections after use by calling ConnectionPoolManager#getInstance#freeConnection(Connection)

Author:

Andreas Enders

Nested Class Summary

Nested classes/interfaces inherited from class net.simplace.sim.io.interfaces.FWSimInterface

FWSimInterface.INTERFACE_TYPE

Field Summary

Fields

Modifier and Type	Field	Description
protected String	iAlias
protected String	iDriver
protected String	iPass
protected String	iURL
protected String	iUser

Fields inherited from class net.simplace.sim.io.interfaces.FWSimInterface

iColumnMap, iColumnNamesInt, iIntColumnNames

Constructor Summary

Constructors

Modifier	Constructor	Description
	DatabaseInterface(String aName)
	DatabaseInterface(String aName, String aDriver, String aURL, String aPass, String aUser)
protected	DatabaseInterface(String aName, FWSimInterface.INTERFACE_TYPE aInterfaceType, int aPoolSize)	Constructor has to be called from implementing interfaces
protected	DatabaseInterface(String aName, FWSimInterface.INTERFACE_TYPE aInterfaceType, org.jdom2.Element aInterfaceElement)	Constructor has to be called from implementing interfaces
protected	DatabaseInterface(String aName, org.jdom2.Element aInterfaceElement)

Method Summary

Modifier and Type	Method	Description
void	finalize()
String	getDriver()
Connection	getInterface(FWSimVarMap aVarMap, FWSimVariable.CONTENT_TYPE aContentType)
String	getPass()
String	getURL()
String	getUser()
static PreparedStatement	prepareDatabase(String aTableName, HashMap<String,FWSimVariable<?>> aHeaderVariables, Connection aConnection, boolean isArrayMode)	Used to create a prepared statement using the driver information and the connection.
FWSimResourceCache	read(FWSimSession aFwSimSession, String aProjectID, Object aCache, LinkedHashMap<String,String> aKeyMap, FWSimInputAdapter aResourceAdapter, String aUniqueID, FWSimInterface.INTERFACE_TYPE aInterfaceType)	factory method creating an interface instance concerning the given data type
void	setDriver(String aDriver)
void	setPass(String aPass)
void	setURL(String aURL)
void	setUser(String aUser)
org.jdom2.Element	toXML()

Methods inherited from class net.simplace.sim.io.interfaces.FWSimInterface

checkHeaderForColMode, createInterface, createInterface, createStatisticInterface, getInterfaceType, getName, getPoolSize, readColArray, toString, transformArrays, writeToDatabase

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

iDriver

protected String iDriver

iURL

protected String iURL

iPass

protected String iPass

iUser

protected String iUser

iAlias

protected String iAlias

Constructor Details

DatabaseInterface

protected DatabaseInterface(String aName,
 FWSimInterface.INTERFACE_TYPE aInterfaceType,
 int aPoolSize)

Constructor has to be called from implementing interfaces

Parameters:

aName -

aInterfaceType -

aPoolSize -

DatabaseInterface

protected DatabaseInterface(String aName,
 FWSimInterface.INTERFACE_TYPE aInterfaceType,
 org.jdom2.Element aInterfaceElement)

Constructor has to be called from implementing interfaces

Parameters:

aName -

aInterfaceType -

aInterfaceElement -

DatabaseInterface

protected DatabaseInterface(String aName,
 org.jdom2.Element aInterfaceElement)

Parameters:

aName -

aPoolSize -

aInterfaceElement -

DatabaseInterface

public DatabaseInterface(String aName,
 String aDriver,
 String aURL,
 String aPass,
 String aUser)

Parameters:

aName -

aDriver -

aURL -

aPass -

aUser -

DatabaseInterface

public DatabaseInterface(String aName)

Parameters:

aName -

Method Details

getInterface

public Connection getInterface(FWSimVarMap aVarMap,
 FWSimVariable.CONTENT_TYPE aContentType)

Specified by:

getInterface in class FWSimInterface<Connection>

Returns:

generic interface connection object. for example: database - connection; xml - fileinfo

See Also:

• FWSimInterface.getInterface(FWSimVarMap, CONTENT_TYPE)

prepareDatabase

public static PreparedStatement prepareDatabase(String aTableName,
 HashMap<String,FWSimVariable<?>> aHeaderVariables,
 Connection aConnection,
 boolean isArrayMode)
                                         throws SQLException

Used to create a prepared statement using the driver information and the connection.

Parameters:

aTableName -

aHeaderVariables -

aConnection -

isArrayMode -

Returns:

the prepared statement

Throws:

SQLException

read

public FWSimResourceCache read(FWSimSession aFwSimSession,
 String aProjectID,
 Object aCache,
 LinkedHashMap<String,String> aKeyMap,
 FWSimInputAdapter aResourceAdapter,
 String aUniqueID,
 FWSimInterface.INTERFACE_TYPE aInterfaceType)
                        throws MissingSimResourceException

Description copied from class: FWSimInterface

factory method creating an interface instance concerning the given data type

Specified by:

read in class FWSimInterface<Connection>

Returns:

generic FWSimResourceCache

Throws:

MissingSimResourceException

getDriver

public String getDriver()

Returns:

the driver

setDriver

public void setDriver(String aDriver)

Parameters:

aDriver - the driver to set

getURL

public String getURL()

Returns:

the uRL

setURL

public void setURL(String aURL)

Parameters:

aURL - the uRL to set

getPass

public String getPass()

Returns:

the pass

setPass

public void setPass(String aPass)

Parameters:

aPass - the pass to set

getUser

public String getUser()

Returns:

the user

setUser

public void setUser(String aUser)

Parameters:

aUser - the user to set

toXML

public org.jdom2.Element toXML()

Overrides:

toXML in class FWSimInterface<Connection>

Returns:

Element containing configuration for this Interface

finalize

public void finalize()
              throws Exception

Specified by:

finalize in class FWSimInterface<Connection>

Throws:

Exception

See Also:

• FWSimInterface.finalize()