com.stratelia.silverpeas.portlet.model
Class PortletColumnTable

java.lang.Object
  com.stratelia.webactiv.util.AbstractTable<PortletColumnRow>
      com.stratelia.silverpeas.portlet.model.PortletColumnTable

public class PortletColumnTable
extends AbstractTable<PortletColumnRow>

Field Summary

protected static String

PORTLETCOLUMN_COLUMNS The column list used for every select query.

Fields inherited from class com.stratelia.webactiv.util.AbstractTable

schema

Constructor Summary

PortletColumnTable(Schema schema)
Builds a new PortletColumnTable

Method Summary

int	create(PortletColumnRow portletColumn) Inserts in the database a new PortletColumn row.
void	delete(int id) Deletes thePortletColumnRow. after having removed all the reference to it.
PortletColumnRow[]	dereferenceSpaceId(int spaceId) Removes a reference to SpaceId
protected PortletColumnRow	fetchRow(ResultSet rs) Fetch the current PortletColumn row from a resultSet.
PortletColumnRow[]	getAllBySpaceId(int spaceId) Returns all the PortletColumnRow having a given spaceId
PortletColumnRow[]	getAllBySpaceId(int aSpaceId, String orderField) Returns all the PortletColumn rows having a given spaceId
PortletColumnRow[]	getAllRows() Returns all the rows.
PortletColumnRow	getPortletColumn(int id) Returns the unique PortletColumn row having a given id
PortletColumnRow	getPortletColumn(String query) Returns the unique row given by a no parameters query.
PortletColumnRow[]	getPortletColumns(String query) Returns all the rows given by a no parameters query.
protected void	prepareInsert(String insertQuery, PreparedStatement insert, PortletColumnRow row) Prepares the statement to insert the given row
protected void	prepareUpdate(String updateQuery, PreparedStatement update, PortletColumnRow row) Prepares the statement to update the given row
void	save(PortletColumnRow portletColumn) Updates thePortletColumn row. or inserts it if new.
void	update(PortletColumnRow portletColumn) Update the given PortletColumnRow

Methods inherited from class com.stratelia.webactiv.util.AbstractTable

aliasColumns, getInteger, getInteger, getMatchingRows, getNextId, getRows, getRows, getRows, getRows, getRows, getRows, getRows, getUniqueRow, getUniqueRow, getUniqueRow, getUniqueRow, getUniqueRow, getUniqueRow, getUniqueRow, insertRow, truncate, updateRelation, updateRelation, updateRow

Methods inherited from class java.lang.Object

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

Field Detail

PORTLETCOLUMN_COLUMNS

protected static final String PORTLETCOLUMN_COLUMNS

The column list used for every select query.

See Also:

Constant Field Values

Constructor Detail

PortletColumnTable

public PortletColumnTable(Schema schema)

Builds a new PortletColumnTable

Method Detail

getPortletColumn

public PortletColumnRow getPortletColumn(int id)
                                  throws UtilException

Returns the unique PortletColumn row having a given id

Throws:

UtilException

getAllBySpaceId

public PortletColumnRow[] getAllBySpaceId(int aSpaceId,
                                          String orderField)
                                   throws UtilException

Returns all the PortletColumn rows having a given spaceId

Throws:

UtilException

getAllBySpaceId

public PortletColumnRow[] getAllBySpaceId(int spaceId)
                                   throws UtilException

Returns all the PortletColumnRow having a given spaceId

Throws:

UtilException

getAllRows

public PortletColumnRow[] getAllRows()
                              throws UtilException

Returns all the rows.

Throws:

UtilException

getPortletColumn

public PortletColumnRow getPortletColumn(String query)
                                  throws UtilException

Returns the unique row given by a no parameters query.

Throws:

UtilException

getPortletColumns

public PortletColumnRow[] getPortletColumns(String query)
                                     throws UtilException

Returns all the rows given by a no parameters query.

Throws:

UtilException

create

public int create(PortletColumnRow portletColumn)
           throws UtilException

Inserts in the database a new PortletColumn row.

Throws:

UtilException

update

public void update(PortletColumnRow portletColumn)
            throws UtilException

Update the given PortletColumnRow

Throws:

UtilException

save

public void save(PortletColumnRow portletColumn)
          throws UtilException

Updates thePortletColumn row. or inserts it if new.

Throws:

UtilException

delete

public void delete(int id)
            throws UtilException

Deletes thePortletColumnRow. after having removed all the reference to it.

Throws:

UtilException

dereferenceSpaceId

public PortletColumnRow[] dereferenceSpaceId(int spaceId)
                                      throws UtilException

Removes a reference to SpaceId

Throws:

UtilException

fetchRow

protected PortletColumnRow fetchRow(ResultSet rs)
                             throws SQLException

Fetch the current PortletColumn row from a resultSet.

Specified by:

fetchRow in class AbstractTable<PortletColumnRow>

Throws:

SQLException

prepareUpdate

protected void prepareUpdate(String updateQuery,
                             PreparedStatement update,
                             PortletColumnRow row)
                      throws SQLException

Prepares the statement to update the given row

Specified by:

prepareUpdate in class AbstractTable<PortletColumnRow>

Throws:

SQLException

prepareInsert

protected void prepareInsert(String insertQuery,
                             PreparedStatement insert,
                             PortletColumnRow row)
                      throws SQLException

Prepares the statement to insert the given row

Specified by:

prepareInsert in class AbstractTable<PortletColumnRow>

Throws:

SQLException