fi.paatti.paattidatabaseutils.dbservice.querydelegates
Class VoluntaryEventsDelegate
java.lang.Object
fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
fi.paatti.paattidatabaseutils.dbservice.querydelegates.VoluntaryEventsDelegate
- All Implemented Interfaces:
- com.vaadin.data.util.sqlcontainer.query.FreeformQueryDelegate, com.vaadin.data.util.sqlcontainer.query.FreeformStatementDelegate, Serializable
public class VoluntaryEventsDelegate
- extends PaattiQueryDelegate
- implements Serializable
Delegate for getting all voluntary events.
- Since:
- 0.0.3
- Author:
- Lauri Satokangas, lauri.n.satokangas@student.jyu.fi
- See Also:
- Serialized Form
-
-
|
Method Summary |
com.vaadin.data.util.sqlcontainer.query.generator.StatementHelper |
getQueryStatement(int offset,
int limit)
Returns a new StatementHelper containing the SELECT query statement. |
protected void |
setRowValues(PreparedStatement statement,
com.vaadin.data.util.sqlcontainer.RowItem row)
Sets the values for the row. |
int |
storeRow(Connection conn,
com.vaadin.data.util.sqlcontainer.RowItem row)
Stores a row in the database. |
| Methods inherited from class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate |
addNewiRowIdListener, fireNewRowIdEvent, getArrayAsStringWithAddedString, getArrayAsStringWithCommas, getArrayAsStringWithCommasAndWithoutIdColumn, getColumnNames, getContainsRowQueryStatement, getContainsRowQueryString, getCountQuery, getCountStatement, getFilters, getFilterStringWithoutWhere, getIdColumn, getInsertQueryString, getInsertQueryString, getOrderBys, getQueryString, getTableName, getUpdateQueryString, getUpdateQueryString, getValuesString, removeNewRowIdListener, removeRow, setFilters, setOrderBy |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
VoluntaryEventsDelegate
public VoluntaryEventsDelegate(Object userID)
- Constructor.
- Parameters:
userID - The id of the user whos events will be searched.
storeRow
public int storeRow(Connection conn,
com.vaadin.data.util.sqlcontainer.RowItem row)
throws SQLException
- Stores a row in the database.
Not in use.
- Specified by:
storeRow in interface com.vaadin.data.util.sqlcontainer.query.FreeformQueryDelegate- Specified by:
storeRow in class PaattiQueryDelegate
- Parameters:
conn - The database connection.row - The row where the values will be set.
- Returns:
- The number of affected rows in the database.
- Throws:
SQLException
setRowValues
protected void setRowValues(PreparedStatement statement,
com.vaadin.data.util.sqlcontainer.RowItem row)
throws SQLException
- Sets the values for the row.
Not in use.
- Specified by:
setRowValues in class PaattiQueryDelegate
- Parameters:
statement - The prepared statement where the values will be set.row - The row where the values will be taken from.
- Throws:
SQLException
getQueryStatement
public com.vaadin.data.util.sqlcontainer.query.generator.StatementHelper getQueryStatement(int offset,
int limit)
throws UnsupportedOperationException
- Returns a new StatementHelper containing the SELECT query statement. Gets
all the events that have -1 as their eventTimeID (eg. there is no
assigned event time), that are assigned to the user and have active row
status.
- Specified by:
getQueryStatement in interface com.vaadin.data.util.sqlcontainer.query.FreeformStatementDelegate
- Parameters:
offset - the starting row.limit - the number of rows to get.
- Returns:
- The StatementHelper containing the SELECT query.
- Throws:
UnsupportedOperationException
Copyright © 2012. All Rights Reserved.