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 >= 0xff65 && c <= 0xff9f ) を有効ã¨ã—ã¾ã™ã?
027     *
028     * タイプãƒã‚§ãƒ?‚¯ã¨ã—ã¦ã€ä»¥ä¸‹ã?æ¡ä»¶ã‚’判定ã—ã¾ã™ã?
029     * ・æ–?­—å?é•·ã¯ã€Byteæ›ç®—ã§ã®æ–?­—æ•°ã¨ã®æ¯”è¼?
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    }