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    import org.opengion.hayabusa.db.DBTableModel;
021    import org.opengion.hayabusa.db.DBColumn;
022    import org.opengion.hayabusa.db.Query;
023    import org.opengion.hayabusa.db.QueryFactory;
024    import org.opengion.fukurou.util.XHTMLTag;
025    import org.opengion.fukurou.util.Attributes;
026    import org.opengion.fukurou.db.Transaction;
027    import org.opengion.fukurou.db.TransactionReal;
028    
029    import static org.opengion.fukurou.util.StringUtil.nval ;
030    
031    import java.io.ObjectOutputStream;
032    import java.io.ObjectInputStream;
033    import java.io.IOException;
034    
035    /**
036     * 繝励Ν繝?え繝ｳ繝｡繝九Η繝ｼ縺ｮ驕ｸ謚樣?逶ｮ繧担ELECT譁??邨先棡縺九ｉ菴懈?縺吶ｋ繧ｿ繧ｰ縺ｧ縺吶?
037     *
038     * 蝓ｺ譛ｬ逧?↓縺ｯ縲?ｽ爽ery繧ｿ繧ｰ縺ｨ蜷後§菴ｿ縺?婿繧偵＠縺ｾ縺吶?
039     * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医↓縲?queryId 繧剃ｸ弱∴繧九％縺ｨ縺ｫ繧医ｊ縲〈ueryId 縺ｫ蟇ｾ蠢懊＠縺?Query繧ｪ繝悶ず繧ｧ繧ｯ繝?
040     * (縺ｮ繧ｵ繝悶け繝ｩ繧ｹ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝?縺御ｽ懈?縺輔ｌ縺ｾ縺吶?
041     * 縺薙％縺ｧ謖?ｮ壹☆繧鬼ELECT譁??縲√?SELECT KEY縲´ABEL1縲´ABEL2縲?ｽ･?･?･ FROM TABLE ?･?･?･縲丞ｽ｢蠑?繧?
042     * 縺励※縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?迚ｹ蛻･縺ｪ繧ｱ繝ｼ繧ｹ縺ｨ縺励※縲√?SELECT KEY FROM TABLE ?･?･?･縲丞ｽ｢蠑上?蝣ｴ蜷医?縲?
043     * LABEL 縺ｫ KEY 縺?菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
044     * SystemData 縺ｮ USE_SQL_INJECTION_CHECK 縺?true 縺九?quotCheck 螻樊?縺?true 縺ｮ蝣ｴ蜷医?縲?
045     * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲也畑縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?繝ｪ繧ｯ繧ｨ繧ｹ繝亥ｼ墓焚縺ｫ
046     * 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(')縺悟性縺ｾ繧後ｋ縺ｨ縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
047     * 蜷梧ｧ倥↓USE_XSS_CHECK縺荊rue縺九?xssCheck螻樊?縺荊rue縺ｮ蝣ｴ蜷医?縲?
048     * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｹ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?縺溘ａless/greater than sign縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
049     *
050     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
051     *
052     * @og.formSample
053     * 笳丞ｽ｢蠑擾ｼ?
054     *     &lt;og:queryOption &gt;
055     *          SELECT譁?
056     *     &lt;/og:queryOption &gt;
057     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
058     *
059     * 笳週ag螳夂ｾｩ??
060     *   &lt;og:queryOption
061     *       value              縲慎AG縲前ption縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､繧呈欠螳壹＠縺ｾ縺?
062     *       separator          縲慎AG縲題､?焚縺ｮ繝ｩ繝吶Ν繧貞粋謌舌☆繧九→縺阪↓菴ｿ逕ｨ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｹ繝壹?繧ｹ)
063     *       defaultVal         縲慎AG縲宋alue蛟､縺君ULL縺ｮ蝣ｴ蜷医↓菴ｿ逕ｨ縺輔ｌ繧句?譛溷?繧定ｨｭ螳壹＠縺ｾ縺?
064     *       language           縲慎AG縲代ち繧ｰ蜀?Κ縺ｧ菴ｿ逕ｨ縺吶ｋ險?ｪ槭さ繝ｼ繝閏ja/en/zh/窶ｦ]繧呈欠螳壹＠縺ｾ縺?
065     *       quotCheck          縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[=true])
066     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?
067     *       addKey             縲慎AG縲鷹?逶ｮ縺御ｸ?▽縺?￠縺ｮ蝣ｴ蜷医??暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ縺ｫ縲√く繝ｼ諠??繧定ｿｽ蜉?☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
068     *       classUseNo         縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?class 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺?
069     *       groupUseNo         縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｮ繧ｰ繝ｫ繝ｼ繝怜喧繧定｡後≧繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺?
070     *       titleUseNo         縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?title 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺?
071     *       xssCheck           縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_XSS_CHECK[=true])
072     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
073     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
074     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
075     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
076     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
077     *   &gt;   ... Body ...
078     *   &lt;/og:queryOption&gt;
079     *
080     * 笳丈ｽｿ逕ｨ萓?
081     *     &lt;og:select name="CDC" &gt;
082     *         &lt;og:queryOption&gt;
083     *                 select NOSYN,NOSYN,NMSYN from DB01 ORDER BY 1
084     *         &lt;/og:queryOption&gt;
085     *     &lt;/og:select&gt;
086     *
087     *     &lt;og:select name="CDC" &gt;                驕ｸ謚樣?逶ｮ縺ｮ荳?分荳翫↓遨ｺ逋ｽ繧偵そ繝?ヨ縺励◆縺?→縺腔ption繧ｿ繧ｰ繧堤ｵ?粋縺帙ｋ縺薙→繧ょ庄閭ｽ縺ｧ縺吶?
088     *         &lt;og:option lbl="" /&gt;               蛻晄悄蛟､繧定ｨｭ螳壹＠縺溘＞縺ｨ縺阪?value螻樊?繧剃ｽｿ縺?∪縺吶?
089     *         &lt;og:queryOption value="61200" separator=":" &gt;
090     *                 select CDBK,CDBK,NMBK from DB02 ORDER BY 1
091     *         &lt;/og:queryOption&gt;
092     *     &lt;/og:select&gt;
093     *
094     * @og.group 驕ｸ謚槭ョ繝ｼ繧ｿ蛻ｶ蠕｡
095     *
096     * @version  4.0
097     * @author   Kazuhiko Hasegawa
098     * @since    JDK5.0,
099     */
100    public class QueryOptionTag extends CommonTagSupport {
101            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
102            private static final String VERSION = "5.7.1.0 (2013/12/06)" ;
103    
104            private static final long serialVersionUID = 571020131206L ;
105    
106            private transient DBTableModel  table           = null;
107            private String  selValue        = null;
108            private String  defaultVal      = null;
109            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
110    //      private String  dbid            = "DEFAULT";
111            private String  dbid            = null;
112            private String  sql                     = null;
113            private String  separator       = " ";          // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
114            private boolean quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
115            private int             classUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧九け繝ｩ繧ｹ螻樊?
116            private int             groupUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ↓霑ｽ蜉?☆繧九げ繝ｫ繝ｼ繝玲枚蟄?
117            private boolean addKey          = false;                // 4.0.0 (2006/11/15) 鬆?岼荳?▽縺ｮ縺ｨ縺阪↓?暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ陦ｨ遉ｺ譎ゅ↓繧ｭ繝ｼ繧ゆｻ伜刈縺吶ｋ縲?
118            private int             titleUseNo              = -1;   // 4.3.8.0 (2009/08/01) 繧ｪ繝励す繝ｧ繝ｳ縺ｮtitle螻樊?
119            private boolean xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
120            private String  rawSql          = null; // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
121    
122            /**
123             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
124             *
125             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
126             *
127             * @return      蠕檎ｶ壼?逅??謖?､ｺ( EVAL_BODY_BUFFERED )
128             */
129            @Override
130            public int doStartTag() {
131                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
132                    if( useTag() ) {
133                            return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
134                    }
135                    return ( SKIP_BODY );                           // Body 繧定ｩ穂ｾ｡縺励↑縺?
136            }
137    
138            /**
139             * Taglib縺ｮ繧ｿ繧ｰ譛ｬ菴薙ｒ蜃ｦ逅?☆繧?doAfterBody() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
140             *
141             * @og.rev 3.1.1.0 (2003/03/28) 繝懊ョ繧｣縺ｮ蜀?ｮｹ繧貞叙蠕励☆繧句?逅?ｒ縲，ommonTagSupport 縺ｧ陦後≧縲?
142             * @og.rev 3.6.0.8 (2004/11/19) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｫ遒ｺ螳溘↓繝ｪ繝ｪ繝ｼ繧ｹ縺輔ｌ繧九ｈ縺?↓ try finally 霑ｽ蜉?
143             * @og.rev 3.7.1.0 (2005/04/26) DBTableModel 縺後☆縺ｧ縺ｫ繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医?縲ヾQL蜃ｦ逅?ｸ崎ｦ√?
144             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
145             * @og.rev 4.0.0.0 (2005/08/31) useQuotCheck() 縺ｫ繧医ｋ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲?
146             * @og.rev 3.8.6.3 (2006/11/30) SQL 譁??蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺阪∪縺吶?
147             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
148             * @og.rev 4.3.6.0 (2009/04/01) EventColumn蟇ｾ蠢?
149             * @og.rev 5.0.0.5 (2009/08/28) XSS蟇ｾ遲?
150             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
151             * @og.rev 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢懊?荳贋ｽ阪↓ TransactionTag 縺後≠繧後?縲√◎縺薙°繧韻onnection 繧偵ｂ繧峨≧縲?
152             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
153             * @og.rev 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
154             *
155             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
156             */
157            @Override
158            public int doAfterBody() {
159                    // 3.7.1.0 (2005/04/26) DBTableModel 縺後☆縺ｧ縺ｫ繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医?縲ヾQL蜃ｦ逅?ｸ崎ｦ√?
160                    if( table != null ) { return(SKIP_BODY); }
161    
162                    // 4.0.0 (2005/08/31) useQuotCheck() 縺ｫ繧医ｋ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲?
163                    useQuotCheck( quotCheck );
164                    // 5.0.0.2 (2009/09/15) XSS蟇ｾ遲?
165                    useXssCheck( xssCheck );
166    
167                    sql = getBodyString().trim();
168    //              String rawsql = getBodyRawString().trim(); // 4.3.6.0 逕溘?SQL繧剃ｿ晄戟
169                    rawSql = getBodyRawString().trim();
170    
171                    // 4.3.6.0 (2009/04/01) 繧ｻ繝?す繝ｧ繝ｳ縺ｸ縺ｮSQL譁?匳骭ｲ
172                    // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
173    //              String[] selectVals = getEventColumn(); // 隕ｪ繧ｿ繧ｰ縺九ｉ繧､繝吶Φ繝医き繝ｩ繝?ｨｭ螳壹ｒ蜿悶ｋ
174    //              if( selectVals[0] != null && selectVals[0].length() > 0 ){
175    //                      addEventColumnSQL( selectVals[1], rawsql );
176    //              }
177    
178                    Query query = QueryFactory.newInstance();               // 4.0.0 (2005/01/31)
179                    Transaction tran = null;
180                    try {
181                            // 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢?
182    //                      final Transaction tran ;
183                            TransactionTag tranTag = (TransactionTag)findAncestorWithClass( this,TransactionTag.class );
184                            if( tranTag == null ) {
185    //                              tran = new TransactionReal( dbid,getApplicationInfo() );
186                                    tran = new TransactionReal( getApplicationInfo() );             // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
187                            }
188                            else {
189                                    tran = tranTag.getTransaction();
190                            }
191                            query.setTransaction( dbid,tran );      // 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢?
192    
193    //                      query.setConnectionID( dbid );
194                            query.setResourceManager( getResource() );      // 4.0.0 (2005/01/31)
195    
196                            query.setStatement( sql );
197    //                      query.setApplicationInfo( getApplicationInfo() );       // 3.8.7.0 (2006/12/15)
198                            query.execute();
199    
200                            table = query.getDBTableModel();
201    
202                            // 4.0.0 (2005/11/30) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧偵?"DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
203                    }
204                    finally {
205    //                      if( query != null ) { query.close(); }
206                            QueryFactory.close( query );
207                            if( tran != null ) { tran.close(); }            // 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
208                    }
209                    return(SKIP_BODY);
210            }
211    
212            /**
213             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
214             *
215             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
216             * @og.rev 3.3.2.0 (2003/07/07) defaultVal 螻樊?縺ｮ霑ｽ蜉??
217             * @og.rev 3.5.4.0 (2003/11/25) selVal 螻樊?繧定ｿｽ蜉??
218             * @og.rev 5.0.2.0 (2009/11/01) 隍?焚繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｮ驕ｸ謚槭↓蟇ｾ蠢?
219             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
220             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
221             * @og.rev 5.7.1.0 (2013/12/06) SelectTag 竍?OptionAncestorIF 縺ｫ螟画峩縺励※縲．atalistTag 縺ｫ繧ょｯｾ蠢懊?
222             *
223             * @return      蠕檎ｶ壼?逅??謖?､ｺ
224             */
225            @Override
226            public int doEndTag() {
227                    debugPrint();           // 4.0.0 (2005/02/28)
228                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
229                    if( useTag() ) {
230    //                      SelectTag select = (SelectTag)findAncestorWithClass( this,SelectTag.class );
231                            OptionAncestorIF select = (OptionAncestorIF)findAncestorWithClass( this,OptionAncestorIF.class );
232                            if( select == null ) {
233    //                              String errMsg = "縺薙?繧ｿ繧ｰ縺ｯ縲ヾelectTag 縺ｮBODY 縺ｫ險倩ｿｰ縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?";
234                                    String errMsg = "<b>" + getTagName() + "繧ｿ繧ｰ縺ｯ縲ヾelectTag 縺ｾ縺溘?縲．atalistTag 縺ｮBODY 縺ｫ險倩ｿｰ縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?</b>";
235                                    throw new HybsSystemException( errMsg );
236                            }
237                            String selVal = nval( select.getValue(),defaultVal );   // 3.5.4.0 (2003/11/25)
238            //              selValue = nval( selValue,selVal );                                             // 3.5.4.0 (2003/11/25)
239                            selValue = "|" + nval( selValue,selVal ) + "|";                 // 5.0.2.0 (2009/11/01)
240                            makeLabel( select );
241    
242                            // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
243                            select.setRawParam( rawSql );
244                    }
245                    return(EVAL_PAGE);
246            }
247    
248            /**
249             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
250             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
251             *
252             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
253             * @og.rev 3.0.1.0 (2003/03/03) 繧ｻ繝代Ξ繝ｼ繧ｿ繝ｼ繧呈欠螳壹〒縺阪ｋ讒倥↓螟画峩縲?
254             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
255             * @og.rev 3.3.2.0 (2003/07/07) defaultVal 螻樊?縺ｮ霑ｽ蜉??
256             * @og.rev 3.8.5.2 (2006/06/09) classUseNo , groupUseNo 螻樊?縺ｮ霑ｽ蜉??
257             * @og.rev 4.0.0.0 (2005/08/31) quotCheck , addKey 螻樊?縺ｮ霑ｽ蜉?
258             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
259             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
260             *
261             */
262            @Override
263            protected void release2() {
264                    super.release2();
265                    table           = null;
266                    selValue        = null;
267                    defaultVal      = null;
268    //              dbid            = "DEFAULT";
269                    dbid            = null;
270                    sql                     = null;
271                    separator       = " ";
272                    classUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧九け繝ｩ繧ｹ螻樊?
273                    groupUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ↓霑ｽ蜉?☆繧九げ繝ｫ繝ｼ繝玲枚蟄?
274                    quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
275                    addKey          = false;                // 4.0.0 (2006/11/15) 鬆?岼荳?▽縺ｮ縺ｨ縺阪↓?暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ陦ｨ遉ｺ譎ゅ↓繧ｭ繝ｼ繧ゆｻ伜刈縺吶ｋ縲?
276                    titleUseNo              = -1;
277                    xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
278                    rawSql          = null; // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
279            }
280    
281            /**
282             * DBTableModel繧偵そ繝?ヨ縺励∪縺吶?
283             *
284             * 繧ｵ繝悶け繝ｩ繧ｹ繧医ｊ縲．BTableModel繧偵そ繝?ヨ縺吶ｋ縺ｮ縺ｫ菴ｿ縺?∪縺吶?
285             *
286             * @og.rev 3.7.1.0 (2005/04/26) 譁ｰ隕剰ｿｽ蜉?
287             *
288             * @param       table   DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
289             */
290            protected void setTableModel( final DBTableModel table ) {
291                    this.table = table ;
292            }
293    
294            /**
295             * 繧ｪ繝励す繝ｧ繝ｳ繧剃ｽ懈?縺励∪縺吶?
296             *
297             * DBTableModel 縺ｮ?醍分逶ｮ縺ｮ蛟､繧?"value" 縺ｫ縲√◎繧御ｻ･髯阪ｒ譁?ｭ怜?繧帝?邨舌＆縺帙※
298             * BODY螻樊? 縺ｫ逋ｻ骭ｲ縺吶ｋOption繧剃ｽ懈?縺励∪縺吶?
299             *
300             * @og.rev 3.0.1.0 (2003/03/03) 縲惨ELECT KEY FROM TABLE ?･?･?･縲丞ｽ｢蠑上?蝣ｴ蜷医?縲´ABEL 縺ｫ KEY 繧剃ｽｿ逕ｨ縲?
301             * @og.rev 3.8.0.9 (2005/10/17) 隍?焚驕ｸ謚槫庄閭ｽ譎ゅ↓蜈ｨ驕ｸ謚槭ｒ險ｭ螳壹☆繧九?
302             * @og.rev 3.8.5.2 (2006/06/09) classUseNo 螻樊?縺ｨ groupUseNo 螻樊?繧定ｿｽ蜉?
303             * @og.rev 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ縺ｮ險ｭ螳壽婿豕輔?繝舌げ菫ｮ豁｣
304             * @og.rev 4.3.8.0 (2009/08/01) titleUseNo螻樊?霑ｽ蜉?
305             * @og.rev 5.0.2.0 (2009/11/01) 隍?焚繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｮ驕ｸ謚槭↓蟇ｾ蠢?
306             * @og.rev 5.7.1.0 (2013/12/06) SelectTag 竍?OptionAncestorIF 縺ｫ螟画峩縺励※縲．atalistTag 縺ｫ繧ょｯｾ蠢懊?
307             *
308             * @param   select SelectTag繧ｪ繝悶ず繧ｧ繧ｯ繝?
309             */
310    //      private void makeLabel( final SelectTag select ) {
311            private void makeLabel( final OptionAncestorIF select ) {
312                    boolean multipleAll = select.isMultipleAll();   // 3.8.0.9 (2005/10/17)
313                    int rowCnt = table.getRowCount();               // 3.5.5.7 (2004/05/10)
314    
315                    String bkGroupKey = "";
316                    String grpLabel ;
317                    for( int row=0; row<rowCnt; row++ ) {
318                            // 3.8.5.2 (2006/06/09) groupUseNo 螻樊?
319                            if( groupUseNo >= 0 ) {
320                                    String groupKey = table.getValue( row,groupUseNo );
321                                    grpLabel = getRendererValue( row,groupUseNo );
322                                    if( !bkGroupKey.equals( groupKey ) ) {          // 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ
323                                            // 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ縺ｮ險ｭ螳壽婿豕輔?繝舌げ菫ｮ豁｣
324    //                                      bkGroupKey = groupKey;
325    //                                      if( row != 0 ) { select.addOption( "</optgroup>" ); }
326    //                                      select.addOption( "<optgroup label=\"" + grpLabel + "\">" );
327    
328                                            if( ! "".equals( bkGroupKey ) ) {
329                                                    select.addOption( "</optgroup>" );
330                                            }
331                                            if( ! "".equals( groupKey ) ) {
332                                                    select.addOption( "<optgroup label=\"" + grpLabel + "\">" );
333                                            }
334                                            bkGroupKey = groupKey;
335                                    }
336                            }
337    
338                            Attributes attri = new Attributes();
339                            String value = table.getValue( row,0 );
340                            attri.set( "value", value );
341    
342                            // 5.0.2.0 (2009/11/01)
343    //                      if( ( selValue != null && selValue.equals( value ) ) || multipleAll ) {
344                            if( ( selValue != null && selValue.length() > 0 && selValue.indexOf( "|" + value + "|" ) >= 0 ) || multipleAll ) {
345                                    attri.set( "selected", "selected" );
346                            }
347    
348                            // 3.8.5.2 (2006/06/09) classUseNo 螻樊?
349                            if( classUseNo >= 0 ) {
350                                    attri.add( "class", table.getValue( row,classUseNo ) );
351                            }
352    
353                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
354                            boolean titleFlg = false; // 4.3.8.0 (2009/08/01) title螻樊?繧剃ｻ倥￠繧九°縺ｩ縺?°
355                            if( table.getColumnCount() == 1 ) {
356                                    // 鬆?岼縺御ｸ?▽縺ｮ queryOption 縺ｧ縺ｯ縲√Λ繝吶Ν繝ｪ繧ｽ繝ｼ繧ｹ縺御ｽｿ逕ｨ縺輔ｌ縺ｾ縺吶?
357                                    if( addKey ) { buf.append( value ).append( ":" ); }
358                                    buf.append( getResource().getLabel( value ) );
359    
360                                    // 4.3.8.0 (2009/08/01) titleUseNo 螻樊? 繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医°縺､繝ｩ繝吶Ν縺ｨ逡ｰ縺ｪ繧句?蜷医?title螻樊?縺ｫ霑ｽ蜉?
361                                    if( titleUseNo >= 0 && !getResource().getLabel( value ).equals( table.getValue( row,titleUseNo ) )) {
362                                            titleFlg = true;
363                                    }
364                            }
365                            else {
366            //                      if( groupUseNo >= 0 ) {
367            //                              buf.append( grpLabel );
368            //                              buf.append( separator );
369            //                      }
370                                    String label = getRendererValue( row,1 );
371                                    buf.append( label );
372            //                      attri.set( "label", label );
373                                    for( int clm=2; clm<table.getColumnCount(); clm++ ) {
374                                            // 4.3.8.0 (2009/08/01) titleUseNo霑ｽ蜉?
375                                            // if( clm == groupUseNo || clm == classUseNo ) { continue; }
376                                            if( clm == groupUseNo || clm == classUseNo || clm==titleUseNo) { continue; }
377                                            buf.append( separator );
378                                            buf.append( getRendererValue( row,clm ) );
379                                    }
380    
381                                    // 4.3.8.0 (2009/08/01) titleUseNo 螻樊? 繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医°縺､繝ｩ繝吶Ν縺ｨ逡ｰ縺ｪ繧句?蜷医?title螻樊?縺ｫ霑ｽ蜉?
382                                    if( titleUseNo >= 0 && !label.equals( table.getValue( row,titleUseNo ) )) {
383                                            titleFlg = true;
384                                    }
385                            }
386    
387                            // 4.3.7.2 (2009/06/22) 繧ｿ繧､繝医Ν螻樊?繧ｻ繝?ヨ
388                            if( titleFlg ){
389                                    attri.add( "title", table.getValue( row,titleUseNo ) );
390                            }
391    
392                            attri.set( "body", buf.toString() );
393                            select.addOption( XHTMLTag.option( attri ) );
394                    }
395    //              if( groupUseNo >= 0 && "".equals( bkGroupKey ) ) {
396                    if( groupUseNo >= 0 && ! "".equals( bkGroupKey ) ) { // 3.8.9.2 (2007/07/28)
397                            select.addOption( "</optgroup>" );
398                    }
399            }
400    
401            /**
402             * 縲慎AG縲前ption縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､繧呈欠螳壹＠縺ｾ縺吶?
403             *
404             * @og.tag Option縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､繧呈欠螳壹＠縺ｾ縺吶?
405             *
406             * @param   val Option縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､
407             */
408            public void setValue( final String val ) {
409                    selValue = getRequestParameter( val );
410            }
411    
412            /**
413             * 縲慎AG縲宋alue蛟､縺君ULL縺ｮ蝣ｴ蜷医↓菴ｿ逕ｨ縺輔ｌ繧句?譛溷?繧定ｨｭ螳壹＠縺ｾ縺吶?
414             *
415             * @og.tag
416             * value蛟､縺君ULL縺ｮ蝣ｴ蜷医↓縲√％縺ｮ蛻晄悄蛟､繧偵そ繝?ヨ縺励∪縺吶?
417             *
418             * @og.rev 3.3.2.0 (2003/07/07) defaultVal 螻樊?縺ｮ霑ｽ蜉??(譁ｰ隕丈ｽ懈?)
419             *
420             * @param       val 蛻晄悄蛟､
421             */
422            public void setDefaultVal( final String val ) {
423                    defaultVal = getRequestParameter( val );
424            }
425    
426            /**
427             * 縲慎AG縲題､?焚縺ｮ繝ｩ繝吶Ν繧貞粋謌舌☆繧九→縺阪↓菴ｿ逕ｨ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｹ繝壹?繧ｹ)縲?
428             *
429             * @og.tag
430             * 蛻晄悄蛟､縺ｯ縲√せ繝壹?繧ｹ縺ｧ縺吶?
431             *
432             * @og.rev 3.0.1.0 (2003/03/03) 繧ｻ繝代Ξ繝ｼ繧ｿ繝ｼ繧呈欠螳壹〒縺阪ｋ讒倥↓螟画峩縲?
433             *
434             * @param   sep 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
435             */
436            public void setSeparator( final String sep ) {
437                    separator = nval( getRequestParameter( sep ),separator );
438            }
439    
440            /**
441             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?class 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
442             *
443             * @og.tag
444             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
445             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ縺ｫ class 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
446             * 蜷?が繝励す繝ｧ繝ｳ縺ｫ濶ｲ繧偵▽縺代ｋ蝣ｴ蜷医?縲√％縺ｮ class 螻樊?縺ｫ蟇ｾ蠢懊☆繧?CSS 繝輔ぃ繧､繝ｫ繧堤畑諢上＠縺ｾ縺吶?
447             * 縺薙％縺ｧ縺ｯ縲…lass 螻樊?縺ｫ菴ｿ逕ｨ縺吶ｋ SQL譁?? 繧ｫ繝ｩ繝?分蜿ｷ( 蜈磯?縺?0 ) 繧呈欠螳壹＠縺ｾ縺吶?
448             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
449             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
450             *
451             * @og.rev 3.8.5.2 (2006/06/09) 譁ｰ隕剰ｿｽ蜉?
452             *
453             * @param   no 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧九け繝ｩ繧ｹ螻樊?
454             */
455            public void setClassUseNo( final String no ) {
456                    classUseNo = nval( getRequestParameter( no ),classUseNo );
457                    if( classUseNo == 0 || classUseNo == 1 ) {
458                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
459                            throw new HybsSystemException( errMsg );
460                    }
461            }
462    
463            /**
464             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｮ繧ｰ繝ｫ繝ｼ繝怜喧繧定｡後≧繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
465             *
466             * @og.tag
467             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
468             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ繧偵げ繝ｫ繝ｼ繝怜喧縺励∪縺吶?繧ｰ繝ｫ繝ｼ繝怜喧縺ｯ optgroup隕∫ｴ?ｒ繝悶Ξ繧､繧ｯ譎ゅ↓
469             * 蜃ｺ蜉帙☆繧倶ｺ九〒蟇ｾ蠢懊＠縺ｾ縺吶?
470             * 縺薙％縺ｧ縺ｯ縲√げ繝ｫ繝ｼ繝怜喧縺ｫ菴ｿ逕ｨ縺吶ｋ SQL譁?? 繧ｫ繝ｩ繝?分蜿ｷ( 蜈磯?縺?0 ) 繧呈欠螳壹＠縺ｾ縺吶?
471             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
472             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
473             *
474             * @og.rev 3.8.5.2 (2006/06/09) 譁ｰ隕剰ｿｽ蜉?
475             *
476             * @param   no 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ↓霑ｽ蜉?☆繧九げ繝ｫ繝ｼ繝玲枚蟄?
477             */
478            public void setGroupUseNo( final String no ) {
479                    groupUseNo = nval( getRequestParameter( no ),groupUseNo );
480                    if( groupUseNo == 0 || groupUseNo == 1 ) {
481                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
482                            throw new HybsSystemException( errMsg );
483                    }
484            }
485    
486            /**
487             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
488             *              (蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
489             *
490             * @og.tag
491             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
492             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
493             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
494             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
495             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
496             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
497             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
498             *
499             * @og.rev 4.0.0.0 (2005/08/31) 譁ｰ隕剰ｿｽ蜉?
500             *
501             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
502             * @see         org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK
503             */
504            public void setQuotCheck( final String flag ) {
505                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
506            }
507    
508            /**
509             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
510             *
511             * @og.tag
512             * Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
513             * 縺薙ｌ縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｧ縲．EFAULT_DB_URL 遲峨〒謖?ｮ壹＠縺ｦ縺?ｋ 繝??繧ｿ繝吶?繧ｹ謗･邯壼?
514             * 諠??縺ｫ縲々X_DB_URL 繧貞ｮ夂ｾｩ縺吶ｋ縺薙→縺ｧ縲?dbid="XX" 縺ｨ縺吶ｋ縺ｨ縲√％縺ｮ 謗･邯壼?繧剃ｽｿ逕ｨ縺励※
515             * 繝??繧ｿ繝吶?繧ｹ縺ｫ繧｢繧ｯ繧ｻ繧ｹ縺ｧ縺阪∪縺吶?
516             *
517             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
518             */
519            public void setDbid( final String id ) {
520                    dbid = nval( getRequestParameter( id ),dbid );
521            }
522    
523            /**
524             * 縲慎AG縲鷹?逶ｮ縺御ｸ?▽縺?￠縺ｮ蝣ｴ蜷医??暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ縺ｫ縲√く繝ｼ諠??繧定ｿｽ蜉?☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
525             *
526             * @og.tag
527             * Query繧ｪ繝悶ず繧ｧ繧ｯ繝医?鬆?岼縺御ｸ?▽縺ｮ蝣ｴ蜷医??暦ｾ搾ｾ橸ｾ咎Κ縺ｫ縺ｯ縲?ｾ暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ繧剃ｽｿ逕ｨ縺励∪縺吶?
528             * 縺薙?譎ゅ??暦ｾ搾ｾ橸ｾ咏┌縺励?蝣ｴ蜷医?縲√く繝ｼ縺瑚｡ｨ遉ｺ縺輔ｌ縺ｾ縺吶′縲?ｾ暦ｾ搾ｾ橸ｾ吶≠繧翫?蝣ｴ蜷医?縲√く繝ｼ縺ｯ陦ｨ遉ｺ縺輔ｌ縺?
529             * ?暦ｾ搾ｾ橸ｾ吶?縺ｿ陦ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
530             * 驛ｽ蜷医↓繧医▲縺ｦ縺ｯ縲√く繝ｼ繧り｡ｨ遉ｺ縺励◆縺??蜷医′縺ゅｊ縺ｾ縺吶?縺ｧ縲√◎縺ｮ讒倥↑繧ｱ繝ｼ繧ｹ縺ｧ縺ｯ縲?
531             * addKey = "true 繧定ｨｭ螳壹☆繧倶ｺ九〒縲√く繝ｼ:?暦ｾ搾ｾ橸ｾ?縺ｮ繧ｻ繝?ヨ繧抵ｾ暦ｾ搾ｾ橸ｾ吶→縺励※謇ｱ縺?∪縺吶?
532             * 蛻晄悄蛟､縺ｯfalse(繧ｭ繝ｼ縺ｯ莉伜刈縺励↑縺?縺ｧ縺吶?
533             *
534             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
535             */
536            public void setAddKey( final String id ) {
537                    addKey = nval( getRequestParameter( id ),addKey );
538            }
539    
540            /**
541             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
542             *              (蛻晄悄蛟､:USE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
543             *
544             * @og.tag
545             * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?荳?腸縺ｨ縺励※less/greater than sign縺ｫ縺､縺?※縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
546             * (&gt;&lt;) 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
547             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
548             *
549             * @og.rev 5.0.0.2 (2009/09/15) 譁ｰ隕剰ｿｽ蜉?
550             *
551             * @param       flag    XSS繝√ぉ繝?け [true:縺吶ｋ/false:縺励↑縺Ь
552             * @see         org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK
553             */
554            public void setXssCheck( final String flag ) {
555                    xssCheck = nval( getRequestParameter( flag ),xssCheck );
556            }
557    
558            /**
559             * row陦鯉ｼ慶olum蛻?縺ｮ繝??繧ｿ縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
560             *
561             * 縺薙ｌ縺ｯ縲√ョ繝ｼ繧ｿ縺ｮ蛟､縺昴?繧ゅ?縺ｧ縺ｯ縺ｪ縺上?縺昴?蛟､縺ｮ繝ｩ繝吶Ν譁?ｭ励ｒ霑斐＠縺ｾ縺吶?
562             *
563             * @param   row         陦檎分蜿ｷ
564             * @param   column      繧ｫ繝ｩ繝?分蜿ｷ
565             *
566             * @return  row陦鯉ｼ慶olum蛻?縺ｮ繝??繧ｿ縺ｮ蛟､
567             */
568            private String getRendererValue( final int row,final int column ) {
569                    String val = table.getValue( row,column );
570                    DBColumn clm = table.getDBColumn( column );
571                    return clm.getRendererValue( val );
572            }
573    
574            /**
575             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?title 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
576             *
577             * @og.tag
578             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
579             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ縺ｫ title 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
580             * title螻樊?縺ｯ繝槭え繧ｹ繧ｪ繝ｼ繝舌?譎ゅ↓繝??繝ｫ繝√ャ繝励→縺励※陦ｨ遉ｺ縺輔ｌ繧九◆繧√?
581             * 繝励Ν繝?え繝ｳ縺ｮ讓ｪ蟷?ｒ遏ｭ縺上＠縺溘＞蝣ｴ蜷医↓譛牙柑縺ｧ縺吶?
582             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
583             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
584             *
585             * @og.rev 4.3.8.0 (2009/08/01) 譁ｰ隕剰ｿｽ蜉?
586             *
587             * @param   no 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧逆itle螻樊?
588             */
589            public void setTitleUseNo( final String no ) {
590                    titleUseNo = nval( getRequestParameter( no ),titleUseNo );
591                    if( titleUseNo == 0 || titleUseNo == 1 ) {
592                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
593                            throw new HybsSystemException( errMsg );
594                    }
595            }
596    
597            /**
598             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
599             *
600             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
601             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
602             *
603             * @param       strm    ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
604             * @throws IOException  蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
605             */
606            private void writeObject( final ObjectOutputStream strm ) throws IOException {
607                    strm.defaultWriteObject();
608            }
609    
610            /**
611             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
612             *
613             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
614             *
615             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
616             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
617             *
618             * @param       strm    ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
619             * @see #release2()
620             * @throws IOException  繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ縺ｫ髢｢縺吶ｋ蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
621             * @throws ClassNotFoundException       繧ｯ繝ｩ繧ｹ繧定ｦ九▽縺代ｋ縺薙→縺後〒縺阪↑縺九▲縺溷?蜷?
622             */
623            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
624                    strm.defaultReadObject();
625            }
626    
627    //      /**
628    //       * 隕ｪ縺ｮog:select繧ｿ繧ｰ縺ｮname縺ｨeventColumn險ｭ螳壹ｒ霑斐＠縺ｾ縺吶?
629    //       *
630    //       * @og.rev 4.3.6.0 (2009/04/01)
631    //       *
632    //       */
633    //      private String[] getEventColumn(){
634    //              SelectTag seltag = (SelectTag)findAncestorWithClass(this,SelectTag.class);
635    //              String[] selectVal = new String[2];
636    //              selectVal[0] = seltag.getEventColumn();
637    //              selectVal[1] = seltag.get("name");
638    //              return selectVal;
639    //      }
640    
641            /**
642             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
643             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
644             *
645             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
646             */
647            @Override
648            public String toString() {
649                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
650                                    .println( "VERSION"             ,VERSION        )
651                                    .println( "selValue"    ,selValue       )
652                                    .println( "defaultVal"  ,defaultVal     )
653                                    .println( "dbid"                ,dbid           )
654                                    .println( "sql"                 ,sql            )
655                                    .println( "separator"   ,separator      )
656                                    .println( "quotCheck"   ,quotCheck      )
657                                    .println( "Other..."    ,getAttributes().getAttribute() )
658                                    .fixForm().toString() ;
659            }
660    }