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 msg="" /&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.3.8.0 (2011/08/01)" ;
103    
104            private static final long serialVersionUID = 538020110801L ;
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             *
222             * @return      蠕檎ｶ壼?逅??謖?､ｺ
223             */
224            @Override
225            public int doEndTag() {
226                    debugPrint();           // 4.0.0 (2005/02/28)
227                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
228                    if( useTag() ) {
229                            SelectTag select = (SelectTag)findAncestorWithClass( this,SelectTag.class );
230                            if( select == null ) {
231                                    String errMsg = "縺薙?繧ｿ繧ｰ縺ｯ縲ヾelectTag 縺ｮBODY 縺ｫ險倩ｿｰ縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?";
232                                    throw new HybsSystemException( errMsg );
233                            }
234                            String selVal = nval( select.getValue(),defaultVal );   // 3.5.4.0 (2003/11/25)
235            //              selValue = nval( selValue,selVal );                                             // 3.5.4.0 (2003/11/25)
236                            selValue = "|" + nval( selValue,selVal ) + "|";                 // 5.0.2.0 (2009/11/01)
237                            makeLabel( select );
238    
239                            // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
240                            select.setRawParam( rawSql );
241                    }
242                    return(EVAL_PAGE);
243            }
244    
245            /**
246             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
247             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
248             *
249             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
250             * @og.rev 3.0.1.0 (2003/03/03) 繧ｻ繝代Ξ繝ｼ繧ｿ繝ｼ繧呈欠螳壹〒縺阪ｋ讒倥↓螟画峩縲?
251             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
252             * @og.rev 3.3.2.0 (2003/07/07) defaultVal 螻樊?縺ｮ霑ｽ蜉??
253             * @og.rev 3.8.5.2 (2006/06/09) classUseNo , groupUseNo 螻樊?縺ｮ霑ｽ蜉??
254             * @og.rev 4.0.0.0 (2005/08/31) quotCheck , addKey 螻樊?縺ｮ霑ｽ蜉?
255             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
256             * @og.rev 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
257             *
258             */
259            @Override
260            protected void release2() {
261                    super.release2();
262                    table           = null;
263                    selValue        = null;
264                    defaultVal      = null;
265    //              dbid            = "DEFAULT";
266                    dbid            = null;
267                    sql                     = null;
268                    separator       = " ";
269                    classUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧九け繝ｩ繧ｹ螻樊?
270                    groupUseNo      = -1;   // 3.8.5.2 (2006/06/09) 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ↓霑ｽ蜉?☆繧九げ繝ｫ繝ｼ繝玲枚蟄?
271                    quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
272                    addKey          = false;                // 4.0.0 (2006/11/15) 鬆?岼荳?▽縺ｮ縺ｨ縺阪↓?暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ陦ｨ遉ｺ譎ゅ↓繧ｭ繝ｼ繧ゆｻ伜刈縺吶ｋ縲?
273                    titleUseNo              = -1;
274                    xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
275                    rawSql          = null; // 5.1.7.0 (2010/06/01) 蜍慕噪繝励Ν繝?え繝ｳ螳溯｣?ｦ狗峩縺?
276            }
277    
278            /**
279             * DBTableModel繧偵そ繝?ヨ縺励∪縺吶?
280             *
281             * 繧ｵ繝悶け繝ｩ繧ｹ繧医ｊ縲．BTableModel繧偵そ繝?ヨ縺吶ｋ縺ｮ縺ｫ菴ｿ縺?∪縺吶?
282             *
283             * @og.rev 3.7.1.0 (2005/04/26) 譁ｰ隕剰ｿｽ蜉?
284             *
285             * @param       table   DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
286             */
287            protected void setTableModel( final DBTableModel table ) {
288                    this.table = table ;
289            }
290    
291            /**
292             * 繧ｪ繝励す繝ｧ繝ｳ繧剃ｽ懈?縺励∪縺吶?
293             *
294             * DBTableModel 縺ｮ?醍分逶ｮ縺ｮ蛟､繧?"value" 縺ｫ縲√◎繧御ｻ･髯阪ｒ譁?ｭ怜?繧帝?邨舌＆縺帙※
295             * BODY螻樊? 縺ｫ逋ｻ骭ｲ縺吶ｋOption繧剃ｽ懈?縺励∪縺吶?
296             *
297             * @og.rev 3.0.1.0 (2003/03/03) 縲惨ELECT KEY FROM TABLE ?･?･?･縲丞ｽ｢蠑上?蝣ｴ蜷医?縲´ABEL 縺ｫ KEY 繧剃ｽｿ逕ｨ縲?
298             * @og.rev 3.8.0.9 (2005/10/17) 隍?焚驕ｸ謚槫庄閭ｽ譎ゅ↓蜈ｨ驕ｸ謚槭ｒ險ｭ螳壹☆繧九?
299             * @og.rev 3.8.5.2 (2006/06/09) classUseNo 螻樊?縺ｨ groupUseNo 螻樊?繧定ｿｽ蜉?
300             * @og.rev 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ縺ｮ險ｭ螳壽婿豕輔?繝舌げ菫ｮ豁｣
301             * @og.rev 4.3.8.0 (2009/08/01) titleUseNo螻樊?霑ｽ蜉?
302             * @og.rev 5.0.2.0 (2009/11/01) 隍?焚繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｮ驕ｸ謚槭↓蟇ｾ蠢?
303             *
304             * @param   select SelectTag繧ｪ繝悶ず繧ｧ繧ｯ繝?
305             */
306            private void makeLabel( final SelectTag select ) {
307                    boolean multipleAll = select.isMultipleAll();   // 3.8.0.9 (2005/10/17)
308                    int rowCnt = table.getRowCount();               // 3.5.5.7 (2004/05/10)
309    
310                    String bkGroupKey = "";
311                    String grpLabel ;
312                    for( int row=0; row<rowCnt; row++ ) {
313                            // 3.8.5.2 (2006/06/09) groupUseNo 螻樊?
314                            if( groupUseNo >= 0 ) {
315                                    String groupKey = table.getValue( row,groupUseNo );
316                                    grpLabel = getRendererValue( row,groupUseNo );
317                                    if( !bkGroupKey.equals( groupKey ) ) {          // 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ
318                                            // 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ縺ｮ險ｭ螳壽婿豕輔?繝舌げ菫ｮ豁｣
319    //                                      bkGroupKey = groupKey;
320    //                                      if( row != 0 ) { select.addOption( "</optgroup>" ); }
321    //                                      select.addOption( "<optgroup label=\"" + grpLabel + "\">" );
322    
323                                            if( ! "".equals( bkGroupKey ) ) {
324                                                    select.addOption( "</optgroup>" );
325                                            }
326                                            if( ! "".equals( groupKey ) ) {
327                                                    select.addOption( "<optgroup label=\"" + grpLabel + "\">" );
328                                            }
329                                            bkGroupKey = groupKey;
330                                    }
331                            }
332    
333                            Attributes attri = new Attributes();
334                            String value = table.getValue( row,0 );
335                            attri.set( "value", value );
336    
337                            // 5.0.2.0 (2009/11/01)
338    //                      if( ( selValue != null && selValue.equals( value ) ) || multipleAll ) {
339                            if( ( selValue != null && selValue.length() > 0 && selValue.indexOf( "|" + value + "|" ) >= 0 ) || multipleAll ) {
340                                    attri.set( "selected", "selected" );
341                            }
342    
343                            // 3.8.5.2 (2006/06/09) classUseNo 螻樊?
344                            if( classUseNo >= 0 ) {
345                                    attri.add( "class", table.getValue( row,classUseNo ) );
346                            }
347    
348                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
349                            boolean titleFlg = false; // 4.3.8.0 (2009/08/01) title螻樊?繧剃ｻ倥￠繧九°縺ｩ縺?°
350                            if( table.getColumnCount() == 1 ) {
351                                    // 鬆?岼縺御ｸ?▽縺ｮ queryOption 縺ｧ縺ｯ縲√Λ繝吶Ν繝ｪ繧ｽ繝ｼ繧ｹ縺御ｽｿ逕ｨ縺輔ｌ縺ｾ縺吶?
352                                    if( addKey ) { buf.append( value ).append( ":" ); }
353                                    buf.append( getResource().getLabel( value ) );
354    
355                                    // 4.3.8.0 (2009/08/01) titleUseNo 螻樊? 繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医°縺､繝ｩ繝吶Ν縺ｨ逡ｰ縺ｪ繧句?蜷医?title螻樊?縺ｫ霑ｽ蜉?
356                                    if( titleUseNo >= 0 && !getResource().getLabel( value ).equals( table.getValue( row,titleUseNo ) )) {
357                                            titleFlg = true;
358                                    }
359                            }
360                            else {
361            //                      if( groupUseNo >= 0 ) {
362            //                              buf.append( grpLabel );
363            //                              buf.append( separator );
364            //                      }
365                                    String label = getRendererValue( row,1 );
366                                    buf.append( label );
367            //                      attri.set( "label", label );
368                                    for( int clm=2; clm<table.getColumnCount(); clm++ ) {
369                                            // 4.3.8.0 (2009/08/01) titleUseNo霑ｽ蜉?
370                                            // if( clm == groupUseNo || clm == classUseNo ) { continue; }
371                                            if( clm == groupUseNo || clm == classUseNo || clm==titleUseNo) { continue; }
372                                            buf.append( separator );
373                                            buf.append( getRendererValue( row,clm ) );
374                                    }
375    
376                                    // 4.3.8.0 (2009/08/01) titleUseNo 螻樊? 繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医°縺､繝ｩ繝吶Ν縺ｨ逡ｰ縺ｪ繧句?蜷医?title螻樊?縺ｫ霑ｽ蜉?
377                                    if( titleUseNo >= 0 && !label.equals( table.getValue( row,titleUseNo ) )) {
378                                            titleFlg = true;
379                                    }
380                            }
381    
382                            // 4.3.7.2 (2009/06/22) 繧ｿ繧､繝医Ν螻樊?繧ｻ繝?ヨ
383                            if( titleFlg ){
384                                    attri.add( "title", table.getValue( row,titleUseNo ) );
385                            }
386    
387                            attri.set( "body", buf.toString() );
388                            select.addOption( XHTMLTag.option( attri ) );
389                    }
390    //              if( groupUseNo >= 0 && "".equals( bkGroupKey ) ) {
391                    if( groupUseNo >= 0 && ! "".equals( bkGroupKey ) ) { // 3.8.9.2 (2007/07/28)
392                            select.addOption( "</optgroup>" );
393                    }
394            }
395    
396            /**
397             * 縲慎AG縲前ption縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､繧呈欠螳壹＠縺ｾ縺吶?
398             *
399             * @og.tag Option縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､繧呈欠螳壹＠縺ｾ縺吶?
400             *
401             * @param   val Option縺ｮ蛻晄悄蛟､縺ｧ驕ｸ縺ｰ繧後ｋ蛟､
402             */
403            public void setValue( final String val ) {
404                    selValue = getRequestParameter( val );
405            }
406    
407            /**
408             * 縲慎AG縲宋alue蛟､縺君ULL縺ｮ蝣ｴ蜷医↓菴ｿ逕ｨ縺輔ｌ繧句?譛溷?繧定ｨｭ螳壹＠縺ｾ縺吶?
409             *
410             * @og.tag
411             * value蛟､縺君ULL縺ｮ蝣ｴ蜷医↓縲√％縺ｮ蛻晄悄蛟､繧偵そ繝?ヨ縺励∪縺吶?
412             *
413             * @og.rev 3.3.2.0 (2003/07/07) defaultVal 螻樊?縺ｮ霑ｽ蜉??(譁ｰ隕丈ｽ懈?)
414             *
415             * @param       val 蛻晄悄蛟､
416             */
417            public void setDefaultVal( final String val ) {
418                    defaultVal = getRequestParameter( val );
419            }
420    
421            /**
422             * 縲慎AG縲題､?焚縺ｮ繝ｩ繝吶Ν繧貞粋謌舌☆繧九→縺阪↓菴ｿ逕ｨ縺吶ｋ鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｹ繝壹?繧ｹ)縲?
423             *
424             * @og.tag
425             * 蛻晄悄蛟､縺ｯ縲√せ繝壹?繧ｹ縺ｧ縺吶?
426             *
427             * @og.rev 3.0.1.0 (2003/03/03) 繧ｻ繝代Ξ繝ｼ繧ｿ繝ｼ繧呈欠螳壹〒縺阪ｋ讒倥↓螟画峩縲?
428             *
429             * @param   sep 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
430             */
431            public void setSeparator( final String sep ) {
432                    separator = nval( getRequestParameter( sep ),separator );
433            }
434    
435            /**
436             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?class 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
437             *
438             * @og.tag
439             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
440             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ縺ｫ class 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
441             * 蜷?が繝励す繝ｧ繝ｳ縺ｫ濶ｲ繧偵▽縺代ｋ蝣ｴ蜷医?縲√％縺ｮ class 螻樊?縺ｫ蟇ｾ蠢懊☆繧?CSS 繝輔ぃ繧､繝ｫ繧堤畑諢上＠縺ｾ縺吶?
442             * 縺薙％縺ｧ縺ｯ縲…lass 螻樊?縺ｫ菴ｿ逕ｨ縺吶ｋ SQL譁?? 繧ｫ繝ｩ繝?分蜿ｷ( 蜈磯?縺?0 ) 繧呈欠螳壹＠縺ｾ縺吶?
443             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
444             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
445             *
446             * @og.rev 3.8.5.2 (2006/06/09) 譁ｰ隕剰ｿｽ蜉?
447             *
448             * @param   no 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧九け繝ｩ繧ｹ螻樊?
449             */
450            public void setClassUseNo( final String no ) {
451                    classUseNo = nval( getRequestParameter( no ),classUseNo );
452                    if( classUseNo == 0 || classUseNo == 1 ) {
453                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
454                            throw new HybsSystemException( errMsg );
455                    }
456            }
457    
458            /**
459             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｮ繧ｰ繝ｫ繝ｼ繝怜喧繧定｡後≧繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
460             *
461             * @og.tag
462             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
463             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ繧偵げ繝ｫ繝ｼ繝怜喧縺励∪縺吶?繧ｰ繝ｫ繝ｼ繝怜喧縺ｯ optgroup隕∫ｴ?ｒ繝悶Ξ繧､繧ｯ譎ゅ↓
464             * 蜃ｺ蜉帙☆繧倶ｺ九〒蟇ｾ蠢懊＠縺ｾ縺吶?
465             * 縺薙％縺ｧ縺ｯ縲√げ繝ｫ繝ｼ繝怜喧縺ｫ菴ｿ逕ｨ縺吶ｋ SQL譁?? 繧ｫ繝ｩ繝?分蜿ｷ( 蜈磯?縺?0 ) 繧呈欠螳壹＠縺ｾ縺吶?
466             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
467             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
468             *
469             * @og.rev 3.8.5.2 (2006/06/09) 譁ｰ隕剰ｿｽ蜉?
470             *
471             * @param   no 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ譎ゅ↓霑ｽ蜉?☆繧九げ繝ｫ繝ｼ繝玲枚蟄?
472             */
473            public void setGroupUseNo( final String no ) {
474                    groupUseNo = nval( getRequestParameter( no ),groupUseNo );
475                    if( groupUseNo == 0 || groupUseNo == 1 ) {
476                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
477                            throw new HybsSystemException( errMsg );
478                    }
479            }
480    
481            /**
482             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
483             *              (蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
484             *
485             * @og.tag
486             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
487             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
488             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
489             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
490             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
491             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
492             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
493             *
494             * @og.rev 4.0.0.0 (2005/08/31) 譁ｰ隕剰ｿｽ蜉?
495             *
496             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
497             * @see         org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK
498             */
499            public void setQuotCheck( final String flag ) {
500                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
501            }
502    
503            /**
504             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
505             *
506             * @og.tag
507             * Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
508             * 縺薙ｌ縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｧ縲．EFAULT_DB_URL 遲峨〒謖?ｮ壹＠縺ｦ縺?ｋ 繝??繧ｿ繝吶?繧ｹ謗･邯壼?
509             * 諠??縺ｫ縲々X_DB_URL 繧貞ｮ夂ｾｩ縺吶ｋ縺薙→縺ｧ縲?dbid="XX" 縺ｨ縺吶ｋ縺ｨ縲√％縺ｮ 謗･邯壼?繧剃ｽｿ逕ｨ縺励※
510             * 繝??繧ｿ繝吶?繧ｹ縺ｫ繧｢繧ｯ繧ｻ繧ｹ縺ｧ縺阪∪縺吶?
511             *
512             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
513             */
514            public void setDbid( final String id ) {
515                    dbid = nval( getRequestParameter( id ),dbid );
516            }
517    
518            /**
519             * 縲慎AG縲鷹?逶ｮ縺御ｸ?▽縺?￠縺ｮ蝣ｴ蜷医??暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ縺ｫ縲√く繝ｼ諠??繧定ｿｽ蜉?☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
520             *
521             * @og.tag
522             * Query繧ｪ繝悶ず繧ｧ繧ｯ繝医?鬆?岼縺御ｸ?▽縺ｮ蝣ｴ蜷医??暦ｾ搾ｾ橸ｾ咎Κ縺ｫ縺ｯ縲?ｾ暦ｾ搾ｾ橸ｾ呻ｾ假ｽｿ?ｰ?ｽ繧剃ｽｿ逕ｨ縺励∪縺吶?
523             * 縺薙?譎ゅ??暦ｾ搾ｾ橸ｾ咏┌縺励?蝣ｴ蜷医?縲√く繝ｼ縺瑚｡ｨ遉ｺ縺輔ｌ縺ｾ縺吶′縲?ｾ暦ｾ搾ｾ橸ｾ吶≠繧翫?蝣ｴ蜷医?縲√く繝ｼ縺ｯ陦ｨ遉ｺ縺輔ｌ縺?
524             * ?暦ｾ搾ｾ橸ｾ吶?縺ｿ陦ｨ遉ｺ縺輔ｌ縺ｾ縺吶?
525             * 驛ｽ蜷医↓繧医▲縺ｦ縺ｯ縲√く繝ｼ繧り｡ｨ遉ｺ縺励◆縺??蜷医′縺ゅｊ縺ｾ縺吶?縺ｧ縲√◎縺ｮ讒倥↑繧ｱ繝ｼ繧ｹ縺ｧ縺ｯ縲?
526             * addKey = "true 繧定ｨｭ螳壹☆繧倶ｺ九〒縲√く繝ｼ:?暦ｾ搾ｾ橸ｾ?縺ｮ繧ｻ繝?ヨ繧抵ｾ暦ｾ搾ｾ橸ｾ吶→縺励※謇ｱ縺?∪縺吶?
527             * 蛻晄悄蛟､縺ｯfalse(繧ｭ繝ｼ縺ｯ莉伜刈縺励↑縺?縺ｧ縺吶?
528             *
529             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
530             */
531            public void setAddKey( final String id ) {
532                    addKey = nval( getRequestParameter( id ),addKey );
533            }
534    
535            /**
536             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
537             *              (蛻晄悄蛟､:USE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
538             *
539             * @og.tag
540             * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?荳?腸縺ｨ縺励※less/greater than sign縺ｫ縺､縺?※縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
541             * (&gt;&lt;) 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
542             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
543             *
544             * @og.rev 5.0.0.2 (2009/09/15) 譁ｰ隕剰ｿｽ蜉?
545             *
546             * @param       flag    XSS繝√ぉ繝?け [true:縺吶ｋ/false:縺励↑縺Ь
547             * @see         org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK
548             */
549            public void setXssCheck( final String flag ) {
550                    xssCheck = nval( getRequestParameter( flag ),xssCheck );
551            }
552    
553            /**
554             * row陦鯉ｼ慶olum蛻?縺ｮ繝??繧ｿ縺ｮ蛟､繧定ｿ斐＠縺ｾ縺吶?
555             *
556             * 縺薙ｌ縺ｯ縲√ョ繝ｼ繧ｿ縺ｮ蛟､縺昴?繧ゅ?縺ｧ縺ｯ縺ｪ縺上?縺昴?蛟､縺ｮ繝ｩ繝吶Ν譁?ｭ励ｒ霑斐＠縺ｾ縺吶?
557             *
558             * @param   row         陦檎分蜿ｷ
559             * @param   column      繧ｫ繝ｩ繝?分蜿ｷ
560             *
561             * @return  row陦鯉ｼ慶olum蛻?縺ｮ繝??繧ｿ縺ｮ蛟､
562             */
563            private String getRendererValue( final int row,final int column ) {
564                    String val = table.getValue( row,column );
565                    DBColumn clm = table.getDBColumn( column );
566                    return clm.getRendererValue( val );
567            }
568    
569            /**
570             * 縲慎AG縲代が繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧?title 螻樊?縺ｮ 繧ｫ繝ｩ繝?分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
571             *
572             * @og.tag
573             * 繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺励※菴懈?縺輔ｌ縺ｾ縺吶′縲√◎縺ｮSQL譁??繧ｫ繝ｩ繝?ュ蝣ｱ繧?
574             * 菴ｿ逕ｨ縺励※ 繧ｪ繝励す繝ｧ繝ｳ縺ｫ title 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
575             * title螻樊?縺ｯ繝槭え繧ｹ繧ｪ繝ｼ繝舌?譎ゅ↓繝??繝ｫ繝√ャ繝励→縺励※陦ｨ遉ｺ縺輔ｌ繧九◆繧√?
576             * 繝励Ν繝?え繝ｳ縺ｮ讓ｪ蟷?ｒ遏ｭ縺上＠縺溘＞蝣ｴ蜷医↓譛牙柑縺ｧ縺吶?
577             * 騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｾ縺吶?
578             * 蛻晄悄蛟､縺ｯ縲∽ｽｿ逕ｨ縺励↑縺?-1)縺ｧ縺吶?
579             *
580             * @og.rev 4.3.8.0 (2009/08/01) 譁ｰ隕剰ｿｽ蜉?
581             *
582             * @param   no 繧ｪ繝励す繝ｧ繝ｳ縺ｫ霑ｽ蜉?☆繧逆itle螻樊?
583             */
584            public void setTitleUseNo( final String no ) {
585                    titleUseNo = nval( getRequestParameter( no ),titleUseNo );
586                    if( titleUseNo == 0 || titleUseNo == 1 ) {
587                            String errMsg = "騾壼ｸｸ縲√き繝ｩ繝?分蜿ｷ=0 縺ｯ 繧ｭ繝ｼ諠??縲?1 縺ｯ繝ｩ繝吶Ν諠?? 縺ｧ縺吶?2 縺?3 繧呈欠螳壹＠縺ｦ荳九＆縺??";
588                            throw new HybsSystemException( errMsg );
589                    }
590            }
591    
592            /**
593             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
594             *
595             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
596             * @serialData
597             *
598             * @param       strm    ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
599             */
600            private void writeObject( final ObjectOutputStream strm ) throws IOException {
601                    strm.defaultWriteObject();
602            }
603    
604            /**
605             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
606             *
607             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
608             *
609             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
610             * @serialData
611             *
612             * @param       strm    ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
613             * @see #release2()
614             */
615            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
616                    strm.defaultReadObject();
617            }
618    
619    //      /**
620    //       * 隕ｪ縺ｮog:select繧ｿ繧ｰ縺ｮname縺ｨeventColumn險ｭ螳壹ｒ霑斐＠縺ｾ縺吶?
621    //       *
622    //       * @og.rev 4.3.6.0 (2009/04/01)
623    //       *
624    //       */
625    //      private String[] getEventColumn(){
626    //              SelectTag seltag = (SelectTag)findAncestorWithClass(this,SelectTag.class);
627    //              String[] selectVal = new String[2];
628    //              selectVal[0] = seltag.getEventColumn();
629    //              selectVal[1] = seltag.get("name");
630    //              return selectVal;
631    //      }
632    
633            /**
634             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
635             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
636             *
637             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
638             */
639            @Override
640            public String toString() {
641                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
642                                    .println( "VERSION"             ,VERSION        )
643                                    .println( "selValue"    ,selValue       )
644                                    .println( "defaultVal"  ,defaultVal     )
645                                    .println( "dbid"                ,dbid           )
646                                    .println( "sql"                 ,sql            )
647                                    .println( "separator"   ,separator      )
648                                    .println( "quotCheck"   ,quotCheck      )
649                                    .println( "Other..."    ,getAttributes().getAttribute() )
650                                    .fixForm().toString() ;
651            }
652    }