Keyword Search

{{toc}}

h1. Specification

h1. Activity Diagram

!FlowChart.jpg!

h1. Programming Guide

h2. Jar version 

|_. version |_. Description  |

| 1.0       | Init           |

h2. Jar File Download

"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>

h1. Methods

h2. Maintenance 

<pre>

com.cosway.keyword.service.KeywordService service = new com.cosway.keyword.service.KeywordService();

</pre>

h3. Keyword

<pre>

boolean              added      = addKeyword(Connection conn, String keyword)

boolean              updated    = updateKeywordStatus(Connection conn, int keywordRefNo, String status)

Map<Integer, String> KeywordMap = getKeywordAInActiveMap(Connection conn) 

Map<Integer, String> KeywordMap = getKeywordAllMap(Connection conn)

Map<Integer, String> KeywordMap = getKeywordPrefixMap(Connection conn, String search)

Map<Integer, String> KeywordMap = getKeywordwildcardMap(Connection conn, String search)

</pre>

h3. Product

<pre>

boolean                        added      = addProductKeyword(Connection conn, KeywordBean keyword)

boolean                        updated    = updateProductStatus(Connection conn, int productRefNo, String status)

Map<Integer, Set<KeywordBean>> productMap = getProductKeywordMap(Connection conn)

Set<KeywordBean>               productSet = getProductKeywordSetByProductRefNo(Connection conn, int productRefNo)

Set<Integer>                   productSet = getProductSetByStatus(Connection conn, String status)

</pre>

h3. Add product Keyword

<pre>

boolean added = addProductPattern(Connection conn, PurchaseBean bean)

</pre>

h3. Search

<pre>

Set<Integer>          productSet = getProductListByType(Connection conn, SearchBean searchBean)

Map<Integer, Integer> productMap = getProductRefNoByLevel(Connection conn, SearchBean searchBean)

</pre>