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 }