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.hayabusa.taglib;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    
021    import org.opengion.fukurou.util.StringUtil;
022    import static org.opengion.fukurou.util.StringUtil.nval ;
023    
024    /**
025     * Where蜿･繧剃ｽ懈?縺吶ｋ縺溘ａ縺ｮ譚｡莉ｶ繧呈欠螳壹＠縺ｾ縺吶?
026     *
027     * 縺薙?繧ｿ繧ｰ縺ｮvalue 蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医?縺昴?繝ｪ繧ｯ繧ｨ繧ｹ繝亥?縺?
028     * 縺ｪ縺??蜷医?縲√％縺ｮ繧ｿ繧ｰ縺昴?繧ゅ?縺後↑縺ｫ繧ょ?蜉帙＠縺ｾ縺帙ｓ縲?縺､縺ｾ繧頑擅莉ｶ縺九ｉ豸医∴縺ｾ縺吶?)
029     * startKey縺ｯ縲」alue 繧帝?邨舌☆繧句?蜷医?鬆ｭ縺ｫ鄂ｮ縺九ｌ繧区枚蟄怜?縺ｧ縲『here蜿･縺ｮ譛??縺ｫ縺ｯ陦ｨ遉ｺ縺輔ｌ縺壹?
030     * 縺昴ｌ莉･髯阪↓縺､縺?※縲∬｡ｨ遉ｺ縺輔ｌ縺ｾ縺吶?(縺､縺ｾ繧翫?where VALUE1 and VALUE2 and VALUE3 窶ｦ 縺ｧ縺吶?)
031     * startKey 縺ｮ蛻晄悄蛟､縺ｯ縲?and" 縺ｧ縺吶?
032     * multi 縺ｯ縲＋&#064;XXXX} 螟画焚縺ｫ縲∝?縺瑚､?焚蜷ｫ縺ｾ繧後※縺?ｋ蝣ｴ蜷医?蜃ｦ逅?ｒ隕丞ｮ壹＠縺ｾ縺吶?
033     * 隍?焚縺ｮ蛟､縺ｨ縺ｯ縲∝酔荳?ame縺ｧ繝√ぉ繝?け繝懊ャ繧ｯ繧ｹ謖?ｮ壹ｄ縲√Γ繝九Η繝ｼ縺ｧ縺ｮ隍?焚謖?ｮ壹＠縺溷?蜷医?
034     * 繝ｪ繧ｯ繧ｨ繧ｹ繝医′驟榊?縺ｧ騾√ｉ繧後∪縺吶?multi="true" 縺ｨ縺吶ｋ縺ｨ縲?xx1','xx2','xx3', ?･?･?･ 縺ｨ縺?≧
035     * 蠖｢蠑上↓螟画鋤縺輔ｌ縺ｾ縺吶?
036     * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲?where PN in ( {&#064;PN} )" 縺ｨ縺?≧譁?ｭ怜?縺ｫ蟇ｾ縺励※縲?
037     * "where PN in ( 'xx1','xx2','xx3' )" 繧剃ｽ懈?縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
038     * multi 縺ｮ蛻晄悄蛟､縺ｯ縲?false" 縺ｧ縺吶?
039     * SystemData 縺ｮ USE_SQL_INJECTION_CHECK 縺?true 縺九?quotCheck 螻樊?縺?true 縺ｮ蝣ｴ蜷医?縲?
040     * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲也畑縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?繝ｪ繧ｯ繧ｨ繧ｹ繝亥ｼ墓焚縺ｫ
041     * 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(')縺悟性縺ｾ繧後ｋ縺ｨ縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
042     * 蜷梧ｧ倥↓USE_XSS_CHECK縺荊rue縺九?xssCheck螻樊?縺荊rue縺ｮ蝣ｴ蜷医?縲?
043     * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｹ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?縺溘ａless/greater than sign縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
044     *
045     * 蜷?ｱ樊?縺ｯ縲＋&#064;XXXX} 螟画焚縺御ｽｿ逕ｨ縺ｧ縺阪∪縺吶?
046     * 縺薙ｌ縺ｯ縲ヾervletRequest 縺九ｉ縲々XXX 繧偵く繝ｼ縺ｫ蛟､繧貞叙繧雁?縺?縺薙?螟画焚縺ｫ蜑ｲ繧雁ｽ薙※縺ｾ縺吶?
047     * 縺､縺ｾ繧翫?縺薙?XXXX繧偵く繝ｼ縺ｫ繝ｪ繧ｯ繧ｨ繧ｹ繝医☆繧後?縲√％縺ｮ螟画焚縺ｫ蛟､繧偵そ繝?ヨ縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
048     *
049     * @og.formSample
050     * 笳丞ｽ｢蠑擾ｼ?lt;og:and startKey="[and|or|窶ｦ]" value="窶ｦ" multi="[false|true]" /&gt;
051     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
052     *
053     * 笳週ag螳夂ｾｩ??
054     *   &lt;og:and
055     *       startKey           縲慎AG縲全QL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)
056     *       value              縲慎AG縲第擅莉ｶ縺ｮ蛟､繧?繧ｻ繝?ヨ縺励∪縺?
057     *       multi              縲慎AG縲題､?焚縺ｮ蠑墓焚縺ｫ蟇ｾ縺励※蜃ｦ逅?☆繧九°縺ｩ縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
058     *       separator          縲慎AG縲僧ulti 繧｢繧ｯ繧ｷ繝ｧ繝ｳ譎ゅ?譁?ｭ怜?繧貞?蜑ｲ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?
059     *       quotCheck          縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[=true])
060     *       instrVals          縲慎AG縲代せ繝壹?繧ｹ縺ｧ蛹ｺ蛻?ｉ繧後◆隍?焚縺ｮ蛟､縺吶∋縺ｦ繧貞性繧?擅莉ｶ繧剃ｽ懈?縺励∪縺?
061     *       instrType          縲慎AG縲訴nstrVals縺ｧ隍?焚縺ｮ蛟､繧呈擅莉ｶ縺ｫ縺吶ｋ髫帙?譁ｹ豕輔ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)
062     *       xssCheck           縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_XSS_CHECK[=true])
063     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
064     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
065     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
066     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
067     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
068     *   &gt;   ... Body ...
069     *   &lt;/og:and&gt;
070     *
071     * 笳丈ｽｿ逕ｨ萓?
072     *     &lt;og:query command="NEW"&gt;
073     *             select PN,YOBI,NMEN,HINM from XX01
074     *         &lt;og:where&gt;
075     *             &lt;og:and value="PN   =    '{&#064;PN}'"    /&gt;
076     *             &lt;og:and value="YOBI like '{&#064;YOBI}%'" /&gt;
077     *         &lt;/og:where&gt;
078     *             order by PN
079     *     &lt;/og:query&gt;
080     *
081     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?PN=AAA , YOBI=BBB)
082     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = 'AAA' and YOBI like 'BBB%' order by PN
083     *
084     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺檎援譁ｹ蜈･蜉帙＆繧後↑縺九▲縺滓凾(PN縺君ULL縺ｮ縺ｨ縺? YOBI=BBB)
085     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where YOBI like 'BBB%' order by PN
086     *
087     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾(PN縺君ULL, YOBI縺君ULL) WHERE蜿･縺後↑縺上↑繧九?
088     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 order by PN
089     *
090     *        豕ｨ諢?WhereTag繧剃ｽｿ繧上↑縺??蜷医↓縲∵､懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺溷?蜷医?縲∽ｸ玖ｨ倥?繧医≧縺ｫ縺ｪ繧翫∪縺吶?
091     *            select PN,YOBI,NMEN,HINM from XX01 where PN = '' and YOBI like '%' order by PN
092     *
093     *    --------------------------------------------------------------------------------------------------------------
094     *
095     *     &lt;og:query command="NEW"&gt;
096     *             select PN,YOBI,NMEN,HINM from XX01 where PN="11111"
097     *         &lt;og:where startKey="and"&gt;
098     *             &lt;og:and value="YOBI in   ({&#064;YOBI})" multi="true" /&gt;
099     *             &lt;og:and value="HINM like '{&#064;HINM}%'"             /&gt;
100     *         &lt;/og:where&gt;
101     *             order by PN
102     *     &lt;/og:query&gt;
103     *
104     *          繝ｻYOBI 繧定､?焚驕ｸ謚槭＠縲（n 縺ｧ讀懃ｴ｢縺吶ｋ譎?YOBI=AA,BB,CC 繧帝∈謚?
105     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = '11111'
106     *                             and YOBI in ( 'AA','BB','CC' ) and HINM like 'BBB%' order by PN
107     *
108     * @og.group 逕ｻ髱｢驛ｨ蜩?
109     *
110     * @version  4.0
111     * @author       Kazuhiko Hasegawa
112     * @since    JDK5.0,
113     */
114    public class SqlAndTag extends CommonTagSupport {
115            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
116            private static final String VERSION = "5.5.1.1 (2012/04/06)" ;
117    
118            private static final long serialVersionUID = 551120120406L ;
119    
120            private String  startKey        = "and";
121            private String  value           = "";
122            private String  instrVals       = null;         // 3.8.8.1 (2007/01/06)
123            private String  instrType       = "and";        // 5.4.1.0 (2011/11/01)
124            private boolean multi           = false;
125            private boolean quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
126            private boolean xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
127    
128            private boolean allNull         = false;        // 5.0.0.2 (2009/09/15)
129    
130    //      private String  matchKey        = null;         // 5.1.9.0 (2010/08/01) 竍?5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
131    
132    //      private String  matchVal        = null;         // 5.1.9.0 (2010/08/01) 竍?5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
133    
134            private String  separator       = null;         // 5.2.2.0 (2010/11/01) 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
135    
136            /**
137             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
138             *
139             * @og.rev 4.0.0.0 (2006/12/05) BODY 驛ｨ縺ｮ蛟､繧?value 縺ｫ菴ｿ逕ｨ縺吶ｋ讖溯?霑ｽ蜉?
140             * @og.rev 4.0.0.0 (2005/08/31) useQuotCheck() 縺ｫ繧医ｋ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲?
141             * @og.rev 5.0.0.2 (2009/09/15) XSS蟇ｾ遲?
142             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
143             *
144             * @return      蠕檎ｶ壼?逅??謖?､ｺ
145             */
146            @Override
147            public int doStartTag() {
148                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
149                    if( useTag() ) {
150                            useQuotCheck( quotCheck );
151                            // 5.0.0.2 (2009/09/15) XSS蟇ｾ遲?
152                            useXssCheck( xssCheck );
153    
154                            value = getRequestParameter( value );
155    
156                            if( value == null || value.isEmpty() ) {
157                                    return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
158                            }
159    
160            //              if( value != null && value.length() > 0 ) {
161            //                      return( SKIP_BODY );                    // Body 繧定ｩ穂ｾ｡縺励↑縺?
162            //              }
163            //              else {
164            //                      return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
165            //              }
166                    }
167                    return( SKIP_BODY );                    // Body 繧定ｩ穂ｾ｡縺励↑縺?
168            }
169    
170            /**
171             * Taglib縺ｮ繧ｿ繧ｰ譛ｬ菴薙ｒ蜃ｦ逅?☆繧?doAfterBody() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
172             *
173             * @og.rev 4.0.0.0 (2006/12/05) BODY 驛ｨ縺ｮ蛟､繧?value 縺ｫ菴ｿ逕ｨ縺吶ｋ讖溯?霑ｽ蜉?
174             *
175             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
176             */
177            @Override
178            public int doAfterBody() {
179                    value = getBodyString();
180                    return(SKIP_BODY);
181            }
182    
183            /**
184             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
185             *
186             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
187             * @og.rev 3.8.8.1 (2007/01/06) makeInstrVals 繧貞刈蜻ｳ縺吶ｋ縲?
188             * @og.rev 5.0.0.2 (2009/09/15) multi譎ゅ?allNull蟇ｾ蠢?
189             * @og.rev 5.1.9.0 (2010/08/01) matchKey 縲［atchVal 蟇ｾ蠢?竍?5.2.2.0 (2010/11/01) 蟒?ｭ｢
190             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
191             *
192             * @return      蠕檎ｶ壼?逅??謖?､ｺ
193             */
194            @Override
195            public int doEndTag() {
196                    debugPrint();           // 4.0.0 (2005/02/28)
197                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
198                    if( useTag() ) {
199                            SqlWhereTag where = (SqlWhereTag)findAncestorWithClass( this,SqlWhereTag.class );
200                            if( where == null ) {
201                                    String errMsg = "<b>縺薙?繧ｿ繧ｰ縺ｯ縲『here 繧ｿ繧ｰ縺ｮ蜀?Κ縺ｫ縺翫￥蠢?ｦ√′縺ゅｊ縺ｾ縺吶?</b>";
202                                    throw new HybsSystemException( errMsg );
203                            }
204    
205                            // 5.1.9.0 (2010/08/01) matchKey 縲［atchVal 蟇ｾ蠢?竍?5.2.2.0 (2010/11/01) 蟒?ｭ｢
206            //              boolean flag = (matchKey == null) || (matchVal == null) || matchKey.matches( matchVal ) ;
207    
208                            // if( ! isNull() ) {
209            //              if( ! isNull() && ! allNull ) {                 // 5.0.0.2 (2009/09/15)
210            //              if( ! isNull() && ! allNull && flag ) { // 5.1.9.0 (2010/08/01)
211                            if( ! isNull() && ! allNull ) {                 // 5.2.2.0 (2010/11/01)
212    //                              value = makeInstrVals( instrVals,value );       // 3.8.8.1 (2007/01/06)
213                                    value = makeInstrVals( instrVals,instrType,value );     // 5.4.1.0 (2011/11/01)
214                                    if( value != null ) {
215                                            set( "keyWord", startKey );
216                                            set( "value"  , value );
217                                            where.setAttributes( getAttributes() );
218                                    }
219                            }
220                    }
221                    return(EVAL_PAGE);
222            }
223    
224            /**
225             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
226             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
227             *
228             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
229             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
230             * @og.rev 3.8.8.1 (2007/01/06) instrVals 螻樊?霑ｽ蜉?
231             * @og.rev 4.0.0.0 (2005/08/31) quotCheck 螻樊?縺ｮ霑ｽ蜉?
232             * @og.rev 5.0.0.2 (2009/09/15) XSS蟇ｾ蠢?
233             * @og.rev 5.0.0.2 (2009/09/15) multi譎ゅ?allNull蟇ｾ蠢?
234             * @og.rev 5.1.9.0 (2010/08/01) matchKey縲［atchVal 螻樊?縺ｮ霑ｽ蜉?
235             * @og.rev 5.2.2.0 (2010/11/01) separator , isMatch 螻樊?縺ｮ霑ｽ蜉?
236             * @og.rev 5.2.2.0 (2010/11/01) matchKey縲［atchVal 螻樊?蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
237             * @og.rev 5.4.1.0 (2011/11/01) instrType螻樊?霑ｽ蜉?
238             */
239            @Override
240            protected void release2() {
241                    super.release2();
242                    startKey        = "and";
243                    value           = "";
244                    instrVals       = null;         // 3.8.8.1 (2007/01/06)
245                    instrType       = "and";        // 5.4.1.0 (2011/11/01)
246                    multi           = false;
247                    quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
248                    xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
249                    allNull         = false;        // 5.0.0.2 (2009/09/15)
250    //              matchKey        = null;         // 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
251    //              matchVal        = null;         // 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
252                    separator       = null;         // 5.2.2.0 (2010/11/01) 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
253            }
254    
255            /**
256             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ譁?ｭ怜?繧貞叙蠕励＠縺ｾ縺吶?
257             *
258             * 縺薙ｌ縺ｯ縲??蟶ｸ縺ｮgetRequestParameter 蜃ｦ逅??荳ｭ縺ｧ蜻ｼ縺ｰ繧後ｋ getRequestValue 繧?
259             * 繧ｪ繝ｼ繝舌?繝ｩ繧､繝医＠縺ｦ縺?∪縺吶?
260             *
261             * @og.rev 5.0.0.2 (2009/09/15) values縺ｮ蜈ｨNULL/遨ｺ譁?ｭ励ｒisNull謇ｱ縺?↓縺吶ｋ
262             * @og.rev 5.3.8.0 (2011/08/01) Attribute遲峨°繧峨ｂ蛟､縺悟叙蠕励〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲ゅ?蟇ｾ蠢懈凾縺ｮ迚ｹ谿雁?逅?
263             *
264             * @param    key 繧ｭ繝ｼ
265             *
266             * @return   繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ譁?ｭ怜?
267             */
268            @Override
269            protected String getRequestValue( final String key ) {
270                    String rtn = "";
271    
272                    if( multi ) {
273                            // 5.3.8.0 (2011/08/01) getRequestValues 縺ｮ荳ｭ縺ｧ縲“etRequestValue 繧貞他縺ｳ蜃ｺ縺吶◆繧√％縺ｮ縺ｾ縺ｾ縺ｧ縺ｯ
274                            // 蜀榊ｸｰ蜻ｼ縺ｳ蜃ｺ縺励′豌ｸ驕?↓邯壹￥縺ｮ縺ｧ縲?ｼ貞屓逶ｮ莉･髯阪?縲∝?蟶ｰ縺励↑縺?ｈ縺?↓縲∝ｼｷ蛻ｶ逧?↓ multi 縺ｮ蛟､繧呈嶌縺肴鋤縺医∪縺吶?
275                            multi = false;  // 5.3.8.0 (2011/08/01) 蜀榊ｸｰ縺励↑縺?ｈ縺?↓縲∝ｼｷ蛻ｶ逧?↓蛟､繧呈嶌縺肴鋤縺?
276                            String[] array = getRequestValues( key );
277                            allNull = true; // 5.0.0.2 (2009/09/15) array縺ｮ蜀?ｮｹ縺悟?縺ｦnull/遨ｺ譁?ｭ励°
278                            if( ! isNull() ) {
279                                    // 5.0.0.2 (2009/09/15) 蜈ｨ縺ｦnull/遨ｺ譁?ｭ励?蝣ｴ蜷医?null縺ｨ謇ｱ縺?
280                                    for( int i = 0; i < array.length; i++ ) {
281                                            if( array[i] != null && array[i].length() > 0 ) {
282                                                    allNull = false;
283                                                    break;
284                                            }
285                                    }
286                                    if( ! allNull ){
287                                            rtn = makeCSVvalue( array );
288                                    }
289                            }
290                            multi = true;   // 5.3.8.0 (2011/08/01) 蠑ｷ蛻ｶ逧?↓譖ｸ縺肴鋤縺医◆蛟､繧貞?縺ｫ謌ｻ縺吶?
291                    }
292                    else {
293                            rtn = super.getRequestValue( key );
294                    }
295                    return rtn ;
296            }
297    
298            /**
299             * 隍?焚縺ｮ蛟､繧?'xx1','xx2','xx3', ?･?･?･ 縺ｨ縺?≧蠖｢蠑上↓螟画鋤縺励∪縺吶?
300             *
301             * 縺薙?蜃ｦ逅??縲（n 縺ｪ縺ｩ縺ｧ菴ｿ逕ｨ縺吶ｋ縺溘ａ縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝医ｒ驟榊?縺ｧ蜿励￠蜿悶▲縺ｦ蜃ｦ逅?
302             * 縺吶ｋ蝣ｴ蜷医?譁?ｭ怜?繧貞刈蟾･縺励∪縺吶?
303             *
304             * @og.rev 5.2.2.0 (2010/11/01) separator 蟇ｾ蠢?
305             *
306             * @param       array   蜈??驟榊?譁?ｭ怜?
307             *
308             * @return  騾｣邨仙ｾ後?譁?ｭ怜?
309             */
310            private String makeCSVvalue( final String[] array ) {
311                    if( array == null || array.length == 0 ) {
312                            String errMsg = "array 蠑墓焚縺ｫ縲］ull 繧??繧ｵ繧､繧ｺ繧ｼ繝ｭ縺ｮ驟榊?縺ｯ菴ｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
313                            throw new HybsSystemException( errMsg );
314                    }
315    
316                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
317    
318                    if( separator != null ) {
319                            for(int i=0; i < array.length; i++) {
320                                    String[] ary = array[i].split( separator );
321                                    for( int j=0; j<ary.length; j++ ) {
322                                            buf.append( "'" );
323                                            buf.append( ary[j] );
324                                            buf.append( "'," );
325                                    }
326                            }
327                            buf.deleteCharAt( buf.length()-1 );             // 譛?ｾ後? 繝斐Μ繧ｪ繝峨ｒ蜑企勁縺吶ｋ縲?
328                    }
329                    else {
330                            for(int i=0; i < array.length; i++) {
331                                    buf.append( "'" );
332                                    buf.append( array[i] );
333                                    buf.append( "'," );
334                            }
335                            buf.deleteCharAt( buf.length()-1 );             // 譛?ｾ後? 繝斐Μ繧ｪ繝峨ｒ蜑企勁縺吶ｋ縲?
336                    }
337    //              buf.append( "'" );
338    //              buf.append( array[0] );
339    //              buf.append( "'" );
340    //              for(int i=1; i < array.length; i++) {
341    //                      buf.append( ",'" );
342    //                      buf.append( array[i] );
343    //                      buf.append( "'" );
344    //              }
345                    return buf.toString();
346            }
347    
348            /**
349             * 繧ｹ繝壹?繧ｹ縺ｧ蛹ｺ蛻?ｉ繧後◆隍?焚縺ｮ蛟､繧?and 謗･邯壹〒騾｣邨舌＠縺ｾ縺吶?
350             *
351             * value="CLM" instrVals="ABC DEF GHI" 縺ｨ謖?ｮ壹☆繧九→縲?
352             * value="CLM LIKE '%ABC%' AND CLM LIKE '%DEF%'  AND CLM LIKE '%GHI%' "
353             * 縺ｨ縺?≧譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
354             * 蛟句挨縺ｫLIKE讀懃ｴ｢鬆?岼繧?AND 騾｣邨舌☆繧狗ぜ縲∫樟繧後ｋ蝣ｴ謇?↓萓晏ｭ倥＠縺ｾ縺帙ｓ縲?
355             * 騾?↓縲∫樟繧後ｋ鬆?ｺ上ｒ謖?ｮ壹☆繧句?蜷医?縲、BC%DEF 縺ｮ讒倥↓謖?ｮ壼庄閭ｽ縺ｧ縺吶?
356             * 縺溘□縺励?columnMarker 縺ｮ instrVals 縺ｧ縲∬､?焚譁?ｭ励?繝槭?繧ｫ繝ｼ繧定｡後≧蝣ｴ蜷医?
357             * ABC%DEF 縺ｨ縺?≧譁?ｭ怜?縺ｯ縲√が繝ｪ繧ｸ繝翫Ν縺ｧ縺ｪ縺??縺ｧ縲√?繝ｼ繧ｯ繧｢繝??縺輔ｌ縺ｾ縺帙ｓ縲?
358             *
359             * @og.rev 5.4.1.0 (2011/11/01) instrType螻樊?蟇ｾ蠢?
360             * @og.rev 5.5.1.1 (2012/04/06) notin蟇ｾ蠢?
361             *
362             * @param       instrVals       郢ｰ霑斐＠蜃ｦ逅?ｒ陦後≧ 蛟､
363             * @param       instrType       騾｣邨先婿豕?
364             * @param       value           郢ｰ霑斐＠蜃ｦ逅?ｒ陦後≧ value
365             *
366             * @return  騾｣邨仙ｾ後?譁?ｭ怜?
367             * @see         #setInstrVals( String )
368             * @see         ColumnMarkerTag#setInstrVals( String )
369             */
370            private String makeInstrVals( final String instrVals, final String instrType , final String value ) {
371                    if( instrVals == null || instrVals.length() == 0 ) { return value; }
372    
373                    String reqVals = nval( getRequestParameter( instrVals ),null );
374                    if( reqVals == null || reqVals.length() == 0 ) { return null; }
375    
376                    final String[] vals ;
377                    if( multi ) {
378                            // multi 縺ｮ縺ｨ縺阪?縲［akeCSVvalue 縺ｧ蜉?ｷ･縺輔ｌ縺溷?縺ｫ縺ｪ縺｣縺ｦ縺?ｋ縲?
379                            vals = StringUtil.csv2Array( reqVals,',' );
380                            // 蜑榊ｾ後? ' 縺ｯ縺壹＠
381                            for( int i=0; i<vals.length; i++ ) {
382                                    vals[i] = vals[i].substring( 1,vals[i].length()-1 );
383                            }
384                    }
385                    else {
386                            vals = StringUtil.csv2Array( reqVals,' ' );
387                    }
388    
389                    if( vals == null || vals.length == 0 ) { return null; }
390    
391                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
392    
393    //              buf.append( value );
394    //              buf.append( " LIKE '%" );
395    //              buf.append( vals[0] );
396    //              buf.append( "%'" );
397    
398                    buf.append( " (" );
399                    // 譚｡莉ｶ:and 竍?蜷??繧誕nd縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ゅｊ)
400                    if( instrType.startsWith( "a" ) ) {
401                            for(int i=0; i < vals.length; i++) {
402                                    if( i > 0 ) { buf.append( " and " ); }
403                                    buf.append( value );
404                                    buf.append( " LIKE '%" ).append( vals[i] ).append( "%'" );
405                            }
406                    }
407                    // 譚｡莉ｶ:or 竍?蜷??繧弛r縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ゅｊ)
408                    else if( instrType.startsWith( "o" ) ) {
409                            for(int i=0; i < vals.length; i++) {
410                                    if( i > 0 ) { buf.append( " or " ); }
411                                    buf.append( value );
412                                    buf.append( " LIKE '%" ).append( vals[i] ).append( "%'" );
413                            }
414                    }
415                    // 譚｡莉ｶ:in 竍?蜷??繧弛r縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ｪ縺?
416                    else if( instrType.startsWith( "i" ) ) {
417                            for(int i=0; i < vals.length; i++) {
418                                    if( i > 0 ) { buf.append( " or " ); }
419                                    buf.append( value );
420                                    buf.append( " LIKE '" ).append( vals[i] ).append( "'" );
421                            }
422                    }
423                    // 譚｡莉ｶ:notin 竍?蜷??繧誕nd縺ｮnot like譚｡莉ｶ縺ｧ邨仙粋(%縺ｪ縺? 5.5.1.1(2012/04/05)
424                    else if( instrType.startsWith( "n" ) ) {
425                            for(int i=0; i < vals.length; i++) {
426                                    if( i > 0 ) { buf.append( " and " ); }
427                                    buf.append( value );
428                                    buf.append( " NOT LIKE '" ).append( vals[i] ).append( "'" );
429                            }
430                    }
431                    else {
432                            String errMsg = "instrType縺ｫ縺ｯ縲?and','or','in','notin'縺ｮ縺?★繧後°繧呈欠螳壹＠縺ｦ荳九＆縺??instrType=[" + instrType + "]";
433                            throw new HybsSystemException( errMsg );
434                    }
435                    buf.append( ") " );
436    
437                    return buf.toString();
438            }
439    
440            /**
441             * 縲慎AG縲全QL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)縲?
442             *
443             * @og.tag
444             * value 繧帝?邨舌☆繧句?蜷医?鬆ｭ縺ｫ鄂ｮ縺九ｌ繧区枚蟄怜?縺ｧ縲『here蜿･縺ｮ譛??縺ｫ縺ｯ陦ｨ遉ｺ縺輔ｌ縺壹?
445             * 縺昴ｌ莉･髯阪↓縺､縺?※縲∬｡ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
446             * (縺､縺ｾ繧翫?where VALUE1 and VALUE2 and VALUE3 窶ｦ 縺ｧ縺吶?)
447             * startKey 縺ｮ蛻晄悄蛟､縺ｯ縲?and" 縺ｧ縺吶?
448             *
449             * @param       skey 譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ?
450             */
451            public void setStartKey( final String skey ) {
452                    if( skey != null && skey.length() > 0 ) { startKey = skey; }
453            }
454    
455            /**
456             * 縲慎AG縲第擅莉ｶ縺ｮ蛟､繧?繧ｻ繝?ヨ縺励∪縺吶?
457             *
458             * @og.tag
459             * 譚｡莉ｶ蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医?縺昴?繝ｪ繧ｯ繧ｨ繧ｹ繝亥?縺後↑縺??蜷医?縲?
460             * 縺薙?繧ｿ繧ｰ縺昴?繧ゅ?縺後↑縺ｫ繧ょ?蜉帙＠縺ｾ縺帙ｓ縲?縺､縺ｾ繧頑擅莉ｶ縺九ｉ豸医∴縺ｾ縺吶?)
461             * BODY 驛ｨ縺ｫ險倩ｿｰ縺吶ｋ縺薙→縺悟庄閭ｽ縺ｧ縺吶?縺昴?蝣ｴ蜷医?縲∵擅莉ｶ螻樊?縺ｫ縺ｪ縺ｫ繧りｨｭ螳壹〒縺阪∪縺帙ｓ縲?
462             *
463             * @param       val 譚｡莉ｶ蛟､
464             */
465            public void setValue( final String val ) {
466                    value = val;
467            }
468    
469            /**
470             * 縲慎AG縲代せ繝壹?繧ｹ縺ｧ蛹ｺ蛻?ｉ繧後◆隍?焚縺ｮ蛟､縺吶∋縺ｦ繧貞性繧?擅莉ｶ繧剃ｽ懈?縺励∪縺吶?
471             *
472             * @og.tag
473             * 騾壼ｸｸ縲」alue="CLM LIKE 'ABC%'" 縺ｨ縺?≧譁?ｭ怜?繧呈欠螳壹＠縺ｾ縺吶′縲?
474             * value="CLM" instrVals="ABC DEF GHI" 縺ｨ謖?ｮ壹☆繧九→縲?
475             * value="CLM LIKE '%ABC%' AND CLM LIKE '%DEF%'  AND CLM LIKE '%GHI%' "
476             * 縺ｨ縺?≧譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
477             * 縺薙ｌ縺ｯ縲（nstrVals 縺ｫ謖?ｮ壹＠縺溷ｼ墓焚縺ｫ蟇ｾ縺励※縲√せ繝壹?繧ｹ蛹ｺ蛻?ｊ縺ｧ蛻?牡縺励?
478             * 蜑肴婿縺ｮ value 縺ｫ隍?焚縺ｮAND讀懃ｴ｢繧貞酔譎ゅ↓螳溽樟縺ｧ縺阪ｋ繧医≧縺ｫ謖?ｮ壹＠縺ｾ縺?
479             * 蛟句挨縺ｫLIKE讀懃ｴ｢鬆?岼繧?AND 騾｣邨舌☆繧狗ぜ縲∫樟繧後ｋ蝣ｴ謇?↓萓晏ｭ倥＠縺ｾ縺帙ｓ縲?
480             * 騾?↓縲∫樟繧後ｋ鬆?ｺ上ｒ謖?ｮ壹☆繧句?蜷医?縲、BC%DEF 縺ｮ讒倥↓謖?ｮ壼庄閭ｽ縺ｧ縺吶?
481             * 縺溘□縺励?columnMarker 縺ｮ instrVals 縺ｧ縲∬､?焚譁?ｭ励?繝槭?繧ｫ繝ｼ繧定｡後≧蝣ｴ蜷医?
482             * ABC%DEF 縺ｨ縺?≧譁?ｭ怜?縺ｯ縲√が繝ｪ繧ｸ繝翫Ν縺ｧ縺ｪ縺??縺ｧ縲√?繝ｼ繧ｯ繧｢繝??縺輔ｌ縺ｾ縺帙ｓ縲?
483             * 窶ｻinstrType螻樊?縺ｮ謖?ｮ壹↓繧医ｊ譚｡莉ｶ縺ｮ逕滓?譁ｹ豕輔ｒ螟画峩縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
484             *   隧ｳ邏ｰ縺ｫ縺､縺?※縺ｯ縲（nstrType螻樊?縺ｮ繝峨く繝･繝｡繝ｳ繝医ｒ蜿ら?荳九＆縺??
485             *
486             * @param       val 隍?粋譚｡莉ｶ菴懈?縺ｮ縺溘ａ縺ｮ險ｭ螳壼?
487             * @see         #setInstrType
488             * @see         ColumnMarkerTag#setInstrVals( String )
489             */
490            public void setInstrVals( final String val ) {
491                    instrVals = val;
492            }
493    
494            /**
495             * 縲慎AG縲訴nstrVals縺ｧ隍?焚縺ｮ蛟､繧呈擅莉ｶ縺ｫ縺吶ｋ髫帙?譁ｹ豕輔ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)縲?
496             *
497             * @og.tag
498             * 騾壼ｸｸ縲（nstrVals縺ｫ謖?ｮ壹＆繧後◆蛟､縺ｯ縲√せ繝壹?繧ｹ蛹ｺ蛻?ｊ縺ｧ蛻?牡縺励◆蜷??繧鱈IKE譚｡莉ｶ縺ｨ縺励※and邨仙粋縺励∪縺吶?
499             * 縺励°縺励?instrType螻樊?繧貞､画峩縺吶ｋ縺薙→縺ｧ縲√％縺ｮ譚｡莉ｶ蠑上?逕滓?譁ｹ豕輔ｒ螟画峩
500             * 縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
501             * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲∽ｻ･荳九?騾壹ｊ縺ｧ縺吶?
502             * 竭?nstrType縺ｫ"and"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?蛻晄悄蛟､)
503             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
504             *   逕滓?譁?ｭ怜? :       "( CLM LIKE '%ABC%' AND CLM LIKE '%DEF%' AND CLM LIKE '%GHI%' )"
505             * 竭｡instrType縺ｫ"or"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
506             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
507             *   逕滓?譁?ｭ怜? :       "( CLM LIKE '%ABC%' OR CLM LIKE '%DEF%' OR CLM LIKE '%GHI%' )"
508             * 竭｢instrType縺ｫ"in"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
509             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
510             *   逕滓?譁?ｭ怜? :       "( CLM LIKE 'ABC' OR CLM LIKE 'DEF5' OR CLM LIKE 'GHI' )"
511             * 竭｣instrType縺ｫ"notin"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
512             *       繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
513             *   逕滓?譁?ｭ怜? :       "( CLM NOT LIKE 'ABC' AND CLM NOT LIKE 'DEF5' AND CLM NOT LIKE 'GHI' )"
514             * 窶ｻ縺薙?螻樊?繧呈欠螳壹＠縺ｪ縺??蜷医?縲≫蔵縺ｮLIKE譚｡莉ｶ縺ｧ縺ｮand邨仙粋縺ｨ縺ｪ繧翫∪縺吶?
515             * 窶ｻ竭｢竭｣縺ｫ縺､縺?※縲´IKE譚｡莉ｶ縺ｧ%繧定?蜍穂ｻ伜刈縺励↑縺?％縺ｨ縺ｫ繧医ｊ縲∫判髱｢縺九ｉ縺ｮ蜈･蜉帛?縺ｫ蠢懊§縺ｦ縲?
516             *   蜑肴婿荳??縲∝ｾ梧婿荳??縲∝燕蠕梧婿荳??縺ｮ蛻ｶ蠕｡繧定｡後≧縺薙→縺後〒縺阪∪縺吶?
517             *
518             * @og.rev 5.5.1.1 (2012/04/06) notin蟇ｾ蠢?繧ｳ繝｡繝ｳ繝井ｿｮ豁｣)
519             *
520             * @param       tp 譚｡莉ｶ譁ｹ豕票and/or/in/notin]
521             * @see         #setInstrVals( String )
522             */
523            public void setInstrType( final String tp ) {
524                    instrType = nval( getRequestParameter( tp ),tp );
525            }
526    
527            /**
528             * 縲慎AG縲題､?焚縺ｮ蠑墓焚縺ｫ蟇ｾ縺励※蜃ｦ逅?☆繧九°縺ｩ縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
529             *
530             * @og.tag
531             * {&#064;XXXX} 螟画焚縺ｫ縲∝?縺瑚､?焚蜷ｫ縺ｾ繧後※縺?ｋ蝣ｴ蜷医?蜃ｦ逅?ｒ隕丞ｮ壹＠縺ｾ縺吶?
532             * multi="true" 縺ｫ險ｭ螳壹☆繧九→縲∬､?焚縺ｮ蠑墓焚縺ｯ縲?xx1','xx2','xx3', ?･?･?･ 縺ｨ縺?≧
533             * 蠖｢蠑上↓螟画鋤縺励∪縺吶?
534             * where 譚｡莉ｶ縺ｧ險?≧縺ｨ縲?"where PN in ( {&#064;PN} )" 縺ｨ縺?≧譁?ｭ怜?縺ｫ蟇ｾ縺励※縲?
535             * "where PN in ( 'xx1','xx2','xx3' )" 繧剃ｽ懈?縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶?
536             * 蛻晄悄蛟､縺ｯ縲?false (繝槭Ν繝∝､画鋤縺励↑縺? 縺ｧ縺吶?
537             *
538             * @param   flag 繝槭Ν繝∝､画鋤 [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺?
539             * @see         #setSeparator( String )
540             */
541            public void setMulti( final String flag ) {
542                    multi = nval( flag,multi );
543            }
544    
545            /**
546             * 縲慎AG縲僧ulti 繧｢繧ｯ繧ｷ繝ｧ繝ｳ譎ゅ?譁?ｭ怜?繧貞?蜑ｲ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
547             *
548             * @og.tag
549             * multi="true" 縺ｮ蝣ｴ蜷医?隍?焚縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝医ｒ騾｣邨舌＠縺ｦ縲?in 蜿･縺ｧ蝠丞粋縺帙ｒ陦後≧譁?ｭ怜?繧?
550             * 菴懈?縺励∪縺吶′縲《eparator 繧呈欠螳壹☆繧九→縲√＆繧峨↓縲《eparator 縺ｧ譁?ｭ怜?繧貞?蜑ｲ縺励※縲?
551             * in 蜿･縺ｮ蠑墓焚繧呈ｧ狗ｯ峨＠縺ｾ縺吶?
552             * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲∝?蜑ｲ蠕後?譁?ｭ怜?縺後?隍?焚縺ｮ蛟九?縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｨ蜷後§蠖｢蠑上↓蜉?ｷ･縺輔ｌ縺ｾ縺吶?
553             * 縺薙?讖溯?縺ｯ縲［ulti="true" 繧呈欠螳壹＠縺溷?蜷医?縺ｿ譛牙柑縺ｫ縺ｪ繧翫∪縺吶?
554             * 蛻晄悄蛟､縺ｯ縲］ull 縺ｧ縺吶?縺､縺ｾ繧翫?蛻?牡蜃ｦ逅??陦後＞縺ｾ縺帙ｓ縲?
555             *
556             * @og.rev 5.2.2.0 (2010/11/01) 譁ｰ隕剰ｿｽ蜉?
557             *
558             * @param   sepa 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
559             * @see         #setMulti( String )
560             */
561            public void setSeparator( final String sepa ) {
562                    separator = nval( getRequestParameter( sepa ),separator );
563            }
564    
565            /**
566             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
567             *              (蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
568             *
569             * @og.tag
570             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
571             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
572             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
573             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
574             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
575             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
576             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
577             *
578             * @og.rev 4.0.0.0 (2005/08/31) 譁ｰ隕剰ｿｽ蜉?
579             *
580             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
581             * @see         org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK
582             */
583            public void setQuotCheck( final String flag ) {
584                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
585            }
586    
587            /**
588             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
589             *              (蛻晄悄蛟､:USE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
590             *
591             * @og.tag
592             * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?荳?腸縺ｨ縺励※less/greater than sign縺ｫ縺､縺?※縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
593             * (&gt;&lt;) 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
594             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
595             *
596             * @og.rev 5.0.0.2 (2009/09/15) 譁ｰ隕剰ｿｽ蜉?
597             *
598             * @param       flag    XSS繝√ぉ繝?け [true:縺吶ｋ/false:縺励↑縺Ь
599             * @see         org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK
600             */
601            public void setXssCheck( final String flag ) {
602                    xssCheck = nval( getRequestParameter( flag ),xssCheck );
603            }
604    
605            /**
606             * 縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
607             *
608             * @og.tag
609             * matchKey.matches( matchVal ) 縺ｮ蛟､縺後?true 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
610             * false 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
611             * value 蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医→蜷後§蜉ｹ譫懊ｒ蠕励ｉ繧後∪縺吶?
612             * 菴輔ｂ謖?ｮ壹＠縺ｪ縺??蜷医?縺ｾ縺溘?縲∝ｼ墓焚縺?null 縺ｮ蝣ｴ蜷医?縲》rue 縺ｨ蜷後§縺ｧ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
613             *
614             * @og.rev 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
615             * @og.rev 5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
616             *
617             * @param       mkey String
618             */
619    //      public void setMatchKey( final String mkey ) {
620    //              matchKey = nval( getRequestParameter( mkey ),matchKey );
621    //      }
622    
623            /**
624             * 縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺吶?
625             *
626             * @og.tag
627             * matchKey.matches( matchVal ) 縺ｮ蛟､縺後?true 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
628             * false 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
629             * value 蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医→蜷後§蜉ｹ譫懊ｒ蠕励ｉ繧後∪縺吶?
630             * 菴輔ｂ謖?ｮ壹＠縺ｪ縺??蜷医?縺ｾ縺溘?縲∝ｼ墓焚縺?null 縺ｮ蝣ｴ蜷医?縲》rue 縺ｨ蜷後§縺ｧ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
631             *
632             * @og.rev 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
633             * @og.rev 5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
634             *
635             * @param       mval String
636             */
637    //      public void setMatchVal( final String mval ) {
638    //              matchVal = nval( getRequestParameter( mval ),matchVal );
639    //      }
640    
641            /**
642             * 繧ｿ繧ｰ縺ｮ蜷咲ｧｰ繧偵?霑斐＠縺ｾ縺吶?
643             * 閾ｪ蛻??霄ｫ縺ｮ繧ｯ繝ｩ繧ｹ蜷阪ｈ繧翫?閾ｪ蜍慕噪縺ｫ蜿悶ｊ蜃ｺ縺帙↑縺?◆繧√?縺薙?繝｡繧ｽ繝?ラ繧偵が繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
644             *
645             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕剰ｿｽ蜉?
646             *
647             * @return  繧ｿ繧ｰ縺ｮ蜷咲ｧｰ
648             */
649            @Override
650            protected String getTagName() {
651                    return "and" ;
652            }
653    
654            /**
655             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
656             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
657             *
658             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
659             */
660            @Override
661            public String toString() {
662                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
663                                    .println( "VERSION"                     ,VERSION        )
664                                    .println( "startKey"            ,startKey       )
665                                    .println( "value"                       ,value          )
666                                    .println( "instrVals"           ,instrVals      )
667                                    .println( "multi"                       ,multi          )
668                                    .println( "quotCheck"           ,quotCheck      )
669                                    .println( "Other..."    ,getAttributes().getAttribute() )
670                                    .fixForm().toString() ;
671            }
672    }