com.sdb.filework

Class ExecuteFileData

java.lang.Object

com.sdb.filework.ExecuteFileData

public class ExecuteFileData
extends java.lang.Object

This class is useful to automate blob and clob data with DB.

Field Summary

Fields

Modifier and Type	Field and Description
static int	BLOB
static int	CLOB

Constructor Summary

Constructors

Constructor and Description
ExecuteFileData(RunDB runDB, java.lang.String[] tableNames, java.lang.String keyField, java.lang.String fileField, java.lang.String[] unqFields, int[] unqFieldTypes, int fileDataType) The basic variables of the constructor include database, table and file information.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getErrorString() For getting errorString
java.io.InputStream	getInpStream() For getting inpStream
java.lang.String	getMessageScript() For getting messageScript
java.io.Reader	getReader() For getting reader
java.lang.String	getResultMessage()
java.lang.Object[][]	getTableData() For getting tableData
void	setInpStream(java.io.InputStream inpStream) For setting inpStream
void	setKeyData(java.lang.String keyData) For setting keyData
void	setReader(java.io.Reader reader) For setting reader
void	setUnqFieldData(java.lang.String[] unqFieldData) For setting unqFieldData
boolean	tableAction(java.lang.String action, boolean isKey) This method call recordFileToDB class and methods for retrieving and recording file data.

Methods inherited from class java.lang.Object

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

Field Detail

BLOB

public static final int BLOB

See Also:

Constant Field Values

CLOB

public static final int CLOB

See Also:

Constant Field Values

Constructor Detail

ExecuteFileData

public ExecuteFileData(RunDB runDB,
                       java.lang.String[] tableNames,
                       java.lang.String keyField,
                       java.lang.String fileField,
                       java.lang.String[] unqFields,
                       int[] unqFieldTypes,
                       int fileDataType)

The basic variables of the constructor include database, table and file information.
In this way, the connection between the database and file is established and transactions are automated.

Parameters:

runDB - for connecting the database and executing processes.

tableNames - The table name to be accessed.

keyField - The key field name of the table to access

fileField - The name of file field of the table to access.

unqFields - Unique fields string array.

unqFieldTypes - Unique field types integer array.

fileDataType - File data type integer representation.

Method Detail

tableAction

public boolean tableAction(java.lang.String action,
                           boolean isKey)
                    throws java.io.IOException

This method call recordFileToDB class and methods for retrieving and recording file data.
Before calling this method, key or unique data and reader or inputStream must be set.

Parameters:

action - String representation of form action. It can be insert, update, delete or download.

isKey - Boolean representation of if key is exist.

Returns:

If process is ok it will return true, else return false.

Throws:

java.io.IOException

getInpStream

public java.io.InputStream getInpStream()

For getting inpStream

Returns:

inpStream

getReader

public java.io.Reader getReader()

For getting reader

Returns:

reader

getTableData

public java.lang.Object[][] getTableData()

For getting tableData

Returns:

tableData

getErrorString

public java.lang.String getErrorString()

For getting errorString

Returns:

errorString

setInpStream

public void setInpStream(java.io.InputStream inpStream)

For setting inpStream

Parameters:

inpStream -

setReader

public void setReader(java.io.Reader reader)

For setting reader

Parameters:

reader -

setKeyData

public void setKeyData(java.lang.String keyData)

For setting keyData

Parameters:

keyData -

setUnqFieldData

public void setUnqFieldData(java.lang.String[] unqFieldData)

For setting unqFieldData

Parameters:

unqFieldData -

getMessageScript

public java.lang.String getMessageScript()

For getting messageScript

Returns:

messageScript

getResultMessage

public java.lang.String getResultMessage()