public class ProductDao extends DBConnector
Modifier and Type | Field and Description |
---|---|
static String |
ALTERNATECOLUMN |
static String |
IDENTIFIERCOLUMN |
static String |
INSTREFCOLUMN |
static String |
INSTTITLECOLUMN |
static String |
INVESTREFCOLUMN |
static String |
INVESTTITLECOLUMN |
static org.apache.log4j.Logger |
logger |
static String |
NODEREFCOLUMN |
static String |
NODETITLECOLUMN |
static String |
TITLECOLUMN |
static String |
TYPECOLUMN |
static String |
VERSIONCOLUMN |
ARCHIVE_STATUS_TABLE_NAME, CERTIFICATION_STATUS_TABLE_NAME, ISO_BASIC, NSSDCA_STATUS_TABLE_NAME
Constructor and Description |
---|
ProductDao() |
Modifier and Type | Method and Description |
---|---|
Product |
getProduct(String idf,
String ver) |
List<Product> |
getProducts(String type)
Product Query - Query the product table for a list of products by type.
|
List<Product> |
getProductsAssociatedAllTypeReferencesOrderByTitle(String instRef,
String investRef,
String nodeRef) |
List<Product> |
getProductsAssociatedDeliveriesOrderByTitle(String instRef,
String investRef)
Product Delivery Query - Query the product, delivery and *_reference
tables for a list of products that have associated deliveries.
|
List<Product> |
getProductsOrderByTitle() |
List<Product> |
getProductsWithLatestReleases(String instRef,
String investRef,
String nodeRef) |
List<Product> |
getProductsWithStatus() |
int |
insertProduct(Product prod) |
Product |
updateProduct(Product prod) |
getConnection
public static org.apache.log4j.Logger logger
public static final String IDENTIFIERCOLUMN
public static final String VERSIONCOLUMN
public static final String TITLECOLUMN
public static final String TYPECOLUMN
public static final String ALTERNATECOLUMN
public static final String INVESTREFCOLUMN
public static final String INVESTTITLECOLUMN
public static final String INSTREFCOLUMN
public static final String INSTTITLECOLUMN
public static final String NODEREFCOLUMN
public static final String NODETITLECOLUMN
public ProductDao() throws ClassNotFoundException, SQLException
ClassNotFoundException
SQLException
public List<Product> getProducts(String type)
type
- (can be null)public List<Product> getProductsOrderByTitle()
public List<Product> getProductsAssociatedDeliveriesOrderByTitle(String instRef, String investRef)
public Product getProduct(String idf, String ver)
logical
- identifierversion
- public List<Product> getProductsAssociatedAllTypeReferencesOrderByTitle(String instRef, String investRef, String nodeRef)
public int insertProduct(Product prod)
prod
- - an object of productpublic List<Product> getProductsWithStatus()
Copyright © 2019. All rights reserved.