de.fh_mannheim.mm.dms.framework
Class ContentConnectionManager

java.lang.Object
  de.fh_mannheim.mm.dms.framework.ConnectionManager
      de.fh_mannheim.mm.dms.framework.ContentConnectionManager

Direct Known Subclasses:

ContentManager

public class ContentConnectionManager

extends ConnectionManager

ContentConnectionManager improves the connectionmanager for contentmanager.

Version:

$Revision: 1.13 $

Author:

Jan Löffler, mail@jlsoft.de

Field Summary

static int

MAX_RESULTS Max results

Constructor Summary

ContentConnectionManager(Config cfg)
Constructor.

Method Summary

boolean	insertIndex(int nFileID, int nKeywordID, int nFrequency) Insert index.
boolean	insertKeyword(java.lang.String strKeyword, int nFrequency) Insert keyword.
boolean	insertQuery(int nUserID, java.lang.String strKeyword, double dWeight) Insert query keyword.
java.sql.ResultSet	searchQuery(int nUserID) Search query.
java.sql.ResultSet	searchQuery(int nUserID, FormattedDate minAge, FormattedDate maxAge, int nLimit) Search query.
java.sql.ResultSet	searchQueryByLanguage(int nUserID, int nLanguage) Search query.
java.sql.ResultSet	searchQueryByLanguage(int nUserID, int nLanguage, FormattedDate minAge, FormattedDate maxAge, int nLimit) Search query.
boolean	updateFileWeight(int nFileID, double dWeight) Update file.
boolean	updateIndexFrequency(int nFileID, int nKeywordID, int nFrequency) Update index.
boolean	updateIndexWeight(int nFileID, int nKeywordID, double dWeight) Update index.
boolean	updateKeywordFrequency(java.lang.String strKeyword, int nFrequency) Update keyword.
boolean	updateKeywordWeight(int nKeywordID, double dWeight) Update keyword.
boolean	updateQuery(int nUserID, java.lang.String strKeyword, double dWeight) Update query.

Methods inherited from class de.fh_mannheim.mm.dms.framework.ConnectionManager

checkConnection, closeConnection, closePreparedStatement, closeResultSet, closeResultSet, commit, executeQuery, executeQueryGetBool, executeQueryGetDate, executeQueryGetDouble, executeQueryGetInt, executeQueryGetString, executeUpdate, formatBool, formatDate, formatDate, formatDouble, formatInteger, formatString, getPreparedStatement, openConnection, optimizeTable, rollback, startTransaction

Methods inherited from class java.lang.Object

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

Field Detail

MAX_RESULTS

public static final int MAX_RESULTS

Max results

See Also:

Constant Field Values

Constructor Detail

ContentConnectionManager

public ContentConnectionManager(Config cfg)

Constructor.

Parameters:

cfg - Config

Method Detail

insertKeyword

public boolean insertKeyword(java.lang.String strKeyword,
                             int nFrequency)

Insert keyword.

Parameters:

strKeyword - Keyword

nFrequency - Frequency

Returns:

true, if successful

insertIndex

public boolean insertIndex(int nFileID,
                           int nKeywordID,
                           int nFrequency)

Insert index.

Parameters:

nFileID - Upload

nKeywordID - Keyword

nFrequency - Frequency

Returns:

true, if successful

insertQuery

public boolean insertQuery(int nUserID,
                           java.lang.String strKeyword,
                           double dWeight)

Insert query keyword.

Parameters:

nUserID - User

strKeyword - Keyword

dWeight - Weight

Returns:

true, if successful

updateKeywordFrequency

public boolean updateKeywordFrequency(java.lang.String strKeyword,
                                      int nFrequency)

Update keyword.

Parameters:

strKeyword - Keyword

nFrequency - Frequency

Returns:

true, if successful

updateKeywordWeight

public boolean updateKeywordWeight(int nKeywordID,
                                   double dWeight)

Update keyword.

Parameters:

nKeywordID - Keyword

dWeight - Weight

Returns:

true, if successful

updateIndexFrequency

public boolean updateIndexFrequency(int nFileID,
                                    int nKeywordID,
                                    int nFrequency)

Update index.

Parameters:

nFileID - Upload

nKeywordID - Keyword

nFrequency - Frequency

Returns:

true, if successful

updateIndexWeight

public boolean updateIndexWeight(int nFileID,
                                 int nKeywordID,
                                 double dWeight)

Update index.

Parameters:

nFileID - Upload

nKeywordID - Keyword

dWeight - Weight

Returns:

true, if successful

updateQuery

public boolean updateQuery(int nUserID,
                           java.lang.String strKeyword,
                           double dWeight)

Update query.

Parameters:

nUserID - User

strKeyword - Keyword

dWeight - Weight

Returns:

true, if successful

updateFileWeight

public boolean updateFileWeight(int nFileID,
                                double dWeight)

Update file.

Parameters:

nFileID - Upload

dWeight - Weight

Returns:

true, if successful

searchQuery

public java.sql.ResultSet searchQuery(int nUserID,
                                      FormattedDate minAge,
                                      FormattedDate maxAge,
                                      int nLimit)

Search query.

Parameters:

nUserID - User

nLimit - Limit

Returns:

Results

searchQuery

public java.sql.ResultSet searchQuery(int nUserID)

Search query.

Parameters:

nUserID - User

Returns:

Results

searchQueryByLanguage

public java.sql.ResultSet searchQueryByLanguage(int nUserID,
                                                int nLanguage)

Search query.

Parameters:

nUserID - User

nLanguage - Language

Returns:

Results

searchQueryByLanguage

public java.sql.ResultSet searchQueryByLanguage(int nUserID,
                                                int nLanguage,
                                                FormattedDate minAge,
                                                FormattedDate maxAge,
                                                int nLimit)

Search query.

Parameters:

nUserID - User

nLimit - Limit

nLanguage - Language

Returns:

Results