net.sf.extjwnl.dictionary.database

Class DatabaseManagerImpl

java.lang.Object

net.sf.extjwnl.dictionary.database.DatabaseManagerImpl

All Implemented Interfaces:

DatabaseManager, Owned

public class DatabaseManagerImpl
extends java.lang.Object
implements DatabaseManager

Database manager.

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	ALL_EXCEPTIONS_SQL
protected static java.lang.String	ALL_LEMMAS_LIKE_SQL
protected static java.lang.String	ALL_LEMMAS_SQL
protected static java.lang.String	ALL_SYNSETS_SQL
protected ConnectionManager	connectionManager
protected static java.lang.String	COUNT_INDEX_WORDS_SQL
protected Dictionary	dictionary
static java.lang.String	DRIVER
protected static java.lang.String	EXCEPTION_SQL
protected static java.lang.String	LEMMA_FOR_INDEX_WORD_ID_SQL
protected java.util.Map<POS,net.sf.extjwnl.dictionary.database.DatabaseManagerImpl.MinMax>	minMaxIds
static java.lang.String	PASSWORD
protected static java.util.Random	rand
protected static java.lang.String	SYNSET_IDS_FOR_INDEX_WORD_SQL SQL query for getting all synsets for an index word.
protected static java.lang.String	SYNSET_POINTER_SQL
protected static java.lang.String	SYNSET_SQL
protected static java.lang.String	SYNSET_VERB_FRAME_SQL
protected static java.lang.String	SYNSET_WORD_SQL
static java.lang.String	URL
static java.lang.String	USERNAME

Constructor Summary

Constructors

Constructor and Description
DatabaseManagerImpl(Dictionary dictionary, java.util.Map<java.lang.String,Param> params)

Method Summary

Modifier and Type	Method and Description
void	close() Closes the connections and frees associated resources.
protected Query	createPOSIdQuery(POS pos, int id, java.lang.String sql)
protected Query	createPOSOffsetQuery(POS pos, long offset, java.lang.String sql)
protected Query	createPOSQuery(POS pos, java.lang.String sql)
protected Query	createPOSStringQuery(POS pos, java.lang.String str, java.lang.String sql)
Dictionary	getDictionary() Returns the dictionary this object belongs to.
Query	getExceptionQuery(POS pos, java.lang.String derivation)
Query	getExceptionsQuery(POS pos)
Query	getIndexWordLemmasQuery(POS pos)
Query	getIndexWordLemmasQuery(POS pos, java.lang.String substring)
Query	getIndexWordSynsetsQuery(POS pos, java.lang.String lemma)
Query	getPointerQuery(POS pos, long offset)
Query	getRandomIndexWordQuery(POS pos)
Query	getSynsetQuery(POS pos, long offset)
Query	getSynsetsQuery(POS pos)
Query	getSynsetWordQuery(POS pos, long offset)
Query	getVerbFrameQuery(POS pos, long offset)
void	setDictionary(Dictionary dictionary) Sets the dictionary this object belongs to.

Methods inherited from class java.lang.Object

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

Field Detail

DRIVER

public static final java.lang.String DRIVER

See Also:

Constant Field Values

URL

public static final java.lang.String URL

See Also:

Constant Field Values

USERNAME

public static final java.lang.String USERNAME

See Also:

Constant Field Values

PASSWORD

public static final java.lang.String PASSWORD

See Also:

Constant Field Values

LEMMA_FOR_INDEX_WORD_ID_SQL

protected static final java.lang.String LEMMA_FOR_INDEX_WORD_ID_SQL

See Also:

Constant Field Values

SYNSET_IDS_FOR_INDEX_WORD_SQL

protected static final java.lang.String SYNSET_IDS_FOR_INDEX_WORD_SQL

SQL query for getting all synsets for an index word.

See Also:

Constant Field Values

COUNT_INDEX_WORDS_SQL

protected static final java.lang.String COUNT_INDEX_WORDS_SQL

See Also:

Constant Field Values

ALL_LEMMAS_SQL

protected static final java.lang.String ALL_LEMMAS_SQL

See Also:

Constant Field Values

ALL_LEMMAS_LIKE_SQL

protected static final java.lang.String ALL_LEMMAS_LIKE_SQL

See Also:

Constant Field Values

SYNSET_SQL

protected static final java.lang.String SYNSET_SQL

See Also:

Constant Field Values

SYNSET_WORD_SQL

protected static final java.lang.String SYNSET_WORD_SQL

See Also:

Constant Field Values

SYNSET_POINTER_SQL

protected static final java.lang.String SYNSET_POINTER_SQL

See Also:

Constant Field Values

SYNSET_VERB_FRAME_SQL

protected static final java.lang.String SYNSET_VERB_FRAME_SQL

See Also:

Constant Field Values

ALL_SYNSETS_SQL

protected static final java.lang.String ALL_SYNSETS_SQL

See Also:

Constant Field Values

EXCEPTION_SQL

protected static final java.lang.String EXCEPTION_SQL

See Also:

Constant Field Values

ALL_EXCEPTIONS_SQL

protected static final java.lang.String ALL_EXCEPTIONS_SQL

See Also:

Constant Field Values

rand

protected static final java.util.Random rand

connectionManager

protected final ConnectionManager connectionManager

minMaxIds

protected final java.util.Map<POS,net.sf.extjwnl.dictionary.database.DatabaseManagerImpl.MinMax> minMaxIds

dictionary

protected final Dictionary dictionary

Constructor Detail

DatabaseManagerImpl

public DatabaseManagerImpl(Dictionary dictionary,
                           java.util.Map<java.lang.String,Param> params)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

getIndexWordSynsetsQuery

public Query getIndexWordSynsetsQuery(POS pos,
                                      java.lang.String lemma)
                               throws java.sql.SQLException

Specified by:

getIndexWordSynsetsQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getIndexWordLemmasQuery

public Query getIndexWordLemmasQuery(POS pos)
                              throws java.sql.SQLException

Specified by:

getIndexWordLemmasQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getIndexWordLemmasQuery

public Query getIndexWordLemmasQuery(POS pos,
                                     java.lang.String substring)
                              throws java.sql.SQLException

Specified by:

getIndexWordLemmasQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getRandomIndexWordQuery

public Query getRandomIndexWordQuery(POS pos)
                              throws java.sql.SQLException

Specified by:

getRandomIndexWordQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getSynsetQuery

public Query getSynsetQuery(POS pos,
                            long offset)
                     throws java.sql.SQLException

Specified by:

getSynsetQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getSynsetWordQuery

public Query getSynsetWordQuery(POS pos,
                                long offset)
                         throws java.sql.SQLException

Specified by:

getSynsetWordQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getPointerQuery

public Query getPointerQuery(POS pos,
                             long offset)
                      throws java.sql.SQLException

Specified by:

getPointerQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getVerbFrameQuery

public Query getVerbFrameQuery(POS pos,
                               long offset)
                        throws java.sql.SQLException

Specified by:

getVerbFrameQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getSynsetsQuery

public Query getSynsetsQuery(POS pos)
                      throws java.sql.SQLException

Specified by:

getSynsetsQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getExceptionQuery

public Query getExceptionQuery(POS pos,
                               java.lang.String derivation)
                        throws java.sql.SQLException

Specified by:

getExceptionQuery in interface DatabaseManager

Throws:

java.sql.SQLException

getExceptionsQuery

public Query getExceptionsQuery(POS pos)
                         throws java.sql.SQLException

Specified by:

getExceptionsQuery in interface DatabaseManager

Throws:

java.sql.SQLException

close

public void close()

Description copied from interface: DatabaseManager

Closes the connections and frees associated resources.

Specified by:

close in interface DatabaseManager

createPOSQuery

protected Query createPOSQuery(POS pos,
                               java.lang.String sql)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

createPOSStringQuery

protected Query createPOSStringQuery(POS pos,
                                     java.lang.String str,
                                     java.lang.String sql)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

createPOSOffsetQuery

protected Query createPOSOffsetQuery(POS pos,
                                     long offset,
                                     java.lang.String sql)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

createPOSIdQuery

protected Query createPOSIdQuery(POS pos,
                                 int id,
                                 java.lang.String sql)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getDictionary

public Dictionary getDictionary()

Description copied from interface: Owned

Returns the dictionary this object belongs to.

Specified by:

getDictionary in interface Owned

Returns:

the dictionary this object belongs to

setDictionary

public void setDictionary(Dictionary dictionary)

Description copied from interface: Owned

Sets the dictionary this object belongs to.

Specified by:

setDictionary in interface Owned

Parameters:

dictionary - the dictionary this object belongs to