com.sdb.filework

Class RecordFileToDB

java.lang.Object

com.sdb.filework.RecordFileToDB

public class RecordFileToDB
extends java.lang.Object

This class is useful for retrieving and recording blob and clob data from DB.

Field Summary

Fields

Modifier and Type	Field and Description
static int	INTEGER This integer represent of data type for integer.
static int	STRING This integer represent of data type for string.

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
boolean	clearBCData() For deleting blob and clob data from DB.
void	closeAll() For calling RunDB class closeAll() method.
java.io.InputStream	getBlobData() For retrieving blob data from DB.
java.io.Reader	getClobData() For retrieving clob data from DB.
java.lang.String	getErrorString() For getting errorString
java.lang.String	getMessageScript() For getting messageScript
java.lang.String	getResultMessage() For getting resultMessage
boolean	isDebug() For getting ifDebug
boolean	recordBlobData(java.io.InputStream inpStream) For recording blob data to DB
boolean	recordClobData(java.io.Reader reader) For recording clob data to DB
void	setIsDebug(boolean isDebug) For setting ifDebug
boolean	setKeyData() If the record is inserted DB, we don't have id yet.

Methods inherited from class java.lang.Object

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

Field Detail

STRING

public static final int STRING

This integer represent of data type for string.

See Also:

Constant Field Values

INTEGER

public static final int INTEGER

This integer represent of data type for integer.

See Also:

Constant Field Values

Constructor Detail

RecordFileToDB

public RecordFileToDB(RunDB runDB,
                      java.lang.String[] tableNames,
                      java.lang.String fileField,
                      java.lang.String keyField,
                      java.lang.String keyData)

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.

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

keyField - The key field name of the table to access.

keyData - Key field data.

RecordFileToDB

public RecordFileToDB(RunDB runDB,
                      java.lang.String[] tableNames,
                      java.lang.String fileField,
                      java.lang.String[] unqFields,
                      java.lang.String[] unqFieldData,
                      int[] unqFieldTypes)

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.

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

unqFields - Unique fields string array.

unqFieldData - Unique data string array.

unqFieldTypes - Unique field types string array.

Method Detail

setKeyData

public boolean setKeyData()

If the record is inserted DB, we don't have id yet. We can get id from DB with using unique data.

Returns:

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

getBlobData

public java.io.InputStream getBlobData()
                                throws java.sql.SQLException

For retrieving blob data from DB.

Returns:

InputStream for blob data.

Throws:

java.sql.SQLException

getClobData

public java.io.Reader getClobData()

For retrieving clob data from DB.

Returns:

Reader for clob data.

recordBlobData

public boolean recordBlobData(java.io.InputStream inpStream)

For recording blob data to DB

Parameters:

inpStream - from blob data

Returns:

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

recordClobData

public boolean recordClobData(java.io.Reader reader)
                       throws java.sql.SQLException

For recording clob data to DB

Parameters:

reader - from clob data

Returns:

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

Throws:

java.sql.SQLException

clearBCData

public boolean clearBCData()

For deleting blob and clob data from DB.

Returns:

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

closeAll

public void closeAll()

For calling RunDB class closeAll() method. Before, it will check resultSet, prepStmt and close them.

getErrorString

public java.lang.String getErrorString()

For getting errorString

Returns:

v

getMessageScript

public java.lang.String getMessageScript()

For getting messageScript

Returns:

messageScript

getResultMessage

public java.lang.String getResultMessage()

For getting resultMessage

Returns:

resultMessage

isDebug

public boolean isDebug()

For getting ifDebug

Returns:

ifDebug

setIsDebug

public void setIsDebug(boolean isDebug)

For setting ifDebug

Parameters:

ifDebug -