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.fukurou.util.StringUtil;
020    import org.opengion.fukurou.util.KanaFilter;
021    import org.opengion.hayabusa.db.AbstractDBType;
022    import org.opengion.hayabusa.db.DBTypeCheckUtil;
023    
024    /**
025     * 蜊願ｧ?蜈ｨ隗呈ｷｷ蝨ｨ縺ｮ繧ｯ繝ｩ繧ｹ縺ｧ縺吶′縲∝濠隗偵き繧ｿ繧ｫ繝翫?縺ｿ繧帝?縺輔↑縺?枚蟄怜?繧呈桶縺?ぜ縺ｮ縲√き繝ｩ繝?ｱ樊?繧貞ｮ夂ｾｩ縺励∪縺吶?
026     *
027     * 蜊願ｧ偵き繧ｿ繧ｫ繝翫?螳夂ｾｩ縺ｯ縲―uFF61 縺九ｉ \uFF9F 縺ｾ縺ｧ縺ｧ縺吶?
028     * 蜊願ｧ偵き繧ｿ繧ｫ繝翫ｒ蜈･蜉帙☆繧九→縲∝?隗偵き繧ｿ繧ｫ繝翫↓螟画鋤縺励※縲∫匳骭ｲ縺励※縺?∪縺吶?
029     * 縺薙?螟画鋤蜃ｦ逅?↓縲゜anaFilter#han2zen 繧剃ｽｿ逕ｨ縺励※縺?∪縺吶?縺薙ｌ縺ｯ縲?
030     * 縲擦JKV譌･荳ｭ髻楢ｶ頑ュ蝣ｱ蜃ｦ逅??縺ｮ繝輔ぅ繝ｫ繧ｿ繝ｼ繧｢繝ｫ繧ｴ繝ｪ繧ｺ繝?〒豼∫せ繧?濠豼∫せ縺ｮ豁｣縺励＞蜃ｦ逅?ｂ蜷ｫ縺ｾ繧後※縺?∪縺吶?
031     *
032     * 繧ｿ繧､繝励メ繧ｧ繝?け縺ｨ縺励※縲∽ｻ･荳九?譚｡莉ｶ繧貞愛螳壹＠縺ｾ縺吶?
033     * 繝ｻ譁?ｭ怜?髟ｷ縺ｯ縲。yte謠帷ｮ励〒縺ｮ譁?ｭ玲焚縺ｨ縺ｮ豈碑ｼ?
034     * 繝ｻ蜊願ｧ呈枚蟄暦ｼ句?隗偵き繧ｿ繧ｫ繝翫メ繧ｧ繝?け縲慶 &lt; 0x20 || ( c &gt;= 0xff61 &amp;&amp; c &lt;= 0xff9f )莉･螟悶?繧ｨ繝ｩ繝ｼ
035     * 繝ｻ譁?ｭ励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ 豁｣隕剰｡ｨ迴ｾ繝√ぉ繝?け
036     * 繝ｻ繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ繝√ぉ繝?け
037     *
038     * @og.rev 3.4.0.0 (2003/09/01) 譁ｰ隕丈ｽ懈?
039     * @og.group 繝??繧ｿ螻樊?
040     *
041     * @version  4.0
042     * @author   Kazuhiko Hasegawa
043     * @since    JDK5.0,
044     */
045    public class DBType_XKZ extends AbstractDBType {
046            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
047            private static final String VERSION = "5.2.2.0 (2010/11/01)" ;
048    
049            /**
050             * 繧ｨ繝?ぅ繧ｿ繝ｼ縺ｧ邱ｨ髮?＆繧後◆繝??繧ｿ繧堤匳骭ｲ縺吶ｋ蝣ｴ蜷医↓縲√ョ繝ｼ繧ｿ縺昴?繧ゅ?繧?
051             * 螟画鋤縺励※縲∝ｮ溽匳骭ｲ繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
052             * 萓九∴縺ｰ,螟ｧ譁?ｭ励?縺ｿ縺ｮ繝輔ぅ繝ｼ繝ｫ繝峨↑繧峨?螟ｧ譁?ｭ怜喧縺励∪縺吶?
053             * 螳溽匳骭ｲ繝??繧ｿ縺ｮ菴懈?縺ｯ縲．BType 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ蛻ｩ逕ｨ縺励∪縺吶?縺ｧ,
054             * 縺薙ｌ縺ｨ Editor 縺ｨ縺後い繝ｳ繝槭ャ繝√?蝣ｴ蜷医?縲√≧縺ｾ縺上ョ繝ｼ繧ｿ螟画鋤
055             * 縺輔ｌ縺ｪ縺?庄閭ｽ諤ｧ縺後≠繧翫∪縺吶?縺ｧ縲∵ｳｨ諢城｡倥＞縺ｾ縺吶?
056             *
057             * @param       value   (荳?握縺ｫ邱ｨ髮?ョ繝ｼ繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺溘ョ繝ｼ繧ｿ)
058             *
059             * @return  菫ｮ豁｣蠕後?譁?ｭ怜?(荳?握縺ｫ繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ)
060             */
061            @Override
062            public String valueSet( final String value ) {
063                    if( value == null ) { return null; }
064                    return KanaFilter.han2zen( StringUtil.rTrim( value ) );
065            }
066    
067            /**
068             * 繝??繧ｿ縺檎匳骭ｲ蜿ｯ閭ｽ縺九←縺?°繧偵メ繧ｧ繝?け縺励∪縺吶?
069             * 繝??繧ｿ縺後お繝ｩ繝ｼ縺ｮ蝣ｴ蜷医?縲√◎縺ｮ繧ｨ繝ｩ繝ｼ蜀?ｮｹ繧定ｿ斐＠縺ｾ縺吶?
070             *
071             * @og.rev 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧貞ｼ墓焚縺ｫ霑ｽ蜉?
072             * @og.rev 5.2.2.0 (2010/11/01) 蜴ｳ蟇?↓繝√ぉ繝?け(isStrict=true)縺吶ｋ繝輔Λ繧ｰ繧定ｿｽ蜉?
073             *
074             * @param   key         繧ｭ繝ｼ
075             * @param   value       蛟､
076             * @param   sizeX       謨ｴ謨ｰ驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
077             * @param   sizeY       蟆第焚驛ｨ蛻??譁?ｭ怜?縺ｮ髟ｷ縺?
078             * @param   typeParam   dbType 繝代Λ繝｡繝ｼ繧ｿ
079             * @param   isStrict    蜴ｳ蟇?↓繝√ぉ繝?け縺吶ｋ縺九←縺?°[true:縺吶ｋ/false:讓呎ｺ也噪]
080             *
081             * @return  繧ｨ繝ｩ繝ｼ蜀?ｮｹ
082             */
083    //      public ErrorMessage valueCheck( final String key ,final String value ,
084    //                                                                      final int sizeX ,final int sizeY ,final String param ) {
085            @Override
086            public ErrorMessage valueCheck( final String key ,final String value ,
087                                                                            final int sizeX ,final int sizeY ,final String typeParam ,final boolean isStrict) {
088    
089                    ErrorMessage msg = new ErrorMessage();
090                    if( value == null || value.length() == 0 ) { return msg; }
091    
092                    int len = (sizeY == 0) ? sizeX : sizeX + sizeY + 1;
093                    String check = DBTypeCheckUtil.byteLengthCheck( value,len );
094                    if( check != null ) {
095                            // 譁?ｭ怜?縺ｮ髟ｷ縺輔′謖?ｮ壹?髟ｷ縺輔ｈ繧翫ｂ髟ｷ縺?〒縺吶?
096                            msg.addMessage( 0,ErrorMessage.NG,"ERR0006",key,value,check,String.valueOf( len ) );
097                    }
098    
099                    StringBuilder val = new StringBuilder();
100                    boolean isError = false;
101                    for( int i=0; i<value.length(); i++ ) {
102                            char ch = value.charAt( i );
103                            if( ch < 0x20 || ( ch >= 0xff61 && ch <= 0xff9f ) ) {
104                                    val.append( "<span class=\"NG\">" ).append( ch ).append( "</span>" );
105                                    isError = true;
106                            }
107                            else {
108                                    val.append( ch );
109                            }
110                    }
111                    if( isError ) {
112                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
113                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,val.toString() );
114                    }
115    
116                    // 3.6.0.0 (2004/09/22) dbType 繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺励◆繝槭ャ繝√メ繧ｧ繝?け
117                    check = DBTypeCheckUtil.matcheCheck( value,typeParam );
118                    if( check != null ) {
119                            // 謖?ｮ壹?譁?ｭ嶺ｻ･螟悶?譁?ｭ励′菴ｿ繧上ｌ縺ｦ縺?∪縺吶?
120                            msg.addMessage( 0,ErrorMessage.NG,"ERR0009", key,check );
121                    }
122    
123                    // 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ蟇ｾ遲厄ｼ?<', '>' 縺ｯ逋ｻ骭ｲ縺輔○縺ｪ縺??
124                    msg = xssCheck( key ,value, msg );
125    
126                    return msg;
127            }
128    }