com.solidstategroup.sitetracker.data
Class DocumentDownloadData

java.lang.Object
  extended by com.solidstategroup.data.DataAccess
      extended by com.solidstategroup.data.FilteredDataAccess
          extended by com.solidstategroup.sitetracker.data.DocumentDownloadData

public class DocumentDownloadData
extends FilteredDataAccess

DocumentDownloadData


Field Summary
static java.lang.String COLNAME_DATE
           
static java.lang.String COLNAME_DOCUMENT_ID
           
static java.lang.String COLNAME_USER_ID
           
static java.lang.String COLUMN_LIST
           
static java.lang.String DOCUMENT_SQL
           
static java.lang.String DOCUMENT_SQL_GROUP
           
static java.lang.String DOCUMENT_SQL_ORDER
           
static java.lang.String SELECT_BY_COUNT
           
static java.lang.String SELECT_BY_ROW
           
static java.lang.String TABLENAME
           
 
Fields inherited from class com.solidstategroup.data.DataAccess
connection, DATA_NO, DATA_YES, NULL_VALUE, ORDER_BY_COUNT, SQL_COUNT, SQL_LIMIT
 
Constructor Summary
DocumentDownloadData(java.sql.Connection connection)
           
 
Method Summary
protected  java.util.Collection configFilter(DataFilter filter, java.lang.StringBuffer stmt)
           
protected  java.lang.Object extractData(java.sql.ResultSet rs)
           
 java.util.Collection getDownloadDocuments(DocumentDownloadFilter filter)
           
protected  java.lang.String getSelectByRow()
           
protected  java.lang.String getSelectCount()
           
static void insertDownload(int documentId, User user)
           
 
Methods inherited from class com.solidstategroup.data.FilteredDataAccess
countByFilter, findByFilter
 
Methods inherited from class com.solidstategroup.data.DataAccess
createEqualClause, createGreaterClause, createGreaterEqualClause, createInClause, createInt, createLessClause, createLessEqualClause, createLikeClause, findByPrimaryKey, getConnection, getCount, getDate, getInt, getResultSet, getRows, insertSql, setConnection, setDate, setInt, updateSql
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

COLNAME_DOCUMENT_ID

public static final java.lang.String COLNAME_DOCUMENT_ID
See Also:
Constant Field Values

COLNAME_DATE

public static final java.lang.String COLNAME_DATE
See Also:
Constant Field Values

COLNAME_USER_ID

public static final java.lang.String COLNAME_USER_ID
See Also:
Constant Field Values

COLUMN_LIST

public static final java.lang.String COLUMN_LIST
See Also:
Constant Field Values

TABLENAME

public static final java.lang.String TABLENAME
See Also:
Constant Field Values

SELECT_BY_ROW

public static final java.lang.String SELECT_BY_ROW
See Also:
Constant Field Values

SELECT_BY_COUNT

public static final java.lang.String SELECT_BY_COUNT
See Also:
Constant Field Values

DOCUMENT_SQL

public static final java.lang.String DOCUMENT_SQL
See Also:
Constant Field Values

DOCUMENT_SQL_GROUP

public static final java.lang.String DOCUMENT_SQL_GROUP
See Also:
Constant Field Values

DOCUMENT_SQL_ORDER

public static final java.lang.String DOCUMENT_SQL_ORDER
See Also:
Constant Field Values
Constructor Detail

DocumentDownloadData

public DocumentDownloadData(java.sql.Connection connection)
Method Detail

getDownloadDocuments

public java.util.Collection getDownloadDocuments(DocumentDownloadFilter filter)

configFilter

protected java.util.Collection configFilter(DataFilter filter,
                                            java.lang.StringBuffer stmt)
Specified by:
configFilter in class FilteredDataAccess

insertDownload

public static void insertDownload(int documentId,
                                  User user)

getSelectByRow

protected java.lang.String getSelectByRow()
Specified by:
getSelectByRow in class FilteredDataAccess

getSelectCount

protected java.lang.String getSelectCount()
Specified by:
getSelectCount in class FilteredDataAccess

extractData

protected java.lang.Object extractData(java.sql.ResultSet rs)
                                throws java.sql.SQLException
Specified by:
extractData in class DataAccess
Throws:
java.sql.SQLException