gov.nasa.pds.tracking.tracking.db

Class SubmissionAndStatusDao

java.lang.Object

gov.nasa.pds.tracking.tracking.db.DBConnector

gov.nasa.pds.tracking.tracking.db.SubmissionAndStatusDao

public class SubmissionAndStatusDao
extends DBConnector

Author:

danyu dan.yu@jpl.nasa.gov

Field Summary

Fields

Modifier and Type	Field and Description
static String	COMMENTCOLUME
static String	DEL_IDENTIFIERCOLUME
static String	EMAILCOLUME
static org.apache.log4j.Logger	logger
static String	STATUSCOLUME
static String	STATUSDATECOLUME
static String	SUBMISSIONDATECOLUME

Fields inherited from class gov.nasa.pds.tracking.tracking.db.DBConnector

ARCHIVE_STATUS_TABLE_NAME, CERTIFICATION_STATUS_TABLE_NAME, ISO_BASIC, NSSDCA_STATUS_TABLE_NAME

Constructor Summary

Constructors

Constructor and Description
SubmissionAndStatusDao()

Method Summary

Modifier and Type	Method and Description
List<SubmissionAndStatus>	getDeliveryStatus(String identifier)
List<SubmissionAndStatus>	getSubmissionsAndStatusList()
int	insertSubmissionAndStatus(SubmissionAndStatus subMS)
int	insertSubmissionStatus(SubmissionAndStatus subMS)
SubmissionAndStatus	updateSubmissionStatus(SubmissionAndStatus subMS)

Methods inherited from class gov.nasa.pds.tracking.tracking.db.DBConnector

getConnection

Methods inherited from class java.lang.Object

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

Field Detail

logger

public static org.apache.log4j.Logger logger

DEL_IDENTIFIERCOLUME

public static String DEL_IDENTIFIERCOLUME

SUBMISSIONDATECOLUME

public static String SUBMISSIONDATECOLUME

STATUSDATECOLUME

public static final String STATUSDATECOLUME

See Also:

Constant Field Values

STATUSCOLUME

public static final String STATUSCOLUME

See Also:

Constant Field Values

EMAILCOLUME

public static final String EMAILCOLUME

See Also:

Constant Field Values

COMMENTCOLUME

public static final String COMMENTCOLUME

See Also:

Constant Field Values

Constructor Detail

SubmissionAndStatusDao

public SubmissionAndStatusDao()
                       throws ClassNotFoundException,
                              SQLException

Throws:

ClassNotFoundException

SQLException

Method Detail

getSubmissionsAndStatusList

public List<SubmissionAndStatus> getSubmissionsAndStatusList()

getDeliveryStatus

public List<SubmissionAndStatus> getDeliveryStatus(String identifier)

insertSubmissionAndStatus

public int insertSubmissionAndStatus(SubmissionAndStatus subMS)

Parameters:

deliveryIdentifier -

subDateTime -

insertSubmissionStatus

public int insertSubmissionStatus(SubmissionAndStatus subMS)

updateSubmissionStatus

public SubmissionAndStatus updateSubmissionStatus(SubmissionAndStatus subMS)