Keyword Search

Wiki » History » Revision 5

Revision 4 (Soh Keong, 06/11/2021 04:44 PM) → Revision 5/28 (Soh Keong, 06/11/2021 04:51 PM)

{{toc}} 

 h1. Specification 

 h1. Activity Diagram 
 !FlowChart.jpg! 

 h1. Programming Guide 

 h2. Jar version  

 |_. version |_. Description    | 
 | 1.0         | Init             | 

 h2. Jar File Download 

 "Jar":/redmine/attachments/download/602/lib.rar 
 "Lib":/redmine/attachments/download/602/lib.rar "Jar": 

 h2. Database Table 

 <pre> 
 CREATE TABLE KEYWORD_PRODUCT ( 
	 KEYWORD_REF_NO INTEGER NOT NULL, 
	 KEYWORD VARCHAR(50) NOT NULL, 
	 STATUS VARCHAR(2) DEFAULT 'A',  
	 CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP, 
	 PRIMARY KEY (KEYWORD_REF_NO)) 

 CREATE UNIQUE INDEX UI_PROD_KEYWORD ON KEYWORD_PRODUCT(KEYWORD) 
 </pre> 

 <pre> 
 CREATE TABLE KEYWORD_PRODUCT_PATTERN ( 
	 PRODUCT_REF_NO INTEGER NOT NULL, 
	 KEYWORD_REF_NO INTEGER NOT NULL, 
	 PRIORITY INTEGER, 
	 STATUS VARCHAR(2) DEFAULT 'A',  
	 CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP, 
	 PRIMARY KEY (PRODUCT_REF_NO,KEYWORD_REF_NO)) 
	
 CREATE INDEX IX_KEYWORD_PRODUCT_PATTERN_PRIO ON KEYWORD_PRODUCT_PATTERN(PRIORITY) 
 CREATE INDEX IX_KEYWORD_PRODUCT_PATTERN_STATUS ON KEYWORD_PRODUCT_PATTERN(STATUS) 
 </pre> 

 <pre> 
 CREATE TABLE KEYWORD_SEARCH_PRODUCT ( 
	 PRODUCT_REF_NO INTEGER NOT NULL, 
	 SHOPPER_REF_NO INTEGER NOT NULL, 
	 SEARCH_TYPE VARCHAR(5) NOT NULL,  
	 CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP, 
	 PRIMARY KEY (PRODUCT_REF_NO,SHOPPER_REF_NO,SEARCH_TYPE)) 
	
 CREATE INDEX IX_KEYWORD_SEARCH_PRODUCT_MODI ON KEYWORD_SEARCH_PRODUCT(MODIFY_DATETIME) 
 </pre> 

 <pre> 
 CREATE TABLE KEYWORD_SEARCH_PATTERN ( 
	 SHOPPER_REF_NO INTEGER NOT NULL, 
	 KEYWORD_REF_NO INTEGER NOT NULL, 
	 PRIORITY INTEGER NOT NULL, 
	 CREATE_DATETIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
	 MODIFY_DATETIME TIMESTAMP, 
	 PRIMARY KEY (SHOPPER_REF_NO, KEYWORD_REF_NO, PRIORITY)) 

 CREATE INDEX IX_KEYWORD_SEARCH_PATTERN_MODIFY ON KEYWORD_SEARCH_PATTERN(MODIFY_DATETIME) 
 </pre> 

 h2. h1. Methods 

 h3. Keyword 

 h2. Maintenance  

 <pre> 
 com.cosway.keyword.service.KeywordService service = new com.cosway.keyword.service.KeywordService(); 
 </pre> 

 h3. Keyword 

 <pre> 
 boolean                added        = service.addKeyword(Connection addKeyword(Connection conn, String keyword) 
 boolean                updated      = service.updateKeywordStatus(Connection updateKeywordStatus(Connection conn, int keywordRefNo, String status) 
 Map<Integer, String> KeywordMap = service.getKeywordAInActiveMap(Connection getKeywordAInActiveMap(Connection conn)  
 Map<Integer, String> KeywordMap = service.getKeywordAllMap(Connection getKeywordAllMap(Connection conn) 
 Map<Integer, String> KeywordMap = service.getKeywordPrefixMap(Connection getKeywordPrefixMap(Connection conn, String search) 
 Map<Integer, String> KeywordMap = service.getKeywordwildcardMap(Connection getKeywordwildcardMap(Connection conn, String search) 
 </pre> 

 h3. Product 

 <pre> 
 com.cosway.keyword.service.ProductService service = new com.cosway.keyword.service.ProductService(); 
 </pre> 

 <pre> 
 boolean                          added        = service.addProductKeyword(Connection addProductKeyword(Connection conn, KeywordBean keyword) 
 boolean                          updated      = service.updateProductStatus(Connection updateProductStatus(Connection conn, int productRefNo, String status) 
 Map<Integer, Set<KeywordBean>> productMap = service.getProductKeywordMap(Connection getProductKeywordMap(Connection conn) 
 Set<KeywordBean>                 productSet = service.getProductKeywordSetByProductRefNo(Connection getProductKeywordSetByProductRefNo(Connection conn, int productRefNo) 
 Set<Integer>                     productSet = service.getProductSetByStatus(Connection getProductSetByStatus(Connection conn, String status) 
 </pre> 

 h3. Add product Keyword 

 <pre> 
 com.cosway.keyword.service.PurchaseService service = new com.cosway.keyword.service.PurchaseService(); 
 </pre> 

 <pre> 
 boolean added = service.addProductPattern(Connection addProductPattern(Connection conn, PurchaseBean bean) 
 </pre> 

 h3. Search 

 <pre> 
 com.cosway.keyword.service.SearchService service = new com.cosway.keyword.service.SearchService(); 
 </pre> 

 <pre> 
 Set<Integer>            productSet = service.getProductListByType(Connection getProductListByType(Connection conn, SearchBean searchBean) 
 Map<Integer, Integer> productMap = service.getProductRefNoByLevel(Connection getProductRefNoByLevel(Connection conn, SearchBean searchBean) 
 </pre>