com.knowgate.crm
Class CompanyLoader

java.lang.Object
  com.knowgate.crm.CompanyLoader

All Implemented Interfaces:

ImportLoader

public class CompanyLoader
extends java.lang.Object
implements ImportLoader

Load Company and Address data from a single source

Company loader creates or updates simultaneously registers at k_companies and k_addresses tables and the links between them k_x_contact_addr. Loading aCompany is a special case of loading a contact, and thus this class delegates all its behavious to a private ContactLoader member.

Field Summary

static int	MODE_APPEND
static int	MODE_APPENDUPDATE
static int	MODE_UPDATE
static int	WRITE_ADDRESSES
static int	WRITE_LOOKUPS

Fields inherited from interface com.knowgate.hipergate.datamodel.ImportLoader

LOOUKP_TR_COLUMNS, LOOUKP_TR_COUNT

Constructor Summary

CompanyLoader()
Default Constructor

CompanyLoader(java.sql.Connection oConn)
Create ContactLoader and call prepare() on Connection

Method Summary

void	close() Method close
int	columnCount() Get columns count
java.lang.String[]	columnNames() Get array of column names
java.lang.Object	get(int iColumnIndex) Method get
java.lang.Object	get(java.lang.String sColumnName) Method get
int	getColumnIndex(java.lang.String sColumnName) Method getColumnIndex
void	prepare(java.sql.Connection oConn, ColumnList oCols) Method prepare
void	put(int iColumnIndex, java.lang.Object oValue) Method put
void	put(java.lang.String sColumnName, java.lang.Object oValue) Method put
void	setAllColumnsToNull() Method setAllColumnsToNull
void	store(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags) Method store

Methods inherited from class java.lang.Object

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

Field Detail

MODE_APPEND

public static final int MODE_APPEND

See Also:

Constant Field Values

MODE_UPDATE

public static final int MODE_UPDATE

See Also:

Constant Field Values

MODE_APPENDUPDATE

public static final int MODE_APPENDUPDATE

See Also:

Constant Field Values

WRITE_LOOKUPS

public static final int WRITE_LOOKUPS

See Also:

Constant Field Values

WRITE_ADDRESSES

public static final int WRITE_ADDRESSES

See Also:

Constant Field Values

Constructor Detail

CompanyLoader

public CompanyLoader()

Default Constructor

CompanyLoader

public CompanyLoader(java.sql.Connection oConn)
              throws java.sql.SQLException

Create ContactLoader and call prepare() on Connection

Parameters:

oConn - Connection

Throws:

java.sql.SQLException

Method Detail

columnCount

public int columnCount()

Description copied from interface: ImportLoader

Get columns count

Specified by:

columnCount in interface ImportLoader

Returns:

int

columnNames

public java.lang.String[] columnNames()
                               throws java.lang.IllegalStateException

Description copied from interface: ImportLoader

Get array of column names

Specified by:

columnNames in interface ImportLoader

Returns:

String[]

Throws:

java.lang.IllegalStateException

get

public java.lang.Object get(int iColumnIndex)
                     throws java.lang.ArrayIndexOutOfBoundsException

Method get

Specified by:

get in interface ImportLoader

Parameters:

iColumnIndex -

Returns:

Throws:

java.lang.ArrayIndexOutOfBoundsException

get

public java.lang.Object get(java.lang.String sColumnName)
                     throws java.lang.ArrayIndexOutOfBoundsException

Method get

Specified by:

get in interface ImportLoader

Parameters:

sColumnName -

Returns:

Throws:

java.lang.ArrayIndexOutOfBoundsException

getColumnIndex

public int getColumnIndex(java.lang.String sColumnName)

Method getColumnIndex

Specified by:

getColumnIndex in interface ImportLoader

Parameters:

sColumnName -

Returns:

put

public void put(int iColumnIndex,
                java.lang.Object oValue)
         throws java.lang.ArrayIndexOutOfBoundsException

Method put

Specified by:

put in interface ImportLoader

Parameters:

iColumnIndex -

oValue -

Throws:

java.lang.ArrayIndexOutOfBoundsException

put

public void put(java.lang.String sColumnName,
                java.lang.Object oValue)
         throws java.lang.ArrayIndexOutOfBoundsException

Method put

Specified by:

put in interface ImportLoader

Parameters:

sColumnName -

oValue -

Throws:

java.lang.ArrayIndexOutOfBoundsException

setAllColumnsToNull

public void setAllColumnsToNull()

Method setAllColumnsToNull

Specified by:

setAllColumnsToNull in interface ImportLoader

prepare

public void prepare(java.sql.Connection oConn,
                    ColumnList oCols)
             throws java.sql.SQLException

Method prepare

Specified by:

prepare in interface ImportLoader

Parameters:

oConn -

oCols -

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Method close

Specified by:

close in interface ImportLoader

Throws:

java.sql.SQLException

store

public void store(java.sql.Connection oConn,
                  java.lang.String sWorkArea,
                  int iFlags)
           throws java.sql.SQLException,
                  java.lang.IllegalArgumentException,
                  java.lang.NullPointerException

Method store

Specified by:

store in interface ImportLoader

Parameters:

oConn -

sWorkArea -

iFlags -

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.NullPointerException