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.util.ArrayList;
021    import java.util.List;
022    
023    import org.opengion.fukurou.util.ErrorMessage;
024    import org.opengion.hayabusa.common.HybsSystem;
025    import org.opengion.hayabusa.common.HybsSystemException;
026    import org.opengion.hayabusa.db.DBTableModel;
027    import org.opengion.hayabusa.db.Query;
028    import org.opengion.hayabusa.resource.GUIInfo;
029    
030    /**
031     * SQL譁?ｒ逶ｴ謗･謖?ｮ壹＠縺ｦ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｫ霑ｽ蜉?譖ｴ譁ｰ/蜑企勁繧定｡後＞縺ｾ縺?queryType="JDBCTableUpdate")縲?
032     *
033     * 蟄伜惠繝√ぉ繝?け繧定｡後≧蝣ｴ蜷医?縲》ableExist 繧ｿ繧ｰ縺ｨ菴ｵ逕ｨ縺励※縺上□縺輔＞縲?
034     * 隍?尅縺ｪ蜃ｦ逅?′蠢?ｦ√↑蝣ｴ蜷医?縲∝ｾ捺擂繧医ｊ菴ｿ逕ｨ縺励※縺?∪縺吶?PLSQL繧辰ALL縺吶ｋ縲?
035     * plsqlUpdate繧ｿ繧ｰ繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞縲?
036     * 縺ｾ縺溘?tableUpdateParam 繧ｿ繧ｰ繧剃ｽｿ逕ｨ縺吶ｋ莠九〒縲√ユ繝ｼ繝悶Ν蜷阪→sqlType縺ｮ謖?ｮ壹〒蜍慕噪縺ｫ
037     * SQL譁?ｒ閾ｪ蜍慕函謌舌〒縺阪∪縺吶?縺薙ｌ縺ｫ繧医ｊ縲∬ｿｽ蜉??譖ｴ譁ｰ縲∝炎髯､繧?ユ繝ｼ繝悶Ν縺ｫ髢｢縺励※縲?
038     * 蜊倅ｸ??JSP逕ｻ髱｢縺ｧ縺吶∋縺ｦ蟇ｾ蠢懊〒縺阪ｋ繧医≧縺ｫ縺ｪ繧翫∪縺吶?
039     *
040     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
041     *
042     * @og.formSample
043     * 笳丞ｽ｢蠑擾ｼ?lt;og:tableUpdate command="窶ｦ" names="窶ｦ" queryType="JDBCTableUpdate" &gt;
044     *             {&#064;SQL}
045     *         &lt;/og:update&gt;
046     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
047     *
048     * 笳週ag螳夂ｾｩ??
049     *   &lt;og:tableUpdate
050     *       queryType          縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID繧呈欠螳壹＠縺ｾ縺?{@og.doc03Link queryType 蛻晄悄蛟､:JDBCTableUpdate})
051     *       sqlType            縲慎AG縲腺ODY驛ｨ縺ｫ譖ｸ縺九ｌ縺ｦ縺?ｋ Param 縺ｮ SQL繧ｿ繧､繝励ｒ謖?ｮ壹＠縺ｾ縺?
052     *       command            縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?PlsqlUpdateTag,UpdateTag 縺ｮ蝣ｴ蜷医?縲・NTRY)
053     *       scope              縲慎AG縲代く繝｣繝?す繝･縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝夕request/page/session/applicaton]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
054     *       displayMsg         縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:VIEW_DISPLAY_MSG[=])
055     *       resourceType       縲千音谿翫?繧ｯ繝ｪ繧｢縺吶ｋ繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ遞ｮ鬘杣GEA03/GEA04/GEA08]繧呈欠螳壹＠縺ｾ縺?
056     *       conditionKey       縲慎AG縲第擅莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
057     *       conditionList      縲慎AG縲第擅莉ｶ蛻､螳壹☆繧句?縺ｮ繝ｪ繧ｹ繝医ｒ縲?|"縺ｧ蛹ｺ蛻?▲縺ｦ逋ｻ骭ｲ縺励∪縺?蛻晄悄蛟､:辟｡譚｡莉ｶ)
058     *       tableId            縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡縺ｮDBTableModel繧偵?session縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
059     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?
060     *       selectedAll        縲慎AG縲代ョ繝ｼ繧ｿ繧貞?莉ｶ驕ｸ謚樊ｸ医∩縺ｨ縺励※蜃ｦ逅?☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
061     *       commitTableModel   縲千音谿翫?SQL螳溯｡悟ｾ後↓邨先棡繧奪BTableModel縺ｫ蜿肴丐縺輔○繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
062     *       followCdkh         縲慎AG縲船BTableModel縺ｮ謾ｹ蟒イ縺ｫ蠕薙▲縺ｦ蜃ｦ逅?ｒ陦後≧縺九ｒ謖?ｮ壹＠縺ｾ縺?
063     *       quotCheck          縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
064     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
065     *   &gt;   ... Body ...
066     *   &lt;/og:tableUpdate&gt;
067     *
068     * 笳丈ｽｿ逕ｨ萓?
069     *    繝ｻQUERY繧剃ｻ悶?JSP縺九ｉ貂｡縺吝?蜷?
070     *    縲芯opy.jsp縲?
071     *        &lt;og:hidden name=&quot;SQL&quot; &gt;
072     *          INSERT INTO GE41
073     *               (CLM,NAME_JA,LABEL_NAME,KBSAKU,SYSTEM_ID,LANG,
074     *               FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD)
075     *          VALUES
076     *               ([CLM],[NAME_JA],[LABEL_NAME],[KBSAKU],[SYSTEM_ID],[LANG],
077     *               &#39;1&#39;,&#39;{&#064;USER.YMDH}&#39;,&#39;{&#064;USER.YMDH}&#39;,&#39;{&#064;USER.ID}&#39;,&#39;{&#064;USER.ID}&#39;,&#39;{&#064;GUI.KEY}&#39;)
078     *        &lt;/og:value&gt;
079     *
080     *    縲親ntry.jsp縲?
081     *        &lt;og:tableUpdate
082     *            command   = &quot;{&#064;command}&quot;
083     *            queryType = &quot;JDBCTableUpdate&quot;
084     *        {&#064;SQL}
085     *        &lt;/og:tableUpdate&gt;
086     *
087     *    繝ｻtableUpdateParam繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷?
088     *    縲親ntry.jsp縲?
089     *        &lt;og:tableUpdate
090     *            command   = &quot;{&#064;command}&quot;
091     *            queryType = &quot;JDBCTableUpdate&quot;
092     *            sqlType   = &quot;{&#064;sqlType}&quot;        // tableUpdateParam 縺ｮ sqlType 縺ｨ荳??
093     *        &gt;
094     *            &lt;og:tableUpdateParam
095     *                sqlType     = &quot;{&#064;sqlType}"       // INSERT,COPY,UPDATE,MODIFY,DELETE
096     *                table       = &quot;{&#064;TABLE_NAME}"    // 蜃ｦ逅?ｯｾ雎｡縺ｮ繝??繝悶Ν蜷?
097     *                names       = &quot;{&#064;names}"         // 蜃ｦ逅?ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?錐
098     *                omitNames   = &quot;{&#064;omitNames}"     // 蜃ｦ逅?ｯｾ雎｡螟悶?繧ｫ繝ｩ繝?錐
099     *                where       = &quot;{&#064;where}"         // 蜃ｦ逅?ｯｾ雎｡繧堤音螳壹☆繧九く繝ｼ
100     *                constKeys   = &quot;{&#064;constKeys}"     // 蜃ｦ逅?き繝ｩ繝?錐縺ｮ荳ｭ縺ｮ蝗ｺ螳壽ュ蝣ｱ繧ｫ繝ｩ繝?錐
101     *                constVals   = &quot;{&#064;constVals}"     // 蜃ｦ逅?き繝ｩ繝?錐縺ｮ荳ｭ縺ｮ蝗ｺ螳壽ュ蝣ｱ險ｭ螳壼?
102     *            /&gt;
103     *        &lt;/og:tableUpdate&gt;
104     *
105     *    繝ｻ蜃ｦ逅??蜿ｯ蜷ｦ繧呈欠螳壹☆繧句?蜷?
106     *    縲親ntry.jsp縲?
107     *        &lt;og:tableUpdate
108     *            command   = &quot;{&#064;command}&quot;
109     *            queryType = &quot;JDBCTableUpdate&quot;
110     *            conditionKey  ="窶ｦ"      : 譚｡莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､繧呈欠螳?蛻晄悄蛟､縺ｯ columnId )
111     *            conditionList ="窶ｦ"      : 譚｡莉ｶ蛻､螳壹☆繧句?縺ｮ繝ｪ繧ｹ繝医ｒ縲?|"縺ｧ蛹ｺ蛻?▲縺ｦ逋ｻ骭ｲ(蛻晄悄蛟､縺ｯ縲∫┌譚｡莉ｶ)
112     *        {&#064;SQL}
113     *        &lt;/og:tableUpdate&gt;
114     *
115     * @og.rev 3.8.8.0 (2007/12/22) 譁ｰ隕丈ｽ懈?
116     * @og.group ?､?｢逋ｻ骭ｲ
117     *
118     * @version  4.0
119     * @author   Kazuhiko Hasegawa
120     * @since    JDK5.0,
121     */
122    public class TableUpdateTag extends QueryTag {
123            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
124            private static final String VERSION = "5.1.7.0 (2010/06/01)" ;
125    
126            private static final long serialVersionUID = 517020100601L ;
127    
128            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 逋ｻ骭ｲ{@value} */
129            public static final String CMD_ENTRY  = "ENTRY" ;
130            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
131            private static final String COMMAND_LIST = CMD_ENTRY;
132    
133            // 蜃ｦ逅?ｒ陦後≧縲√Μ繧ｽ繝ｼ繧ｹ縺ｮ遞ｮ鬘槭ｒ謖?ｮ壹＠縺ｾ縺吶?(GEA03,GEA04,GEA08 縺ｮ縺ｩ繧後°)
134            private String  sqlType                 = null;         // INSERT,COPY,UPDATE,MODIFY,DELETE
135            private String  resourceType    = null;
136            private int             resTypeColNo    = -1;
137            private String  conditionKey    = null;         // 譚｡莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､繧呈欠螳?蛻晄悄蛟､縺ｯ columnId )
138            private String  conditionList   = null;         // 譚｡莉ｶ蛻､螳壹☆繧句?縺ｮ繝ｪ繧ｹ繝医ｒ縲?|"縺ｧ蛹ｺ蛻?▲縺ｦ逋ｻ骭ｲ(蛻晄悄蛟､縺ｯ縲∫┌譚｡莉ｶ)
139            private boolean selectedAll             = false;
140            private boolean commitTableModel= true;         // 4.0.2.0 (2007/12/25)
141            private boolean followCdkh              = false;        // 4.3.2.0 (2008/09/09).
142            private boolean quotCheck               = false;        // 5.1.7.0 (2010/06/01) quotCheck繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲や?菴?＠縲∝?譛溷?縺ｯfalse蝗ｺ螳壹?繧ｿ繧､繝溘Φ繧ｰ繧定ｦ九※菫ｮ豁｣隕?
143    
144            /**
145             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
146             *
147             * @og.rev 4.0.0.0 (2007/11/14) 0莉ｶ縺ｮ蝣ｴ蜷医〒繧ＴtartQueryTransaction繧帝?縺吶ｈ縺?↓螟画峩
148             * @og.rev 5.1.7.0 (2010/06/01) quotCheck繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲や?菴?＠縲∝?譛溷?縺ｯfalse蝗ｺ螳壹?
149             *
150             * @return      蠕檎ｶ壼?逅??謖?､ｺ( EVAL_BODY_BUFFERED )
151             */
152            @Override
153            public int doStartTag() {
154                    dyStart = System.currentTimeMillis();
155                    table = (DBTableModel)getObject( tableId );
156                    startQueryTransaction( tableId );               // 4.0.0.0 (2007/11/14) 0莉ｶ縺ｮ蝣ｴ蜷医〒繧ＥoEnd縺ｧPAGE_SKIP縺励↑縺?ｈ縺?↓菴咲ｽｮ螟画峩縲?
157                    if( table == null || table.getRowCount() == 0 ||
158                            ! check( command, COMMAND_LIST ) ) { return(SKIP_BODY); }
159    //              startQueryTransaction( tableId );               // 3.6.0.8 (2004/11/19)
160    //              quotCheck = false;              // 縺薙?繧ｿ繧ｰ縺ｧ縺ｯ縲√け繧ｪ繝ｼ繝医メ繧ｧ繝?け縺ｯ陦後＞縺ｾ縺帙ｓ縲?
161                    super.quotCheck = quotCheck;
162    
163                    return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
164            }
165    
166            /**
167             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
168             *
169             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
170             *
171             * @return      蠕檎ｶ壼?逅??謖?､ｺ
172             */
173            @Override
174            public int doEndTag() {
175                    debugPrint();
176    
177    //              String label = HybsSystem.BR;                           // 讀懃ｴ｢縺励↑縺九▲縺溷?蜷医?
178                    String label  = "";                             // 4.0.0 (2005/11/30) 讀懃ｴ｢縺励↑縺九▲縺溷?蜷医?
179                    if( check( command, COMMAND_LIST ) ) {
180                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
181                            if( executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
182                                    buf.append( executeCount );
183    //                              buf.append( getResource().getMessage( displayMsg ) );
184                                    buf.append( getResource().getLabel( displayMsg ) );
185                                    buf.append( HybsSystem.BR );
186                            }
187    
188                            String err = TaglibUtil.makeHTMLErrorTable( errMessage,getResource() );
189                            if( err != null && err.length() > 0 ) {
190    //                              if( errCode >= ErrorMessage.NG ) {           // 逡ｰ蟶ｸ縺ｮ蝣ｴ蜷?
191    //                                      label = err ;
192    //                              }
193                                    buf.append( err );
194                                    setSessionAttribute( errMsgId,errMessage );
195                            }
196                            else {
197                                    removeSessionAttribute( errMsgId );
198                            }
199                            label = buf.toString();
200    
201                            if( table != null && ! commitTableObject( tableId, table )  ) {
202                                    // 3.6.0.8 (2004/11/19) 繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
203                                    jspPrint( "TableUpdateTag Query蜃ｦ逅?′蜑ｲ繧願ｾｼ縺ｾ繧後∪縺励◆縲?BTableModel 縺ｯ逋ｻ骭ｲ縺励∪縺帙ｓ縲? );
204                                    return (SKIP_PAGE);
205                            }
206                    }
207    
208                    jspPrint( label );
209    
210                    // 隴ｦ蜻頑凾縺ｫ蛛懈ｭ｢縺励※縺?∪縺励◆縺後?邯咏ｶ壼?逅?＆縺帙∪縺吶?
211    //              int rtnCode = EVAL_PAGE;
212    //              if( errCode >= ErrorMessage.NG )  {  // 逡ｰ蟶ｸ
213    //                      rtnCode = SKIP_PAGE;
214    //              }
215    //              else {
216    //                      rtnCode = EVAL_PAGE;
217    //              }
218    
219                    long dyTime = System.currentTimeMillis()-dyStart;
220                    jspPrint( "<div id=\"queryTime\" value=\"" + (dyTime) + "\"></div>" );      // 3.5.6.3 (2004/07/12)
221    
222                    // 繧ｻ繧ｭ繝･繝ｪ繝?ぅ繝√ぉ繝?け(繝??繧ｿ繧｢繧ｯ繧ｻ繧ｹ莉ｶ謨ｰ逋ｻ骭ｲ)
223                    GUIInfo guiInfo = (GUIInfo)getSessionAttribute( HybsSystem.GUIINFO_KEY );
224                    if( guiInfo != null ) { guiInfo.addWriteCount( executeCount,dyTime,sql ); }
225    
226                    int rtnCode = ( errCode >= ErrorMessage.NG ) ? SKIP_PAGE : EVAL_PAGE ;
227                    return( rtnCode );
228            }
229    
230            /**
231             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
232             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
233             *
234             * @og.rev 4.0.2.0 (2007/12/25) commitTableModel霑ｽ蜉?
235             * @og.rev 4.1.2.0 (2008/03/12) sqlType霑ｽ蜉?
236             * @og.rev 5.1.7.0 (2010/06/01) quotCheck繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲や?菴?＠縲∝?譛溷?縺ｯfalse蝗ｺ螳壹?
237             *
238             */
239            @Override
240            protected void release2() {
241                    super.release2();
242                    sqlType                 = null;         // INSERT,COPY,UPDATE,MODIFY,DELETE
243                    resourceType    = null;
244                    resTypeColNo    = -1;
245                    conditionKey    = null;         // 譚｡莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､繧呈欠螳?蛻晄悄蛟､縺ｯ columnId )
246                    conditionList   = null;         // 譚｡莉ｶ蛻､螳壹☆繧句?縺ｮ繝ｪ繧ｹ繝医ｒ縲?|"縺ｧ蛹ｺ蛻?▲縺ｦ逋ｻ骭ｲ(蛻晄悄蛟､縺ｯ縲∫┌譚｡莉ｶ)
247                    selectedAll             = false;
248                    commitTableModel= true;         // 4.0.2.0 (2007/12/25)
249                    followCdkh              = false;        // 4.3.2.0 (2008/09/09)
250                    quotCheck               = false;        // 5.1.7.0 (2010/06/01)
251            }
252    
253            /**
254             * Query 繧貞ｮ溯｡後＠縺ｾ縺吶?
255             *
256             * @og.rev 4.0.2.0 (2007/12/25) commitTableModel霑ｽ蜉?
257             *
258             * @param   query 繧ｪ繝悶ず繧ｧ繧ｯ繝?
259             */
260            @Override
261            protected void execute( final Query query ) {
262    
263                    try {
264                            int[] rowNo = getParameterRows();               // 4.0.0 (2005/01/31)
265                            if( rowNo.length > 0 ) {
266                                    query.execute( rowNo,table );
267    
268                                    errCode = query.getErrorCode();
269                                    errMessage = query.getErrorMessage();
270    
271                                    // 繝ｪ繧ｽ繝ｼ繧ｹ繧ｯ繝ｪ繧｢蜃ｦ逅?
272                                    if( resourceType != null ) {
273    //                                      if( "GEA09".equals( resourceType ) ) {
274    //                                              resTypeColNo = table.getColumnNo( "MSGCD" );    // 繧ｭ繝ｼ縺ｯ縲｀SGCD
275    //                                      }
276    //                                      else {
277                                            resTypeColNo = table.getColumnNo( "CLM" );              // 繧ｭ繝ｼ縺ｯ縲，LM
278    //                                      }
279                                    }
280    
281                                    // 騾??縺ｫDELETE縺励↑縺?→縲∬｡檎分蜿ｷ縺後★繧後※縺励∪縺??
282                                    int row;
283                                    for( int j=rowNo.length-1; j>=0; j-- ) {
284                                            row = rowNo[j];
285                                            if( resTypeColNo >= 0 ) {
286                                                    clearResourceData( table.getValue( row,resTypeColNo ) );                // 繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ繧ｯ繝ｪ繧｢
287                                            }
288    
289                                            if( commitTableModel ) { // 4.0.2.0 (2007/12/25)
290                                                    if( DBTableModel.DELETE_TYPE.equals( table.getModifyType( row ) ) ) {
291                                                            table.removeValue( row );
292                                                    }
293                                                    else {
294                                                            table.resetModify( row );
295                                                    }
296                                            }
297                                    }
298    //                              if( query.getUpdateFlag() ) { query.commit(); }
299                                    if( query.isUpdate() ) { query.commit(); }
300                            }
301                    }
302                    finally {
303                            if( query != null ) { query.close(); }
304                    }
305            }
306    
307            /**
308             * 陦ｨ遉ｺ繝??繧ｿ縺ｮ HybsSystem.ROW_SEL_KEY 繧貞?縺ｫ縲?∈縺ｰ繧後◆ 陦檎分蜿ｷ縺ｮ
309             * 驟榊?繧定ｿ斐＠縺ｾ縺吶?
310             * 縺薙％縺ｧ縺ｯ縲…onditionKey 縺ｫ蛟､縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲√◎縺ｮ繧ｫ繝ｩ繝??蛟､縺?
311             * conditionList 縺ｫ繝槭ャ繝√☆繧句?蜷医?縺ｿ蟇ｾ雎｡驕ｸ謚櫁｡後→縺励※霑斐＠縺ｾ縺吶?
312             * 蛟､縺後そ繝?ヨ縺輔ｌ縺ｦ縺?↑縺??蜷医?縲??蟶ｸ縺ｮCommonTagSupport#getParameterRows()
313             * 縺悟他縺ｰ繧後∪縺吶?
314             * 縺ｪ縺ｫ繧る∈縺ｰ繧後※縺?↑縺??蜷医?縲√し繧､繧ｺ?舌?驟榊?繧定ｿ斐＠縺ｾ縺吶?
315             *
316             * @og.rev 4.3.2.0 (2008/09/09) followCdkh螻樊?蟇ｾ蠢?
317             *
318             * @return       (驕ｸ縺ｰ繧後※縺?↑縺??蜷医?縲√し繧､繧ｺ?舌?驟榊?繧定ｿ斐☆)
319             */
320            @Override
321            protected int[] getParameterRows() {
322                    int[] rowNo ;
323                    if( selectedAll ) {
324                            int rowCnt = table.getRowCount();               // 3.5.5.7 (2004/05/10)
325                            rowNo = new int[ rowCnt ];
326                            for( int i=0; i<rowCnt; i++ ) {
327                                    rowNo[i] = i;
328                            }
329                    } else {
330                            rowNo = super.getParameterRows();               // 4.0.0 (2005/01/31)
331                    }
332    
333                    if( conditionKey != null ) {
334                            int col = table.getColumnNo( conditionKey );
335                            List<Integer> list = new ArrayList<Integer>();
336                            for( int i=0; i<rowNo.length; i++ ) {
337                                    String val = "|" + table.getValue( rowNo[i],col ) + "|";
338                                    if( conditionList.indexOf( val ) >= 0 ) {
339                                            list.add( Integer.valueOf( rowNo[i] ) );
340                                    }
341                            }
342    
343                            int size = list.size();
344                            rowNo = new int[size];
345                            for( int i=0; i<size; i++ ) {
346                                    rowNo[i] = (list.get(i)).intValue();
347                            }
348                    }
349    
350                    // 4.3.2.0 (2008/09/09)
351                    if( sqlType != null && sqlType.length() > 0 && followCdkh ) {
352                            List<Integer> flist = new ArrayList<Integer>();
353                            for( int i=0; i<rowNo.length; i++ ) {
354                                    String cdkh = table.getModifyType( rowNo[i] );
355                                    if( ( ( "INSERT".equals( sqlType ) || "COPY".equals( sqlType ) )
356                                                            && DBTableModel.INSERT_TYPE.equals( cdkh ) )
357                                            ||
358                                            ( ( "UPDATE".equals( sqlType ) || "CHANGE".equals( sqlType ) )
359                                                            && DBTableModel.UPDATE_TYPE.equals( cdkh ) )
360                                            ||
361                                            ( ( "DELETE".equals( sqlType ) )
362                                                            && DBTableModel.DELETE_TYPE.equals( cdkh ) ) ) {
363                                            flist.add(  Integer.valueOf( rowNo[i] ) );
364                                    }
365                            }
366    
367                            int size = flist.size();
368                            rowNo = new int[size];
369                            for( int i=0; i<size; i++ ) {
370                                    rowNo[i] = (flist.get(i)).intValue();
371                            }
372                    }
373    
374                    return rowNo;
375            }
376    
377            /**
378             * 縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID繧呈欠螳壹＠縺ｾ縺?{@og.doc03Link queryType 蛻晄悄蛟､:JDBCTableUpdate})縲?
379             *
380             * @og.tag
381             * 蠑墓焚謖?ｮ壹?INSERT/UPDATE譁?ｒ螳溯｡後☆繧句?蜷医?縲〈ueryType 螻樊?繧剃ｽｿ逕ｨ縺励∪縺吶?
382             * 縺薙?繧ｿ繧ｰ縺ｧ縺ｯ縲‘xecute( int[] ,DBTableModel )繧貞ｮ溯｡後＠縺ｾ縺吶?
383             * 莉｣陦ｨ逧?↑繧ｯ繝ｩ繧ｹ縺ｨ縺励※縲?JDBCTableUpdate" 縺梧ｨ呎ｺ悶〒逕ｨ諢上＆繧後※縺?∪縺吶?
384             *
385             * 繧ｿ繧ｰ縺ｫ繧医ｊ菴ｿ逕ｨ縺ｧ縺阪ｋ?丞?譚･縺ｪ縺?′縺ゅｊ縺ｾ縺吶′縲√％繧後?縲｛rg.opengion.hayabusa.db
386             * 莉･荳九? Query_**** 繧ｯ繝ｩ繧ｹ縺ｮ **** 繧剃ｸ弱∴縺ｾ縺吶?
387             * 縺薙ｌ繧峨?縲＿uery 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧堤ｶ呎価縺励◆繧ｵ繝悶け繝ｩ繧ｹ縺ｧ縺吶?
388             * {@og.doc03Link queryType Query_**** 繧ｯ繝ｩ繧ｹ}
389             *
390             * @param       id Query 繧堤匱陦後☆繧狗ぜ縺ｮ螳溘け繝ｩ繧ｹ ID
391             * @see         org.opengion.hayabusa.db.Query  Query縺ｮ繧ｵ繝悶け繝ｩ繧ｹ
392             * @see         org.opengion.hayabusa.db.Query#execute( int[] ,DBTableModel )
393             */
394            @Override
395            public void setQueryType( final String id ) {
396                    super.setQueryType( nval( id,"JDBCTableUpdate" ) );
397            }
398    
399            /**
400             * resourceType 縺瑚ｨｭ螳壹＆繧後◆縺ｨ縺阪?縺ｿ菴ｿ逕ｨ縺輔ｌ繧九?繧ｭ繝｣繝?す繝･縺ｮ蛻晄悄蛹悶Γ繧ｽ繝?ラ縺ｧ縺吶?
401             *
402             * @param       key     蛻晄悄蛹悶ｒ陦後≧繧ｭ繝ｼ
403             */
404            private void clearResourceData( final String key ) {
405                    getResource().clear( key );
406            }
407    
408            /**
409             * 縲千音谿翫?繧ｯ繝ｪ繧｢縺吶ｋ繝ｪ繧ｽ繝ｼ繧ｹ縺ｮ遞ｮ鬘杣GEA03/GEA04/GEA08]繧呈欠螳壹＠縺ｾ縺吶?
410             *
411             * @og.tag
412             * 豕ｨ諢擾ｼ壹％縺ｮ螻樊?縺ｯ縲√Μ繧ｽ繝ｼ繧ｹ髢｢騾｣DB縺ｮ繝｡繝ｳ繝?リ繝ｳ繧ｹ譎ゅ↓縺ｮ縺ｿ縲∝?驛ｨ繝ｪ繧ｽ繝ｼ繧ｹ繧ｭ繝｣繝?す繝･繧?
413             * 繧ｯ繝ｪ繧｢縺吶ｋ逶ｮ逧?〒菴ｿ逕ｨ縺励∪縺吶?荳?握縺ｮ螻樊?縺ｨ縺励※縺ｯ縲∽ｽｿ逕ｨ縺吶ｋ縺薙→縺ｯ縺ｪ縺?◆繧√?
414             * 縺疲ｳｨ諢上￥縺?＆縺??
415             * 繝ｪ繧ｽ繝ｼ繧ｹ髢｢騾｣縺ｮ繝??繝悶Ν繧呈峩譁ｰ縺励◆蝣ｴ蜷医?繝ｪ繧ｽ繝ｼ繧ｹ繧ｭ繝｣繝?す繝･繧偵け繝ｪ繧｢縺励※
416             * 鄂ｮ縺九↑縺?→縲√ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｮ蛟､縺悟渚譏?＆繧後∪縺帙ｓ縲?
417             * 譏斐?縲√Μ繧ｽ繝ｼ繧ｹ縺ｮ譖ｴ譁ｰ縺斐→縺ｫ縲∝?莉ｶ繧ｯ繝ｪ繧｢縺励※縺?∪縺励◆縺後?驛ｨ蛻?け繝ｪ繧｢縺?
418             * 縺ｧ縺阪ｋ繧医≧縺ｫ縺ｪ縺｣縺溘◆繧√?驛ｨ蛻?け繝ｪ繧｢繧定｡後＞縺ｾ縺吶?
419             * 縺薙〒縺ｯ縲?GEA03,GEA04,GEA08) 縺ｮ縺ｩ繧後°繧呈欠螳壹＠縺ｦ縺上□縺輔＞縲?
420             *
421             * @param       type    繧ｯ繝ｪ繧｢縺吶ｋ繝ｪ繧ｽ繝ｼ繧ｹ繧ｿ繧､繝?[GEA03/GEA04/GEA08]
422             */
423            public void setResourceType( final String type ) {
424                    resourceType = nval( getRequestParameter(type),resourceType );
425    
426                    if( resourceType != null &&
427    //                      "|GEA03|GEA04|GEA08|GEA09|".indexOf( "|" + resourceType + "|" ) < 0 ) {
428    //                              String errMsg = "resourceType縺ｯ GEA03,GEA04,GEA08,GEA09 縺ｮ縺ｩ繧後°縺ｧ縺吶?"
429    //                                                      + "resourceType=" + type ;
430                            "|GEA03|GEA04|GEA08|".indexOf( "|" + resourceType + "|" ) < 0 ) {
431                                    String errMsg = "resourceType縺ｯ GEA03,GEA04,GEA08 縺ｮ縺ｩ繧後°縺ｧ縺吶?"
432                                                            + "resourceType=" + type ;
433                                    throw new HybsSystemException( errMsg );
434                    }
435            }
436    
437            /**
438             * 縲慎AG縲第擅莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)縲?
439             *
440             * @og.tag
441             * 謖?ｮ壹?繧ｫ繝ｩ繝?ｼｩ?､縺ｮ蛟､縺ｨ縲…onditionList 縺ｮ蛟､繧呈ｯ碑ｼ?＠縺ｦ縲?
442             * 蟄伜惠縺吶ｋ蝣ｴ蜷医?縲＿uery 蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
443             * 萓九∴縺ｰ縲…onditionKey="CDKH" 縺ｨ縺励※縲…onditionList="A" 縺ｨ縺吶ｌ縺ｰ縲?
444             * 謾ｹ蟒?さ繝ｼ繝峨′"A"縺ｮ繝??繧ｿ縺ｧ縲√°縺､驕ｸ謚槭＆繧後◆繝??繧ｿ縺ｮ縺ｿ繧貞?逅?＠縺ｾ縺吶?
445             * 險ｭ螳壹＠縺ｪ縺??蜷医?縲??蟶ｸ縺ｮ蜃ｦ逅?→蜷梧ｧ倥↓縲?∈謚櫁｡後?縺ｿ蜃ｦ逅?＆繧後∪縺吶?
446             *
447             * @param       key 譚｡莉ｶ蛻､螳壹☆繧九き繝ｩ繝?ｼｩ?､
448             * @see         #setConditionList( String )
449             */
450            public void setConditionKey( final String key ) {
451                    conditionKey = nval( getRequestParameter( key ),null ) ;
452            }
453    
454            /**
455             * 縲慎AG縲第擅莉ｶ蛻､螳壹☆繧句?縺ｮ繝ｪ繧ｹ繝医ｒ縲?|"縺ｧ蛹ｺ蛻?▲縺ｦ逋ｻ骭ｲ縺励∪縺?蛻晄悄蛟､:辟｡譚｡莉ｶ)縲?
456             *
457             * @og.tag
458             * conditionKey 縺ｨ繝壹い縺ｧ謖?ｮ壹＠縺ｾ縺吶?縺薙％縺ｫ縺ｯ縲√き繝ｩ繝??險ｭ螳壼?縺ｮ繝ｪ繧ｹ繝医ｒ
459             * 謖?ｮ壹☆繧九％縺ｨ縺ｧ縲∬､?焚譚｡莉ｶ(?ｯ?ｲ邨仙粋)縺ｧ縺ｮ豈碑ｼ?ｒ陦後＞縲√Μ繧ｹ繝医↓繧ｫ繝ｩ繝??縺?
460             * 蟄伜惠縺吶ｋ蝣ｴ蜷医?縺ｿ縲＿uery 蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
461             * 蛟､縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲√◎縺ｮ蛟､縺ｨ繝槭ャ繝√☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?縺ｪ縺ｫ繧ゅそ繝?ヨ
462             * 縺輔ｌ縺ｪ縺??蜷医?縺ｾ縺溘?縲］ull 縺ｮ蝣ｴ蜷医?縲］ull 繝??繧ｿ縺ｨ繝槭ャ繝√☆繧句?蜷医?縺ｿ蜃ｦ逅?
463             * 縺輔ｌ縺ｾ縺吶?縺ｧ縲√＃豕ｨ諢上￥縺?＆縺??
464             *
465             * @param       list    蛟､縺ｮ繝ｪ繧ｹ繝?"|"蛹ｺ蛻?
466             * @see         #setConditionKey( String )
467             */
468            public void setConditionList( final String list ) {
469                    conditionList = "|" + nval( getRequestParameter( list ),"" ) + "|" ;
470            }
471    
472            /**
473             * 縲慎AG縲代ョ繝ｼ繧ｿ繧貞?莉ｶ驕ｸ謚樊ｸ医∩縺ｨ縺励※蜃ｦ逅?☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
474             *
475             * @og.tag
476             * 蜈ｨ縺ｦ縺ｮ繝??繧ｿ繧帝∈謚樊ｸ医∩繝??繧ｿ縺ｨ縺励※謇ｱ縺｣縺ｦ蜃ｦ逅?＠縺ｾ縺吶?
477             * 蜈ｨ莉ｶ蜃ｦ逅?☆繧句?蜷医↓縲?true/false)繧呈欠螳壹＠縺ｾ縺吶?
478             * 蛻晄悄蛟､縺ｯ false 縺ｧ縺吶?
479             *
480             * @param  all 繝??繧ｿ繧貞?莉ｶ驕ｸ謚樊ｸ医∩ [true:蜈ｨ莉ｶ驕ｸ謚樊ｸ医∩/false:騾壼ｸｸ]
481             */
482            public void setSelectedAll( final String all ) {
483                    selectedAll = nval( getRequestParameter( all ),selectedAll );
484            }
485    
486            /**
487             * 縲千音谿翫?SQL螳溯｡悟ｾ後↓邨先棡繧奪BTableModel縺ｫ蜿肴丐縺輔○繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
488             *
489             * @og.tag
490             * 豕ｨ諢擾ｼ壹％縺ｮ螻樊?縺ｯ縲√Μ繧ｽ繝ｼ繧ｹ髢｢騾｣DB縺ｮ繝｡繝ｳ繝?リ繝ｳ繧ｹ譎ゅ↓縲∬､?焚DB縺ｸ縺ｮ逋ｻ骭ｲ繧定｡後≧縺溘ａ縺ｮ縲?
491             * 證ｫ螳壼ｯｾ蠢懊→縺励※螳夂ｾｩ縺励※縺?∪縺吶?
492             * false縺ｫ縺励◆蝣ｴ蜷医?縲∝ｮ溘ョ繝ｼ繧ｿ縺ｨDBTableModel縺ｮ謨ｴ蜷域?縺悟叙繧後↑縺上↑繧九◆繧√?菴ｿ逕ｨ縺ｫ縺ｯ蜊∝?豕ｨ縺励※荳九＆縺??
493             * 蛻晄悄蛟､縺ｯ true 縺ｧ縺吶?
494             *
495             * @og.rev 4.0.2.0 (2007/12/25) 譁ｰ隕丈ｽ懈?
496             *
497             * @param  commitTblMdl 繝??繝悶Ν繝｢繝?Ν縺ｸ蜿肴丐縺吶ｋ [true:蜿肴丐縺吶ｋ/false:蜿肴丐縺励↑縺Ь
498             */
499            public void setCommitTableModel( final String commitTblMdl ) {
500                    commitTableModel = nval( getRequestParameter( commitTblMdl ),commitTableModel );
501            }
502    
503            /**
504             * 蠑墓焚縺ｮ蜷咲ｧｰ驟榊?
505             *
506             * @return      蜷咲ｧｰ驟榊?
507             */
508            protected String[] getNames() {
509                    return table.getNames() ;
510            }
511    
512            /**
513             * 縲慎AG縲腺ODY驛ｨ縺ｫ譖ｸ縺九ｌ縺ｦ縺?ｋ Param 縺ｮ SQL繧ｿ繧､繝励ｒ謖?ｮ壹＠縺ｾ縺吶?
514             *
515             * @og.tag
516             * TableUpdateParamTag 縺ｯ縲∽ｸ贋ｽ阪? TableUpdateTag 縺ｮ sqlType 螻樊? 縺ｨ蜷後§
517             * sqlType 螻樊?縺ｮ蝣ｴ蜷医?縺ｿ縲ヾQL譁?ｒ蜷域?繝ｻ蜃ｺ蜉帙＠縺ｾ縺吶?
518             * 縺､縺ｾ繧翫?TableUpdateTag蛛ｴ縺ｮsqlType 螻樊?繧偵ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｫ縲ゝableUpdateParamTag
519             * 縺ｮ sqlType 螻樊?繧貞崋螳壼?縺ｫ縺吶ｋ縺薙→縺ｧ縲√←縺ｮ繝代Λ繝｡繝ｼ繧ｿ繧剃ｽｿ逕ｨ縺吶ｋ縺九ｒ
520             * 驕ｸ謚槭〒縺阪ｋ讖溯?繧貞ｮ溽樟縺吶ｋ莠九′蜿ｯ閭ｽ縺ｧ縺吶?
521             *
522             * @og.rev 4.1.2.0 (2008/03/12) 譁ｰ隕剰ｿｽ蜉?
523             *
524             * @param       type BODY驛ｨ縺ｫ譖ｸ縺九ｌ縺ｦ縺?ｋ SQL 繧ｿ繧､繝?
525             */
526            public void setSqlType( final String type ) {
527                    sqlType = nval( getRequestParameter( type ),sqlType );
528            }
529    
530            /**
531             * 縲慎AG縲船BTableModel縺ｮ謾ｹ蟒イ縺ｫ蠕薙▲縺ｦ蜃ｦ逅?ｒ陦後≧縺九ｒ謖?ｮ壹＠縺ｾ縺吶?
532             *
533             * @og.tag
534             * 縺薙?螻樊?縺ｯ縲《qlType縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縺ｿ譛牙柑縺ｧ縺吶?
535             * sqlType縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縺昴?sqlType縺ｫ蟇ｾ蠢懊＠縺溘?謾ｹ蟒イ縺瑚ｨｭ螳壹＆繧後※縺?ｋ
536             * 陦後?縺ｿ繧貞?逅?＠縺ｾ縺吶?
537             * 蟇ｾ蠢憺未菫ゅ?縲∽ｻ･荳九?騾壹ｊ縺ｧ縺吶?
538             *  sqlType = "INSERT" or "COPY" 竍?謾ｹ蟒イ='A'縺ｮ縺ｿ蜃ｦ逅?
539             *  sqlType = "UPDATE" or "CHANGE" 竍?謾ｹ蟒イ='C'縺ｮ縺ｿ蜃ｦ逅?
540             *  sqlType = "DELETE" 竍?謾ｹ蟒イ='D'縺ｮ縺ｿ蜃ｦ逅?
541             *
542             * @og.rev 4.3.2.0 (2008/09/09) 譁ｰ隕剰ｿｽ蜉?
543             *
544             * @param       flg DBTableModel縺ｮ謾ｹ蟒イ縺ｫ蠕薙▲縺ｦ蜃ｦ逅?ｒ陦後≧縺?
545             */
546            public void setFollowCdkh( final String flg ) {
547                    followCdkh = nval( getRequestParameter( flg ),followCdkh );
548            }
549    
550            /**
551             * 縲慎AG縲代Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 蟄伜惠繝√ぉ繝?け繧貞ｮ滓命縺吶ｋ縺九←縺?°[true/false]繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
552             *
553             * @og.tag
554             * ?ｳ?ｱ?ｬ繧､繝ｳ繧ｸ繧ｧ繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ遲悶?荳?▽縺ｨ縺励※縲∵圻螳夂噪縺ｧ縺ｯ縺ゅｊ縺ｾ縺吶′縲ヾQL縺ｮ繝代Λ繝｡繝ｼ繧ｿ縺ｫ
555             * 貂｡縺呎枚蟄怜?縺ｫ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ(') 繧定ｨｱ縺輔↑縺?ｨｭ螳壹↓縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｯ髦ｲ豁｢縺ｧ縺阪∪縺吶?
556             * 謨ｰ蟄励ち繧､繝励?蠑墓焚縺ｫ縺ｯ縲?or 5=5 縺ｪ縺ｩ縺ｮ繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繧剃ｽｿ逕ｨ縺励↑縺?さ繝ｼ繝峨ｒ蝓九ａ縺ｦ繧ゅ?
557             * 謨ｰ蟄励メ繧ｧ繝?け縺ｧ讀懷?蜿ｯ閭ｽ縺ｧ縺吶?譁?ｭ励ち繧､繝励?蝣ｴ蜷医?縲∝ｿ?★ (')繧偵?縺壹＠縺ｦ縲?
558             * ' or 'A' like 'A 縺ｮ繧医≧縺ｪ蠖｢蠑上↓縺ｪ繧狗ぜ縲?')繝√ぉ繝?け縺?￠縺ｧ繧よ怏蜉ｹ縺ｧ縺吶?
559             * (') 縺悟性縺ｾ繧後※縺?◆繧ｨ繝ｩ繝ｼ縺ｫ縺吶ｋ(true)?上°繝弱?繝√ぉ繝?け縺?false)繧呈欠螳壹＠縺ｾ縺吶?
560             * 窶ｻ(莉悶?繧ｿ繧ｰ縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ縺ｮUSE_SQL_INJECTION_CHECK[={@og.value org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK}])
561             * 縺ｧ縺吶′縲゛SP縺ｮ莠呈鋤諤ｧ繧定?諷ｮ縺励?蛻晄悄蛟､繧貞崋螳壹〒false縺ｫ縺励※縺?∪縺?
562             *
563             * @og.rev 5.1.7.0 (2010/06/01) 譁ｰ隕剰ｿｽ蜉?
564             *
565             * @param   flag 繧ｯ繧ｩ繝ｼ繝?ぅ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
566             */
567            @Override
568            public void setQuotCheck( final String flag ) {
569                    quotCheck = nval( getRequestParameter( flag ),quotCheck );
570            }
571    
572            /**
573             * SQL繧ｿ繧､繝励ｒ霑斐＠縺ｾ縺吶?
574             *
575             * @og.rev 4.1.2.0 (2008/03/12) 譁ｰ隕剰ｿｽ蜉?
576             *
577             * @return      SQL繧ｿ繧､繝?
578             */
579            protected String getSqlType() {
580                    return sqlType ;
581            }
582    
583            /**
584             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
585             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
586             *
587             * @og.rev 4.0.2.0 (2007/12/25) resourceColumn縲…ommitTableModel霑ｽ蜉?
588             *
589             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
590             */
591            @Override
592            public String toString() {
593                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
594                                    .println( "VERSION"                     ,VERSION                )
595                                    .println( "resourceType"        ,resourceType   )
596                                    .println( "resTypeColNo"        ,resTypeColNo   )
597                                    .println( "conditionKey"        ,conditionKey   )
598                                    .println( "conditionList"       ,conditionList  )
599                                    .println( "followCdkh"          ,followCdkh             )
600                                    .println( "CMD_ENTRY"           ,CMD_ENTRY              )
601                                    .println( "commitTabelModel",commitTableModel )         // 4.0.2.0 (2007/12/25)
602                                    .println( "sql"                         ,sql                    )               // 4.1.2.0 (2008/03/12)
603                                    .println( "Other..."    ,getAttributes().getAttribute() )
604                                    .fixForm().toString()
605                            + HybsSystem.CR
606                            + super.toString() ;
607            }
608    }