com.openindex.openestate.impl.db.hsql

Class HSqlDbContactsHandler

java.lang.Object

com.openindex.openestate.impl.db.DbHandlerImpl

com.openindex.openestate.impl.db.DbContactsHandlerImpl

com.openindex.openestate.impl.db.hsql.HSqlDbContactsHandler

All Implemented Interfaces:

DbContactsHandler, DbHandler

public class HSqlDbContactsHandler
extends DbContactsHandlerImpl

HSqlDbContactsHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field and Description
static String	FIELD_ADDRESS_CITY
static String	FIELD_ADDRESS_COUNTRY
static String	FIELD_ADDRESS_DISTRICT
static String	FIELD_ADDRESS_LATITUDE
static String	FIELD_ADDRESS_LONGITUDE
static String	FIELD_ADDRESS_POSTAL_CODE
static String	FIELD_ADDRESS_REGION
static String	FIELD_ADDRESS_STREET
static String	FIELD_ADDRESS_STREET_NR
static String	FIELD_ADDRESS_STREET2
static String	FIELD_CONTACT_ID
static String	FIELD_CONTACT_OFFICE_HOURS
static String	FIELD_CONTACT_WEBSITE
static String	FIELD_PERSON_DATE_OF_BIRTH
static String	FIELD_PERSON_FAX
static String	FIELD_PERSON_FIRST_NAME
static String	FIELD_PERSON_GENDER
static String	FIELD_PERSON_LAST_NAME
static String	FIELD_PERSON_MAIL
static String	FIELD_PERSON_MIDDLE_NAME
static String	FIELD_PERSON_MOBILE_PHONE
static String	FIELD_PERSON_PHONE
static String	FIELD_PERSON_TITLE
static String	PROC_REMOVE_CONTACTS
static String	PROC_SAVE_CONTACTS
static String	VIEW_CONTACTS

Constructor Summary

Constructors

Constructor and Description
HSqlDbContactsHandler()
HSqlDbContactsHandler(String schema)

Method Summary

Modifier and Type	Method and Description
protected DbContact	buildContact(ResultSet result)
long[]	getContactIds(Connection c, Boolean withObjects)
DbContact[]	getContacts(Connection c, Boolean withObjects)
DbContact[]	getContacts(Connection c, long[] ids)
void	removeContacts(Connection c, long[] ids)
void	saveContact(Connection c, DbContact contact)
protected void	saveContactAdditionally(Connection c, DbContact contact, long contactId, List<Statement> statements)

Methods inherited from class com.openindex.openestate.impl.db.DbContactsHandlerImpl

createContact, getContact, getContactIds, getContacts, removeContact

Methods inherited from class com.openindex.openestate.impl.db.DbHandlerImpl

getSchema, getSchemaPath, setSchema

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.openindex.openestate.impl.db.DbHandler

getSchema, setSchema

Field Detail

PROC_REMOVE_CONTACTS

public static final String PROC_REMOVE_CONTACTS

See Also:

Constant Field Values

PROC_SAVE_CONTACTS

public static final String PROC_SAVE_CONTACTS

See Also:

Constant Field Values

VIEW_CONTACTS

public static final String VIEW_CONTACTS

See Also:

Constant Field Values

FIELD_CONTACT_ID

public static final String FIELD_CONTACT_ID

See Also:

Constant Field Values

FIELD_PERSON_FIRST_NAME

public static final String FIELD_PERSON_FIRST_NAME

See Also:

Constant Field Values

FIELD_PERSON_MIDDLE_NAME

public static final String FIELD_PERSON_MIDDLE_NAME

See Also:

Constant Field Values

FIELD_PERSON_LAST_NAME

public static final String FIELD_PERSON_LAST_NAME

See Also:

Constant Field Values

FIELD_PERSON_TITLE

public static final String FIELD_PERSON_TITLE

See Also:

Constant Field Values

FIELD_PERSON_GENDER

public static final String FIELD_PERSON_GENDER

See Also:

Constant Field Values

FIELD_PERSON_DATE_OF_BIRTH

public static final String FIELD_PERSON_DATE_OF_BIRTH

See Also:

Constant Field Values

FIELD_PERSON_MAIL

public static final String FIELD_PERSON_MAIL

See Also:

Constant Field Values

FIELD_PERSON_PHONE

public static final String FIELD_PERSON_PHONE

See Also:

Constant Field Values

FIELD_PERSON_MOBILE_PHONE

public static final String FIELD_PERSON_MOBILE_PHONE

See Also:

Constant Field Values

FIELD_PERSON_FAX

public static final String FIELD_PERSON_FAX

See Also:

Constant Field Values

FIELD_ADDRESS_STREET

public static final String FIELD_ADDRESS_STREET

See Also:

Constant Field Values

FIELD_ADDRESS_STREET2

public static final String FIELD_ADDRESS_STREET2

See Also:

Constant Field Values

FIELD_ADDRESS_STREET_NR

public static final String FIELD_ADDRESS_STREET_NR

See Also:

Constant Field Values

FIELD_ADDRESS_POSTAL_CODE

public static final String FIELD_ADDRESS_POSTAL_CODE

See Also:

Constant Field Values

FIELD_ADDRESS_CITY

public static final String FIELD_ADDRESS_CITY

See Also:

Constant Field Values

FIELD_ADDRESS_DISTRICT

public static final String FIELD_ADDRESS_DISTRICT

See Also:

Constant Field Values

FIELD_ADDRESS_COUNTRY

public static final String FIELD_ADDRESS_COUNTRY

See Also:

Constant Field Values

FIELD_ADDRESS_REGION

public static final String FIELD_ADDRESS_REGION

See Also:

Constant Field Values

FIELD_ADDRESS_LATITUDE

public static final String FIELD_ADDRESS_LATITUDE

See Also:

Constant Field Values

FIELD_ADDRESS_LONGITUDE

public static final String FIELD_ADDRESS_LONGITUDE

See Also:

Constant Field Values

FIELD_CONTACT_WEBSITE

public static final String FIELD_CONTACT_WEBSITE

See Also:

Constant Field Values

FIELD_CONTACT_OFFICE_HOURS

public static final String FIELD_CONTACT_OFFICE_HOURS

See Also:

Constant Field Values

Constructor Detail

HSqlDbContactsHandler

public HSqlDbContactsHandler()

HSqlDbContactsHandler

public HSqlDbContactsHandler(String schema)

Method Detail

buildContact

protected DbContact buildContact(ResultSet result)
                          throws SQLException

Throws:

SQLException

getContacts

public DbContact[] getContacts(Connection c,
                               Boolean withObjects)
                        throws SQLException

Specified by:

getContacts in interface DbContactsHandler

Specified by:

getContacts in class DbContactsHandlerImpl

Throws:

SQLException

getContacts

public DbContact[] getContacts(Connection c,
                               long[] ids)
                        throws SQLException

Specified by:

getContacts in interface DbContactsHandler

Specified by:

getContacts in class DbContactsHandlerImpl

Throws:

SQLException

getContactIds

public long[] getContactIds(Connection c,
                            Boolean withObjects)
                     throws SQLException

Specified by:

getContactIds in interface DbContactsHandler

Specified by:

getContactIds in class DbContactsHandlerImpl

Throws:

SQLException

removeContacts

public void removeContacts(Connection c,
                           long[] ids)
                    throws SQLException

Specified by:

removeContacts in interface DbContactsHandler

Specified by:

removeContacts in class DbContactsHandlerImpl

Throws:

SQLException

saveContact

public void saveContact(Connection c,
                        DbContact contact)
                 throws SQLException

Specified by:

saveContact in interface DbContactsHandler

Specified by:

saveContact in class DbContactsHandlerImpl

Throws:

SQLException

saveContactAdditionally

protected void saveContactAdditionally(Connection c,
                                       DbContact contact,
                                       long contactId,
                                       List<Statement> statements)
                                throws SQLException

Throws:

SQLException