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     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲｀IS繧ｷ繧ｹ繝?Β蜈ｱ騾壹?邂｡逅?け繝ｩ繧ｹ縺ｧ縺吶?
024     * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲?
025     *     譖ｴ譁ｰ繝輔Λ繧ｰ  FGJ
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     *
040     * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ縺ｧ縺ｯ縲√ユ繝ｼ繝悶Ν蜷阪?繝ｦ繝ｼ繧ｶ繝ｼID,逕ｻ髱｢ID 繧貞女縺大叙繧翫∪縺吶?
041     * 逋ｻ骭ｲ譎ょ綾縺ｯ縲√％縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医′逕滓?縺輔ｌ縺滓凾髢薙ｒ騾壼ｸｸ縺ｯ菴ｿ逕ｨ縺励∪縺吶?
042     * 繝??繝悶Ν蜷阪ｒ貂｡縺吶?縺ｯ縲√Ρ繝ｼ繧ｯ縺ｪ縺ｩ縲√ユ繝ｼ繝悶Ν蜊倅ｽ阪↓蜃ｦ逅?☆繧九き繝ｩ繝?′
043     * 逡ｰ縺ｪ繧九?縺ｧ縲√◎繧後∈縺ｮ蟇ｾ蠢懊〒縺吶?
044     * 蜃ｦ逅?′邁｡邏?喧縺ｧ縺阪ｋ繧医≧縺ｫ縲√Ν繝ｼ繝ｫ繧定ｦ丞ｮ壹☆縺ｹ縺阪〒縺吶?
045     *
046     * @og.rev 4.3.7.5 (2009/07/08) 譁ｰ隕剰ｿｽ蜉?
047     * @og.group 繝??繧ｿ逋ｻ骭ｲ
048     *
049     * @version  4.0
050     * @author   Kazuhiko Hasegawa
051     * @since    JDK5.0,
052     */
053    public class DBConstValue_GF implements DBConstValue {
054            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
055            private static final String VERSION = "4.3.7.5 (2009/07/08)" ;
056    
057            private static final String[] MSTR_INSKEYS =
058                    new String[] { "FGJ","DYSET","DYUPD","USRSET","USRUPD","PGSET","PGUPD","PGPSET","PGPUPD" };
059    
060            private static final String[] MSTR_UPDKEYS =
061                    new String[] { "FGJ","DYUPD","USRUPD","PGUPD","PGPUPD" };
062    
063            private static final String[] MSTR_LOGDELKEYS = // 4.3.7.0 (2009/06/01)
064                    new String[] { "FGJ","DYUPD","USRUPD","PGUPD","PGPUPD" };
065    
066            private static final String[] ZERO = new String[0] ;
067    
068            private String[] insKeys = ZERO;
069            private String[] insVals = ZERO;
070    
071            private String[] updKeys = ZERO;
072            private String[] updVals = ZERO;
073    
074            private String[] logDelKeys = ZERO; // 4.3.7.0 (2009/06/01)
075            private String[] logDelVals = ZERO; // 4.3.7.0 (2009/06/01)
076    
077            /**
078             * 蛻晄悄蛹匁ュ蝣ｱ繧定ｨｭ螳壹＠縺ｾ縺吶?
079             *
080             * @param       table   繝??繝悶Ν蜷?
081             * @param       user    繝ｦ繝ｼ繧ｶ繝ｼID
082             * @param       gamen   逕ｻ髱｢ID
083             */
084            public void init( final String table, final String user, final String gamen ) {
085                    init( table, user, gamen, "" );
086            }
087    
088            /**
089             * 蛻晄悄蛹匁ュ蝣ｱ繧定ｨｭ螳壹＠縺ｾ縺吶?
090             *
091             * @param       table   繝??繝悶Ν蜷?
092             * @param       user    繝ｦ繝ｼ繧ｶ繝ｼID
093             * @param       gamen   逕ｻ髱｢ID
094             * @param       pgamen  隕ｪ逕ｻ髱｢ID
095             */
096            public void init( final String table, final String user, final String gamen, final String pgamen ) {
097                    if( isUseClm( table ) ) {
098                            String userID    = "'" + user + "'";
099                            String gamenID   = "'" + gamen + "'";
100                            String pgamenID  = "'" + pgamen + "'";
101                            String timestamp = "'" + HybsSystem.getDate( "yyyyMMddHHmmss" ) + "'" ;
102    
103                            insKeys = MSTR_INSKEYS;
104                            insVals = new String[] {
105                                                             "'1'"                  // FGJ
106                                                            ,timestamp              // DYSET
107                                                            ,timestamp              // DYUPD
108                                                            ,userID                 // USRSET
109                                                            ,userID                 // USRUPD
110                                                            ,gamenID                // PGSET
111                                                            ,gamenID                // PGUPD
112                                                            ,pgamenID               // PGPSET
113                                                            ,pgamenID               // PGPUPD
114                            };
115    
116                            updKeys = MSTR_UPDKEYS;
117                            updVals = new String[] {
118                                                             "'1'"                  // FGJ
119                                                            ,timestamp              // DYUPD
120                                                            ,userID                 // USRUPD
121                                                            ,gamenID                // PGUPD
122                                                            ,pgamenID               // PGPUPD
123                            };
124    
125                            // 4.3.7.0 (2009/06/01)
126                            logDelKeys = MSTR_LOGDELKEYS;
127                            logDelVals = new String[] {
128                                                             "'9'"                  // FGJ
129                                                            ,timestamp              // DYUPD
130                                                            ,userID                 // USRUPD
131                                                            ,gamenID                // PGUPD
132                                                            ,pgamenID               // PGPUPD
133                            };
134                    }
135            }
136    
137            /**
138             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
139             *
140             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
141             *
142             * @og.rev 4.3.1.1 (2008/08/23) 螟画峩蜿ｯ閭ｽ縺ｪ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜿ら?繧堤峩謗･霑斐＆縺ｪ縺?ｈ縺?↓縺励∪縺吶?
143             *
144             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?(髱柤ull)
145             */
146            public String[] getInsertKeys() {
147    //              return insKeys ;
148                    return insKeys.clone();
149            }
150    
151            /**
152             * 繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
153             *
154             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
155             *
156             * @og.rev 4.3.1.1 (2008/08/23) 螟画峩蜿ｯ閭ｽ縺ｪ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜿ら?繧堤峩謗･霑斐＆縺ｪ縺?ｈ縺?↓縺励∪縺吶?
157             *
158             * @return      繧､繝ｳ繧ｵ繝ｼ繝医☆繧句?蜷医?蛟､驟榊?(髱柤ull)
159             */
160            public String[] getInsertVals() {
161    //              return insVals ;
162                    return insVals.clone();
163            }
164    
165            /**
166             *繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
167             *
168             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
169             *
170             * @og.rev 4.3.1.1 (2008/08/23) 螟画峩蜿ｯ閭ｽ縺ｪ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜿ら?繧堤峩謗･霑斐＆縺ｪ縺?ｈ縺?↓縺励∪縺吶?
171             *
172             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
173             */
174            public String[] getUpdateKeys() {
175    //              return updKeys ;
176                    return updKeys.clone();
177            }
178    
179            /**
180             * 繧｢繝??繝??繝医☆繧句?蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
181             *
182             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
183             *
184             * @og.rev 4.3.1.1 (2008/08/23) 螟画峩蜿ｯ閭ｽ縺ｪ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜿ら?繧堤峩謗･霑斐＆縺ｪ縺?ｈ縺?↓縺励∪縺吶?
185             *
186             * @return      繧｢繝??繝??繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
187             */
188            public String[] getUpdateVals() {
189    //              return updVals ;
190                    return updVals.clone();
191            }
192    
193            /**
194             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?繧ｭ繝ｼ驟榊?繧定ｿ斐＠縺ｾ縺吶?
195             *
196             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
197             *
198             * @og.rev 4.3.7.0 (2009/06/01) 譁ｰ隕丈ｽ懈?
199             *
200             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
201             */
202            public String[] getLogicalDeleteKeys() {
203                    return logDelKeys.clone();
204            }
205    
206            /**
207             * 繝?Μ繝ｼ繝?隲也炊蜑企勁) 縺吶ｋ蝣ｴ蜷医?蛟､驟榊?繧定ｿ斐＠縺ｾ縺吶?
208             *
209             * 謖?ｮ壹?蛟､縺後↑縺代ｌ縺ｰ縲?聞縺輔ぞ繝ｭ驟榊?繧定ｿ斐＠縺ｾ縺吶?
210             *
211             * @og.rev 4.3.7.0 (2009/06/01) 譁ｰ隕丈ｽ懈?
212             *
213             * @return      繝?Μ繝ｼ繝医☆繧句?蜷医?繧ｭ繝ｼ驟榊?(髱柤ull)
214             */
215            public String[] getLogicalDeleteVals() {
216    //              return updVals ;
217                    return logDelVals.clone();
218            }
219    
220            /**
221             * 繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°繧呈ｱｺ繧√ｋ繝ｭ繧ｸ繝?け
222             *
223             * 繝??繝悶Ν蜷阪ｈ繧翫?繝ｭ繧ｸ繝?け逧?↓蟆弱″蜃ｺ縺励∪縺吶?
224             *
225             * @param       table   繝??繝悶Ν蜷?
226             *
227             * @return      繧ｫ繝ｩ繝?ｒ霑斐☆縺九←縺?°(true:繧ｫ繝ｩ繝?ｒ逕滓?/false:繧ｫ繝ｩ繝??逕滓?縺励↑縺?
228             */
229            private boolean isUseClm( final String table ) {
230                    boolean flag = ( table != null ) ;
231    
232                    return flag ;
233            }
234    }