|
| |
|
| java.lang.Object
 com.knowgate.crm.ContactLoader
| ContactLoader | | public class ContactLoader implements ImportLoader(Code) | | Load Contact, Company and Address data from a single source
Contact loader creates or updates simultaneously registers at k_companies,
k_contacts and k_addresses tables and the links between them k_x_contact_addr.
author:
Sergio Montoro Ten
version:
1.0 |
| Method Summary | |
| public void | close()
| | public int | columnCount()
| | public String[] | columnNames()
| | public Object | get(int iColumnIndex)
| | public Object | get(String sColumnName)
| | public int | getColumnIndex(String sColumnName)
| | public void | prepare(Connection oConn, ColumnList oColList)
Prepare statements for execution
This method needs to be called only once if the default constructor was used.
If ContactLoader(Connection) constructor was used, there is no need to call prepare()
and a SQLException will be raised if the attempt is made.
It is neccesary to call close() always for prepared instances as a failure
to do so will leave open cursors on the database causing it eventually to stop. | | public void | put(int iColumnIndex, Object oValue)
| | public void | put(String sColumnName, Object oValue)
| | public void | putAll(Map oValues)
| | public void | setAllColumnsToNull()
| | public void | store(Connection oConn, String sWorkArea, int iFlags)
|
| MODE_APPEND | | final public static int MODE_APPEND(Code) | | |
| MODE_APPENDUPDATE | | final public static int MODE_APPENDUPDATE(Code) | | |
| MODE_UPDATE | | final public static int MODE_UPDATE(Code) | | |
| NO_DUPLICATED_MAILS | | final public static int NO_DUPLICATED_MAILS(Code) | | |
| NO_DUPLICATED_NAMES | | final public static int NO_DUPLICATED_NAMES(Code) | | |
| WRITE_ADDRESSES | | final public static int WRITE_ADDRESSES(Code) | | |
| WRITE_COMPANIES | | final public static int WRITE_COMPANIES(Code) | | |
| WRITE_CONTACTS | | final public static int WRITE_CONTACTS(Code) | | |
| WRITE_LOOKUPS | | final public static int WRITE_LOOKUPS(Code) | | |
| bo_active | | public static int bo_active(Code) | | |
| bo_change_pwd | | public static int bo_change_pwd(Code) | | |
| bo_private | | public static int bo_private(Code) | | |
| contact_person | | public static int contact_person(Code) | | |
| coord_x | | public static int coord_x(Code) | | |
| coord_y | | public static int coord_y(Code) | | |
| de_company | | public static int de_company(Code) | | |
| de_title | | public static int de_title(Code) | | |
| direct_phone | | public static int direct_phone(Code) | | |
| dt_birth | | public static int dt_birth(Code) | | |
| dt_created | | public static int dt_created(Code) | | |
| dt_drivelic | | public static int dt_drivelic(Code) | | |
| dt_founded | | public static int dt_founded(Code) | | |
| dt_modified | | public static int dt_modified(Code) | | |
| dt_pwd_expires | | public static int dt_pwd_expires(Code) | | |
| fax_phone | | public static int fax_phone(Code) | | |
| gu_address | | public static int gu_address(Code) | | |
| gu_company | | public static int gu_company(Code) | | |
| gu_contact | | public static int gu_contact(Code) | | |
| gu_geozone | | public static int gu_geozone(Code) | | |
| gu_sales_man | | public static int gu_sales_man(Code) | | |
| gu_workarea | | public static int gu_workarea(Code) | | |
| gu_writer | | public static int gu_writer(Code) | | |
| home_phone | | public static int home_phone(Code) | | |
| id_address_ref | | public static int id_address_ref(Code) | | |
| id_company_ref | | public static int id_company_ref(Code) | | |
| id_company_status | | public static int id_company_status(Code) | | |
| id_contact_ref | | public static int id_contact_ref(Code) | | |
| id_contact_status | | public static int id_contact_status(Code) | | |
| id_country | | public static int id_country(Code) | | |
| id_gender | | public static int id_gender(Code) | | |
| id_legal | | public static int id_legal(Code) | | |
| id_sector | | public static int id_sector(Code) | | |
| id_state | | public static int id_state(Code) | | |
| im_revenue | | public static int im_revenue(Code) | | |
| ix_address | | public static int ix_address(Code) | | |
| mn_city | | public static int mn_city(Code) | | |
| mov_phone | | public static int mov_phone(Code) | | |
| nm_commercial | | public static int nm_commercial(Code) | | |
| nm_country | | public static int nm_country(Code) | | |
| nm_legal | | public static int nm_legal(Code) | | |
| nm_state | | public static int nm_state(Code) | | |
| nm_street | | public static int nm_street(Code) | | |
| nu_employees | | public static int nu_employees(Code) | | |
| nu_street | | public static int nu_street(Code) | | |
| ny_age | | public static int ny_age(Code) | | |
| other_phone | | public static int other_phone(Code) | | |
| po_box | | public static int po_box(Code) | | |
| sn_drivelic | | public static int sn_drivelic(Code) | | |
| sn_passport | | public static int sn_passport(Code) | | |
| tp_company | | public static int tp_company(Code) | | |
| tp_location | | public static int tp_location(Code) | | |
| tp_passport | | public static int tp_passport(Code) | | |
| tp_street | | public static int tp_street(Code) | | |
| tx_addr1 | | public static int tx_addr1(Code) | | |
| tx_addr2 | | public static int tx_addr2(Code) | | |
| tx_challenge | | public static int tx_challenge(Code) | | |
| tx_comments | | public static int tx_comments(Code) | | |
| tx_dept | | public static int tx_dept(Code) | | |
| tx_division | | public static int tx_division(Code) | | |
| tx_email | | public static int tx_email(Code) | | |
| tx_email_alt | | public static int tx_email_alt(Code) | | |
| tx_franchise | | public static int tx_franchise(Code) | | |
| tx_name | | public static int tx_name(Code) | | |
| tx_nickname | | public static int tx_nickname(Code) | | |
| tx_pwd | | public static int tx_pwd(Code) | | |
| tx_remarks | | public static int tx_remarks(Code) | | |
| tx_reply | | public static int tx_reply(Code) | | |
| tx_salutation | | public static int tx_salutation(Code) | | |
| tx_surname | | public static int tx_surname(Code) | | |
| url_addr | | public static int url_addr(Code) | | |
| work_phone | | public static int work_phone(Code) | | |
| zipcode | | public static int zipcode(Code) | | |
| ContactLoader | | public ContactLoader()(Code) | | Default construtor
|
| close | | public void close() throws SQLException(Code) | | Close prepared statements
This method must always be called before object is destroyed or else
throws:
SQLException - |
| columnCount | | public int columnCount()(Code) | | |
| getColumnIndex | | public int getColumnIndex(String sColumnName)(Code) | | Get column index at ColumnNames array given its name
This method performs binary search assuming that ColumnNames is sorted in
ascending order
Parameters:
sColumnName - String Column name (case insensitive) int Column index or -1 if not found |
| prepare | | public void prepare(Connection oConn, ColumnList oColList) throws SQLException(Code) | | Prepare statements for execution
This method needs to be called only once if the default constructor was used.
If ContactLoader(Connection) constructor was used, there is no need to call prepare()
and a SQLException will be raised if the attempt is made.
It is neccesary to call close() always for prepared instances as a failure
to do so will leave open cursors on the database causing it eventually to stop.
Parameters:
oConn - Connection Open JDBC database connection
Parameters:
oColList - ColumnList This parameter is ignored
throws:
SQLException - |
| putAll | | public void putAll(Map oValues)(Code) | | Put all values from a map on their corresponding columns matching by name
Parameters:
oValues - Map |
| setAllColumnsToNull | | public void setAllColumnsToNull()(Code) | | Set all column values to null
|
|
|
|