blackboard.cms.lrngobj
Class LOItemManager

java.lang.Object
  blackboard.cms.lrngobj.LOItemManager

public class LOItemManager
extends java.lang.Object

The LOItemManager provides methods for managing LOItems items. This class provides methods for loading, saving, deleting and some other convenience methods for managing LOItems items.

Since:

Bb CS 1.2

Version:

1.0

See Also:

LOItem

Constructor Summary

LOItemManager()

Method Summary

static void	deleteById(blackboard.persist.Id id) Delete a LOItem identified by the Id
static void	deleteById(blackboard.persist.Id id, java.sql.Connection con) Delete a LOItem identified by the Id using the supplied Connection
static java.util.List	loadAll() Load a List of all LOItems
static java.util.List	loadAll(java.sql.Connection con) Load a List of all LOItems using the supplied Connection
static java.util.List	loadByCategoryId(blackboard.persist.Id id) Load a List of LOItems based on a Category Id
static java.util.List	loadByCategoryId(blackboard.persist.Id id, java.sql.Connection con) Load a List of LOItems based on a Category Id using the Supplied Connection
static java.util.List	loadByCategoryIdAndStatus(blackboard.persist.Id id, LOItem.Status status) Load a List of LOItems based on a supplied Category Id and LOItem Status
static java.util.List	loadByCategoryIdAndStatus(blackboard.persist.Id id, LOItem.Status status, java.sql.Connection con) Load a List of LOItems based on a supplied Category Id and LOItem Status using a supplied Connection.
static java.util.List	loadByFileEntryPath(java.lang.String path) Load a List of LOItems by file path
static java.util.List	loadByFileEntryPath(java.lang.String path, java.sql.Connection con) Load a List of LOItems by file path using a supplied Connection
static LOItem	loadById(blackboard.persist.Id id) Load a LOItem item by Id
static LOItem	loadById(blackboard.persist.Id id, java.sql.Connection con) Load a LOItem item by Id using a supplied Connection
static java.util.List	loadByStatus(LOItem.Status status) Load a List of LOItems by Status
static java.util.List	loadByStatus(LOItem.Status status, java.sql.Connection con) Load a List of LOItems by Status using a supplied Connection
static java.util.List	loadUncategorized() Load a List of all uncategorized LOItems
static java.util.List	loadUncategorized(java.sql.Connection con) Load a List of all uncategorized LOItems using the Supplied Connection
static java.util.List	loadUncategorizedByStatus(LOItem.Status status) Load a List of uncategorized LOItems based on LOItem Status
static java.util.List	loadUncategorizedByStatus(LOItem.Status status, java.sql.Connection con) Load a List of uncategorized LOItems based on LOItem Status using the supplied connection
static java.util.List	loadWhereRecordDataContains(java.lang.String value) Load a List of LOItems using a pattern match on the Record Data Strings.
static java.util.List	loadWhereRecordDataContains(java.lang.String value, java.sql.Connection con) Load a List of LOItems using a pattern match on the Record Data Strings using the supplied Connection.
static java.util.List	loadWhereTitleStartsWith(java.lang.String value) Load a List of LOItems using a pattern match on the Title String.
static java.util.List	loadWhereTitleStartsWith(java.lang.String value, java.sql.Connection con) Load a List of LOItems using a pattern match on the Title String using a supplied Connection.
static void	save(LOItem item) Inserts or updates the LOItem.
static void	save(LOItem item, java.sql.Connection con) Inserts or updates the LOItem used the supplied Connection.

Methods inherited from class java.lang.Object

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

Constructor Detail

LOItemManager

public LOItemManager()

Method Detail

save

public static void save(LOItem item,
                        java.sql.Connection con)
                 throws blackboard.persist.PersistenceException

Inserts or updates the LOItem used the supplied Connection. After using any of the set methods on the LOItem object (e.g. setTitle(), setFileEntryPath()), call this save() method to persist the changes.

Parameters:

item -

con - a Connection to be used.

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

save

public static void save(LOItem item)
                 throws blackboard.persist.PersistenceException

Inserts or updates the LOItem. After using any of the set methods on the LOItem object (e.g. setTitle(), setFileEntryPath()), call this save() method to persist the changes.

Parameters:

item -

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

deleteById

public static void deleteById(blackboard.persist.Id id)
                       throws blackboard.persist.PersistenceException

Delete a LOItem identified by the Id

Parameters:

id - The Id of the LOItem to be deleted

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

deleteById

public static void deleteById(blackboard.persist.Id id,
                              java.sql.Connection con)
                       throws blackboard.persist.PersistenceException

Delete a LOItem identified by the Id using the supplied Connection

Parameters:

id - The Id of the LOItem to be deleted

con - The Connection to be used

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadById

public static LOItem loadById(blackboard.persist.Id id,
                              java.sql.Connection con)
                       throws blackboard.persist.PersistenceException

Load a LOItem item by Id using a supplied Connection

Parameters:

id - The Id of the LOItem to be loaded

con - the Connection to be used

Returns:

a LOItem Item

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadById

public static LOItem loadById(blackboard.persist.Id id)
                       throws blackboard.persist.PersistenceException

Load a LOItem item by Id

Parameters:

id - The Id of the LOItem to be loaded

Returns:

a LOItem Item

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByFileEntryPath

public static java.util.List loadByFileEntryPath(java.lang.String path,
                                                 java.sql.Connection con)
                                          throws blackboard.persist.PersistenceException

Load a List of LOItems by file path using a supplied Connection

Parameters:

path - The file entry path of the item to be loaded

con - the Connection to be used

Returns:

a LOItem Item

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByFileEntryPath

public static java.util.List loadByFileEntryPath(java.lang.String path)
                                          throws blackboard.persist.PersistenceException

Load a List of LOItems by file path

Parameters:

path - The file entry path of the item to be loaded

Returns:

a LOItem Item

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByStatus

public static java.util.List loadByStatus(LOItem.Status status,
                                          java.sql.Connection con)
                                   throws blackboard.persist.PersistenceException

Load a List of LOItems by Status using a supplied Connection

Parameters:

status - The LOItem status

con - the Connection to be used

Returns:

a List of LOItems with the LOItem.Status = status

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByStatus

public static java.util.List loadByStatus(LOItem.Status status)
                                   throws blackboard.persist.PersistenceException

Load a List of LOItems by Status

Parameters:

status - The LOItem status

Returns:

a List of LOItems with the LOItem.Status = status

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadWhereTitleStartsWith

public static java.util.List loadWhereTitleStartsWith(java.lang.String value,
                                                      java.sql.Connection con)
                                               throws blackboard.persist.PersistenceException

Load a List of LOItems using a pattern match on the Title String using a supplied Connection. The method will perform a search in the form "[value]%", where % represents all characters.

Note: This method will only return LOItems that have a status of APPROVED

Parameters:

value - A String representing all or part of a specific title for a LOItem

con - the Connection to be used

Returns:

a List of matching LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadWhereTitleStartsWith

public static java.util.List loadWhereTitleStartsWith(java.lang.String value)
                                               throws blackboard.persist.PersistenceException

Load a List of LOItems using a pattern match on the Title String. The method will perform a search in the form "[value]%", where % represents all characters.

Note: This method will only return LOItems that have a status of APPROVED

Parameters:

value - A String representing all or part of a specific title for a LOItem

Returns:

a List of matching LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadWhereRecordDataContains

public static java.util.List loadWhereRecordDataContains(java.lang.String value,
                                                         java.sql.Connection con)
                                                  throws blackboard.persist.PersistenceException

Load a List of LOItems using a pattern match on the Record Data Strings using the supplied Connection. The method will perform a search in the form "%[value]%", where % represents any characters on the following fields:
Title, Authors, Description, Keywords, Learning Objectives

Note: This method will only return LOItems that have a status of APPROVED

Parameters:

value - The string pattern/fragment/word that is searched for

con - the Connection to be used

Returns:

a List of matching LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadWhereRecordDataContains

public static java.util.List loadWhereRecordDataContains(java.lang.String value)
                                                  throws blackboard.persist.PersistenceException

Load a List of LOItems using a pattern match on the Record Data Strings. The method will perform a search in the form "%[value]%", where % represents any characters on the following fields:
Title, Authors, Description, Keywords, Learning Objectives

Note: This method will only return LOItems that have a status of APPROVED

Parameters:

value - The string pattern/fragment/word that is searched for

Returns:

a List of matching LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByCategoryIdAndStatus

public static java.util.List loadByCategoryIdAndStatus(blackboard.persist.Id id,
                                                       LOItem.Status status,
                                                       java.sql.Connection con)
                                                throws blackboard.persist.PersistenceException

Load a List of LOItems based on a supplied Category Id and LOItem Status using a supplied Connection.

Parameters:

id - Represents the LOCategory Id

status - Represents the status of the LOItem(s)

con - The Connection to be used

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByCategoryIdAndStatus

public static java.util.List loadByCategoryIdAndStatus(blackboard.persist.Id id,
                                                       LOItem.Status status)
                                                throws blackboard.persist.PersistenceException

Load a List of LOItems based on a supplied Category Id and LOItem Status

Parameters:

id - Represents the LOCategory Id

status - Represents the status of the LOItem(s)

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadUncategorizedByStatus

public static java.util.List loadUncategorizedByStatus(LOItem.Status status,
                                                       java.sql.Connection con)
                                                throws blackboard.persist.PersistenceException

Load a List of uncategorized LOItems based on LOItem Status using the supplied connection

Parameters:

status - Represents the status of the LOItem(s)

con - The Connection to be used

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadUncategorizedByStatus

public static java.util.List loadUncategorizedByStatus(LOItem.Status status)
                                                throws blackboard.persist.PersistenceException

Load a List of uncategorized LOItems based on LOItem Status

Parameters:

status - Represents the status of the LOItem(s)

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadUncategorized

public static java.util.List loadUncategorized(java.sql.Connection con)
                                        throws blackboard.persist.PersistenceException

Load a List of all uncategorized LOItems using the Supplied Connection

Parameters:

con - The Connection to be used

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadUncategorized

public static java.util.List loadUncategorized()
                                        throws blackboard.persist.PersistenceException

Load a List of all uncategorized LOItems

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByCategoryId

public static java.util.List loadByCategoryId(blackboard.persist.Id id,
                                              java.sql.Connection con)
                                       throws blackboard.persist.PersistenceException

Load a List of LOItems based on a Category Id using the Supplied Connection

Parameters:

id - Represents an Id from a LOCategory object

con - The Connection to be used

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadByCategoryId

public static java.util.List loadByCategoryId(blackboard.persist.Id id)
                                       throws blackboard.persist.PersistenceException

Load a List of LOItems based on a Category Id

Parameters:

id - Represents an Id from a LOCategory object

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadAll

public static java.util.List loadAll(java.sql.Connection con)
                              throws blackboard.persist.PersistenceException

Load a List of all LOItems using the supplied Connection

Parameters:

con - The Connection to be used

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2

loadAll

public static java.util.List loadAll()
                              throws blackboard.persist.PersistenceException

Load a List of all LOItems

Returns:

a List of LOItems

Throws:

blackboard.persist.PersistenceException

Since:

Bb CS 1.2