com.silverpeas.wysiwyg.dynamicvalue.dao
Class DynamicValueDAO

java.lang.Object
  com.silverpeas.wysiwyg.dynamicvalue.dao.DynamicValueDAO

public class DynamicValueDAO
extends Object

data access object layer, this class allows executing operation on the table which contains the dynamic values

Constructor Summary

DynamicValueDAO()

Method Summary

static List<DynamicValue>	getAllValidDynamicValue(Connection conn) gets a list of DynamicValue object.
static DynamicValue	getValidDynamicValue(Connection conn, String id) gets a dynamic value object by his ID.
static List<DynamicValue>	searchValidDynamicValue(Connection conn, String criterion) realizes a search by criterion.Only the value with a valid start and end date will be returned.

Methods inherited from class java.lang.Object

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

Constructor Detail

DynamicValueDAO

public DynamicValueDAO()

Method Detail

getValidDynamicValue

public static DynamicValue getValidDynamicValue(Connection conn,
                                                String id)
                                         throws SQLException

gets a dynamic value object by his ID. Only the value with a valid start and end date will be returned

Parameters:

conn - connection object to access database

id - DynamicValue object identifier

Returns:

a DynamicValue object

Throws:

SQLException - whether a SQl error occurred during the process

getAllValidDynamicValue

public static List<DynamicValue> getAllValidDynamicValue(Connection conn)
                                                  throws SQLException

gets a list of DynamicValue object. Only the value with a valid start and end date will be returned

Parameters:

conn - connection object to access database

Returns:

a list of DynamicValue object

Throws:

SQLException - whether a SQl error occurred during the process

searchValidDynamicValue

public static List<DynamicValue> searchValidDynamicValue(Connection conn,
                                                         String criterion)
                                                  throws SQLException

realizes a search by criterion.Only the value with a valid start and end date will be returned. The search is realized on key column

Parameters:

conn - connection object to access database

criterion - String used to realize the search

Returns:

a list of DynamicValue object corresponding to the search criterion

Throws:

SQLException - whether a SQl error occurred during the process