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.util.ErrorMessage;
019    import org.opengion.hayabusa.db.AbstractDBType;
020    import org.opengion.hayabusa.db.DBTypeCheckUtil;
021    
022    /**
023     * 譌ｧOAS縺ｧ螳溯｣?＠縺ｦ縺?◆縲∝濠隗呈枚蟄?繧ｫ繝雁性繧?蜷咲ｧｰ逕ｨ險伜捷繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
024     *
025     * 菴ｿ逕ｨ蜿ｯ閭ｽ譁?ｭ励?縲∝濠隗定恭謨ｰ螟ｧ蟆乗枚蟄?繧ｹ繝壹?繧ｹ,蜊願ｧ偵き繧ｿ繧ｫ繝??･,+,-,(,),*,#,/,.,% 縺ｧ縺吶?(,縺ｯ蜷ｫ縺ｿ縺ｾ縺帙ｓ)
026     * 蜊願ｧ偵き繧ｿ繧ｫ繝翫?Unicode遽?峇縺ｯ縲?c &gt;= 0xff65 &amp;&amp; c &lt;= 0xff9f ) 繧呈怏蜉ｹ縺ｨ縺励∪縺吶?
027     *
028     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
029     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲。yte謠帷ｮ励〒縺ｮ譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
030     * 繝ｻ蜊願ｧ呈枚蟄暦ｼ句濠隗偵き繧ｿ繧ｫ繝奇ｼ狗音谿雁錐遘ｰ繝√ぉ繝?け
031     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
032     *
033     * @og.rev 3.8.0.2 (2005/07/11) 譁ｰ隕丈ｽ懈?
034     * @og.group 繝??繧ｿ螻樊?
035     *
036     * @version  4.0
037     * @author   Kazuhiko Hasegawa
038     * @since    JDK5.0,
039     */
040    public class DBType_OASNM extends AbstractDBType {
041            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
042            private static final String VERSION = "5.2.2.0 (2010/11/01)" ;
043    
044            private static final String OAS_NAME = "+-()*#/.%" ;
045    
046            /**
047             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
048             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
049             *
050             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
051             *
052             * @param   key         繧ｭ繝ｼ
053             * @param   value       蛟､
054             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
055             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
056             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
057             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
058             *
059             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
060             */
061    //      public ErrorMessage valueCheck( final String key ,final String value ,
062    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
063            @Override
064            public ErrorMessage valueCheck( final String key ,final String value ,
065                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
066    
067                    ErrorMessage msg = new ErrorMessage();
068                    if( value == null || value.length() == 0 ) { return msg; }
069    
070                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
071                    String check = DBTypeCheckUtil.byteLengthCheck( value,len );
072                    if( check != null ) {
073                            // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
074                            msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,check,String.valueOf( len ) );
075                    }
076    
077                    StringBuilder val = new StringBuilder();
078                    boolean isError = false;
079                    for( int i=0; i<value.length(); i++ ) {
080                            char ch = value.charAt( i );
081                            boolean okFlag = (  (ch >= '0' && ch <= '9' ) || (ch >= 'A' && ch <= 'Z' ) ||
082                                                                    (ch >= 'a' && ch <= 'z' ) || ( OAS_NAME.indexOf( ch ) >= 0 ) ||
083                                                                    (ch >= 0xff65 && ch <= 0xff9f ) || ch == ' ' );
084    
085                            if( okFlag ) {
086                                    val.append( ch );
087                            }
088                            else {
089                                    val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
090                                    isError = true;
091                            }
092                    }
093                    if( isError ) {
094                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
095                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
096                    }
097    
098                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
099                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
100                    if( check != null ) {
101                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
102                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
103                    }
104    
105                    return msg;
106            }
107    }