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 static org.opengion.fukurou.util.StringUtil.nval;
019    
020    import java.io.IOException;
021    import java.io.ObjectInputStream;
022    import java.io.ObjectOutputStream;
023    import java.util.Locale;
024    
025    import org.opengion.fukurou.db.DBUtil;
026    import org.opengion.fukurou.db.Transaction;
027    import org.opengion.fukurou.db.TransactionReal;
028    import org.opengion.fukurou.util.ErrorMessage;
029    import org.opengion.fukurou.util.StringUtil;
030    import org.opengion.hayabusa.common.HybsSystem;
031    import org.opengion.hayabusa.common.HybsSystemException;
032    import org.opengion.hayabusa.db.DBColumn;
033    import org.opengion.hayabusa.db.DBEditConfig;
034    import org.opengion.hayabusa.db.DBTableModel;
035    import org.opengion.hayabusa.db.Query;
036    import org.opengion.hayabusa.db.QueryFactory;
037    import org.opengion.hayabusa.resource.GUIInfo;
038    
039    /**
040     * 繝??繧ｿ繝吶?繧ｹ縺ｮ讀懃ｴ｢繧定｡後≧繧ｿ繧ｰ縺ｧ縺吶?
041     *
042     * 縺薙?繧ｿ繧ｰ縺ｮ蜀?ｮｹ縺ｫ縲ヾQL譁?ｒ險倩ｿｰ縺励∪縺吶? where繧ｿ繧ｰ縲?and繧ｿ繧ｰ 繧剃ｽｿ縺?→蠑墓焚縺ｫ蠢懊§縺ｦ
043     * 螳溯｡後＆繧後ｋSQL譁?′逡ｰ縺ｪ繧翫∪縺?菴ｿ逕ｨ萓句盾辣ｧ)縲?
044     * 縺ｾ縺溘?PL/SQL縺ｮSP縺ｧ讀懃ｴ｢繧定｡後≧縺ｨ縺阪ｂ縺薙?繧ｿ繧ｰ繧剃ｽｿ縺?∪縺吶?
045     * SystemData 縺ｮ USE_SQL_INJECTION_CHECK 縺?true 縺九?quotCheck 螻樊?縺?true 縺ｮ蝣ｴ蜷医?縲?
046     * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲也畑縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?繝ｪ繧ｯ繧ｨ繧ｹ繝亥ｼ墓焚縺ｫ
047     * 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(')縺悟性縺ｾ繧後ｋ縺ｨ縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
048     * 蜷梧ｧ倥↓USE_XSS_CHECK縺荊rue縺九?xssCheck螻樊?縺荊rue縺ｮ蝣ｴ蜷医?縲?
049     * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｹ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?縺溘ａless/greater than sign縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
050     *
051     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
052     *
053     * @og.formSample
054     * 笳丞ｽ｢蠑擾ｼ?
055     *       繝ｻ&lt;og:query command="NEW" &gt;
056     *              SELECT譁?
057     *         &lt;/og:query&gt;
058     *       繝ｻ&lt;og:query command="NEW" names="?･?･?･" queryType="JDBCErrMsg" &gt;
059     *              { call PL/SQL(?,?,?,? ) } 
060     *         &lt;/og:query&gt;
061     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
062     *
063     * 笳週ag螳夂ｾｩ??
064     *   &lt;og:query
065     *       queryType          縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID(JDBC,JDBCCallable,JDBCErrMsg,JDBCUpdate)繧呈欠螳壹＠縺ｾ縺几@og.doc03Link queryType 蛻晄悄蛟､:JDBC})
066     *       command            縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?PlsqlUpdateTag,UpdateTag 縺ｮ蝣ｴ蜷医?縲・NTRY)
067     *       scope              縲慎AG縲代く繝｣繝?す繝･縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝夕request/page/session/applicaton]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
068     *       maxRowCount        縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ譛?､ｧ隱ｭ縺ｿ霎ｼ縺ｿ莉ｶ謨ｰ繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:DB_MAX_ROW_COUNT[=1000])(0:[辟｡蛻ｶ髯疹)
069     *       skipRowCount       縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､繧呈欠螳壹＠縺ｾ縺?
070     *       displayMsg         縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:VIEW_DISPLAY_MSG[=])
071     *       overflowMsg        縲慎AG縲第､懃ｴ｢繝??繧ｿ縺梧怙螟ｧ讀懃ｴ｢謨ｰ繧偵が繝ｼ繝舌?縺励◆蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:MSG0007[讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆])
072     *       notfoundMsg        縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])
073     *       names              縲慎AG縲善L/SQL繧貞茜逕ｨ縺吶ｋ蝣ｴ蜷医?蠑墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
074     *       stopZero           縲慎AG縲第､懃ｴ｢邨先棡縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺榊?逅?ｒ邯夊｡後☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[邯夊｡後☆繧犠)
075     *       tableId            縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡縺ｮDBTableModel繧偵?session縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
076     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?
077     *       trace              縲慎AG縲大ｼ墓焚縺ｮ SQL 譁?ｒ EXPLAIN PLAN 繧端true:陦後≧/縺昴ｌ莉･螟?陦後ｏ縺ｪ縺Ь繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
078     *       checkNames         縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧繧定｡後≧繧ｫ繝ｩ繝?ｒCSV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
079     *       modifyType         縲慎AG縲船B讀懃ｴ｢譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝励ｒ謖?ｮ壹＠縺ｾ縺兌A:霑ｽ蜉?C:譖ｴ譁ｰ/D:蜑企勁]
080     *       quotCheck          縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:USE_SQL_INJECTION_CHECK)
081     *       stopError          縲慎AG縲善LSQL/SQL蜃ｦ逅?お繝ｩ繝ｼ縺ｮ譎ゅ↓蜃ｦ逅?ｒ荳ｭ豁｢縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
082     *       xssCheck           縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_XSS_CHECK[=true])
083     *       mainTrans          縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
084     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
085     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
086     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
087     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
088     *       useBeforeHtmlTag   縲慎AG縲?蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉媼true:譛牙柑/false:辟｡蜉ｹ]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
089     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
090     *   &gt;   ... Body ...
091     *   &lt;/og:query&gt;
092     *
093     * 笳丈ｽｿ逕ｨ萓?
094     *     &lt;og:query command="NEW"&gt;
095     *             select PN,YOBI,NMEN,HINM from XX01 where PN = '{&#064;PN}' order by PN
096     *     &lt;/og:query&gt;
097     *
098     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;PN}縺君OT NULL縺ｮ縺ｨ縺?
099     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = 'AAA' order by PN
100     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;PN}縺君ULL縺ｮ縺ｨ縺?
101     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = '' order by PN
102     *
103     *     &lt;og:query command="NEW"&gt;
104     *             select PN,YOBI,NMEN,HINM from XX01
105     *         &lt;og:where&gt;
106     *             &lt;og:and value="PN = '{&#064;PN}%'" /&gt;
107     *             &lt;og:and value="YOBI like '{&#064;YOBI}%'" /&gt;
108     *         &lt;/og:where&gt;
109     *             order by PN
110     *     &lt;/og:query&gt;
111     *
112     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;PN}縺君OT NULL縺ｮ縺ｨ縺?
113     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = 'AAA%' and YOBI like 'BBB%' order by PN
114     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;PN}縺君ULL縺ｮ縺ｨ縺? WHERE蜿･縺後↑縺上↑繧九?
115     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 order by PN
116     *
117     *        豕ｨ諢?WhereTag繧剃ｽｿ縺｣縺溷?蜷医?荳九?繧医≧縺ｫ縺ｯ縺ｪ繧翫∪縺帙ｓ縲?
118     *            select PN,YOBI,NMEN,HINM from XX01 PN = '' and YOBI like '%' order by PN
119     *
120     *     &lt;og:query command="NEW"&gt;
121     *             select PN,YOBI,NMEN,HINM from XX01 where PN="11111"
122     *         &lt;og:where startKey="and"&gt;
123     *             &lt;og:and value="YOBI like '{&#064;PN}%'" /&gt;
124     *         &lt;/og:where&gt;
125     *             order by PN
126     *     &lt;/og:query&gt;
127     *
128     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;YOBI}縺君OT NULL縺ｮ縺ｨ縺?
129     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = '11111' and YOBI like 'BBB%' order by PN
130     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;YOBI}縺君ULL縺ｮ縺ｨ縺? WHERE蜿･縺後↑縺上↑繧九?
131     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = '11111' order by PN
132     *
133     *     &lt;og:query
134     *          command    = "NEW"
135     *          names      = "SYSTEM_ID,LANG,CLM,NAME_JA,LABEL_NAME,KBSAKU,USER.ID"
136     *          checkNames = "CLM,NAME_JA"
137     *          queryType  = "JDBCErrMsg"
138     *          displayMsg = ""&gt;
139     *              {call TYPE3B01.TYPE3B01(?,?,?,?)}
140     *     &lt;/og:query&gt;
141     *
142     *          繝ｻqueryType 縺ｫ JDBCErrMsg 繧呈欠螳壹＠縺ｦ縲￣L/SQL 繧偵さ繝ｼ繝ｫ縺ｧ縺阪∪縺吶?
143     *            蠑墓焚縺ｯ縲］ames 螻樊?繧偵く繝ｼ縺ｫ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺九ｉ隱ｭ縺ｿ霎ｼ縺ｿ縺ｾ縺吶?
144     *          繝ｻcheckNames 縺ｫ繧ｫ繝ｩ繝?錐繧呈欠螳壹☆繧九→縲…olumns.valueSet 縺ｫ繧医ｋ
145     *            繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧繧定｡後＞縺ｾ縺吶?
146     *
147     * @og.group ?､?｢讀懃ｴ｢
148     * @og.group ?､?｢逋ｻ骭ｲ
149     *
150     * @version  4.0
151     * @author       Kazuhiko Hasegawa
152     * @since    JDK5.0,
153     */
154    public class QueryTag extends CommonTagSupport {
155            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
156            private static final String VERSION = "5.6.5.3 (2013/06/28)" ;
157    
158            private static final long serialVersionUID = 565320130628L ;
159    
160            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 譁ｰ隕?{@value} */
161            public static final String CMD_NEW       = "NEW" ;
162            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 蜀肴､懃ｴ｢ {@value} */
163            public static final String CMD_RENEW = "RENEW" ;
164            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
165            private static final String[] COMMAND_LIST = new String[] { CMD_NEW , CMD_RENEW };
166    
167            /** 繧ｨ繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸID {@value} */
168            protected static final String errMsgId   = HybsSystem.ERR_MSG_KEY;
169    
170            private   String        queryType       = null;
171            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
172    //      private   String        dbid            = "DEFAULT";
173            private   String        dbid            = null ;
174            protected transient DBTableModel        table           = null;
175            protected transient ErrorMessage        errMessage      = null;
176            protected String        tableId         = HybsSystem.TBL_MDL_KEY;
177            protected String        command         = CMD_NEW;
178            protected int           skipRowCount = 0;
179            protected int           maxRowCount     = -1;
180            protected String        sql                     = null;
181            protected int           executeCount = -1;                      // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
182            protected String        names           = null;
183            protected boolean       outMessage      = true;
184            protected int           errCode         = ErrorMessage.OK;
185            protected boolean       quotCheck       = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
186            private   boolean       trace           = false;                // 4.0.0 (2005/01/31) 蟒?ｭ｢
187            private   boolean       stopZero        = false;
188            private   String        modifyType      = null;                 // 3.8.5.1 (2006/05/08) modifyType 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
189    //      private   String        displayMsg      = "MSG0033";    // 縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲?
190            protected String        displayMsg      = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
191            private   String        overflowMsg     = "MSG0007";    // 讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆縲?
192            private   String        notfoundMsg     = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
193            private   boolean       isMainTrans     = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
194    
195            // 3.5.4.7 (2004/02/06) 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｮDIV隕∫ｴ?ｒ蜃ｺ蜉帙＠縺ｾ縺吶?
196            protected long dyStart = 0;
197            // 4.3.3.0 (2008/09/22) PLSQL/SQL螳溯｡後お繝ｩ繝ｼ縺ｮ髫帙↓縲∝?逅?ｒ荳ｭ豁｢縺吶ｋ縺九←縺?°縲?
198            protected boolean stopError             = true;
199    
200            private StringBuilder debugMsg = null;          // 3.5.6.0 (2004/06/18)
201    
202            // 3.8.0.5 (2005/08/20) 繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧繧定｡後＞縺ｾ縺吶?
203            private String                  checkNames      = null;
204    
205            // 3.8.5.3 (2006/08/07) 繝医Ξ繝ｼ繧ｹ譎ゅ?繝｡繝?そ繝ｼ繧ｸ譁?ｭ怜?繧剃ｿ晏ｭ倥＠縺ｦ縺翫″縺ｾ縺吶?
206            private String                  traceMsg        = null;
207    
208            protected boolean       xssCheck        = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
209    
210            // 5.3.5.0 (2011/05/01) 蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉帙?譛牙柑/辟｡蜉ｹ繧呈欠螳壹＠縺ｾ縺吶?
211            private boolean         useBeforeHtmlTag        = true ;
212    
213            /**
214             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
215             *
216             * @og.rev 3.5.4.7 (2004/02/06) 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｫ縲?幕蟋区凾蛻ｻ繧貞叙蠕励＠縺ｾ縺吶?
217             * @og.rev 3.5.6.5 (2004/08/09) 證ｫ螳夂噪縺ｫ縲．BTableModel繧貞?陦悟炎髯､縺励∪縺吶?
218             * @og.rev 3.6.0.0 (2004/09/24) DBTableModel 縺ｮ蜈郁｡悟炎髯､縺ｯ縲《cope="session" 縺ｮ蝣ｴ蜷医?縺ｿ縲?
219             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
220             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
221             *
222             * @return      蠕檎ｶ壼?逅??謖?､ｺ
223             */
224            @Override
225            public int doStartTag() {
226                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
227                    if( useTag() ) {
228                            dyStart = System.currentTimeMillis();
229                            if( ! check( command, COMMAND_LIST ) ) { return(SKIP_BODY); }
230    
231                            useMainTrans( isMainTrans );                    // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
232                            startQueryTransaction( tableId );               // 3.6.0.8 (2004/11/19)
233    
234                            // 3.5.6.5 (2004/08/09) 蜑企勁縺吶ｋ縺ｮ縺ｯ縲√そ繝?す繝ｧ繝ｳ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医〒繧医＞縲?
235                            // 3.6.0.0 (2004/09/24) 蜑企勁縺吶ｋ縺ｮ縺ｯ縲《cope="session" 縺ｮ蝣ｴ蜷医?縺ｿ縲?
236                            if( "session".equals( getScope() ) ) {
237                                    removeSessionAttribute( tableId );
238                                    removeSessionAttribute( HybsSystem.VIEWFORM_KEY );
239                            }
240    
241                            return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
242                    }
243                    return ( SKIP_BODY );                           // Body 繧定ｩ穂ｾ｡縺励↑縺?
244            }
245    
246            /**
247             * Taglib縺ｮ繧ｿ繧ｰ譛ｬ菴薙ｒ蜃ｦ逅?☆繧?doAfterBody() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
248             *
249             * @og.rev 3.1.1.0 (2003/03/28) 繝懊ョ繧｣縺ｮ蜀?ｮｹ繧貞叙蠕励☆繧句?逅?ｒ縲，ommonTagSupport 縺ｧ陦後≧縲?
250             * @og.rev 3.6.0.8 (2004/11/19) 繧ｨ繝ｩ繝ｼ逋ｺ逕滓凾縺ｫ遒ｺ螳溘↓繝ｪ繝ｪ繝ｼ繧ｹ縺輔ｌ繧九ｈ縺?↓ try finally 霑ｽ蜉?
251             * @og.rev 3.8.5.3 (2006/08/07) USER.LASTSQL 縺ｸ縺ｮSQL譁??菫晏ｭ倥?縲∝ｮ溯｡悟燕縺ｫ陦後▲縺ｦ縺翫″縺ｾ縺吶?
252             * @og.rev 3.8.6.3 (2006/11/30) SQL 譁??蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺阪∪縺吶?
253             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
254             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
255             * @og.rev 4.0.0.0 (2005/08/31) useQuotCheck() 縺ｫ繧医ｋ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲?
256             * @og.rev 4.3.4.0 (2008/12/01) GE20(繝ｦ繝ｼ繧ｶ繝ｼ螳壽焚)縺ｸ逋ｻ骭ｲ縺吶ｋ縺九?繝輔Λ繧ｰ縺ｸ縺ｮ蟇ｾ蠢?
257             * @og.rev 5.0.0.2 (2009/09/15) XSS蟇ｾ蠢?
258             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
259             * @og.rev 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢懊?荳贋ｽ阪↓ TransactionTag 縺後≠繧後?縲√◎縺薙°繧韻onnection 繧偵ｂ繧峨≧縲?
260             * @og.rev 5.3.6.0 (2011/06/01) 髮?ｨ医?蜷郁ｨ医↑縺ｩ縺ｮEdit讖溯?縺ｫ蟇ｾ蠢懊＠縺ｾ縺吶?
261             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
262             * @og.rev 5.3.7.0 (2011/07/01) PL/SQL縺九▽scope="request"縺ｧ豁｣縺励￥蜃ｺ蜉帙☆繧九◆繧〈ueryType,names繧ゆｿ晏ｭ倥☆繧九?
263             * @og.rev 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
264             * @og.rev 5.5.3.4 (2012/06/19) trace 譎ゅ?縲∝ｮ滄圀縺ｮ讀懃ｴ｢蜃ｦ逅?ｒ陦後ｏ縺ｪ縺?ｧ倥↓螟画峩縲?
265             * @og.rev 5.6.5.3 (2013/06/28) LASTQUERYTYPE 竍?LASTSQLTYPE 螟画峩縲?
266             *
267             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
268             */
269            @Override
270            public int doAfterBody() {
271    
272                    // 4.0.0 (2005/08/31) useQuotCheck() 縺ｫ繧医ｋ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲?
273                    useQuotCheck( quotCheck );
274                    // 5.0.0.2 (2009/09/15) XSS蟇ｾ遲?
275                    useXssCheck( xssCheck );
276    
277                    sql = getBodyString().trim();
278    
279                    // 3.2.1.0 (2003/05/28) 譛?ｵゑｼｳ?ｱ?ｬ譁?ｒ縲ゞserInfo 縺ｫ縲√く繝｣繝?す繝･縺励※縺翫￥縲?
280    //              setUserInfo( "LASTSQL", sql );
281                    // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
282                    if( isMainTrans ) {
283                            setUserInfo( "LASTSQL", sql, false );
284                            // 5.3.7.0 (2011/07/01) PL/SQL縺九▽scope="request"縺ｧ豁｣縺励￥蜃ｺ蜉帙☆繧九◆繧〈ueryType,names繧ゆｿ晏ｭ倥☆繧九?
285    //                      setUserInfo( "LASTQUERYTYPE", queryType, false );
286                            setUserInfo( "LASTSQLTYPE", queryType, false );                         // 5.6.5.3 (2013/06/28)
287                            setUserInfo( "LASTNAMES", names, false );
288                    }
289    
290                    Query query = QueryFactory.newInstance( queryType );
291                    Transaction tran = null;
292                    try {
293                            if( maxRowCount < 0 ) {
294                                    maxRowCount     = sysInt( "DB_MAX_ROW_COUNT" );
295                            }
296    
297                            // 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢?
298    //                      final Transaction tran ;
299                            TransactionTag tranTag = (TransactionTag)findAncestorWithClass( this,TransactionTag.class );
300                            if( tranTag == null ) {
301    //                              tran = new TransactionReal( dbid,getApplicationInfo() );
302                                    tran = new TransactionReal( getApplicationInfo() );             // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
303                            }
304                            else {
305                                    tran = tranTag.getTransaction();
306                            }
307                            query.setTransaction( dbid,tran );      // 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢?
308    
309                            query.setSkipRowCount( skipRowCount );
310                            query.setMaxRowCount( maxRowCount );
311    //                      query.setConnectionID( dbid );
312                            query.setResourceManager( getResource() );      // 4.0.0 (2005/01/31)
313    
314                            if( trace ) {
315    //                              traceMsg = traceQuery( sql );
316                                    traceMsg = traceQuery( sql,tran );              // 5.1.9.0 (2010/08/01) TransactionTag 蟇ｾ蠢?
317                                    // 5.5.3.4 (2012/06/19) trace 譎ゅ?縲∝ｮ滄圀縺ｮ讀懃ｴ｢蜃ｦ逅?ｒ陦後ｏ縺ｪ縺?ｧ倥↓螟画峩
318    //                              query.setMaxRowCount( 1 );
319                                    return(SKIP_BODY);
320                            }
321                            query.setStatement( sql );
322    //                      query.setApplicationInfo( getApplicationInfo() );       // 3.8.7.0 (2006/12/15)
323    
324                            // 5.3.6.0 (2011/06/01) 髮?ｨ医?蜷郁ｨ医↑縺ｩ縺ｮEdit讖溯?縺ｫ蟇ｾ蠢懊＠縺ｾ縺吶?
325                            if( isMainTrans ) {
326                                    String guikey = getGUIInfoAttri( "KEY" );
327                                    String editName = getRequestValue( "editName" );
328                                    DBEditConfig config = getUser().getEditConfig( guikey, editName );
329                                    if( config != null ) {
330                                            query.setEditConfig( config );
331                                    }
332                            }
333    
334                            execute( query );
335    
336                            executeCount = query.getExecuteCount();
337                            if( errCode < ErrorMessage.NG && executeCount >= 0 ) {            // 逡ｰ蟶ｸ莉･螟悶?蝣ｴ蜷?
338                                    table = query.getDBTableModel();
339                                    // 3.8.5.1 (2006/05/08) modifyType 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
340                                    if( modifyType != null ) {
341                                            for( int row=0; row<executeCount; row++ ) {
342                                                    table.setModifyType( row,modifyType );
343                                            }
344                                    }
345                            }
346                    }
347                    finally {
348    //                      if( query != null ) { query.close(); }
349                            QueryFactory.close( query );
350                            if( tran != null ) { tran.close(); }            // 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
351                    }
352                    return(SKIP_BODY);
353            }
354    
355            /**
356             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
357             *
358             * @og.rev 2.0.0.8 (2002/10/09) command="NEW" 縺ｮ縺ｨ縺阪?縺ｿ縲‥isplayMsg 繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
359             * @og.rev 2.1.1.4 (2002/11/25) 繝?ヰ繝?げ譎ゅ↓譛?ｵ４QL繧偵Θ繝ｼ繧ｶ繝ｼ諠??繧偵そ繝?ヨ縺吶ｋ繧医≧縺ｫ螟画峩縲?
360             * @og.rev 2.1.2.1 (2002/11/27) ErrorMessage 繧偵け繝ｪ繧｢縺励↑縺?ｈ縺?↓螟画峩縲?
361             * @og.rev 3.1.1.0 (2003/03/28) JspWriter 繧ｪ繝悶ず繧ｧ繧ｯ繝医?菴ｿ逕ｨ邂?園繧偵?jspPrint() 繧剃ｽｿ逕ｨ縺吶ｋ繧医≧縺ｫ螟画峩縲?
362             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
363             * @og.rev 3.2.1.0 (2003/05/28) 譛?ｵゑｼｳ?ｱ?ｬ譁?ｒ縲ゞserInfo 縺ｫ縲√く繝｣繝?す繝･縺励※縺翫￥縲?
364             * @og.rev 3.3.3.3 (2003/08/06) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧偵?"DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
365             * @og.rev 3.3.3.3 (2003/08/06) 讀懃ｴ｢邨先棡繧偵?"DB.ERR_CODE" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
366             * @og.rev 3.5.4.7 (2004/02/06) 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｮDIV隕∫ｴ?ｒ蜃ｺ蜉帙＠縺ｦ縺翫″縺ｾ縺吶?
367             * @og.rev 3.5.4.9 (2004/02/25) 隴ｦ蜻頑凾縺ｫ蛛懈ｭ｢縺励※縺?∪縺励◆縺後?邯咏ｶ壼?逅?＆縺帙∪縺吶?
368             * @og.rev 3.5.5.0 (2004/03/12) ErrorMessage 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ縲〈uery 縺梧?蜉溘＠縺滓凾縺ｫ繧ゅけ繝ｪ繧｢縺吶ｋ繧医≧縺ｫ螟画峩
369             * @og.rev 3.5.5.2 (2004/04/02) TaglibUtil.makeHTMLErrorTable 繝｡繧ｽ繝?ラ繧貞茜逕ｨ
370             * @og.rev 3.5.5.8 (2004/05/20) ErrorMessage 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ縲√さ繝槭Φ繝峨′ NEW 縺ｮ蝣ｴ蜷医?縺ｿ縲√け繝ｪ繧｢
371             * @og.rev 3.5.6.0 (2004/06/18) debugMsg 螻樊?繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣縺励∪縺吶?
372             * @og.rev 3.6.0.8 (2004/11/19) DBTableModel 繧偵そ繝ｼ繝悶☆繧区凾縺ｫ縲√ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
373             * @og.rev 3.8.5.3 (2006/08/07) USER.LASTSQL 縺ｸ縺ｮSQL譁??菫晏ｭ倥?縲∝ｮ溯｡悟燕縺ｫ陦後▲縺ｦ縺翫″縺ｾ縺吶?
374             * @og.rev 4.0.0.0 (2006/11/14) notfoundMsg 螻樊?繧定ｿｽ蜉??displayMsg 縺ｯ縲〃IEW_USE_DISPLAY_MSG 縺ｧ蛻ｶ蠕｡
375             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
376             * @og.rev 4.3.3.0 (2008/09/22) 螻樊? stopError 縺ｮ險ｭ螳壹↓繧医ｊ縲゛SP蜃ｦ逅?ｒ荳ｭ豁｢縺吶ｋ縺九←縺?°繧貞宛蠕｡縺励∪縺吶?
377             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
378             * @og.rev 5.3.5.0 (2011/05/01) 蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉帙?譛牙柑/辟｡蜉ｹ繧呈欠螳壹＠縺ｾ縺吶?
379             * @og.rev 5.5.0.3 (2012/03/13) 繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ繝｡繝?そ繝ｼ繧ｸ縺悟ｭ伜惠縺励↑縺?→縺阪?縲∽ｽ輔ｂ縺励↑縺??(謾ｹ陦後ｂ蜈･繧後↑縺?
380             * @og.rev 5.5.3.4 (2012/06/19) trace 譎ゅ?縲∝ｮ滄圀縺ｮ讀懃ｴ｢蜃ｦ逅?ｒ陦後ｏ縺ｪ縺?ｧ倥↓螟画峩縲?
381             * @og.rev 5.6.3.0 (2013/04/01) 繧ｨ繝ｩ繝ｼ譎ゅΓ繝?そ繝ｼ繧ｸ螟画峩
382             *
383             * @return      蠕檎ｶ壼?逅??謖?､ｺ
384             */
385            @Override
386            public int doEndTag() {
387                    debugPrint();           // 4.0.0 (2005/02/28)
388                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
389                    if( !useTag() ) { return(EVAL_PAGE); }
390    
391                    if( trace ) {
392                            jspPrint( traceMsg );
393                            return (SKIP_PAGE);             // 5.5.3.4 (2012/06/19) trace 譎ゅ?縲∝ｮ滄圀縺ｮ讀懃ｴ｢蜃ｦ逅?ｒ陦後ｏ縺ｪ縺?ｧ倥↓螟画峩縲?
394                    }
395    
396                    String label  = "";                             // 4.0.0 (2005/11/30) 讀懃ｴ｢縺励↑縺九▲縺溷?蜷医?
397                    if( check( command, COMMAND_LIST ) ) {
398                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
399    
400                            // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ command="NEW" 縺ｮ縺ｨ縺阪?縺ｿ縲‥isplayMsg 繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
401                            // 4.0.0 (2005/11/30) 蜃ｺ蜉幃?縺ｮ螟画峩縲ゆｸ?分譛??縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
402    //                      boolean useStatusBar = HybsSystem.sysBool( "VIEW_USE_DISPLAY_MSG" );
403                            if( CMD_NEW.equals( command ) ) {
404    //                              if( useStatusBar && executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
405                                    if( executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
406                                            buf.append( executeCount );
407    //                                      buf.append( getResource().getMessage( displayMsg ) );
408                                            buf.append( getResource().getLabel( displayMsg ) );
409                                            buf.append( HybsSystem.BR );
410                                    }
411                                    else if( executeCount == 0 && notfoundMsg != null && notfoundMsg.length() > 0 ) {
412    //                                      buf.append( getResource().getMessage( notfoundMsg ) );
413                                            buf.append( getResource().getLabel( notfoundMsg ) );
414                                            buf.append( HybsSystem.BR );
415                                    }
416                            }
417    
418                            // 3.3.3.3 (2003/08/06) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧偵?"DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
419                            setRequestAttribute( "DB.COUNT"   , String.valueOf( executeCount ) );
420                            // 3.3.3.3 (2003/08/06) 讀懃ｴ｢邨先棡繧偵?"DB.ERR_CODE" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
421                            setRequestAttribute( "DB.ERR_CODE", String.valueOf( errCode ) );
422    
423                            // 繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ譎ゅ?繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ
424    //                      if( table != null && table.isOverflow() ) {
425                            // 5.5.0.3 (2012/03/09) 繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ繝｡繝?そ繝ｼ繧ｸ縺悟ｭ伜惠縺励↑縺?→縺阪?縲∽ｽ輔ｂ縺励↑縺??(謾ｹ陦後ｂ蜈･繧後↑縺?
426                            if( table != null && table.isOverflow() && overflowMsg != null && overflowMsg.length() > 0  ) {
427    //                              buf.append( getResource().getMessage( overflowMsg ) );
428                                    buf.append( getResource().getLabel( overflowMsg ) );
429                                    buf.append( HybsSystem.BR );
430                            }
431    
432                            // 3.5.5.2 (2004/04/02) TaglibUtil.makeHTMLErrorTable 繝｡繧ｽ繝?ラ繧貞茜逕ｨ
433                            String err = TaglibUtil.makeHTMLErrorTable( errMessage,getResource() );
434                            if( err != null && err.length() > 0 ) {
435                                    buf.append( err );
436                                    setSessionAttribute( errMsgId,errMessage );
437                            }
438                            else if( CMD_NEW.equals( command ) ) {          // 3.5.5.8 (2004/05/20)
439                                    removeSessionAttribute( errMsgId );
440                            }
441                            label = buf.toString();
442    
443                            if( table != null && ! commitTableObject( tableId, table ) ) {
444                                    // 3.6.0.8 (2004/11/19) 繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
445                                    // jspPrint( "QueryTag Query蜃ｦ逅?′蜑ｲ繧願ｾｼ縺ｾ繧後∪縺励◆縲?BTableModel 縺ｯ逋ｻ骭ｲ縺励∪縺帙ｓ縲? );
446                                    
447                                    // 5.6.4.0 (2013/04/01) 繝ｪ繧ｽ繝ｼ繧ｹ縺九ｉ蜃ｺ蜉帙☆繧九ｈ縺?↓蟇ｾ蠢?
448                                    ErrorMessage errMsgObj = new ErrorMessage( "QueryTag Query Error!" );
449                                    errMsgObj.addMessage( 0,ErrorMessage.NG,"ERR0041" );
450                                    jspPrint( TaglibUtil.makeHTMLErrorTable( errMsgObj,getResource() ) );
451                                    
452                                    return (SKIP_PAGE);
453                            }
454                    }
455    
456                    jspPrint( label );
457    
458                    // 3.5.4.9 (2004/02/25) 隴ｦ蜻頑凾縺ｫ蛛懈ｭ｢縺励※縺?∪縺励◆縺後?邯咏ｶ壼?逅?＆縺帙∪縺吶?
459    //              int rtnCode = EVAL_PAGE;
460                    final int rtnCode ;
461                    if( errCode >= ErrorMessage.NG )  {  // 逡ｰ蟶ｸ
462                            if( stopError ) {                               // 4.3.3.0 (2008/09/22) 螻樊? stopError 縺ｮ險ｭ螳壹↓繧医ｊ縲∝?逅?ｒ荳ｭ豁｢縺吶ｋ縺九ｒ蛻､譁ｭ縺励∪縺吶?
463                                    rtnCode = SKIP_PAGE;
464                            }
465                            else {
466                                    rtnCode = EVAL_PAGE;
467                            }
468                    }
469                    else {
470                            // 莉ｶ謨ｰ?蝉ｻｶ縺九▽ stopZero = true
471                            if( executeCount == 0 && stopZero )     {
472                                    rtnCode = SKIP_PAGE;
473                            }
474                            else {
475                                    rtnCode = EVAL_PAGE;
476                            }
477                    }
478    
479                    // 3.5.4.7 (2004/02/06)
480                    long dyTime = System.currentTimeMillis()-dyStart;
481    
482                    // 5.3.5.0 (2011/05/01) 蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉帙?譛牙柑/辟｡蜉ｹ繧呈欠螳壹＠縺ｾ縺吶?
483                    if( useBeforeHtmlTag ) {
484                            jspPrint( "<div id=\"queryTime\" value=\"" + (dyTime) + "\"></div>" );      // 3.5.6.3 (2004/07/12)
485                    }
486    
487                    // 4.0.0 (2005/01/31) 繧ｻ繧ｭ繝･繝ｪ繝?ぅ繝√ぉ繝?け(繝??繧ｿ繧｢繧ｯ繧ｻ繧ｹ莉ｶ謨ｰ逋ｻ骭ｲ)
488                    GUIInfo guiInfo = (GUIInfo)getSessionAttribute( HybsSystem.GUIINFO_KEY );
489                    if( guiInfo != null ) { guiInfo.addReadCount( executeCount,dyTime,sql ); }
490    
491                    return( rtnCode );
492            }
493    
494            /**
495             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
496             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
497             *
498             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
499             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
500             * @og.rev 3.5.4.7 (2004/02/06) 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｫ縲‥yStart 繧定ｿｽ蜉?＠縺ｾ縺吶?
501             * @og.rev 3.5.6.0 (2004/06/18) debugMsg 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
502             * @og.rev 3.8.0.5 (2005/08/20) checkNames 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
503             * @og.rev 3.8.5.1 (2006/05/08) modifyType 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
504             * @og.rev 3.8.5.1 (2006/05/08) traceMsg 螻樊?(繝医Ξ繝ｼ繧ｹ譎ゅ?繝｡繝?そ繝ｼ繧ｸ譁?ｭ怜?)繧定ｿｽ蜉?＠縺ｾ縺吶?
505             * @og.rev 4.0.0.0 (2005/08/31) quotCheck 螻樊?縺ｮ霑ｽ蜉?
506             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
507             * @og.rev 4.3.3.0 (2008/09/22) stopError 螻樊?縺ｮ霑ｽ蜉?
508             * @og.rev 5.0.0.2 (2009/09/15) XSS蟇ｾ蠢?
509             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
510             * @og.rev 5.3.5.0 (2011/05/01) 蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉帙?譛牙柑/辟｡蜉ｹ繧呈欠螳壹＠縺ｾ縺吶?
511             *
512             */
513            @Override
514            protected void release2() {
515                    super.release2();
516                    tableId                 = HybsSystem.TBL_MDL_KEY;
517                    queryType               = null;
518    //              dbid                    = "DEFAULT";
519                    dbid                    = null;
520                    command                 = CMD_NEW;
521                    skipRowCount    = 0;
522                    maxRowCount             = -1;
523                    table                   = null;
524                    sql                             = null;
525    //              displayMsg              = "MSG0033";    // 縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲?
526                    displayMsg              = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
527                    overflowMsg             = "MSG0007";    // 讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆縲?
528                    notfoundMsg             = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
529                    executeCount    = -1;                   // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
530                    names                   = null;
531                    outMessage              = true;
532                    trace                   = false;
533                    errCode                 = ErrorMessage.OK;
534                    errMessage              = null;
535                    stopZero                = false;
536                    stopError               = true;                 // 4.3.3.0 (2008/09/22)
537                    dyStart                 = 0;
538                    debugMsg                = null;                 // 3.5.6.0 (2004/06/18)
539                    checkNames              = null;                 // 3.8.0.5 (2005/08/20)
540                    quotCheck               = HybsSystem.sysBool( "USE_SQL_INJECTION_CHECK" );      // 4.0.0 (2005/08/31)
541                    modifyType      = null;                 // 3.8.5.1 (2006/05/08)
542                    traceMsg                = null;                 // 3.8.5.3 (2006/08/07)
543                    xssCheck                = HybsSystem.sysBool( "USE_XSS_CHECK" );        // 5.0.0.2 (2009/09/15)
544                    isMainTrans             = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
545                    useBeforeHtmlTag        = true ;        // 5.3.5.0 (2011/05/01)
546            }
547    
548            /**
549             * Query 繧貞ｮ溯｡後＠縺ｾ縺吶?
550             *
551             * @og.rev 2.1.2.3 (2002/12/02) 繝??繧ｿ繝吶?繧ｹ譖ｴ譁ｰ譎ゅ↓縲∵峩譁ｰ繝輔Λ繧ｰ繧偵そ繝?ヨ縺吶ｋ繧医≧縺ｫ螟画峩
552             * @og.rev 3.4.0.0 (2003/09/01) 逋ｻ骭ｲ繧ｨ繝ｩ繝ｼ譎ゅ?繧ｭ繝ｼ縺ｨ蛟､繧定｡ｨ遉ｺ縺吶ｋ繧医≧縺ｫ螟画峩縲?
553             * @og.rev 3.5.6.0 (2004/06/18) 繝?ヰ繝?げ諠??蜃ｺ蜉帷畑縺ｫ縲｝rintDebug 繝｡繧ｽ繝?ラ繧定ｿｽ蜉??
554             * @og.rev 3.6.1.0 (2005/01/05) 繧ｨ繝ｩ繝ｼ繧ｳ繝ｼ繝峨↓繧医ｋ commit/rollback 縺ｮ蛻､譁ｭ霑ｽ蜉?
555             * @og.rev 5.3.7.0 (2011/07/01) name縺ｮ蛻､螳壹↓繧ｼ繝ｭ譁?ｭ怜?繧剃ｻ伜刈
556             *
557             * @param       query 繧ｪ繝悶ず繧ｧ繧ｯ繝?
558             */
559            protected void execute( final Query query ) {
560                    String[] nameArray = null;
561                    String[] values    = null;
562                    try {
563    //                      if( names == null ) {
564                            if( names == null || names.length() == 0 ) {
565                                    query.execute();
566                            }
567                            else {
568                                    nameArray = StringUtil.csv2Array( names );
569                                    values = getRequest( nameArray );
570                                    // 3.5.6.0 (2004/06/18) 繝?ヰ繝?げ諠??蜃ｺ蜉帷畑
571                                    if( isDebug() ) { printDebug( nameArray,values ); }
572                                    query.execute( values );
573                            }
574                            errCode = query.getErrorCode();
575                            errMessage = query.getErrorMessage();
576                            // 3.6.1.0 (2005/01/05) 繧ｨ繝ｩ繝ｼ繧ｳ繝ｼ繝峨↓繧医ｋ commit/rollback 縺ｮ蛻､譁ｭ霑ｽ蜉?
577    //                      if( query.getUpdateFlag() ) {
578                            if( query.isUpdate() ) {
579                                    if( errCode < ErrorMessage.NG ) {            // 逡ｰ蟶ｸ莉･荳九?蝣ｴ蜷?
580                                            query.commit();
581                                    }
582                                    else {
583                                            query.rollback();
584                                    }
585                            }
586                    }
587                    catch( HybsSystemException ex ) {
588                            query.rollback();
589    
590                            // 4.0.0 (2005/02/28) 繧ｨ繝ｩ繝ｼ譎ゅ?陦ｨ遉ｺ縺ｨ繝?ヰ繝?げ譎ゅ?陦ｨ遉ｺ繧堤ｵｱ荳?☆繧九?
591                            String errMsg = "DATABASE ERROR! " + HybsSystem.CR ;
592                            if( nameArray != null ) {
593                                    printDebug( nameArray,values );
594                                    errMsg += debugMsg;
595                            }
596                            throw new HybsSystemException( errMsg,ex );             // 3.5.5.4 (2004/04/15) 蠑墓焚縺ｮ荳ｦ縺ｳ鬆?､画峩
597                    }
598                    finally {
599                            if( query != null ) { query.close(); }
600                    }
601            }
602    
603            /**
604             * 繝?ヰ繝?げ逕ｨ縺ｫ縲??蛻励ョ繝ｼ繧ｿ繧呈嶌縺榊?縺励∪縺吶?
605             *
606             * @og.rev 3.5.6.0 (2004/06/18) 譁ｰ隕剰ｿｽ蜉?
607             *
608             * @param       nms     蠑墓焚 names 縺ｮ驟榊?繝??繧ｿ
609             * @param       vals    names 縺ｫ蟇ｾ蠢懊☆繧九Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ驟榊?
610             */
611            private void printDebug( final String[] nms,final String[] vals ) {
612                    if( debugMsg == null ) { debugMsg = new StringBuilder(); }
613    
614                    debugMsg.append( "  names=[" );
615                    debugMsg.append( StringUtil.array2csv( nms ) );
616                    debugMsg.append( "]" );
617                    debugMsg.append( HybsSystem.CR );
618                    debugMsg.append( "  values=[" );
619                    debugMsg.append( StringUtil.array2csv( vals ) );
620                    debugMsg.append( "]" );
621                    debugMsg.append( HybsSystem.CR );
622            }
623    
624            /**
625             * 蜷咲ｧｰ驟榊?繧貞?縺ｫ縲√Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ繝??繧ｿ繧貞叙蠕励＠縺ｾ縺吶?
626             * checkNames 螻樊?縺ｫ險ｭ螳壹＆繧後※縺?ｋ繧ｫ繝ｩ繝?′縺ゅｌ縺ｰ縲∝?繧呈ｭ｣隕丞喧縺励∪縺吶?
627             *
628             * @og.rev 3.8.0.5 (2005/08/20) 繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧(checkNames)蟇ｾ蠢?
629             *
630             * @param       nameArray       繧ｭ繝ｼ縺ｨ縺ｪ繧句錐遘ｰ縺ｮ驟榊?
631             *
632             * @return      縺昴?繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ驟榊?
633             */
634            protected String[] getRequest( final String[] nameArray ) {
635                    String[] rtn = new String[nameArray.length];
636    
637                    for( int i=0; i<rtn.length; i++ ) {
638                            rtn[i] = getRequestValue( nameArray[i] );
639    
640                            // 3.8.0.5 (2005/08/20) checkNames 縺後≠繧翫?rtn[i] 縺後≠繧句?蜷医?
641                            if( checkNames != null && checkNames.length() > 0 && rtn[i].length() > 0 ) {
642                                    if( ( "," + checkNames + "," ).indexOf( "," + nameArray[i] + "," ) >= 0 ) {
643                                            DBColumn dbColumn = getDBColumn( nameArray[i] );
644                                            String val = dbColumn.valueSet( rtn[i] );
645                                            if( val != null ) { rtn[i] = val; }
646                                    }
647                            }
648                    }
649    
650                    return rtn;
651            }
652    
653            /**
654             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､繧呈欠螳壹＠縺ｾ縺吶?
655             *
656             * @og.tag
657             * 繝??繧ｿ繝吶?繧ｹ閾ｪ菴薙?讀懃ｴ｢縺ｯ,謖?ｮ壹＆繧後◆SQL縺ｮ蜈ｨ莉ｶ繧呈､懃ｴ｢縺励∪縺吶′,
658             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※縺ｯ縲√せ繧ｭ繝??莉ｶ謨ｰ蛻??逋ｻ骭ｲ縺輔ｌ縺ｾ縺帙ｓ縲?
659             * 繧ｵ繝ｼ繝舌?縺ｮ繝｡繝｢繝ｪ雉?ｺ舌→蠢懃ｭ疲凾髢薙?遒ｺ菫昴?轤ｺ縺ｧ縺吶?
660             *
661             * @param       count 隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､
662             */
663            public void setSkipRowCount( final String count ) {
664                    skipRowCount = nval( getRequestParameter( count ),skipRowCount );
665            }
666    
667            /**
668             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ譛?､ｧ隱ｭ縺ｿ霎ｼ縺ｿ莉ｶ謨ｰ繧呈欠螳壹＠縺ｾ縺?
669             *              (蛻晄悄蛟､:DB_MAX_ROW_COUNT[={@og.value org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT}])縲?
670             *
671             * @og.tag
672             * 繝??繧ｿ繝吶?繧ｹ閾ｪ菴薙?讀懃ｴ｢縺ｯ,謖?ｮ壹＆繧後◆SQL縺ｮ蜈ｨ莉ｶ繧呈､懃ｴ｢縺励∪縺吶′,
673             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺吶ｋ譛?､ｧ莉ｶ謨ｰ繧偵％縺ｮ蛟､縺ｫ險ｭ螳壹＠縺ｾ縺吶?
674             * 繧ｵ繝ｼ繝舌?縺ｮ繝｡繝｢繝ｪ雉?ｺ舌→蠢懃ｭ疲凾髢薙?遒ｺ菫昴?轤ｺ縺ｧ縺吶?
675             * 0 繧偵そ繝?ヨ縺吶ｋ縺ｨ縲∫┌蛻ｶ髯?Integer.MAX_VALUE)縺ｫ縺ｪ繧翫∪縺吶?
676             * (蛻晄悄蛟､:繝ｦ繝ｼ繧ｶ繝ｼ螳壽焚縺ｮDB_MAX_ROW_COUNT[={@og.value org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT}])縲?
677             *
678             * @og.rev 5.5.8.5 (2012/11/27) 0繧堤┌蛻ｶ髯舌→縺励※蜃ｦ逅?＠縺ｾ縺吶?
679             *
680             * @param       count 譛?､ｧ隱ｭ縺ｿ霎ｼ縺ｿ莉ｶ謨ｰ
681             * @see         org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT
682             */
683            public void setMaxRowCount( final String count ) {
684                    maxRowCount = nval( getRequestParameter( count ),maxRowCount );
685                    if( maxRowCount == 0 ) { maxRowCount = Integer.MAX_VALUE ; }            // 5.5.8.5 (2012/11/27)
686            }
687    
688            /**
689             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡縺ｮDBTableModel繧偵?session縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
690             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
691             *
692             * @og.tag
693             * 讀懃ｴ｢邨先棡繧医ｊ縲．BTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?縺薙ｌ繧偵?荳区ｵ√?view繧ｿ繧ｰ遲峨↓
694             * 貂｡縺吝?蜷医↓縲??蟶ｸ縺ｯ縲《ession 繧貞茜逕ｨ縺励∪縺吶?縺昴?蝣ｴ蜷医?逋ｻ骭ｲ繧ｭ繝ｼ縺ｧ縺吶?
695             * query 繧ｿ繧ｰ繧貞酔譎ゅ↓螳溯｡後＠縺ｦ縲∫ｵ先棡繧呈ｱゅａ繧句?蜷医?蜷御ｸ?Γ繝｢繝ｪ縺ｫ驟咲ｽｮ縺輔ｌ繧狗ぜ縲?
696             * 縺薙? tableId 螻樊?繧貞茜逕ｨ縺励※縲√Γ繝｢繝ｪ遨ｺ髢薙ｒ蛻?￠縺ｾ縺吶?
697             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
698             *
699             * @param       id session縺ｫ逋ｻ骭ｲ縺吶ｋ譎ゅ? ID
700             */
701            public void setTableId( final String id ) {
702                    tableId   = nval( getRequestParameter( id ),tableId );  // 3.8.0.9 (2005/10/17)
703            }
704    
705            /**
706             * 縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID(JDBC,JDBCCallable,JDBCErrMsg,JDBCUpdate)繧呈欠螳壹＠縺ｾ縺?{@og.doc03Link queryType 蛻晄悄蛟､:JDBC})縲?
707             *
708             * @og.tag
709             * 讀懃ｴ｢繧貞ｮ溯｡後☆繧区焔谿ｵ縺ｯ縲＿uery 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ縺ｮ螳溯｣?け繝ｩ繧ｹ縺ｫ縺ｪ繧翫∪縺吶?
710             * 縺薙?繧ｿ繧ｰ縺ｧ縺ｯ縲＿uery.execute( String[] ) 繝｡繧ｽ繝?ラ縺悟他縺ｰ繧後∪縺吶?
711             * 萓九∴縺ｰ縲√せ繝医い繝峨?繝ｭ繧ｷ繝ｼ繧ｸ繝｣遲峨ｒ螳溯｡後☆繧句?蜷医↓縲〈ueryType="JDBCErrMsg"
712             * 繧呈欠螳壹☆繧九％縺ｨ縺後〒縺阪∪縺吶?
713             * 蛻晄悄蛟､縺ｯ縲?JDBC" 縺ｧ縺吶?
714             * queryType 縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ Query_**** 螳｣險?? **** 繧剃ｸ弱∴縺ｾ縺吶?
715             * 縺薙ｌ繧峨?縲＿uery 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧堤ｶ呎価縺励◆繧ｵ繝悶け繝ｩ繧ｹ縺ｧ縺ゅｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
716             * 讓呎ｺ悶〒縲｛rg.opengion.hayabusa.db 莉･荳九? Query_**** 繧ｯ繝ｩ繧ｹ縺後?Query_**** 螳｣險?縺ｨ
717             * 縺励※縲∝ｮ夂ｾｩ縺輔ｌ縺ｦ縺?∪縺吶?
718             * 螻樊?繧ｯ繝ｩ繧ｹ螳夂ｾｩ縺ｮ {@link org.opengion.hayabusa.db.Query Query} 繧貞盾辣ｧ鬘倥＞縺ｾ縺吶?
719             * {@og.doc03Link queryType Query_**** 繧ｯ繝ｩ繧ｹ}
720             *
721             * @param       id Query 繧堤匱陦後☆繧狗ぜ縺ｮ螳溘け繝ｩ繧ｹ ID
722             * @see         org.opengion.hayabusa.db.Query  Query縺ｮ繧ｵ繝悶け繝ｩ繧ｹ
723             * @see         org.opengion.hayabusa.db.Query#execute( String[] )
724             */
725            public void setQueryType( final String id ) {
726                    queryType = getRequestParameter( id );
727            }
728    
729            /**
730             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
731             *
732             * @og.tag
733             * Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
734             * 縺薙ｌ縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｧ縲．EFAULT_DB_URL 遲峨〒謖?ｮ壹＠縺ｦ縺?ｋ 繝??繧ｿ繝吶?繧ｹ謗･邯壼?
735             * 諠??縺ｫ縲々X_DB_URL 繧貞ｮ夂ｾｩ縺吶ｋ縺薙→縺ｧ縲?dbid="XX" 縺ｨ縺吶ｋ縺ｨ縲√％縺ｮ 謗･邯壼?繧剃ｽｿ逕ｨ縺励※
736             * 繝??繧ｿ繝吶?繧ｹ縺ｫ繧｢繧ｯ繧ｻ繧ｹ縺ｧ縺阪∪縺吶?
737             *
738             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
739             */
740            public void setDbid( final String id ) {
741                    dbid = nval( getRequestParameter( id ),dbid );
742            }
743    
744            /**
745             * 縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?PlsqlUpdateTag,UpdateTag 縺ｮ蝣ｴ蜷医?縲・NTRY)縲?
746             *
747             * @og.tag
748             * 繧ｳ繝槭Φ繝峨?,HTML縺九ｉ(get/post)謖?ｮ壹＆繧後∪縺吶?縺ｧ,CMD_xxx 縺ｧ險ｭ螳壹＆繧後ｋ
749             * 繝輔ぅ繝ｼ繝ｫ繝牙ｮ壽焚蛟､縺ｮ縺?▼繧後°繧偵?謖?ｮ壹〒縺阪∪縺吶?
750             *
751             * @param       cmd 繧ｳ繝槭Φ繝?public static final 螳｣險?＆繧後※縺?ｋ譁?ｭ怜?)
752             * @see         <a href="../../../../constant-values.html#org.opengion.hayabusa.taglib.QueryTag.CMD_NEW">繧ｳ繝槭Φ繝牙ｮ壽焚</a>
753             */
754            public void setCommand( final String cmd ) {
755                    String cmd2 = getRequestParameter( cmd );
756                    if( cmd2 != null && cmd2.length() >= 0 ) { command = cmd2.toUpperCase(Locale.JAPAN); }
757            }
758    
759            /**
760             * 縲慎AG縲第､懃ｴ｢邨先棡縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺榊?逅?ｒ邯夊｡後☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[邯夊｡後☆繧犠)縲?
761             *
762             * @og.tag
763             * 蛻晄悄蛟､縺ｯ縲’alse(邯夊｡後☆繧?縺ｧ縺吶?
764             *
765             * @param  cmd 讀懃ｴ｢邨先棡縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺阪?[true:蜃ｦ逅?ｒ荳ｭ豁｢縺吶ｋ/false:邯夊｡後☆繧犠
766             */
767            public void setStopZero( final String cmd ) {
768                    stopZero = nval( getRequestParameter( cmd ),stopZero );
769            }
770    
771            /**
772             * 縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?
773             *              (蛻晄悄蛟､:VIEW_DISPLAY_MSG[={@og.value org.opengion.hayabusa.common.SystemData#VIEW_DISPLAY_MSG}])縲?
774             *
775             * @og.tag
776             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
777             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ陦ｨ遉ｺ縺励∪縺吶?
778             * 莉ｶ謨ｰ繧定｡ｨ遉ｺ縺輔○縺溘＞蝣ｴ蜷医?縲‥isplayMsg = "MSG0033"[縲?ｻｶ讀懃ｴ｢縺励∪縺励◆] 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
779             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
780             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮVIEW_DISPLAY_MSG[={@og.value org.opengion.hayabusa.common.SystemData#VIEW_DISPLAY_MSG}])縲?
781             *
782             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
783             * @see         org.opengion.hayabusa.common.SystemData#VIEW_DISPLAY_MSG
784             */
785            public void setDisplayMsg( final String id ) {
786                    String ids = getRequestParameter( id );
787                    if( ids != null ) { displayMsg = ids; }
788            }
789    
790            /**
791             * 縲慎AG縲第､懃ｴ｢繝??繧ｿ縺梧怙螟ｧ讀懃ｴ｢謨ｰ繧偵が繝ｼ繝舌?縺励◆蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?
792             *              (蛻晄悄蛟､:MSG0007[讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆])縲?
793             *
794             * @og.tag
795             * 讀懃ｴ｢邨先棡縺後?maxRowCount 縺ｧ險ｭ螳壹＆繧後◆蛟､繧医ｊ螟壹＞蝣ｴ蜷医?菴輔ｉ縺九?繝??繧ｿ縺ｯ讀懃ｴ｢縺輔ｌ縺?
796             * 蛻?ｊ謐ｨ縺ｦ繧峨ｌ縺溘％縺ｨ縺ｫ縺ｪ繧翫∪縺吶?
797             * 縺薙％縺ｧ縺ｯ縲‥isplayMsg 繧定｡ｨ遉ｺ縺励◆蠕後?蠢?ｦ√↓蠢懊§縺ｦ縲√％縺ｮ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺励∪縺吶?
798             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, overflowMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
799             * 蛻晄悄蛟､縺ｯ縲｀SG0007[讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆]縺ｧ縺吶?
800             *
801             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
802             */
803            public void setOverflowMsg( final String id ) {
804                    String ids = getRequestParameter( id );
805                    if( ids != null ) { overflowMsg = ids; }
806            }
807    
808            /**
809             * 縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])縲?
810             *
811             * @og.tag
812             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ縲∫音蛻･縺ｪ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
813             * 蠕捺擂縺ｯ縲‥isplayMsg 縺ｨ蜈ｼ逕ｨ縺ｧ縲√?0縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲上→縺?≧陦ｨ遉ｺ縺ｧ縺励◆縺後?
814             * displayMsg 縺ｮ蛻晄悄陦ｨ遉ｺ縺ｯ縲＾FF 縺ｫ縺ｪ繧翫∪縺励◆縺ｮ縺ｧ縲√ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ蛻･縺ｫ陦ｨ遉ｺ縺輔○縺ｾ縺吶?
815             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, notfoundMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
816             * 蛻晄悄蛟､縺ｯ縲｀SG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆]縺ｧ縺吶?
817             *
818             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
819             */
820            public void setNotfoundMsg( final String id ) {
821                    String ids = getRequestParameter( id );
822                    if( ids != null ) { notfoundMsg = ids; }
823            }
824    
825            /**
826             * 縲慎AG縲善L/SQL繧貞茜逕ｨ縺吶ｋ蝣ｴ蜷医?蠑墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
827             *
828             * @og.tag
829             * 隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ励〒貂｡縺励∪縺吶?
830             * names 螻樊?縺ｯ縲〈ueryType 縺ｫ蠢懊§縺ｦ險ｭ螳壼庄蜷ｦ縺檎焚縺ｪ繧翫∪縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
831             * names 縺ｪ縺暦ｼ哽DBC,JDBCUpdate
832             * names 縺ゅｊ?哽DBCCallable,JDBCErrMsg,JDBCUpdate
833             * (JDBCUpdate縺ｯ縲］ames 螻樊?縺ｮ縺ゅｊ/縺ｪ縺嶺ｸ｡譁ｹ縺ｫ蟇ｾ蠢懊＠縺ｦ縺?∪縺吶?)
834             *
835             * @og.rev 3.0.1.3 (2003/03/11) names 螻樊?縺ｫ null 縺ｧ貂｡縺吝?蜷医?繝舌げ繧剃ｿｮ豁｣
836             *
837             * @param       nm 蠑墓焚縺ｮ蜷咲ｧｰ(隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ?
838             */
839            public void setNames( final String nm ) {
840                    names = nval( getRequestParameter( nm ),names );
841            }
842    
843            /**
844             * 縲慎AG縲第､懃ｴ｢邨先棡縺ｮ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺吶ｋ/縺励↑縺Ъtrue/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
845             *
846             * @og.tag
847             * 蛻晄悄蛟､縺ｯ縲∬｡ｨ遉ｺ縺吶ｋ?嗾rue 縺ｧ縺吶?
848             *
849             * @param       flag  [true:陦ｨ遉ｺ縺吶ｋ/縺昴ｌ莉･螟?蜷ｫ繧√↑縺Ь
850             */
851            public void setOutMessage( final String flag ) {
852                    outMessage = nval( getRequestParameter( flag ),outMessage );
853            }
854    
855            /**
856             * 縲慎AG縲大ｼ墓焚縺ｮ SQL 譁?ｒ EXPLAIN PLAN 繧端true:陦後≧/縺昴ｌ莉･螟?陦後ｏ縺ｪ縺Ь繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
857             *
858             * @og.tag
859             *
860             * 縺薙％縺ｧ縺ｯ縲∽ｻ･荳九?蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
861             * ?托ｼ主ｼ墓焚縺ｮ SQL 譁?ｒ逕ｻ髱｢縺ｫ陦ｨ遉ｺ縺励∪縺吶?
862             * ?抵ｼ主ｼ墓焚縺ｮ SQL 譁?ｒ EXPLAIN PLAN 縺励◆邨先棡繧偵?逕ｻ髱｢縺ｫ陦ｨ遉ｺ縺励∪縺吶?
863             * 縺ｪ縺翫?莉･蜑阪?縲√そ繝?す繝ｧ繝ｳ縺ｮ繝医Ξ繝ｼ繧ｹ繧定｡後▲縺ｦ縺?∪縺励◆縺後?縺昴?讖溯?縺ｯ縲∝ｻ?ｭ｢縺?◆縺励∪縺吶?
864             * 蛻晄悄蛟､縺ｯ縲∬｡後ｏ縺ｪ縺?ｼ喃alse 縺ｧ縺吶?
865             *
866             * @param       flag 繝医Ξ繝ｼ繧ｹ [true:陦後≧/縺昴ｌ莉･螟?陦後ｏ縺ｪ縺Ь
867             */
868            public void setTrace( final String flag ) {
869                    trace = nval( getRequestParameter( flag ),trace );
870            }
871    
872            /**
873             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧繧定｡後≧繧ｫ繝ｩ繝?ｒCSV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
874             *
875             * @og.tag
876             * PL/SQL繧貞茜逕ｨ縺吶ｋ蝣ｴ蜷医?蠑墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ繧偵?繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ
877             * 蛟､縺昴?縺ｾ縺ｾ縺ｧ縺ｯ縺ｪ縺上?繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医? valueSet 繝｡繧ｽ繝?ラ邨檎罰縺ｧ豁｣隕丞喧
878             * 縺励◆蛟､繧剃ｽｿ逕ｨ縺吶ｋ繧医≧縺ｫ縺励∪縺吶?
879             *
880             * @og.rev 3.8.0.5 (2005/08/20) 譁ｰ隕剰ｿｽ蜉?
881             *
882             * @param       nm 繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ豁｣隕丞喧繧定｡後≧繧ｫ繝ｩ繝?
883             */
884            public void setCheckNames( final String nm ) {
885                    checkNames = nval( getRequestParameter( nm ),checkNames );
886            }
887    
888            /**
889             * 縲慎AG縲船B讀懃ｴ｢譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝励ｒ謖?ｮ壹＠縺ｾ縺兌A:霑ｽ蜉?C:譖ｴ譁ｰ/D:蜑企勁]縲?
890             *
891             * @og.tag
892             * DB讀懃ｴ｢譎ゅ↓縲√◎縺ｮ繝??繧ｿ繧但(霑ｽ蜉?縲，(譖ｴ譁ｰ)縲．(蜑企勁)縺ｮ繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝励ｒ
893             * 縺､縺代◆迥ｶ諷九↓縺励∪縺吶?
894             * 縺昴?迥ｶ諷九〒縲√◎縺ｮ縺ｾ縺ｾ縲「pdate 縺吶ｋ莠九′蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
895             *
896             * @og.rev 3.8.5.1 (2006/05/08) 譁ｰ隕剰ｿｽ蜉?
897             *
898             * @param   type DB讀懃ｴ｢譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝?[A:霑ｽ蜉?C:譖ｴ譁ｰ/D:蜑企勁]
899             */
900            public void setModifyType( final String type ) {
901                    modifyType = nval( getRequestParameter( type ),modifyType );
902            }
903    
904            /**
905             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
906             *              (蛻晄悄蛟､:USE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])縲?
907             *
908             * @og.tag
909             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
910             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
911             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
912             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
913             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
914             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
915             * 蛻晄悄蛟､縺ｯ縲ヾystemData#USE_SQL_INJECTION_CHECK 縺ｧ縺吶?
916             *
917             * @og.rev 4.0.0.0 (2005/08/31) 譁ｰ隕剰ｿｽ蜉?
918             *
919             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
920             */
921            public void setQuotCheck( final String flag ) {
922                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
923            }
924    
925            /**
926             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ HTMLTag髢句ｧ?邨ゆｺ?枚蟄?&gt;&lt;) 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?
927             *              (蛻晄悄蛟､:USE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])縲?
928             *
929             * @og.tag
930             * 繧ｯ繝ｭ繧ｹ繧ｵ繧､繝医せ繧ｯ繝ｪ繝励ユ繧｣繝ｳ繧ｰ(XSS)蟇ｾ遲悶?荳?腸縺ｨ縺励※less/greater than sign縺ｫ縺､縺?※縺ｮ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
931             * (&gt;&lt;) 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
932             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_XSS_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK}])
933             *
934             * @og.rev 5.0.0.2 (2009/09/15) 譁ｰ隕剰ｿｽ蜉?
935             *
936             * @param       flag    XSS繝√ぉ繝?け [true:縺吶ｋ/false:縺励↑縺Ь
937             * @see         org.opengion.hayabusa.common.SystemData#USE_XSS_CHECK
938             */
939            public void setXssCheck( final String flag ) {
940                    xssCheck = nval( getRequestParameter( flag ),xssCheck );
941            }
942    
943            /**
944             * 縲慎AG縲善LSQL/SQL蜃ｦ逅?お繝ｩ繝ｼ縺ｮ譎ゅ↓蜃ｦ逅?ｒ荳ｭ豁｢縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
945             *
946             * @og.tag
947             * false(荳ｭ豁｢縺励↑縺?縺ｫ險ｭ螳壹☆繧句?蜷医?蠕檎ｶ壼?逅?〒縺ｯ縲＋&#064;DB.ERR_CODE}縺ｮ蛟､縺ｫ繧医ｊ縲?
948             * PLSQL/SQL縺ｮ逡ｰ蟶ｸ/豁｣蟶ｸ邨ゆｺ?↓繧医▲縺ｦ蛻?ｲ仙?逅??蜿ｯ閭ｽ縺ｨ縺ｪ繧翫∪縺吶?
949             * 蛻晄悄蛟､縺ｯ縲》rue(荳ｭ豁｢縺吶ｋ)縺ｧ縺吶?
950             *
951             * @og.rev 4.3.3.0 (2008/09/22) 譁ｰ隕剰ｿｽ蜉?
952             *
953             * @param   flag  [true:荳ｭ豁｢縺吶ｋ/false:荳ｭ豁｢縺励↑縺Ь
954             */
955            public void setStopError( final String flag ) {
956                    stopError = nval( getRequestParameter( flag ),stopError );
957            }
958    
959            /**
960             * 蠑墓焚縺ｮ SQL 譁?ｒ EXPLAIN PLAN 縺励∪縺吶?
961             *
962             * 縺薙％縺ｧ縺ｯ縲∽ｻ･荳九?蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
963             * ?托ｼ主ｼ墓焚縺ｮ SQL 譁?ｒ逕ｻ髱｢縺ｫ陦ｨ遉ｺ縺励∪縺吶?
964             * ?抵ｼ主ｼ墓焚縺ｮ SQL 譁?ｒ EXPLAIN PLAN 縺励◆邨先棡繧偵?逕ｻ髱｢縺ｫ陦ｨ遉ｺ縺励∪縺吶?
965             * 縺ｪ縺翫?縺薙?蜃ｦ逅??縲＾RACLE 蟆ら畑蜃ｦ逅?〒縺吶?
966             *
967             * @og.rev 3.8.5.3 (2006/08/07) 譁ｰ隕剰ｿｽ蜉?
968             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
969             * @og.rev 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢懊＠縺ｾ縺吶?
970             * @og.rev 5.5.3.4 (2012/06/19) getUserInfo 縺ｯ縲√く繝ｼ驛ｨ蛻?□縺代〒蜃ｦ逅?＠縺ｾ縺吶?
971             *
972             * @param   sql         EXPLAIN PLAN縺吶ｋSQL 譁?
973             * @param   tran        Transaction繧ｪ繝悶ず繧ｧ繧ｯ繝?
974             *
975             * @return 繝医Ξ繝ｼ繧ｹ邨先棡縺ｮ譁?ｭ怜?
976             */
977    //      private String traceQuery( final String sql ) {
978            private String traceQuery( final String sql , final Transaction tran ) {
979    //              ApplicationInfo appInfo = getApplicationInfo();
980    
981    //              String userId = getUserInfo( "USER.ID" ) ;
982                    String userId = getUserInfo( "ID" ) ;                   // 5.5.3.4 (2012/06/19) getUserInfo 縺ｯ縲√く繝ｼ驛ｨ蛻?□縺代〒蜃ｦ逅?＠縺ｾ縺吶?
983    
984                    String[] arg1 = new String[] { userId };
985    //              DBUtil.dbExecute( "DELETE FROM PLAN_TABLE WHERE STATEMENT_ID = ?",arg1,appInfo,dbid );
986                    DBUtil.dbExecute( "DELETE FROM PLAN_TABLE WHERE STATEMENT_ID = ?",arg1,tran,dbid );             // 5.1.9.0 (2010/08/01)
987    
988                    String explan1 = "EXPLAIN PLAN SET STATEMENT_ID = '" + userId + "' FOR " + sql ;
989    //              DBUtil.dbExecute( explan1,null,appInfo,dbid );
990                    DBUtil.dbExecute( explan1,null,tran,dbid );             // 5.1.9.0 (2010/08/01)
991    
992                    String[] arg2 = new String[] { userId,userId,userId };
993    //              String explan2 = "SELECT LEVEL,LPAD(' ',LEVEL,' ') || RTRIM( OPERATION ) || ' ' ||"
994    //                                              + " RTRIM( OPTIONS )   || ' ' || RTRIM( OBJECT_NAME )"
995    //                                              + " FROM PLAN_TABLE"
996    //                                              + " WHERE STATEMENT_ID = ?"
997    //                                              + " CONNECT BY PRIOR ID = PARENT_ID"
998    //                                              + "         AND STATEMENT_ID = ?"
999    //                                              + " START WITH ID = 0"
1000    //                                              + "         AND STATEMENT_ID = ?" ;
1001                    String explan2 = "select LEVEL as LVL"
1002                                                            + ",lpad(' ',LEVEL,' ') || rtrim( OPERATION ) || ' ' || rtrim( OPTIONS ) || ' ' || rtrim( OBJECT_NAME ) as EXECUTION_PLAN"
1003                                                            + ",OBJECT_NAME                 as OBJ_NAME"
1004                                                            + ",DECODE(INSTR(OBJECT_TYPE,' '),0,OBJECT_TYPE,SUBSTR(OBJECT_TYPE,1,INSTR(OBJECT_TYPE,' ')-1)) as OBJ_TYPE"
1005                                                            + ",OPTIMIZER                   as OPT"
1006                                                            + ",COST                                as CST"
1007                                                            + ",CARDINALITY                 as CARD"
1008                                                            + ",BYTES                               as BYTE"
1009                                                            + ",ACCESS_PREDICATES   as ACCS"
1010                                                            + ",FILTER_PREDICATES   as FILTER"
1011                                                    + " from PLAN_TABLE"
1012                                                    + " where STATEMENT_ID = ?"
1013                                                    + " start with ID = 0"
1014                                                    + "       and STATEMENT_ID = ?"
1015                                                    + " connect by prior ID = PARENT_ID"
1016                                                    + "       and STATEMENT_ID = ?" ;
1017    //              String[][] plan = DBUtil.dbExecute( explan2,arg2,appInfo,dbid );
1018    //              String[][] plan = DBUtil.dbExecute( explan2,arg2,tran,dbid );                   // 5.1.9.0 (2010/08/01)
1019    
1020    //              StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
1021    //              buf.append( "<pre>" ).append( sql ).append( "</pre>" ).append( HybsSystem.BR );
1022    //              buf.append( "<table>" );
1023    //              buf.append( "<tr  class=\"row_h\"><th>LEVEL</th><th>EXECUTION_PLAN</th></tr>" );
1024    //              for( int i=0; i<plan.length; i++ ) {
1025    //                      buf.append( "<tr class=\"row_" ).append( i%2 ).append( "\">" );
1026    //                      buf.append( "<td>" ).append( plan[i][0] ).append( "</td>" );
1027    //                      buf.append( "<td><pre>" ).append( plan[i][1] ).append( "</td></tr>" );
1028    //              }
1029    //              buf.append( "</table>" ).append( HybsSystem.BR );
1030    
1031                    String[][] plan = DBUtil.dbExecute( explan2,arg2,tran,dbid,true );                      // 5.5.3.4 (2012/06/19) 繝倥ャ繝??諠??繧ょ酔譎ゅ↓蜿門ｾ励☆繧九?
1032    
1033                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
1034                    buf.append( "<pre>" ).append( sql ).append( "</pre>" ).append( HybsSystem.BR );
1035                    buf.append( "<table>" );
1036                    // 1陦檎岼縺ｮ繝倥ャ繝??縺ｮ蜃ｺ蜉?
1037                    int colsize = plan[0].length;
1038                    buf.append( "<tr class=\"row_h\">" );
1039                    for( int j=0; j<colsize; j++ ) {
1040                            buf.append( "<th>" ).append( plan[0][j] ).append( "</th>" );
1041                    }
1042                    buf.append( "</tr>" );
1043    
1044                    for( int i=1; i<plan.length; i++ ) {
1045                            buf.append( "<tr class=\"row_" ).append( i%2 ).append( "\">" );
1046                            for( int j=0; j<colsize; j++ ) {
1047                                    if( j==1 ) {
1048                                            buf.append( "<td><pre>" ).append( plan[i][1] ).append( "</pre></td>" );
1049                                    }
1050                                    else {
1051                                            buf.append( "<td>" ).append( plan[i][j] ).append( "</td>" );
1052                                    }
1053                            }
1054                            buf.append( "</tr>" );
1055                    }
1056                    buf.append( "</table>" ).append( HybsSystem.BR );
1057                    return buf.toString();
1058            }
1059    
1060            /**
1061             * 縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
1062             *
1063             * @og.tag
1064             * 縺薙?蛟､縺ｯ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅?↓蠖ｱ髻ｿ縺励∪縺吶?縺薙?蛟､縺荊rue縺ｫ謖?ｮ壹＆繧後◆譎ゅ↓commit縺輔ｌ縺櫂BTableModel縺?
1065             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨?蟇ｾ雎｡縺ｮ陦ｨ縺ｫ縺ｪ繧翫∪縺吶?
1066             *
1067             * 縺薙?繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｯ縲??蟶ｸ縲∝推繧ｿ繧ｰ縺ｫ繧医ｊ螳溯｣?＆繧後?繝ｦ繝ｼ繧ｶ繝ｼ縺梧欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲?
1068             * 菴?＠縲?縺､縺ｮJSP蜀?〒DBTableModel縺瑚､?焚逕滓?縺輔ｌ繧句?蜷医↓縲∝燕縺ｫ蜃ｦ逅?＠縺櫂BTableModel縺ｫ縺､縺?※繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨ｒ縺輔○縺溘＞
1069             * 蝣ｴ蜷医?縲∝ｾ後ｍ縺ｧDBTableModel繧堤函謌舌☆繧九ち繧ｰ縺ｧ縲∵?遉ｺ逧?↓縺薙?蛟､繧断alse縺ｫ謖?ｮ壹☆繧九％縺ｨ縺ｧ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅??蟇ｾ雎｡縺九ｉ
1070             * 髯､螟悶☆繧九％縺ｨ縺後〒縺阪∪縺吶?
1071             *
1072             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
1073             *
1074             * @param  flag 繝｡繧､繝ｳ繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ縺九←縺?°
1075             */
1076            public void setMainTrans( final String flag ) {
1077                    isMainTrans = nval( getRequestParameter( flag ),isMainTrans );
1078            }
1079    
1080            /**
1081             * 縲慎AG縲?蜃ｦ逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??蜃ｺ蜉媼true:譛牙柑/false:辟｡蜉ｹ]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
1082             *
1083             * @og.tag
1084             * Query 縺ｧ縲∵､懃ｴ｢縺吶ｋ蝣ｴ蜷医↓縲∝?逅?凾髢?queryTime)縺ｪ縺ｩ縺ｮ諠??繧貞?蜉帙＠縺ｦ縺?∪縺吶′縲?
1085             * ViewForm 縺ｧ縲，ustomData 縺ｪ縺ｩ縺ｮ 髱曰TML陦ｨ遉ｺ繝薙Η繝ｼ繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?繝??繧ｿ縺ｨ縺励※縲?
1086             * 邏帙ｌ霎ｼ繧薙〒縺励∪縺?◆繧√?蜃ｺ蜉帙ｒ謚大宛縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
1087             * true(譛牙柑)縺ｫ縺吶ｋ縺ｨ縲√％繧後ｉ縺ｮHTML縺悟?蜉帙＆繧後∪縺吶?false 縺ｫ縺吶ｋ縺ｨ縲∝?蜉帙＆繧後∪縺帙ｓ縲?
1088             * 蛻晄悄蛟､縺ｯ縲》rue(譛牙柑) 縺ｧ縺吶?
1089             *
1090             * @og.rev 5.3.5.0 (2011/05/01) 譁ｰ隕剰ｿｽ蜉?
1091             *
1092             * @param  useTag  諠??蜃ｺ蜉帙?譛牙柑/辟｡蜉ｹ繧呈欠螳?[true:譛牙柑/false:辟｡蜉ｹ]
1093             */
1094            public void setUseBeforeHtmlTag( final String useTag ) {
1095                    useBeforeHtmlTag = nval( getRequestParameter( useTag ),useBeforeHtmlTag );
1096            }
1097    
1098            /**
1099             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
1100             *
1101             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
1102             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
1103             *
1104             * @param       strm    ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
1105             * @throws IOException  蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
1106             */
1107            private void writeObject( final ObjectOutputStream strm ) throws IOException {
1108                    strm.defaultWriteObject();
1109            }
1110    
1111            /**
1112             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
1113             *
1114             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
1115             *
1116             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
1117             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
1118             *
1119             * @param       strm    ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
1120             * @see #release2()
1121             * @throws IOException  繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ縺ｫ髢｢縺吶ｋ蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
1122             * @throws ClassNotFoundException       繧ｯ繝ｩ繧ｹ繧定ｦ九▽縺代ｋ縺薙→縺後〒縺阪↑縺九▲縺溷?蜷?
1123             */
1124            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
1125                    strm.defaultReadObject();
1126            }
1127    
1128            /**
1129             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
1130             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
1131             *
1132             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
1133             */
1134            @Override
1135            public String toString() {
1136                    return sql ;
1137    
1138            //      return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
1139            //                      .println( "VERSION"                     ,VERSION                )
1140            //                      .println( "tableId"                     ,tableId                )
1141            //                      .println( "queryType"           ,queryType              )
1142            //                      .println( "dbid"                        ,dbid                   )
1143            //                      .println( "command"                     ,command                )
1144            //                      .println( "skipRowCount"        ,skipRowCount   )
1145            //                      .println( "maxRowCount"         ,maxRowCount    )
1146            //                      .println( "sql"                         ,sql                    )
1147            //                      .println( "displayMsg"          ,displayMsg             )
1148            //                      .println( "overflowMsg"         ,overflowMsg    )
1149            //                      .println( "executeCount"        ,executeCount   )
1150            //                      .println( "names"                       ,names                  )
1151            //                      .println( "outMessage"          ,outMessage             )
1152            //                      .println( "trace"                       ,trace                  )
1153            //                      .println( "errCode"                     ,errCode                )
1154            //                      .println( "stopZero"            ,stopZero               )
1155            //                      .println( "quotCheck"           ,quotCheck              )
1156            //                      .println( "dyStart"                     ,dyStart                )
1157            //                      .println( "checkNames"          ,checkNames             )
1158            //                      .println( "Other..."            ,getAttributes().getAttribute() )
1159            //                      .fixForm().toString() ;
1160            }
1161    }