public class DespatchAdviceLoader extends CSVParser implements ImportLoader
LOOUKP_TR_COLUMNS, LOOUKP_TR_COUNT, MODE_APPEND, MODE_APPENDUPDATE, MODE_UPDATE, WRITE_LOOKUPS
Constructor and Description |
---|
DespatchAdviceLoader()
Default constructor
Input file is assumed to be in ISO-8859-1 character set encoding and default delimiter is TAB
|
DespatchAdviceLoader(java.lang.String sCharSet,
java.lang.String sColDelimiter)
Constructor
|
Modifier and Type | Method and Description |
---|---|
void |
close()
Close DespacthAdviceLoader
Must be always called before DespacthAdviceLoader is destroyed
|
int |
columnCount()
Gt columns count
|
java.lang.String[] |
columnNames()
Get array of column names
|
java.lang.Object |
get(int iColumnIndex)
Get current value for a column given its index
|
java.lang.Object |
get(java.lang.String sColumnName)
Get current value for a column given its name
|
int |
getColumnIndex(java.lang.String sColumnName)
Get column index from its name
|
void |
importFile(java.sql.Connection oConn,
java.lang.String sWorkArea,
int iFlags,
java.lang.String sFilePath,
java.lang.String sColumnList)
Import despatch advices from a delimited file into the database
|
void |
prepare(java.sql.Connection oConn,
ColumnList oCols)
Prepare DespacthAdviceLoader for repeated execution
|
void |
put(int iColumnIndex,
java.lang.Object oValue)
Put current value for a column
|
void |
put(java.lang.String sColumnName,
java.lang.Object oValue)
Put current value for a column
|
void |
setAllColumnsToNull()
Set all current values to null
|
void |
store(java.sql.Connection oConn,
java.lang.String sWorkArea,
int iFlags)
Store a single despatch advice line
|
charSet, charSet, errorLine, find, findi, getColumnCount, getColumnPosition, getDelimiter, getField, getField, getLine, getLineAsMap, getLineCount, parseData, parseFile, parseFile, parseSheet, writeToFile, writeToStream
public DespatchAdviceLoader()
Default constructor
Input file is assumed to be in ISO-8859-1 character set encoding and default delimiter is TABpublic DespatchAdviceLoader(java.lang.String sCharSet, java.lang.String sColDelimiter)
String
- sCharSet Character set of input fileString
- Column delimiterpublic void importFile(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags, java.lang.String sFilePath, java.lang.String sColumnList) throws ImportExportException
Connection
- Opened JDBC database connectionString
- sWorkArea GUID of WorkArea where despatch advices are to be loadedint
- iFlags Additional flags for data loading { MODE_APPEND, MODE_UPDATE, MODE_APPENDUPDATE, WRITE_LOOKUPS }String
- sFilePath Full path of file to be imported, including protocol.String
- sColumnList Comma delimited list of columns present at the input file: "id_ref,nm_product,pr_total,..."
Like "file:///tmp/myfile.txt" or "file://C:\\Temp\\MyFile.txt" or "ftp://myhost:21/dir/myfile.txt"ImportExportException
public int columnCount()
columnCount
in interface ImportLoader
public java.lang.String[] columnNames() throws java.lang.IllegalStateException
columnNames
in interface ImportLoader
java.lang.IllegalStateException
public java.lang.Object get(int iColumnIndex) throws java.lang.ArrayIndexOutOfBoundsException
get
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]java.lang.ArrayIndexOutOfBoundsException
public java.lang.Object get(java.lang.String sColumnName) throws java.lang.ArrayIndexOutOfBoundsException
get
in interface ImportLoader
sColumnName
- Case insensitive Stringjava.lang.ArrayIndexOutOfBoundsException
- if no column with such name was foundpublic int getColumnIndex(java.lang.String sColumnName)
getColumnIndex
in interface ImportLoader
sColumnName
- Stringpublic void put(int iColumnIndex, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
put
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]oValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void put(java.lang.String sColumnName, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
put
in interface ImportLoader
sColumnName
- String Column nameoValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void setAllColumnsToNull()
setAllColumnsToNull
in interface ImportLoader
public void prepare(java.sql.Connection oConn, ColumnList oCols) throws java.sql.SQLException
prepare
in interface ImportLoader
oConn
- ConnectionoCols
- ColumnList List of columns that will be inserted or updated at the databasejava.sql.SQLException
public void close() throws java.sql.SQLException
Close DespacthAdviceLoader
Must be always called before DespacthAdviceLoader is destroyedclose
in interface ImportLoader
java.sql.SQLException
public void store(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.lang.NullPointerException
store
in interface ImportLoader
oConn
- ConnectionsWorkArea
- StringiFlags
- intjava.sql.SQLException
java.lang.IllegalArgumentException
java.lang.NullPointerException