Package com.openindex.openestate.tool.contacts.db.hsql

Class HSqlDbContactsHandler

java.lang.Object

com.openindex.openestate.tool.contacts.db.DbContactsHandlerImpl

com.openindex.openestate.tool.contacts.db.hsql.HSqlDbContactsHandler

All Implemented Interfaces:

DbContactsHandler

public class HSqlDbContactsHandler
extends DbContactsHandlerImpl

HSqlDbContactsHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_ENTRY_ACTIVE
static String	FIELD_ENTRY_BIRTHDAY
static String	FIELD_ENTRY_ID
static String	FIELD_ENTRY_NOTES
static String	FIELD_ENTRY_PUBLIC_ID
static String	FIELD_FILE_CONTENT
static String	FIELD_FILE_ID
static String	FIELD_FILE_MIMETYPE
static String	FIELD_FILE_NAME
static String	FIELD_GROUP_ID
static String	FIELD_GROUP_NAME
static String	FIELD_GROUP_NOTES
static String	FIELD_SETTING_KEY
static String	FIELD_SETTING_VALUE
static String	PROC_GET_ENTRY_ID
static String	PROC_REMOVE_ENTRIES
static String	PROC_REMOVE_ENTRIES_ADDRESS
static String	PROC_REMOVE_ENTRIES_SETTINGS
static String	PROC_REMOVE_GROUPS
static String	PROC_SAVE_ENTRIES
static String	PROC_SAVE_ENTRIES_SETTINGS
static String	PROC_SAVE_GROUPS
static String	PROC_SET_ENTRIES_ACTIVE
static String	PROC_SET_ENTRIES_GROUP
static String	TABLE_ENTRIES
static String	TABLE_ENTRIES_FILES
static String	TABLE_ENTRIES_SETTINGS
static String	TABLE_GROUPS
static String	VIEW_ENTRIES
static String	VIEW_ENTRIES_FILES
static String	VIEW_ENTRIES_FILES_CONTENT
static String	VIEW_ENTRIES_SETTINGS
static String	VIEW_GROUPS

Constructor Summary

Constructors

Constructor	Description
HSqlDbContactsHandler()

Method Summary

Modifier and Type	Method	Description
DbContactsEntry[]	getEntries(Connection c, long[] ids)
DbContactsEntry[]	getEntriesByAddress(Connection c, String key, String value, boolean ignoreCase)	Deprecated.
DbContactsEntry[]	getEntriesByBirthday(Connection c, Date begin, Date end, Boolean active)
DbContactsEntry[]	getEntriesByInternetAddress(Connection c, javax.mail.internet.InternetAddress address, int limit)
DbContactsEntry[]	getEntriesByKeyword(Connection c, String keyword, long[] groupIds, int limit)
DbContactsEntry[]	getEntriesBySetting(Connection c, String key, String value, boolean ignoreCase)	Deprecated.
long	getEntryId(Connection c, String publicId)
long[]	getEntryIds(Connection c)
DbContactsEntry[]	getGroupEntries(Connection c, long[] groupIds)
long[]	getGroupIds(Connection c)
DbContactsGroup[]	getGroups(Connection c, long[] ids)
DbContactsGroup[]	getGroups(Connection c, String name)
void	loadEntrySettings(Connection c, DbContactsEntry[] entries)
void	removeEntries(Connection c, long[] ids)
void	removeGroups(Connection c, long[] ids)
void	saveEntry(Connection c, DbContactsEntry entry)
void	saveGroup(Connection c, DbContactsGroup group)
void	setEntriesActive(Connection c, long[] entryIds, boolean active)
void	setEntriesGroup(Connection c, long[] entryIds, long groupId)

Methods inherited from class com.openindex.openestate.tool.contacts.db.DbContactsHandlerImpl

getEntries, getEntriesByBirthday, getEntriesByInternetAddress, getEntriesByKeyword, getEntriesByKeyword, getEntriesByKeyword, getEntry, getEntry, getGroup, getGroupEntries, getGroups, loadEntrySettings, removeEntry, removeGroup, setEntryActive, setEntryGroup

Methods inherited from class java.lang.Object

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

Field Detail

PROC_REMOVE_GROUPS

public static final String PROC_REMOVE_GROUPS

See Also:

Constant Field Values

PROC_REMOVE_ENTRIES

public static final String PROC_REMOVE_ENTRIES

See Also:

Constant Field Values

PROC_REMOVE_ENTRIES_ADDRESS

public static final String PROC_REMOVE_ENTRIES_ADDRESS

See Also:

Constant Field Values

PROC_REMOVE_ENTRIES_SETTINGS

public static final String PROC_REMOVE_ENTRIES_SETTINGS

See Also:

Constant Field Values

PROC_GET_ENTRY_ID

public static final String PROC_GET_ENTRY_ID

See Also:

Constant Field Values

PROC_SAVE_GROUPS

public static final String PROC_SAVE_GROUPS

See Also:

Constant Field Values

PROC_SAVE_ENTRIES

public static final String PROC_SAVE_ENTRIES

See Also:

Constant Field Values

PROC_SAVE_ENTRIES_SETTINGS

public static final String PROC_SAVE_ENTRIES_SETTINGS

See Also:

Constant Field Values

PROC_SET_ENTRIES_ACTIVE

public static final String PROC_SET_ENTRIES_ACTIVE

See Also:

Constant Field Values

PROC_SET_ENTRIES_GROUP

public static final String PROC_SET_ENTRIES_GROUP

See Also:

Constant Field Values

VIEW_GROUPS

public static final String VIEW_GROUPS

See Also:

Constant Field Values

VIEW_ENTRIES

public static final String VIEW_ENTRIES

See Also:

Constant Field Values

VIEW_ENTRIES_FILES

public static final String VIEW_ENTRIES_FILES

See Also:

Constant Field Values

VIEW_ENTRIES_FILES_CONTENT

public static final String VIEW_ENTRIES_FILES_CONTENT

See Also:

Constant Field Values

VIEW_ENTRIES_SETTINGS

public static final String VIEW_ENTRIES_SETTINGS

See Also:

Constant Field Values

TABLE_GROUPS

public static final String TABLE_GROUPS

See Also:

Constant Field Values

FIELD_GROUP_ID

public static final String FIELD_GROUP_ID

See Also:

Constant Field Values

FIELD_GROUP_NAME

public static final String FIELD_GROUP_NAME

See Also:

Constant Field Values

FIELD_GROUP_NOTES

public static final String FIELD_GROUP_NOTES

See Also:

Constant Field Values

TABLE_ENTRIES

public static final String TABLE_ENTRIES

See Also:

Constant Field Values

FIELD_ENTRY_ID

public static final String FIELD_ENTRY_ID

See Also:

Constant Field Values

FIELD_ENTRY_NOTES

public static final String FIELD_ENTRY_NOTES

See Also:

Constant Field Values

FIELD_ENTRY_ACTIVE

public static final String FIELD_ENTRY_ACTIVE

See Also:

Constant Field Values

FIELD_ENTRY_BIRTHDAY

public static final String FIELD_ENTRY_BIRTHDAY

See Also:

Constant Field Values

FIELD_ENTRY_PUBLIC_ID

public static final String FIELD_ENTRY_PUBLIC_ID

See Also:

Constant Field Values

TABLE_ENTRIES_SETTINGS

public static final String TABLE_ENTRIES_SETTINGS

See Also:

Constant Field Values

FIELD_SETTING_KEY

public static final String FIELD_SETTING_KEY

See Also:

Constant Field Values

FIELD_SETTING_VALUE

public static final String FIELD_SETTING_VALUE

See Also:

Constant Field Values

TABLE_ENTRIES_FILES

public static final String TABLE_ENTRIES_FILES

See Also:

Constant Field Values

FIELD_FILE_ID

public static final String FIELD_FILE_ID

See Also:

Constant Field Values

FIELD_FILE_NAME

public static final String FIELD_FILE_NAME

See Also:

Constant Field Values

FIELD_FILE_MIMETYPE

public static final String FIELD_FILE_MIMETYPE

See Also:

Constant Field Values

FIELD_FILE_CONTENT

public static final String FIELD_FILE_CONTENT

See Also:

Constant Field Values

Constructor Detail

HSqlDbContactsHandler

public HSqlDbContactsHandler()

Method Detail

getEntries

public DbContactsEntry[] getEntries(Connection c,
                                    long[] ids)
                             throws SQLException

Specified by:

getEntries in interface DbContactsHandler

Specified by:

getEntries in class DbContactsHandlerImpl

Throws:

SQLException

getEntriesByAddress

@Deprecated
public DbContactsEntry[] getEntriesByAddress(Connection c,
                                             String key,
                                             String value,
                                             boolean ignoreCase)
                                      throws SQLException

Deprecated.

Specified by:

getEntriesByAddress in interface DbContactsHandler

Specified by:

getEntriesByAddress in class DbContactsHandlerImpl

Throws:

SQLException

getEntriesByBirthday

public DbContactsEntry[] getEntriesByBirthday(Connection c,
                                              Date begin,
                                              Date end,
                                              Boolean active)
                                       throws SQLException

Specified by:

getEntriesByBirthday in interface DbContactsHandler

Specified by:

getEntriesByBirthday in class DbContactsHandlerImpl

Throws:

SQLException

getEntriesByInternetAddress

public DbContactsEntry[] getEntriesByInternetAddress(Connection c,
                                                     javax.mail.internet.InternetAddress address,
                                                     int limit)
                                              throws SQLException

Specified by:

getEntriesByInternetAddress in interface DbContactsHandler

Specified by:

getEntriesByInternetAddress in class DbContactsHandlerImpl

Throws:

SQLException

getEntriesByKeyword

public DbContactsEntry[] getEntriesByKeyword(Connection c,
                                             String keyword,
                                             long[] groupIds,
                                             int limit)
                                      throws SQLException

Specified by:

getEntriesByKeyword in interface DbContactsHandler

Specified by:

getEntriesByKeyword in class DbContactsHandlerImpl

Throws:

SQLException

getEntriesBySetting

@Deprecated
public DbContactsEntry[] getEntriesBySetting(Connection c,
                                             String key,
                                             String value,
                                             boolean ignoreCase)
                                      throws SQLException

Deprecated.

Specified by:

getEntriesBySetting in interface DbContactsHandler

Specified by:

getEntriesBySetting in class DbContactsHandlerImpl

Throws:

SQLException

getEntryId

public long getEntryId(Connection c,
                       String publicId)
                throws SQLException

Specified by:

getEntryId in interface DbContactsHandler

Specified by:

getEntryId in class DbContactsHandlerImpl

Throws:

SQLException

getEntryIds

public long[] getEntryIds(Connection c)
                   throws SQLException

Specified by:

getEntryIds in interface DbContactsHandler

Specified by:

getEntryIds in class DbContactsHandlerImpl

Throws:

SQLException

getGroups

public DbContactsGroup[] getGroups(Connection c,
                                   long[] ids)
                            throws SQLException

Specified by:

getGroups in interface DbContactsHandler

Specified by:

getGroups in class DbContactsHandlerImpl

Throws:

SQLException

getGroups

public DbContactsGroup[] getGroups(Connection c,
                                   String name)
                            throws SQLException

Specified by:

getGroups in interface DbContactsHandler

Specified by:

getGroups in class DbContactsHandlerImpl

Throws:

SQLException

getGroupIds

public long[] getGroupIds(Connection c)
                   throws SQLException

Specified by:

getGroupIds in interface DbContactsHandler

Specified by:

getGroupIds in class DbContactsHandlerImpl

Throws:

SQLException

getGroupEntries

public DbContactsEntry[] getGroupEntries(Connection c,
                                         long[] groupIds)
                                  throws SQLException

Specified by:

getGroupEntries in interface DbContactsHandler

Specified by:

getGroupEntries in class DbContactsHandlerImpl

Throws:

SQLException

loadEntrySettings

public void loadEntrySettings(Connection c,
                              DbContactsEntry[] entries)
                       throws SQLException

Specified by:

loadEntrySettings in interface DbContactsHandler

Specified by:

loadEntrySettings in class DbContactsHandlerImpl

Throws:

SQLException

removeEntries

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

Specified by:

removeEntries in interface DbContactsHandler

Specified by:

removeEntries in class DbContactsHandlerImpl

Throws:

SQLException

removeGroups

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

Specified by:

removeGroups in interface DbContactsHandler

Specified by:

removeGroups in class DbContactsHandlerImpl

Throws:

SQLException

saveEntry

public void saveEntry(Connection c,
                      DbContactsEntry entry)
               throws SQLException

Specified by:

saveEntry in interface DbContactsHandler

Specified by:

saveEntry in class DbContactsHandlerImpl

Throws:

SQLException

saveGroup

public void saveGroup(Connection c,
                      DbContactsGroup group)
               throws SQLException

Specified by:

saveGroup in interface DbContactsHandler

Specified by:

saveGroup in class DbContactsHandlerImpl

Throws:

SQLException

setEntriesActive

public void setEntriesActive(Connection c,
                             long[] entryIds,
                             boolean active)
                      throws SQLException

Specified by:

setEntriesActive in interface DbContactsHandler

Specified by:

setEntriesActive in class DbContactsHandlerImpl

Throws:

SQLException

setEntriesGroup

public void setEntriesGroup(Connection c,
                            long[] entryIds,
                            long groupId)
                     throws SQLException

Specified by:

setEntriesGroup in interface DbContactsHandler

Specified by:

setEntriesGroup in class DbContactsHandlerImpl

Throws:

SQLException