001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.plugin.query;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.db.DBConstValue;
020    
021    /**
022     * 繝??繧ｿ繝吶?繧ｹ逋ｻ骭ｲ譎ゅ↓縲∝崋螳壼?繧ｫ繝ｩ繝??險ｭ螳壹ｒ陦後≧諠??繧堤ｮ｡逅?☆繧九け繝ｩ繧ｹ縺ｧ縺吶?
023     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲；rowingMIS Ver6逕ｨ縺ｮ邂｡逅?け繝ｩ繧ｹ縺ｧ縺吶?
024     * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲?
025     *     迚ｩ逅?EQ     SEQxxxx   (xxxx縺ｯ繝??繝悶Ν蜷?
026     *     菴懈?譌･譎?   DYSET
027     *     菴懈??ｰ?ｧ    PGSET
028     *     菴懈?隕ｪ?ｰ?ｧ  PGPSET
029     *     菴懈?遉ｾ蜩｡    USRSET
030     *     譖ｴ譁ｰ譌･譎?   DYUPD
031     *     譖ｴ譁ｰ?ｰ?ｧ    PGUPD
032     *     譖ｴ譁ｰ隕ｪ?ｰ?ｧ  PGPUPD
033     *     譖ｴ譁ｰ遉ｾ蜩｡    USRUPD
034     * 縺ｪ縺ｩ縺ｮ諠??繧偵?INSERT縲ゞPDATE 縺ｮ迥ｶ豕√↓蠢懊§縺ｦ謠蝉ｾ帙＠縺ｾ縺吶?
035     * INSERT 縺ｫ縺ｯ縲√☆縺ｹ縺ｦ縺ｮ諠??(XXUPD)縺ｫ繧ょ?繧偵そ繝?ヨ縺励∪縺吶?
036     * 縺薙ｌ縺ｯ縲ゞPDATE 縺輔ｌ縺滓律莉倥ｄ譎ょ綾縺ｧ縲∽ｸ?ｦｧ讀懃ｴ｢縺ｧ縺阪ｋ繧医≧縺ｫ縺吶ｋ轤ｺ縺ｧ縲?
037     * null 縺ｫ縺励※縺翫￥縺ｨ縲！S NULL 縺ｧ蝠上＞蜷医ｏ縺帙ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
038     * INSERT 繝??繧ｿ縺?￠蜿門?縺吝?蜷医?縲仝HERE DYSET = DYUPD 縺ｨ縺励∪縺吶?
039     * 縺ｾ縺溘? 迚ｩ逅?EQ縺ｯ縲ヾEQxxxx(xxxx縺ｯ繝??繝悶Ν蜷?蠖｢蠑上?繧ｫ繝ｩ繝?錐縺ｨ縺励?
040     * 蛟､縺ｯ縲ヾEQxxxxS01.NEXTVAL 縺ｨ縺励∪縺吶?
041     *
042     * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縺ｯ縲√ユ繝ｼ繝悶Ν蜷阪?繝ｦ繝ｼ繧ｶ繝ｼID,逕ｻ髱｢ID 繧貞女縺大叙繧翫∪縺吶?
043     * 逋ｻ骭ｲ譎ょ綾縺ｯ縲√％縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医′逕滓?縺輔ｌ縺滓凾髢薙ｒ騾壼ｸｸ縺ｯ菴ｿ逕ｨ縺励∪縺吶?
044     * 繝??繝悶Ν蜷阪ｒ貂｡縺吶?縺ｯ縲√Ρ繝ｼ繧ｯ縺ｪ縺ｩ縲√ユ繝ｼ繝悶Ν蜊倅ｽ阪↓蜃ｦ逅?☆繧九き繝ｩ繝?′
045     * 逡ｰ縺ｪ繧九?縺ｧ縲√◎繧後∈縺ｮ蟇ｾ蠢懊〒縺吶?
046     * 蜃ｦ逅?′邁｡邏?喧縺ｧ縺阪ｋ繧医≧縺ｫ縲√Ν繝ｼ繝ｫ繧定ｦ丞ｮ壹☆縺ｹ縺阪〒縺吶?
047     *
048     * @og.rev 5.5.1.8 (2012/04/17) 譁ｰ隕剰ｿｽ蜉?
049     * @og.group 繝??繧ｿ逋ｻ骭ｲ
050     *
051     * @version  5.5
052     * @author   Kazuhiko Hasegawa
053     * @since    JDK7.0,
054     */
055    public class DBConstValue_VV implements DBConstValue {
056            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
057            private static final String VERSION = "5.5.1.8 (2012/04/17)" ;
058    
059    //      private static final String[] MSTR_INSKEYS =
060    //              new String[] { "DYSET","PGSET","PGPSET","USRSET","DYUPD","PGUPD","PGPUPD","USRUPD" };
061    
062            private static final String[] MSTR_UPDKEYS =
063                    new String[] { "DYUPD","PGUPD","PGPUPD","USRUPD" };
064    
065            private static final String[] ZERO = new String[0] ;
066    
067            private String[] insKeys = ZERO;
068            private String[] insVals = ZERO;
069    
070            private String[] updKeys = ZERO;
071            private String[] updVals = ZERO;
072    
073            /**
074             * 蛻晄悄蛹匁ュ蝣ｱ繧定ｨｭ螳壹＠縺ｾ縺吶?
075             *
076             * @param       table   繝??繝悶Ν蜷?
077             * @param       user    繝ｦ繝ｼ繧ｶ繝ｼID
078             * @param       gamen   逕ｻ髱｢ID
079             */
080            public void init( final String table, final String user, final String gamen ) {
081                    if( isUseClm( table ) ) {
082                            String userID  = "'" + user + "'";
083                            String gamenID = "'" + gamen + "'";
084                            String timestamp = "'" + HybsSystem.getDate( "yyyyMMddHHmmss" ) + "'" ;
085                            String seqID   = "SEQ" + table ;
086                            String seqFanc = "SEQ" + table + "S01.NEXTVAL" ;
087    
088    //                      insKeys = MSTR_INSKEYS;
089                            insKeys = new String[] { seqID, "DYSET","PGSET","PGPSET","USRSET","DYUPD","PGUPD","PGPUPD","USRUPD" };
090                            insVals = new String[] {
091                                                             seqFanc                // SEQ鬆伜沺縺ｮ髢｢謨ｰ
092                                                            ,timestamp              // DYSET
093                                                            ,gamenID                // PGSET
094                                                            ,gamenID                // PGPSET
095                                                            ,userID                 // USRSET
096                                                            ,timestamp              // DYUPD
097                                                            ,gamenID                // PGUPD
098                                                            ,gamenID                // PGPUPD
099                                                            ,userID                 // USRUPD
100                            };
101    
102                            updKeys = MSTR_UPDKEYS;
103                            updVals = new String[] {
104                                                             timestamp              // DYUPD
105                                                            ,gamenID                // PGUPD
106                                                            ,gamenID                // PGPUPD
107                                                            ,userID                 // USRUPD
108                            };
109                    }
110            }
111    
112            /**
113             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
114             *
115             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
116             *
117             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
118             */
119            public String[] getInsertKeys() {
120                    return insKeys.clone();
121            }
122    
123            /**
124             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
125             *
126             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
127             *
128             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
129             */
130            public String[] getInsertVals() {
131                    return insVals.clone();
132            }
133    
134            /**
135             * 繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
136             *
137             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
138             *
139             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
140             */
141            public String[] getUpdateKeys() {
142                    return updKeys.clone();
143            }
144    
145            /**
146             * 繧｢繝??繝??繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
147             *
148             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
149             *
150             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
151             */
152            public String[] getUpdateVals() {
153                    return updVals.clone();
154            }
155    
156            /**
157             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
158             *
159             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
160             *
161             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
162             */
163            public String[] getLogicalDeleteKeys() {
164                    return ZERO;
165            }
166    
167            /**
168             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
169             *
170             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
171             *
172             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
173             */
174            public String[] getLogicalDeleteVals() {
175                    return ZERO;
176            }
177    
178            /**
179             * 繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°繧呈ｱｺ繧√ｋ繝ｭ繧ｸ繝?け
180             *
181             * 繝??繝悶Ν蜷阪′蟄伜惠縺励※縺?ｌ縺ｰ縲∝茜逕ｨ蜿ｯ閭ｽ縺ｨ蛻､譁ｭ縺励∪縺吶?
182             * 縺薙ｌ縺ｯ縲∝ｱ･豁ｴ繝??繝悶Ν縺ｪ縺ｩ縲√％縺ｮ蜃ｦ逅?ｒ菴ｿ繧上↑縺??蜷医↓縲?
183             * 繝??繝悶Ν蜷阪°繧牙愛螳壹☆繧句?蜷医↓菴ｿ縺?∪縺吶?迴ｾ譎らせ縺ｧ縺ｯ縲∝ｱ･豁ｴ繝??繝悶Ν縺ｯ
184             * 繝輔Ξ繝ｼ繝?Ρ繝ｼ繧ｯ蛛ｴ縺ｧ螟画峩縺吶ｋ縺ｮ縺ｧ縺ｯ縺ｪ縺上?繝医Μ繧ｬ遲峨↓繧医ｋ閾ｪ蜍募庶髮?→
185             * 縺励∪縺吶?縺ｧ縲∝愛螳壼ｯｾ雎｡縺ｨ縺励※縺?∪縺帙ｓ縲?
186             *
187             * @param       table   繝??繝悶Ν蜷?
188             *
189             * @return      繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°(true:繧ｫ繝ｩ繝?ｒ逕滓?/false:繧ｫ繝ｩ繝??逕滓?縺励↑縺?
190             */
191            private boolean isUseClm( final String table ) {
192                    boolean flag = ( table != null && table.length() > 0 ) ;
193    
194                    return flag ;
195            }
196    }