public interface ImportLoader
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
LOOUKP_TR_COLUMNS |
static int |
LOOUKP_TR_COUNT |
static int |
MODE_APPEND |
static int |
MODE_APPENDUPDATE |
static int |
MODE_UPDATE |
static int |
WRITE_LOOKUPS |
Modifier and Type | Method and Description |
---|---|
void |
close()
Close ImportLoader
Must be always called before ImportLoader is destroyed
|
int |
columnCount()
Get 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 |
prepare(java.sql.Connection oConn,
ColumnList oCols)
Prepare ImportLoader 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 row or a set of related rows
|
static final int MODE_APPEND
static final int MODE_UPDATE
static final int MODE_APPENDUPDATE
static final int WRITE_LOOKUPS
static final java.lang.String LOOUKP_TR_COLUMNS
static final int LOOUKP_TR_COUNT
int columnCount()
java.lang.String[] columnNames() throws java.lang.IllegalStateException
java.lang.IllegalStateException
java.lang.Object get(int iColumnIndex) throws java.lang.ArrayIndexOutOfBoundsException
iColumnIndex
- int [0..columnCount()-1]java.lang.ArrayIndexOutOfBoundsException
java.lang.Object get(java.lang.String sColumnName) throws java.lang.ArrayIndexOutOfBoundsException
sColumnName
- Case insensitive Stringjava.lang.ArrayIndexOutOfBoundsException
- if no column with such name was foundint getColumnIndex(java.lang.String sColumnName)
sColumnName
- Stringvoid put(int iColumnIndex, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
iColumnIndex
- int [0..columnCount()-1]oValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
void put(java.lang.String sColumnName, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
sColumnName
- String Column nameoValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
void setAllColumnsToNull()
void prepare(java.sql.Connection oConn, ColumnList oCols) throws java.sql.SQLException
oConn
- ConnectionoCols
- ColumnList List of columns that will be inserted or updated at the databasejava.sql.SQLException
void close() throws java.sql.SQLException
Close ImportLoader
Must be always called before ImportLoader is destroyedjava.sql.SQLException
void store(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.lang.NullPointerException
oConn
- ConnectionsWorkArea
- StringiFlags
- intjava.sql.SQLException
java.lang.IllegalArgumentException
java.lang.NullPointerException