Project

General

Profile

Actions

Wiki » History » Revision 3

« Previous | Revision 3/28 (diff) | Next »
Soh Keong, 06/11/2021 04:20 PM


Specification

Activity Diagram

Programming Guide

Jar version

version Description
1.0 Init

Jar File Download

"Jar":

Database Table

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

Methods

Maintenance

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

Keyword

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)

Updated by Soh Keong over 3 years ago · 3 revisions