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.column;
017    
018    import org.opengion.fukurou.model.NativeType;
019    import org.opengion.fukurou.util.ErrorMessage;
020    import org.opengion.fukurou.util.StringUtil;
021    import org.opengion.hayabusa.db.AbstractDBType;
022    import org.opengion.hayabusa.db.DBTypeCheckUtil;
023    
024    /**
025     * 蜊願ｧ呈焚蟄励? NUMBER 繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
026     *
027     * '0' ??'9' ,'-' 縺ｧ縺ｮ縺ｿ讒区?縺輔ｌ縺ｦ縺?ｋ謨ｰ蟄怜梛繧ｫ繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
028     * 縺輔ｉ縺ｫ縲√き繝ｳ繝?,'縺悟性縺ｾ繧後※縺?※繧?OK 縺ｨ縺励∪縺吶?縺溘□縺励?繝??繧ｿ縺九ｉ縺ｯ蜿悶ｊ髯､縺阪∪縺吶?
029     *
030     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
031     * 繝ｻ?撰ｽ橸ｼ吶♀繧医?繝槭う繝翫せ(-)繧定ｨｱ蜿ｯ
032     * 繝ｻ謨ｴ謨ｰ驛ｨ縺ｮ髟ｷ縺輔メ繧ｧ繝?け
033     * 繝ｻ隨ｦ蜿ｷ縺ｮ菴咲ｽｮ繝√ぉ繝?け
034     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
035     *
036     * @og.group 繝??繧ｿ螻樊?
037     *
038     * @version  4.0
039     * @author       Kazuhiko Hasegawa
040     * @since    JDK5.0,
041     */
042    public class DBType_S9 extends AbstractDBType {
043            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
044            private static final String VERSION = "5.6.0.3 (2012/01/24)" ;
045    
046            private static final String DEF_VALUE = "0" ;           // 繝??繧ｿ縺ｮ繝?ヵ繧ｩ繝ｫ繝亥?
047    
048            /**
049             * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
050             *
051             * @og.rev 4.0.0.0 (2005/01/31) type 蟒?ｭ｢
052             */
053            public DBType_S9() {
054                    super( DEF_VALUE );
055            }
056    
057            /**
058             * NATIVE縺ｮ蝙九?隴伜挨繧ｳ繝ｼ繝峨ｒ霑斐＠縺ｾ縺吶?
059             *
060             * @og.rev 3.5.4.7 (2004/02/06) 譁ｰ隕丈ｽ懈?
061             * @og.rev 4.1.1.2 (2008/02/28) Enum蝙?fukurou.model.NativeType)縺ｫ螟画峩
062             *
063             * @return  NATIVE縺ｮ蝙九?隴伜挨繧ｳ繝ｼ繝?DBType 縺ｧ隕丞ｮ?
064             * @see org.opengion.fukurou.model.NativeType
065             */
066            @Override
067            public NativeType getNativeType() {
068                    return NativeType.INT;
069            }
070    
071            /**
072             * 蜊願ｧ抵ｼ先枚蟄励?蝗ｺ螳夐聞縺ｧFILL蝓九ａ縺輔ｌ縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
073             * 縺ｪ縺翫?繧ｨ繝ｩ繝ｼ繝√ぉ繝?け縺ｯ陦後ｏ繧後∪縺帙ｓ縲?
074             * 螳溯｡悟燕縺ｫ縲∝ｿ?★ valueCheck( String value ,int len ) 縺瑚｡後ｏ繧後ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
075             *
076             * @og.rev 3.5.4.5 (2004/01/23) 繧ｨ繝ｳ繧ｳ繝ｼ繝画欠螳壹↓螟画峩縺励∪縺吶?
077             *
078             * @param       value    ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺吶ｋ譁?ｭ怜?
079             * @param       sizeX    謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
080             * @param       sizeY    蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
081             * @param   encode   蝗ｺ螳夐聞縺ｧ螟画鋤縺吶ｋ譁?ｭ励お繝ｳ繧ｳ繝ｼ繝?
082             *
083             * @return      ?ｦ?ｩ?ｬ?ｬ蝓九ａ縺励◆譁ｰ縺励＞譁?ｭ怜?
084             */
085            @Override
086            public String valueFill( final String value ,final int sizeX ,final int sizeY,final String encode ) {
087                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
088    
089                    // 豕ｨ諢?繝槭う繝翫せ險伜捷縺ｮ蜃ｦ逅?′縺ｾ縺?〒縺吶?
090                    return StringUtil.intFill( value,len );
091            }
092    
093            /**
094             * String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?繧定ｿ斐＠縺ｾ縺吶?
095             * 縺薙ｌ縺ｯ縲∬恭蟄励?蝣ｴ蜷?A,B,C 縺ｪ縺ｩ)縺ｯ縲。,C,D 縺ｮ繧医≧縺ｫ,譛?ｵよ｡√?譁?ｭ励さ繝ｼ繝峨ｒ
096             * ?具ｼ?縺励∪縺吶?
097             * 譁?ｭ怜?縺梧焚蟄励ち繧､繝励?蝣ｴ蜷医?, 謨ｰ蟄励↓螟画鋤縺励※縲?1 縺励∪縺吶?(譯∽ｸ翫′繧翫ｂ縺ゅｊ)
098             * 豺ｷ蝨ｨ繧ｿ繧､繝励?蝣ｴ蜷医?,譛?ｾ後?譯√□縺代ｒ遒ｺ隱阪＠縺ｦ ?具ｼ代＠縺ｾ縺吶?
099             * 蠑墓焚縺?null 縺ｮ蝣ｴ蜷医→縲√ぞ繝ｭ譁?ｭ怜?("")縺ｮ蝣ｴ蜷医?,迚ｩ逅?噪蛻晄悄險ｭ螳壼?(String getDefault())
100             * 縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
101             *
102             * @og.rev 4.0.0.0 (2005/01/31) Integer 竍?Long 縺ｫ螟画峩
103             *
104             * @param       value   String蠑墓焚縺ｮ譁?ｭ怜?
105             *
106             * @return      String蠑墓焚縺ｮ譁?ｭ怜?繧抵ｼ具ｼ代＠縺滓枚蟄怜?
107             */
108            @Override
109            public String valueAdd( final String value ) {
110                    if( value == null || value.length() == 0 ) { return getDefault(); }
111                    long val = Long.parseLong( value ) ;
112    
113                    return ( String.valueOf( val + 1L ) );
114            }
115    
116            /**
117             * String蠑墓焚縺ｮ譁?ｭ怜?縺ｫ縲∫ｬｬ?貞ｼ墓焚縺ｫ謖?ｮ壹?譁?ｭ怜?(謨ｰ蟄励?譌･莉倡ｭ?繧貞刈邂励＠縺ｦ霑斐＠縺ｾ縺吶?
118             *
119             * 縺薙％縺ｧ縺ｯ縲∵焚蟄玲枚蟄怜?縺ｫ縲∝挨縺ｮ謨ｰ蟄玲枚蟄怜?繧貞刈邂励＠縺ｾ縺吶?
120             * 蜀?Κ蜃ｦ逅?↓縲〕ong 繧剃ｽｿ逕ｨ縺励※縺?∪縺吶?
121             *
122             * @og.rev 5.6.0.3 (2012/01/24) ADD 縺ｫ縲∝ｼ墓焚縺ｮ蛟､繧貞刈邂励☆繧区ｩ溯?繧定ｿｽ蜉?＠縺ｾ縺吶?
123             *
124             * @param   value  String蠑墓焚
125             * @param   add    蜉?ｮ励☆繧区焚蟄玲枚蟄怜?
126             *
127             * @return  蠑墓焚縺ｮ譁?ｭ怜?縺ｫ謨ｰ蟄励ｒ蜉?ｮ励＠縺ｾ縺吶?
128             */
129            @Override
130            public String valueAdd( final String value,final String add ) {
131                    if( value == null || value.length() == 0 ) { return getDefault(); }
132    
133                    long addSu = 1L;
134                    if( add != null && !add.isEmpty() ) {
135                            addSu = Long.parseLong( add );
136                    }
137    
138                    long val = Long.parseLong( value ) + addSu ;
139    
140                    return String.valueOf( val );
141            }
142    
143            /**
144             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
145             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
146             * 萓九∴縺ｰ,螟ｧ譁?ｭ励?縺ｿ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↑繧峨?螟ｧ譁?ｭ怜喧縺励∪縺吶?
147             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
148             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
149             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
150             *
151             * @og.rev 3.3.3.0 (2003/07/09) 蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺?※縺翫￥縲?
152             * @og.rev 3.3.3.1 (2003/07/18) 蠕後ｍ繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺上?(StringUtil#rTrim)
153             * @og.rev 3.8.5.3 (2006/08/07) 蜈磯?繧ｼ繝ｭ繧ｵ繝励Ξ繧ｹ蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
154             *
155             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
156             *
157             * @return      菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
158             */
159            @Override
160            public String valueSet( final String value ) {
161                    if( value == null || value.length() == 0 ) { return ""; }
162                    return StringUtil.lTrim0( StringUtil.deleteChar( value,',' ) );
163            }
164    
165            /**
166             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
167             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
168             *
169             * @og.rev 2.3.1.4 (2003/02/18) 螻樊?繝√ぉ繝?け繧貞ｼｷ蛹悶＠縺溘?
170             * @og.rev 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧貞ｼ墓焚縺ｫ霑ｽ蜉?
171             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
172             *
173             * @param   key         繧ｭ繝ｼ
174             * @param   value       蛟､
175             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
176             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
177             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
178             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
179             *
180             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
181             */
182    //      public ErrorMessage valueCheck( final String key ,final String value ,
183    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
184            @Override
185            public ErrorMessage valueCheck( final String key ,final String value ,
186                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
187    
188                    ErrorMessage msg = new ErrorMessage();
189                    if( value == null || value.length() == 0 ) { return msg; }
190    
191                    String check;
192    
193                    check = DBTypeCheckUtil.numberFormatCheck( value );
194                    if( check != null ) {
195                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
196                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
197                    }
198    
199                    check = DBTypeCheckUtil.sizeXCheck( value ,sizeX ,sizeY );
200                    if( check != null ) {
201                            // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
202                            msg.addMessage( 0, ErrorMessage.NG, "ERR0006", key, value, check, String.valueOf( sizeX ) );
203                    }
204    
205                    check = DBTypeCheckUtil.decimalCodeCheck( value );
206                    if( check != null ) {
207                            // 隨ｦ蜿ｷ縺ｮ菴咲ｽｮ縺御ｸ肴ｭ｣縺ｧ縺吶?
208                            msg.addMessage( 0, ErrorMessage.NG, "ERR0023", key, check );
209                    }
210    
211                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
212                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
213                    if( check != null ) {
214                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
215                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
216                    }
217    
218                    return msg;
219            }
220    }