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 }