eu.bootstrep.Beans
Class MainBean

java.lang.Object
  eu.bootstrep.Beans.MainBean

public class MainBean
extends java.lang.Object

This class manages global variables. Managed variables are the following:

• STR_LOAD The SQL load instruction
• STR_TERM The SQL rule to manage field termination. These two variables manage the SQL load intruction. The SQL load instruction "LOAD DATA LOCAL INFILE FILE INTO TABLE TAB> FIELDS TERMINATED BY ',' ENCLOSED BY '\"' (COL1..COLN)" is built by using the STR_LOAD and STR_TERM variables. Details on table, columns and file are retrieved from the dictionary frame.
• conn The connection to database. conn is persistent. This means that the connection is established when the software starts and is closed when the software ends. Each database accessing method uses this connection
• data2Write The link between one table and its input file. This hashtable contains input files as keys and lists of values as objects. The link between files and tables is straightforward: the name of input files for target frame tables is the name of the corresponding table. This object is used both to create the SQL load intruction (table and file name) and to write data onto input files
• isConnected True when conn is established
• ps The PrintStream used to write down log files. By default this value is System.out
• sep The file/folder separator, accordingly to operating system
• xmlFileExixts True when the XIF file exists

This bean is instantiated in the

• Process

class

Field Summary

(package private) java.sql.Connection	conn The persistent connection.
(package private) java.util.Hashtable	data2Write hashtable containing files and data to load.
(package private) java.lang.Boolean	isConnected Boolean: true if the connection is available.
(package private) java.io.PrintStream	ps The printStream.
(package private) java.lang.String	sep The separator string.
(package private) java.lang.String	STR_LOAD The load instruction.
(package private) java.lang.String	STR_TERM LOAD instruction: file termination contraints.
(package private) java.lang.Boolean	xmlfileExist Boolean: true if the input file exists.

Constructor Summary

MainBean()
Creates a new instance of MainBean

Method Summary

java.sql.Connection	getConn() get the connection.
java.util.Hashtable	getData2Write() This method gets the data2Write object
java.lang.Boolean	getIsConnected() get if the system is connected
java.io.PrintStream	getPs() get the PrintStream
java.lang.String	getSep() This method gets the platform separator.
java.lang.String	getSTR_LOAD() This method gets the STR_LOAD string
java.lang.String	getSTR_TERM() This method gets the STR_TERM string
java.lang.Boolean	getXmlfileExist() get if the XML XIF input file exists..
void	setConn(java.sql.Connection conn) set the connection to a not null value.
void	setData2Write(java.util.Hashtable data2Write) This method sets the data2Write object
void	setIsConnected(java.lang.Boolean isConnected) set the isConnected value to true or false
void	setPs(java.io.PrintStream ps) set The printStream either to System.out or to an a file
void	setSep(java.lang.String Lsep) This method gets the platform separator.
void	setSTR_LOAD(java.lang.String str_load) This method sets the STR_LOAD string
void	setSTR_TERM(java.lang.String str_term) This method sets the STR_TERM string
void	setXmlfileExist(java.lang.Boolean xmlfileExist) set this variable to true or false.

Methods inherited from class java.lang.Object

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

Field Detail

STR_LOAD

java.lang.String STR_LOAD

The load instruction. This variable along with its get&set methods is used in:

• Process

STR_TERM

java.lang.String STR_TERM

LOAD instruction: file termination contraints. This variable along with its get&set methods is used in:

• Process

sep

java.lang.String sep

The separator string. This variable along its get&set methods is used in:

• GeneralMethods
• Platform
• Process

conn

java.sql.Connection conn

The persistent connection. This variable along with its get&set methods is used in

• DbMethods
• GeneralMethods
• WorkDictionary
• Process

ps

java.io.PrintStream ps

The printStream. By default it is the System.out.
This variable along with its get&set methods is used in

• DbMethods
• GeneralMethods
• WorkDictionary
• Process
• IOMethods
• iniETL
• ManageJdom

isConnected

java.lang.Boolean isConnected

Boolean: true if the connection is available. This variable along with its get& set methods is used in:

• Process

xmlfileExist

java.lang.Boolean xmlfileExist

Boolean: true if the input file exists. This variable along with its get& set methods is used in:

• Process

data2Write

java.util.Hashtable data2Write

hashtable containing files and data to load. This hashTable has the file names as key, and the list of values as objects. Lists of values are passed to the writeInputFiles method.
Used in

• IOMethods
• GeneralMethods
• iniETL
• ManageJdom
• Process

Constructor Detail

MainBean

public MainBean()

Creates a new instance of MainBean

Method Detail

getConn

public java.sql.Connection getConn()

get the connection. The value is null if no connection is available

Returns:

the conn, null if no connection is available.

setConn

public void setConn(java.sql.Connection conn)

set the connection to a not null value.

Parameters:

conn - the conn to set

getPs

public java.io.PrintStream getPs()

get the PrintStream

Returns:

the ps

setPs

public void setPs(java.io.PrintStream ps)

set The printStream either to System.out or to an a file

Parameters:

ps - the ps to set

getIsConnected

public java.lang.Boolean getIsConnected()

get if the system is connected

Returns:

isConnected. True if the system is connected to the database.

setIsConnected

public void setIsConnected(java.lang.Boolean isConnected)

set the isConnected value to true or false

Parameters:

isConnected - the isConnected to set

getXmlfileExist

public java.lang.Boolean getXmlfileExist()

get if the XML XIF input file exists..

Returns:

the xmlfileExist

setXmlfileExist

public void setXmlfileExist(java.lang.Boolean xmlfileExist)

set this variable to true or false.
This variable, together with the isConnected, allows for starting the process.

Parameters:

xmlfileExist - the xmlfileExist to set

getData2Write

public java.util.Hashtable getData2Write()

This method gets the data2Write object

Returns:

the data2Write

setData2Write

public void setData2Write(java.util.Hashtable data2Write)

This method sets the data2Write object

Parameters:

data2Write - the data2Write to set

getSTR_LOAD

public java.lang.String getSTR_LOAD()

This method gets the STR_LOAD string

Returns:

the sTR_LOAD

setSTR_LOAD

public void setSTR_LOAD(java.lang.String str_load)

This method sets the STR_LOAD string

Parameters:

str_load - the sTR_LOAD to set

getSTR_TERM

public java.lang.String getSTR_TERM()

This method gets the STR_TERM string

Returns:

the sTR_TERM

setSTR_TERM

public void setSTR_TERM(java.lang.String str_term)

This method sets the STR_TERM string

Parameters:

str_term - the sTR_TERM to set

getSep

public java.lang.String getSep()

This method gets the platform separator. Used to manage multi platform.

Returns:

the separator

setSep

public void setSep(java.lang.String Lsep)

This method gets the platform separator. Used to manage multi platform.

Parameters:

Lsep - The separator to set