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                                    String errMsg = "<b>" + getTagName() + "繧ｿ繧ｰ縺ｯ縲『here 繧ｿ繧ｰ縺ｮ蜀?Κ縺ｫ縺翫￥蠢?ｦ√′縺ゅｊ縺ｾ縺吶?</b>";
203                                    throw new HybsSystemException( errMsg );
204                            }
205    
206                            // 5.1.9.0 (2010/08/01) matchKey 縲［atchVal 蟇ｾ蠢?竍?5.2.2.0 (2010/11/01) 蟒?ｭ｢
207            //              boolean flag = (matchKey == null) || (matchVal == null) || matchKey.matches( matchVal ) ;
208    
209                            // if( ! isNull() ) {
210            //              if( ! isNull() && ! allNull ) {                 // 5.0.0.2 (2009/09/15)
211            //              if( ! isNull() && ! allNull && flag ) { // 5.1.9.0 (2010/08/01)
212                            if( ! isNull() && ! allNull ) {                 // 5.2.2.0 (2010/11/01)
213    //                              value = makeInstrVals( instrVals,value );       // 3.8.8.1 (2007/01/06)
214                                    value = makeInstrVals( instrVals,instrType,value );     // 5.4.1.0 (2011/11/01)
215                                    if( value != null ) {
216                                            set( "keyWord", startKey );
217                                            set( "value"  , value );
218                                            where.setAttributes( getAttributes() );
219                                    }
220                            }
221                    }
222                    return(EVAL_PAGE);
223            }
224    
225            /**
226             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
227             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
228             *
229             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
230             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
231             * @og.rev 3.8.8.1 (2007/01/06) instrVals 螻樊?霑ｽ蜉?
232             * @og.rev 4.0.0.0 (2005/08/31) quotCheck 螻樊?縺ｮ霑ｽ蜉?
233             * @og.rev 5.0.0.2 (2009/09/15) XSS蟇ｾ蠢?
234             * @og.rev 5.0.0.2 (2009/09/15) multi譎ゅ?allNull蟇ｾ蠢?
235             * @og.rev 5.1.9.0 (2010/08/01) matchKey縲［atchVal 螻樊?縺ｮ霑ｽ蜉?
236             * @og.rev 5.2.2.0 (2010/11/01) separator , isMatch 螻樊?縺ｮ霑ｽ蜉?
237             * @og.rev 5.2.2.0 (2010/11/01) matchKey縲［atchVal 螻樊?蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
238             * @og.rev 5.4.1.0 (2011/11/01) instrType螻樊?霑ｽ蜉?
239             */
240            @Override
241            protected void release2() {
242                    super.release2();
243                    startKey        = "and";
244                    value           = "";
245                    instrVals       = null;         // 3.8.8.1 (2007/01/06)
246                    instrType       = "and";        // 5.4.1.0 (2011/11/01)
247                    multi           = false;
248                    quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
249                    xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
250                    allNull         = false;        // 5.0.0.2 (2009/09/15)
251    //              matchKey        = null;         // 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
252    //              matchVal        = null;         // 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
253                    separator       = null;         // 5.2.2.0 (2010/11/01) 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
254            }
255    
256            /**
257             * 繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ譁?ｭ怜?繧貞叙蠕励＠縺ｾ縺吶?
258             *
259             * 縺薙ｌ縺ｯ縲??蟶ｸ縺ｮgetRequestParameter 蜃ｦ逅??荳ｭ縺ｧ蜻ｼ縺ｰ繧後ｋ getRequestValue 繧?
260             * 繧ｪ繝ｼ繝舌?繝ｩ繧､繝医＠縺ｦ縺?∪縺吶?
261             *
262             * @og.rev 5.0.0.2 (2009/09/15) values縺ｮ蜈ｨNULL/遨ｺ譁?ｭ励ｒisNull謇ｱ縺?↓縺吶ｋ
263             * @og.rev 5.3.8.0 (2011/08/01) Attribute遲峨°繧峨ｂ蛟､縺悟叙蠕励〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲ゅ?蟇ｾ蠢懈凾縺ｮ迚ｹ谿雁?逅?
264             *
265             * @param    key 繧ｭ繝ｼ
266             *
267             * @return   繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ譁?ｭ怜?
268             */
269            @Override
270            protected String getRequestValue( final String key ) {
271                    String rtn = "";
272    
273                    if( multi ) {
274                            // 5.3.8.0 (2011/08/01) getRequestValues 縺ｮ荳ｭ縺ｧ縲“etRequestValue 繧貞他縺ｳ蜃ｺ縺吶◆繧√％縺ｮ縺ｾ縺ｾ縺ｧ縺ｯ
275                            // 蜀榊ｸｰ蜻ｼ縺ｳ蜃ｺ縺励′豌ｸ驕?↓邯壹￥縺ｮ縺ｧ縲?ｼ貞屓逶ｮ莉･髯阪?縲∝?蟶ｰ縺励↑縺?ｈ縺?↓縲∝ｼｷ蛻ｶ逧?↓ multi 縺ｮ蛟､繧呈嶌縺肴鋤縺医∪縺吶?
276                            multi = false;  // 5.3.8.0 (2011/08/01) 蜀榊ｸｰ縺励↑縺?ｈ縺?↓縲∝ｼｷ蛻ｶ逧?↓蛟､繧呈嶌縺肴鋤縺?
277                            String[] array = getRequestValues( key );
278                            allNull = true; // 5.0.0.2 (2009/09/15) array縺ｮ蜀?ｮｹ縺悟?縺ｦnull/遨ｺ譁?ｭ励°
279                            if( ! isNull() ) {
280                                    // 5.0.0.2 (2009/09/15) 蜈ｨ縺ｦnull/遨ｺ譁?ｭ励?蝣ｴ蜷医?null縺ｨ謇ｱ縺?
281                                    for( int i = 0; i < array.length; i++ ) {
282                                            if( array[i] != null && array[i].length() > 0 ) {
283                                                    allNull = false;
284                                                    break;
285                                            }
286                                    }
287                                    if( ! allNull ){
288                                            rtn = makeCSVvalue( array );
289                                    }
290                            }
291                            multi = true;   // 5.3.8.0 (2011/08/01) 蠑ｷ蛻ｶ逧?↓譖ｸ縺肴鋤縺医◆蛟､繧貞?縺ｫ謌ｻ縺吶?
292                    }
293                    else {
294                            rtn = super.getRequestValue( key );
295                    }
296                    return rtn ;
297            }
298    
299            /**
300             * 隍?焚縺ｮ蛟､繧?'xx1','xx2','xx3', ?･?･?･ 縺ｨ縺?≧蠖｢蠑上↓螟画鋤縺励∪縺吶?
301             *
302             * 縺薙?蜃ｦ逅??縲（n 縺ｪ縺ｩ縺ｧ菴ｿ逕ｨ縺吶ｋ縺溘ａ縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝医ｒ驟榊?縺ｧ蜿励￠蜿悶▲縺ｦ蜃ｦ逅?
303             * 縺吶ｋ蝣ｴ蜷医?譁?ｭ怜?繧貞刈蟾･縺励∪縺吶?
304             *
305             * @og.rev 5.2.2.0 (2010/11/01) separator 蟇ｾ蠢?
306             *
307             * @param       array   蜈??驟榊?譁?ｭ怜?
308             *
309             * @return  騾｣邨仙ｾ後?譁?ｭ怜?
310             */
311            private String makeCSVvalue( final String[] array ) {
312                    if( array == null || array.length == 0 ) {
313                            String errMsg = "array 蠑墓焚縺ｫ縲］ull 繧??繧ｵ繧､繧ｺ繧ｼ繝ｭ縺ｮ驟榊?縺ｯ菴ｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
314                            throw new HybsSystemException( errMsg );
315                    }
316    
317                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
318    
319                    if( separator != null ) {
320                            for(int i=0; i < array.length; i++) {
321                                    String[] ary = array[i].split( separator );
322                                    for( int j=0; j<ary.length; j++ ) {
323                                            buf.append( "'" );
324                                            buf.append( ary[j] );
325                                            buf.append( "'," );
326                                    }
327                            }
328                            buf.deleteCharAt( buf.length()-1 );             // 譛?ｾ後? 繝斐Μ繧ｪ繝峨ｒ蜑企勁縺吶ｋ縲?
329                    }
330                    else {
331                            for(int i=0; i < array.length; i++) {
332                                    buf.append( "'" );
333                                    buf.append( array[i] );
334                                    buf.append( "'," );
335                            }
336                            buf.deleteCharAt( buf.length()-1 );             // 譛?ｾ後? 繝斐Μ繧ｪ繝峨ｒ蜑企勁縺吶ｋ縲?
337                    }
338    //              buf.append( "'" );
339    //              buf.append( array[0] );
340    //              buf.append( "'" );
341    //              for(int i=1; i < array.length; i++) {
342    //                      buf.append( ",'" );
343    //                      buf.append( array[i] );
344    //                      buf.append( "'" );
345    //              }
346                    return buf.toString();
347            }
348    
349            /**
350             * 繧ｹ繝壹?繧ｹ縺ｧ蛹ｺ蛻?ｉ繧後◆隍?焚縺ｮ蛟､繧?and 謗･邯壹〒騾｣邨舌＠縺ｾ縺吶?
351             *
352             * value="CLM" instrVals="ABC DEF GHI" 縺ｨ謖?ｮ壹☆繧九→縲?
353             * value="CLM LIKE '%ABC%' AND CLM LIKE '%DEF%'  AND CLM LIKE '%GHI%' "
354             * 縺ｨ縺?≧譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
355             * 蛟句挨縺ｫLIKE讀懃ｴ｢鬆?岼繧?AND 騾｣邨舌☆繧狗ぜ縲∫樟繧後ｋ蝣ｴ謇?↓萓晏ｭ倥＠縺ｾ縺帙ｓ縲?
356             * 騾?↓縲∫樟繧後ｋ鬆?ｺ上ｒ謖?ｮ壹☆繧句?蜷医?縲、BC%DEF 縺ｮ讒倥↓謖?ｮ壼庄閭ｽ縺ｧ縺吶?
357             * 縺溘□縺励?columnMarker 縺ｮ instrVals 縺ｧ縲∬､?焚譁?ｭ励?繝槭?繧ｫ繝ｼ繧定｡後≧蝣ｴ蜷医?
358             * ABC%DEF 縺ｨ縺?≧譁?ｭ怜?縺ｯ縲√が繝ｪ繧ｸ繝翫Ν縺ｧ縺ｪ縺??縺ｧ縲√?繝ｼ繧ｯ繧｢繝??縺輔ｌ縺ｾ縺帙ｓ縲?
359             *
360             * @og.rev 5.4.1.0 (2011/11/01) instrType螻樊?蟇ｾ蠢?
361             * @og.rev 5.5.1.1 (2012/04/06) notin蟇ｾ蠢?
362             *
363             * @param       instrVals       郢ｰ霑斐＠蜃ｦ逅?ｒ陦後≧ 蛟､
364             * @param       instrType       騾｣邨先婿豕?
365             * @param       value           郢ｰ霑斐＠蜃ｦ逅?ｒ陦後≧ value
366             *
367             * @return  騾｣邨仙ｾ後?譁?ｭ怜?
368             * @see         #setInstrVals( String )
369             * @see         ColumnMarkerTag#setInstrVals( String )
370             */
371            private String makeInstrVals( final String instrVals, final String instrType , final String value ) {
372                    if( instrVals == null || instrVals.length() == 0 ) { return value; }
373    
374                    String reqVals = nval( getRequestParameter( instrVals ),null );
375                    if( reqVals == null || reqVals.length() == 0 ) { return null; }
376    
377                    final String[] vals ;
378                    if( multi ) {
379                            // multi 縺ｮ縺ｨ縺阪?縲［akeCSVvalue 縺ｧ蜉?ｷ･縺輔ｌ縺溷?縺ｫ縺ｪ縺｣縺ｦ縺?ｋ縲?
380                            vals = StringUtil.csv2Array( reqVals,',' );
381                            // 蜑榊ｾ後? ' 縺ｯ縺壹＠
382                            for( int i=0; i<vals.length; i++ ) {
383                                    vals[i] = vals[i].substring( 1,vals[i].length()-1 );
384                            }
385                    }
386                    else {
387                            vals = StringUtil.csv2Array( reqVals,' ' );
388                    }
389    
390                    if( vals == null || vals.length == 0 ) { return null; }
391    
392                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
393    
394    //              buf.append( value );
395    //              buf.append( " LIKE '%" );
396    //              buf.append( vals[0] );
397    //              buf.append( "%'" );
398    
399                    buf.append( " (" );
400                    // 譚｡莉ｶ:and 竍?蜷??繧誕nd縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ゅｊ)
401                    if( instrType.startsWith( "a" ) ) {
402                            for(int i=0; i < vals.length; i++) {
403                                    if( i > 0 ) { buf.append( " and " ); }
404                                    buf.append( value );
405                                    buf.append( " LIKE '%" ).append( vals[i] ).append( "%'" );
406                            }
407                    }
408                    // 譚｡莉ｶ:or 竍?蜷??繧弛r縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ゅｊ)
409                    else if( instrType.startsWith( "o" ) ) {
410                            for(int i=0; i < vals.length; i++) {
411                                    if( i > 0 ) { buf.append( " or " ); }
412                                    buf.append( value );
413                                    buf.append( " LIKE '%" ).append( vals[i] ).append( "%'" );
414                            }
415                    }
416                    // 譚｡莉ｶ:in 竍?蜷??繧弛r縺ｮlike譚｡莉ｶ縺ｧ邨仙粋(%縺ｪ縺?
417                    else if( instrType.startsWith( "i" ) ) {
418                            for(int i=0; i < vals.length; i++) {
419                                    if( i > 0 ) { buf.append( " or " ); }
420                                    buf.append( value );
421                                    buf.append( " LIKE '" ).append( vals[i] ).append( "'" );
422                            }
423                    }
424                    // 譚｡莉ｶ:notin 竍?蜷??繧誕nd縺ｮnot like譚｡莉ｶ縺ｧ邨仙粋(%縺ｪ縺? 5.5.1.1(2012/04/05)
425                    else if( instrType.startsWith( "n" ) ) {
426                            for(int i=0; i < vals.length; i++) {
427                                    if( i > 0 ) { buf.append( " and " ); }
428                                    buf.append( value );
429                                    buf.append( " NOT LIKE '" ).append( vals[i] ).append( "'" );
430                            }
431                    }
432                    else {
433                            String errMsg = "instrType縺ｫ縺ｯ縲?and','or','in','notin'縺ｮ縺?★繧後°繧呈欠螳壹＠縺ｦ荳九＆縺??instrType=[" + instrType + "]";
434                            throw new HybsSystemException( errMsg );
435                    }
436                    buf.append( ") " );
437    
438                    return buf.toString();
439            }
440    
441            /**
442             * 縲慎AG縲全QL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)縲?
443             *
444             * @og.tag
445             * value 繧帝?邨舌☆繧句?蜷医?鬆ｭ縺ｫ鄂ｮ縺九ｌ繧区枚蟄怜?縺ｧ縲『here蜿･縺ｮ譛??縺ｫ縺ｯ陦ｨ遉ｺ縺輔ｌ縺壹?
446             * 縺昴ｌ莉･髯阪↓縺､縺?※縲∬｡ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
447             * (縺､縺ｾ繧翫?where VALUE1 and VALUE2 and VALUE3 窶ｦ 縺ｧ縺吶?)
448             * startKey 縺ｮ蛻晄悄蛟､縺ｯ縲?and" 縺ｧ縺吶?
449             *
450             * @param       skey 譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ?
451             */
452            public void setStartKey( final String skey ) {
453                    if( skey != null && skey.length() > 0 ) { startKey = skey; }
454            }
455    
456            /**
457             * 縲慎AG縲第擅莉ｶ縺ｮ蛟､繧?繧ｻ繝?ヨ縺励∪縺吶?
458             *
459             * @og.tag
460             * 譚｡莉ｶ蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医?縺昴?繝ｪ繧ｯ繧ｨ繧ｹ繝亥?縺後↑縺??蜷医?縲?
461             * 縺薙?繧ｿ繧ｰ縺昴?繧ゅ?縺後↑縺ｫ繧ょ?蜉帙＠縺ｾ縺帙ｓ縲?縺､縺ｾ繧頑擅莉ｶ縺九ｉ豸医∴縺ｾ縺吶?)
462             * BODY 驛ｨ縺ｫ險倩ｿｰ縺吶ｋ縺薙→縺悟庄閭ｽ縺ｧ縺吶?縺昴?蝣ｴ蜷医?縲∵擅莉ｶ螻樊?縺ｫ縺ｪ縺ｫ繧りｨｭ螳壹〒縺阪∪縺帙ｓ縲?
463             *
464             * @param       val 譚｡莉ｶ蛟､
465             */
466            public void setValue( final String val ) {
467                    value = val;
468            }
469    
470            /**
471             * 縲慎AG縲代せ繝壹?繧ｹ縺ｧ蛹ｺ蛻?ｉ繧後◆隍?焚縺ｮ蛟､縺吶∋縺ｦ繧貞性繧?擅莉ｶ繧剃ｽ懈?縺励∪縺吶?
472             *
473             * @og.tag
474             * 騾壼ｸｸ縲」alue="CLM LIKE 'ABC%'" 縺ｨ縺?≧譁?ｭ怜?繧呈欠螳壹＠縺ｾ縺吶′縲?
475             * value="CLM" instrVals="ABC DEF GHI" 縺ｨ謖?ｮ壹☆繧九→縲?
476             * value="CLM LIKE '%ABC%' AND CLM LIKE '%DEF%'  AND CLM LIKE '%GHI%' "
477             * 縺ｨ縺?≧譁?ｭ怜?繧剃ｽ懈?縺励∪縺吶?
478             * 縺薙ｌ縺ｯ縲（nstrVals 縺ｫ謖?ｮ壹＠縺溷ｼ墓焚縺ｫ蟇ｾ縺励※縲√せ繝壹?繧ｹ蛹ｺ蛻?ｊ縺ｧ蛻?牡縺励?
479             * 蜑肴婿縺ｮ value 縺ｫ隍?焚縺ｮAND讀懃ｴ｢繧貞酔譎ゅ↓螳溽樟縺ｧ縺阪ｋ繧医≧縺ｫ謖?ｮ壹＠縺ｾ縺?
480             * 蛟句挨縺ｫLIKE讀懃ｴ｢鬆?岼繧?AND 騾｣邨舌☆繧狗ぜ縲∫樟繧後ｋ蝣ｴ謇?↓萓晏ｭ倥＠縺ｾ縺帙ｓ縲?
481             * 騾?↓縲∫樟繧後ｋ鬆?ｺ上ｒ謖?ｮ壹☆繧句?蜷医?縲、BC%DEF 縺ｮ讒倥↓謖?ｮ壼庄閭ｽ縺ｧ縺吶?
482             * 縺溘□縺励?columnMarker 縺ｮ instrVals 縺ｧ縲∬､?焚譁?ｭ励?繝槭?繧ｫ繝ｼ繧定｡後≧蝣ｴ蜷医?
483             * ABC%DEF 縺ｨ縺?≧譁?ｭ怜?縺ｯ縲√が繝ｪ繧ｸ繝翫Ν縺ｧ縺ｪ縺??縺ｧ縲√?繝ｼ繧ｯ繧｢繝??縺輔ｌ縺ｾ縺帙ｓ縲?
484             * 窶ｻinstrType螻樊?縺ｮ謖?ｮ壹↓繧医ｊ譚｡莉ｶ縺ｮ逕滓?譁ｹ豕輔ｒ螟画峩縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
485             *   隧ｳ邏ｰ縺ｫ縺､縺?※縺ｯ縲（nstrType螻樊?縺ｮ繝峨く繝･繝｡繝ｳ繝医ｒ蜿ら?荳九＆縺??
486             *
487             * @param       val 隍?粋譚｡莉ｶ菴懈?縺ｮ縺溘ａ縺ｮ險ｭ螳壼?
488             * @see         #setInstrType
489             * @see         ColumnMarkerTag#setInstrVals( String )
490             */
491            public void setInstrVals( final String val ) {
492                    instrVals = val;
493            }
494    
495            /**
496             * 縲慎AG縲訴nstrVals縺ｧ隍?焚縺ｮ蛟､繧呈擅莉ｶ縺ｫ縺吶ｋ髫帙?譁ｹ豕輔ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:and)縲?
497             *
498             * @og.tag
499             * 騾壼ｸｸ縲（nstrVals縺ｫ謖?ｮ壹＆繧後◆蛟､縺ｯ縲√せ繝壹?繧ｹ蛹ｺ蛻?ｊ縺ｧ蛻?牡縺励◆蜷??繧鱈IKE譚｡莉ｶ縺ｨ縺励※and邨仙粋縺励∪縺吶?
500             * 縺励°縺励?instrType螻樊?繧貞､画峩縺吶ｋ縺薙→縺ｧ縲√％縺ｮ譚｡莉ｶ蠑上?逕滓?譁ｹ豕輔ｒ螟画峩
501             * 縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
502             * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲∽ｻ･荳九?騾壹ｊ縺ｧ縺吶?
503             * 竭?nstrType縺ｫ"and"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?蛻晄悄蛟､)
504             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
505             *   逕滓?譁?ｭ怜? :       "( CLM LIKE '%ABC%' AND CLM LIKE '%DEF%' AND CLM LIKE '%GHI%' )"
506             * 竭｡instrType縺ｫ"or"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
507             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
508             *   逕滓?譁?ｭ怜? :       "( CLM LIKE '%ABC%' OR CLM LIKE '%DEF%' OR CLM LIKE '%GHI%' )"
509             * 竭｢instrType縺ｫ"in"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
510             *   繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
511             *   逕滓?譁?ｭ怜? :       "( CLM LIKE 'ABC' OR CLM LIKE 'DEF5' OR CLM LIKE 'GHI' )"
512             * 竭｣instrType縺ｫ"notin"縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷?
513             *       繧ｿ繧ｰ縺ｮ險倩ｿｰ : value="CLM" instrVals="ABC DEF GHI"
514             *   逕滓?譁?ｭ怜? :       "( CLM NOT LIKE 'ABC' AND CLM NOT LIKE 'DEF5' AND CLM NOT LIKE 'GHI' )"
515             * 窶ｻ縺薙?螻樊?繧呈欠螳壹＠縺ｪ縺??蜷医?縲≫蔵縺ｮLIKE譚｡莉ｶ縺ｧ縺ｮand邨仙粋縺ｨ縺ｪ繧翫∪縺吶?
516             * 窶ｻ竭｢竭｣縺ｫ縺､縺?※縲´IKE譚｡莉ｶ縺ｧ%繧定?蜍穂ｻ伜刈縺励↑縺?％縺ｨ縺ｫ繧医ｊ縲∫判髱｢縺九ｉ縺ｮ蜈･蜉帛?縺ｫ蠢懊§縺ｦ縲?
517             *   蜑肴婿荳??縲∝ｾ梧婿荳??縲∝燕蠕梧婿荳??縺ｮ蛻ｶ蠕｡繧定｡後≧縺薙→縺後〒縺阪∪縺吶?
518             *
519             * @og.rev 5.5.1.1 (2012/04/06) notin蟇ｾ蠢?繧ｳ繝｡繝ｳ繝井ｿｮ豁｣)
520             *
521             * @param       tp 譚｡莉ｶ譁ｹ豕票and/or/in/notin]
522             * @see         #setInstrVals( String )
523             */
524            public void setInstrType( final String tp ) {
525                    instrType = nval( getRequestParameter( tp ),tp );
526            }
527    
528            /**
529             * 縲慎AG縲題､?焚縺ｮ蠑墓焚縺ｫ蟇ｾ縺励※蜃ｦ逅?☆繧九°縺ｩ縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
530             *
531             * @og.tag
532             * {&#064;XXXX} 螟画焚縺ｫ縲∝?縺瑚､?焚蜷ｫ縺ｾ繧後※縺?ｋ蝣ｴ蜷医?蜃ｦ逅?ｒ隕丞ｮ壹＠縺ｾ縺吶?
533             * multi="true" 縺ｫ險ｭ螳壹☆繧九→縲∬､?焚縺ｮ蠑墓焚縺ｯ縲?xx1','xx2','xx3', ?･?･?･ 縺ｨ縺?≧
534             * 蠖｢蠑上↓螟画鋤縺励∪縺吶?
535             * where 譚｡莉ｶ縺ｧ險?≧縺ｨ縲?"where PN in ( {&#064;PN} )" 縺ｨ縺?≧譁?ｭ怜?縺ｫ蟇ｾ縺励※縲?
536             * "where PN in ( 'xx1','xx2','xx3' )" 繧剃ｽ懈?縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶?
537             * 蛻晄悄蛟､縺ｯ縲?false (繝槭Ν繝∝､画鋤縺励↑縺? 縺ｧ縺吶?
538             *
539             * @param   flag 繝槭Ν繝∝､画鋤 [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺?
540             * @see         #setSeparator( String )
541             */
542            public void setMulti( final String flag ) {
543                    multi = nval( flag,multi );
544            }
545    
546            /**
547             * 縲慎AG縲僧ulti 繧｢繧ｯ繧ｷ繝ｧ繝ｳ譎ゅ?譁?ｭ怜?繧貞?蜑ｲ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
548             *
549             * @og.tag
550             * multi="true" 縺ｮ蝣ｴ蜷医?隍?焚縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝医ｒ騾｣邨舌＠縺ｦ縲?in 蜿･縺ｧ蝠丞粋縺帙ｒ陦後≧譁?ｭ怜?繧?
551             * 菴懈?縺励∪縺吶′縲《eparator 繧呈欠螳壹☆繧九→縲√＆繧峨↓縲《eparator 縺ｧ譁?ｭ怜?繧貞?蜑ｲ縺励※縲?
552             * in 蜿･縺ｮ蠑墓焚繧呈ｧ狗ｯ峨＠縺ｾ縺吶?
553             * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲∝?蜑ｲ蠕後?譁?ｭ怜?縺後?隍?焚縺ｮ蛟九?縺ｮ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｨ蜷後§蠖｢蠑上↓蜉?ｷ･縺輔ｌ縺ｾ縺吶?
554             * 縺薙?讖溯?縺ｯ縲［ulti="true" 繧呈欠螳壹＠縺溷?蜷医?縺ｿ譛牙柑縺ｫ縺ｪ繧翫∪縺吶?
555             * 蛻晄悄蛟､縺ｯ縲］ull 縺ｧ縺吶?縺､縺ｾ繧翫?蛻?牡蜃ｦ逅??陦後＞縺ｾ縺帙ｓ縲?
556             *
557             * @og.rev 5.2.2.0 (2010/11/01) 譁ｰ隕剰ｿｽ蜉?
558             *
559             * @param   sepa 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
560             * @see         #setMulti( String )
561             */
562            public void setSeparator( final String sepa ) {
563                    separator = nval( getRequestParameter( sepa ),separator );
564            }
565    
566            /**
567             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
568             *              (蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
569             *
570             * @og.tag
571             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
572             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
573             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
574             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
575             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
576             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
577             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
578             *
579             * @og.rev 4.0.0.0 (2005/08/31) 譁ｰ隕剰ｿｽ蜉?
580             *
581             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
582             * @see         org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK
583             */
584            public void setQuotCheck( final String flag ) {
585                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
586            }
587    
588            /**
589             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
590             *              (蛻晄悄蛟､:USE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
591             *
592             * @og.tag
593             * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?荳?腸縺ｨ縺励※less/greater than sign縺ｫ縺､縺?※縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
594             * (&gt;&lt;) 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
595             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
596             *
597             * @og.rev 5.0.0.2 (2009/09/15) 譁ｰ隕剰ｿｽ蜉?
598             *
599             * @param       flag    XSS繝√ぉ繝?け [true:縺吶ｋ/false:縺励↑縺Ь
600             * @see         org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK
601             */
602            public void setXssCheck( final String flag ) {
603                    xssCheck = nval( getRequestParameter( flag ),xssCheck );
604            }
605    
606            /**
607             * 縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
608             *
609             * @og.tag
610             * matchKey.matches( matchVal ) 縺ｮ蛟､縺後?true 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
611             * false 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
612             * value 蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医→蜷後§蜉ｹ譫懊ｒ蠕励ｉ繧後∪縺吶?
613             * 菴輔ｂ謖?ｮ壹＠縺ｪ縺??蜷医?縺ｾ縺溘?縲∝ｼ墓焚縺?null 縺ｮ蝣ｴ蜷医?縲》rue 縺ｨ蜷後§縺ｧ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
614             *
615             * @og.rev 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
616             * @og.rev 5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
617             *
618             * @param       mkey String
619             */
620    //      public void setMatchKey( final String mkey ) {
621    //              matchKey = nval( getRequestParameter( mkey ),matchKey );
622    //      }
623    
624            /**
625             * 縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺吶?
626             *
627             * @og.tag
628             * matchKey.matches( matchVal ) 縺ｮ蛟､縺後?true 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
629             * false 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
630             * value 蛟､縺ｫ縲＋&#064;XXXX} 螟画焚縺悟性縺ｾ繧後※縺?ｋ蝣ｴ蜷医→蜷後§蜉ｹ譫懊ｒ蠕励ｉ繧後∪縺吶?
631             * 菴輔ｂ謖?ｮ壹＠縺ｪ縺??蜷医?縺ｾ縺溘?縲∝ｼ墓焚縺?null 縺ｮ蝣ｴ蜷医?縲》rue 縺ｨ蜷後§縺ｧ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
632             *
633             * @og.rev 5.1.9.0 (2010/08/01) 譁ｰ隕剰ｿｽ蜉?
634             * @og.rev 5.2.2.0 (2010/11/01) 蟒?ｭ｢(caseKey,caseVal螻樊?繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
635             *
636             * @param       mval String
637             */
638    //      public void setMatchVal( final String mval ) {
639    //              matchVal = nval( getRequestParameter( mval ),matchVal );
640    //      }
641    
642            /**
643             * 繧ｿ繧ｰ縺ｮ蜷咲ｧｰ繧偵?霑斐＠縺ｾ縺吶?
644             * 閾ｪ蛻??霄ｫ縺ｮ繧ｯ繝ｩ繧ｹ蜷阪ｈ繧翫?閾ｪ蜍慕噪縺ｫ蜿悶ｊ蜃ｺ縺帙↑縺?◆繧√?縺薙?繝｡繧ｽ繝?ラ繧偵が繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
645             *
646             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕剰ｿｽ蜉?
647             *
648             * @return  繧ｿ繧ｰ縺ｮ蜷咲ｧｰ
649             */
650            @Override
651            protected String getTagName() {
652                    return "and" ;
653            }
654    
655            /**
656             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
657             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
658             *
659             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
660             */
661            @Override
662            public String toString() {
663                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
664                                    .println( "VERSION"                     ,VERSION        )
665                                    .println( "startKey"            ,startKey       )
666                                    .println( "value"                       ,value          )
667                                    .println( "instrVals"           ,instrVals      )
668                                    .println( "multi"                       ,multi          )
669                                    .println( "quotCheck"           ,quotCheck      )
670                                    .println( "Other..."    ,getAttributes().getAttribute() )
671                                    .fixForm().toString() ;
672            }
673    }