001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.hayabusa.taglib;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    import org.opengion.hayabusa.resource.GUIInfo;
021    import org.opengion.fukurou.db.Transaction;
022    import org.opengion.fukurou.db.TransactionReal;
023    import org.opengion.fukurou.util.FileUtil;
024    import org.opengion.fukurou.util.Closer ;
025    import org.opengion.fukurou.util.StringUtil;
026    import org.opengion.fukurou.xml.HybsXMLSave ;
027    
028    import static org.opengion.fukurou.util.StringUtil.nval ;
029    
030    import java.sql.Connection;
031    
032    import java.io.File;
033    import java.io.BufferedReader;
034    import java.util.Map;
035    import java.util.HashMap;
036    
037    /**
038     * 謖?ｮ壹?諡｡蠑ｵXDK蠖｢蠑上ヵ繧｡繧､繝ｫ繧堤峩謗･繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ蜈･蜉帙ち繧ｰ縺ｧ縺吶?
039     *
040     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲√が繝ｩ繧ｯ繝ｫ XDK縺ｮ oracle.xml.sql.dml.OracleXMLSave 繧ｯ繝ｩ繧ｹ縺ｨ
041     * 縺ｻ縺ｼ蜷梧ｧ倥?逶ｮ逧?〒菴ｿ逕ｨ縺ｧ縺阪ｋ org.opengion.fukurou.xml.HybsXMLSave 縺ｮ繝ｩ繝?ヱ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
042     * 諡｡蠑ｵXDK蠖｢蠑上?XML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ縺ｿ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｫ INSERT 縺励∪縺吶?
043     * 諡｡蠑ｵXDK蠖｢蠑上?蜈?→縺ｪ繧?繧ｪ繝ｩ繧ｯ繝ｫ XDK(Oracle XML Developer's Kit)縺ｫ縺､縺?※縺ｯ縲∽ｻ･荳九?
044     * 繝ｪ繝ｳ繧ｯ繧貞盾辣ｧ鬘倥＞縺ｾ縺吶?
045     * <a href="http://otn.oracle.co.jp/software/tech/xml/xdk/index.html" target="_blank" >
046     * XDK(Oracle XML Developer's Kit)</a>
047     *
048     * 縺薙?繧ｿ繧ｰ縺ｧ縺ｯ縲〔eys,vals 繧堤匳骭ｲ縺吶ｋ縺薙→縺ｫ繧医ｊ縲｀L繝輔ぃ繧､繝ｫ縺ｫ蟄伜惠縺励↑縺?き繝ｩ繝?ｒ
049     * 霑ｽ蜉?＠縺溘ｊ縲々ML繝輔ぃ繧､繝ｫ縺ｮ諠??繧呈嶌縺肴鋤縺医ｋ縺薙→縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
050     * 萓九∴縺ｰ縲∫匳骭ｲ譌･繧??逋ｻ骭ｲ閠??縺ｾ縺溘?縲√ユ繝ｳ繝励Ξ繝ｼ繝医ｈ繧雁推繧ｷ繧ｹ繝?ΒID豈弱↓
051     * 逋ｻ骭ｲ縺吶ｋ縺ｪ縺ｩ縺ｧ縺吶?
052     *
053     * 諡｡蠑ｵXDK蠖｢蠑上→縺ｯ縲ヽOW 莉･螟悶↓縲ヾQL蜃ｦ逅?畑繧ｿ繧ｰ(EXEC_SQL)繧呈戟縺､ XML 繝輔ぃ繧､繝ｫ縺ｧ縺吶?
054     * 縺ｾ縺溘?逋ｻ骭ｲ縺吶ｋ繝??繝悶Ν(table)繧?ROWSET繧ｿ繧ｰ縺ｮ螻樊?諠??縺ｨ縺励※莉倅ｸ弱☆繧九％縺ｨ縺後〒縺阪∪縺吶?
055     * (螟ｧ譁?ｭ怜ｰ乗枚蟄励↓豕ｨ諢?
056     * 縺薙ｌ縺ｯ縲√が繝ｩ繧ｯ繝ｫXDK縺ｧ蜃ｦ逅?☆繧句?蜷医?辟｡隕悶＆繧後∪縺吶?縺ｧ縲∝酔讒倥↓謇ｱ縺?％縺ｨ縺悟?譚･縺ｾ縺吶?
057     * 縺薙?縲・XEC_SQL 縺ｯ縲√◎繧後◎繧後? XML繝??繧ｿ繧偵ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ髫帙↓縲?
058     * SQL蜃ｦ逅?ｒ閾ｪ蜍慕噪縺ｫ豬√☆轤ｺ縺ｮ縲ヾQL譁?ｒ險倩ｼ峨＠縺ｾ縺吶?
059     * 縺薙?蜃ｦ逅??縲√う繝吶Φ繝域ｯ弱↓螳溯｡後＆繧後ｋ轤ｺ縲√◎縺ｮ驟咲ｽｮ鬆??驥崎ｦ√〒縺吶?
060     * 縺薙?繧ｿ繧ｰ縺ｯ縲∬､?焚險倩ｿｰ縺吶ｋ縺薙→繧ょ?譚･縺ｾ縺吶′縲。ODY驛ｨ縺ｫ縺ｯ縲?ｼ代▽縺ｮSQL譁??縺ｿ險倩ｿｰ縺励∪縺吶?
061     *
062     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
063     *
064     *   &lt;ROWSET tableName="XX" &gt;
065     *       &lt;EXEC_SQL&gt;                    譛??縺ｫ險倩ｼ峨＠縺ｦ縲∝?譛溷?逅?繝??繧ｿ繧ｯ繝ｪ繧｢遲?繧貞ｮ溯｡後＆縺帙ｋ縲?
066     *           delete from GEXX where YYYYY
067     *       &lt;/EXEC_SQL&gt;
068     *       &lt;MERGE_SQL&gt;                   縺薙?SQL譁?〒 UPDATE縺励※縲∫ｵ先棡縺鯉ｼ蝉ｻｶ縺ｪ繧迂NSERT繧定｡後＞縺ｾ縺吶?
069     *           update GEXX set AA=[AA] , BB=[BB] where CC=[CC]
070     *       &lt;/MERGE_SQL&gt;
071     *       &lt;ROW num="1"&gt;
072     *           &lt;繧ｫ繝ｩ繝?&gt;蛟､1&lt;/繧ｫ繝ｩ繝?&gt;
073     *             ?･?･?･
074     *           &lt;繧ｫ繝ｩ繝?&gt;蛟､n&lt;/繧ｫ繝ｩ繝?&gt;
075     *       &lt;/ROW&gt;
076     *        ?･?･?･
077     *       &lt;ROW num="n"&gt;
078     *          ?･?･?･
079     *       &lt;/ROW&gt;
080     *       &lt;EXEC_SQL&gt;                    譛?ｾ後↓險倩ｼ峨＠縺ｦ縲??逶ｮ縺ｮ險ｭ螳?謨ｴ蜷域?逋ｻ骭ｲ)繧定｡後≧縲?
081     *           update GEXX set AA='XX' , BB='XX' where YYYYY
082     *       &lt;/EXEC_SQL&gt;
083     *   &lt;ROWSET&gt;
084     *
085     * @og.formSample
086     * 笳丞ｽ｢蠑擾ｼ?lt;og:directXMLSave filename="[?･?･?･]" ?･?･?･ /&gt;
087     * 笳獣ody?壹↑縺?
088     *
089     * 笳週ag螳夂ｾｩ??
090     *   &lt;og:directXMLSave
091     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)
092     *       fileURL            縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?(蛻晄悄蛟､:FILE_URL[=filetemp/])
093     *       filename           縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:FILE_FILENAME[=file.xls])
094     *       displayMsg         縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0040[縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆])
095     *       keys               縲慎AG縲噌ML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒謖?ｮ壹☆繧九く繝ｼ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
096     *       vals               縲慎AG縲噌ML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒謖?ｮ壹☆繧句?繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
097     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
098     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
099     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
100     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
101     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
102     *   /&gt;
103     *
104     * 笳丈ｽｿ逕ｨ萓?
105     *     &lt;og:directXMLSave
106     *         dbid         = "ORCL"                謗･邯壹ョ繝ｼ繧ｿ繝吶?繧ｹID(蛻晄悄蛟､:DEFAULT)
107     *         fileURL      = "{&#064;USER.ID}"     隱ｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷?
108     *         filename     = "{&#064;filename}"    隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷?
109     *         displayMsg   = "MSG0040"             逋ｻ骭ｲ螳御ｺ?ｾ後?繝｡繝?そ繝ｼ繧ｸ
110     *     /&gt;
111     *
112     * @og.group 繝輔ぃ繧､繝ｫ蜈･蜉?
113     * @og.rev 4.0.0.0 (2007/03/08) 譁ｰ隕剰ｿｽ蜉?
114     *
115     * @version  4.0
116     * @author   Kazuhiko Hasegawa
117     * @since    JDK5.0,
118     */
119    public class DirectXMLSaveTag extends CommonTagSupport {
120            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
121            private static final String VERSION = "5.6.7.0 (2013/07/27)" ;
122    
123            private static final long serialVersionUID = 567020130727L ;
124    
125            private static final String ENCODE = "UTF-8";
126            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
127    //      private String  dbid            = "DEFAULT";
128            private String  dbid            = null;
129            private String  fileURL         = HybsSystem.sys( "FILE_URL" );         // 4.0.0 (2005/01/31)
130            private String  filename        = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
131            private String  displayMsg      = "MSG0040";    // 縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆縲?
132            private String[]        keys    = null;
133            private String[]        vals    = null;
134            private long    dyStart         = 0;    // 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｮDIV隕∫ｴ?ｒ蜃ｺ蜉帙＠縺ｾ縺吶?
135    
136            /**
137             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
138             *
139             * @og.rev 5.6.6.1 (2013/07/12) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
140             *
141             * @return      蠕檎ｶ壼?逅??謖?､ｺ( SKIP_BODY )
142             */
143            @Override
144            public int doStartTag() {
145                    // 5.6.6.1 (2013/07/12) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
146                    if( useTag() ) {
147                            dyStart = System.currentTimeMillis();           // 譎る俣貂ｬ螳夂畑
148                    }
149                    return( SKIP_BODY );    // Body 繧定ｩ穂ｾ｡縺励↑縺?
150            }
151    
152            /**
153             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
154             *
155             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
156             * @og.rev 4.0.0.1 (2007/12/03) try ??catch ??finally 繧偵″縺｡繧薙→陦後≧縲?
157             * @og.rev 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
158             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
159             * @og.rev 5.5.2.6 (2012/05/25) findbugs蟇ｾ蠢懊?萓句､也ｵ瑚ｷｯ縺ｧ null 蛟､繧貞茜逕ｨ縺吶ｋ縺薙→縺御ｿ晁ｨｼ縺輔ｌ縺ｦ縺?∪縺吶?
160             * @og.rev 5.6.6.1 (2013/07/12) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
161             * @og.rev 5.6.7.0 (2013/07/27) DDL?医ョ繝ｼ繧ｿ螳夂ｾｩ險?ｪ橸ｼ咼ata Definition Language?峨?蜃ｦ逅?ｻｶ謨ｰ霑ｽ蜉?
162             *
163             * @return      蠕檎ｶ壼?逅??謖?､ｺ
164             */
165            @Override
166            public int doEndTag() {
167                    debugPrint();           // 4.0.0 (2005/02/28)
168                    // 5.6.6.1 (2013/07/12) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
169                    if( !useTag() ) { return(EVAL_PAGE); }
170    
171                    BufferedReader reader   = null;
172                    final int insCnt ;
173                    final int updCnt ;
174                    final int delCnt ;
175                    final int ddlCnt ;                              // 5.6.7.0 (2013/07/27) DDL蜃ｦ逅?ｻｶ謨ｰ霑ｽ蜉?
176                    boolean errFlag = true;
177    //              Connection  conn = null;
178                    Transaction tran = null;                // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
179                    try {
180                            // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
181                            TransactionTag tranTag = (TransactionTag)findAncestorWithClass( this,TransactionTag.class );
182                            if( tranTag == null ) {
183    //                              tran = new TransactionReal( dbid,getApplicationInfo() );
184                                    tran = new TransactionReal( getApplicationInfo() );             // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
185                            }
186                            else {
187                                    tran = tranTag.getTransaction();
188                            }
189    //                      conn = ConnectionFactory.connection( dbid,getApplicationInfo() );       // 3.8.7.0 (2006/12/15)
190    
191                            Connection conn = tran.getConnection( dbid );           // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
192                            HybsXMLSave save = new HybsXMLSave( conn );
193                            if( keys != null ) { save.setAfterMap( getAfterMap() ); }
194    
195                            reader = getBufferedReader();
196                            save.insertXML( reader );
197                            insCnt = save.getInsertCount();
198                            updCnt = save.getUpdateCount();
199                            delCnt = save.getDeleteCount();
200                            ddlCnt = save.getDDLCount();            // 5.6.7.0 (2013/07/27) DDL蜃ｦ逅?ｻｶ謨ｰ霑ｽ蜉?
201    //                      Closer.commit( conn );
202                            tran.commit();                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
203                            errFlag = false;                // 繧ｨ繝ｩ繝ｼ縺ｧ縺ｯ縺ｪ縺?
204                    }
205                    catch( Throwable ex ) {
206    //                      Closer.rollback( conn );
207                            if( tran != null ) {            // 5.5.2.6 (2012/05/25) findbugs蟇ｾ蠢?
208                                    tran.rollback();                // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
209                            }
210                            throw new HybsSystemException( ex );
211                    }
212                    finally {
213                            if( tran != null ) {            // 5.5.2.6 (2012/05/25) findbugs蟇ｾ蠢?
214                                    tran.close( errFlag );
215                            }
216    //                      if( errFlag ) { ConnectionFactory.remove( conn,dbid ); }        // 蜑企勁
217    //                      else {                  ConnectionFactory.close( conn,dbid );  }        // 霑泌唆
218    //                      Closer.connClose( conn );
219                            Closer.ioClose( reader );
220                    }
221    
222                    // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ
223                    // 4.0.0 (2005/11/30) 蜃ｺ蜉幃?縺ｮ螟画峩縲ゆｸ?分譛??縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
224                    if( displayMsg != null && displayMsg.length() > 0 ) {
225                            StringBuilder buf = new StringBuilder();
226                            buf.append( "INS:"    ).append( insCnt );
227                            buf.append( " / UPD:" ).append( updCnt );
228                            buf.append( " / DEL:" ).append( delCnt );
229                            buf.append( " / DDL:" ).append( ddlCnt );                               // 5.6.7.0 (2013/07/27) DDL蜃ｦ逅?ｻｶ謨ｰ霑ｽ蜉?
230    //                      buf.append( getResource().getMessage( displayMsg ) );
231                            buf.append( getResource().getLabel( displayMsg ) );
232                            buf.append( HybsSystem.BR );
233    
234                            jspPrint( buf.toString() );
235                    }
236    
237                    // 譎る俣貂ｬ螳夂畑縺ｮ DIV 隕∫ｴ?ｒ蜃ｺ蜉?
238                    long dyTime = System.currentTimeMillis()-dyStart;
239                    jspPrint( "<div id=\"queryTime\" value=\"" + (dyTime) + "\"></div>" );      // 3.5.6.3 (2004/07/12)
240    
241                    // 4.0.0 (2005/01/31) 繧ｻ繧ｭ繝･繝ｪ繝?ぅ繝√ぉ繝?け(繝??繧ｿ繧｢繧ｯ繧ｻ繧ｹ莉ｶ謨ｰ逋ｻ骭ｲ)
242                    GUIInfo guiInfo = (GUIInfo)getSessionAttribute( HybsSystem.GUIINFO_KEY );
243                    if( guiInfo != null ) { guiInfo.addWriteCount( insCnt,dyTime,fileURL + filename ); }
244    
245                    return(EVAL_PAGE);
246            }
247    
248            /**
249             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
250             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
251             *
252             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
253             */
254            @Override
255            protected void release2() {
256                    super.release2();
257    //              dbid            = "DEFAULT";
258                    dbid            = null;
259                    fileURL         = HybsSystem.sys( "FILE_URL" );         // 4.0.0 (2005/01/31)
260                    filename        = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
261                    displayMsg      = "MSG0040";    // 縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆縲?
262                    keys            = null;
263                    vals            = null;
264            }
265    
266            /**
267             * BufferedReader 繧貞叙蠕励＠縺ｾ縺吶?
268             *
269             * 縺薙％縺ｧ縺ｯ縲∽ｸ?握逧?↑繝輔ぃ繧､繝ｫ蜃ｺ蜉帙ｒ閠??縺励◆ BufferedReader 繧剃ｽ懈?縺励∪縺吶?
270             *
271             * @return      繝輔ぃ繧､繝ｫ蜈･蜉帷畑BufferedReader繧ｪ繝悶ず繧ｧ繧ｯ繝?
272             */
273            private BufferedReader getBufferedReader() {
274                    if( filename == null ) {
275                            String errMsg = "繝輔ぃ繧､繝ｫ蜷阪′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?;
276                            throw new HybsSystemException( errMsg );
277                    }
278                    String directory = HybsSystem.url2dir( fileURL );
279                    File file = new File( StringUtil.urlAppend( directory,filename ) );
280    
281                    BufferedReader out = FileUtil.getBufferedReader( file,ENCODE );
282    
283                    return out ;
284            }
285    
286            /**
287             * BufferedReader 繧貞叙蠕励＠縺ｾ縺吶?
288             *
289             * 縺薙％縺ｧ縺ｯ縲∽ｸ?握逧?↑繝輔ぃ繧､繝ｫ蜃ｺ蜉帙ｒ閠??縺励◆ BufferedReader 繧剃ｽ懈?縺励∪縺吶?
290             *
291             * @og.rev 5.6.6.1 (2013/07/12) key 縺?null 繧?繧ｼ繝ｭ譁?ｭ怜?縺ｮ蝣ｴ蜷医?縲｀ap 縺ｫ霑ｽ蜉?＠縺ｾ縺帙ｓ縲?
292             *
293             * @return      繝輔ぃ繧､繝ｫ蜈･蜉帷畑BufferedReader
294             */
295            private Map<String,String> getAfterMap() {
296                    Map<String,String> map = new HashMap<String,String>();
297    
298                    for( int i=0; i<keys.length; i++ ) {
299                            if( keys[i] != null && keys[i].length() > 0 ) {              // 5.6.6.1 (2013/07/12)
300                                    map.put( keys[i],vals[i] );
301                            }
302                    }
303                    return map ;
304            }
305    
306            /**
307             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)縲?
308             *
309             * @og.tag
310             *   讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?蛻晄悄蛟､縺ｯ縲．EFAULT 縺ｧ縺吶?
311             *
312             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
313             */
314            public void setDbid( final String id ) {
315                    dbid = nval( getRequestParameter( id ),dbid );
316            }
317    
318            /**
319             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?
320             *              (蛻晄悄蛟､:FILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
321             *
322             * @og.tag
323             * 縺薙?螻樊?縺ｧ謖?ｮ壹＆繧後ｋ繝?ぅ繝ｬ繧ｯ繝医Μ繧医ｊ縲√ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
324             * 謖?ｮ壽婿豕輔?縲??蟶ｸ縺ｮ fileURL 螻樊?縺ｨ蜷梧ｧ倥↓縲∝?鬆ｭ縺後?'/' (UNIX) 縺ｾ縺溘?縲?ｼ呈枚蟄礼岼縺後?
325             * ":" (Windows)縺ｮ蝣ｴ蜷医?縲∵欠螳壹?URL縺昴?縺ｾ縺ｾ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√◎縺?〒縺ｪ縺??蜷医?縲?
326             * fileURL = "{&#064;USER.ID}" 縺ｨ謖?ｮ壹☆繧九→縲：ILE_URL 螻樊?縺ｧ謖?ｮ壹?繝輔か繝ｫ繝??荳九↓縲?
327             * 縺輔ｉ縺ｫ縲∝推蛟倶ｺｺID蛻･縺ｮ繝輔か繝ｫ繝??荳九ｈ繧翫?隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
328             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
329             *
330             * @og.rev 4.0.0.0 (2007/11/20) 謖?ｮ壹＆繧後◆繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪?譛?ｾ後′"\"or"/"縺ｧ邨ゅｏ縺｣縺ｦ縺?↑縺??蜷医↓縲?/"繧剃ｻ伜刈縺吶ｋ縲?
331             *
332             * @param       url 繝輔ぃ繧､繝ｫURL
333             * @see         org.opengion.hayabusa.common.SystemData#FILE_URL
334             */
335            public void setFileURL( final String url ) {
336                    String furl = nval( getRequestParameter( url ),null );
337                    if( furl != null ) {
338                            char ch = furl.charAt( furl.length()-1 );
339                            if( ch != '/' && ch != '\\' ) { furl = furl + "/"; }
340                            fileURL = StringUtil.urlAppend( fileURL,furl );
341                    }
342            }
343    
344            /**
345             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
346             *              (蛻晄悄蛟､:FILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
347             *
348             * @og.tag
349             * 繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
350             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
351             *
352             * @param   filename 繝輔ぃ繧､繝ｫ蜷?
353             * @see         org.opengion.hayabusa.common.SystemData#FILE_FILENAME
354             */
355            public void setFilename( final String filename ) {
356                    this.filename = nval( getRequestParameter( filename ),this.filename );
357            }
358    
359            /**
360             * 縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0040[縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆])縲?
361             *
362             * @og.tag
363             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
364             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ
365             * 陦ｨ遉ｺ縺励∪縺吶?
366             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
367             * 蛻晄悄蛟､縺ｯ縲∵､懃ｴ｢莉ｶ謨ｰ繧定｡ｨ遉ｺ縺励∪縺吶?
368             * 窶ｻ 縺薙?螻樊?縺ｫ縺ｯ縲√Μ繧ｯ繧ｨ繧ｹ繝亥､画焚({&#064;XXXX})縺ｯ菴ｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?
369             *
370             * @param   id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
371             */
372            public void setDisplayMsg( final String id ) {
373                    if( id != null ) { displayMsg = id; }
374            }
375    
376            /**
377             * 縲慎AG縲噌ML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒謖?ｮ壹☆繧九く繝ｼ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
378             *
379             * @og.tag
380             * XML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒縲√ョ繝ｼ繧ｿ繧貞､画峩縺ｧ縺阪∪縺吶?
381             * 螟画峩縺吶ｋ繧ｫ繝ｩ繝?錐(繧ｭ繝ｼ)繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
382             * XML繝輔ぃ繧､繝ｫ縺ｫ繧ｭ繝ｼ縺悟ｭ伜惠縺励※縺?◆蝣ｴ蜷医?縲」als 縺ｧ謖?ｮ壹?蛟､縺ｫ譖ｸ縺肴鋤縺医∪縺吶?
383             * 繧ｭ繝ｼ縺悟ｭ伜惠縺励※縺?↑縺??蜷医?縲√％縺薙〒謖?ｮ壹☆繧九く繝ｼ縺ｨ蛟､縺後?繝??繧ｿ縺ｨ縺励※
384             * 霑ｽ蜉?＆繧後∪縺吶?
385             * 萓九∴縺ｰ縲∫匳骭ｲ譌･繧??逋ｻ骭ｲ閠??縺ｾ縺溘?縲√ユ繝ｳ繝励Ξ繝ｼ繝医ｈ繧雁推繧ｷ繧ｹ繝?ΒID豈弱↓
386             * 逋ｻ骭ｲ縺吶ｋ縺ｪ縺ｩ縺ｮ菴ｿ縺?婿繧呈Φ螳壹＠縺ｦ縺?∪縺吶?
387             * 蛻?ｧ｣譁ｹ豕輔?縲，SV螟画焚繧貞?縺ｫ蛻?ｧ｣縺励※縺九ｉ縲“etRequestParameter 縺ｧ蛟､繧貞叙蠕励＠縺ｾ縺吶?
388             * 縺薙≧縺励↑縺?→繝??繧ｿ閾ｪ霄ｫ縺ｫ繧ｫ繝ｳ繝槭ｒ謖√▲縺ｦ縺?ｋ蝣ｴ蜷医↓蛻?ｧ｣繧偵Α繧ｹ繧狗ぜ縺ｧ縺吶?
389             *
390             * @param       key 繝ｪ繝ｳ繧ｯ蜈医↓貂｡縺吶く繝ｼ
391             * @see         #setVals( String )
392             */
393            public void setKeys( final String key ) {
394                    keys = getCSVParameter( key );
395            }
396    
397            /**
398             * 縲慎AG縲噌ML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒謖?ｮ壹☆繧句?繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
399             *
400             * @og.tag
401             * XML繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶▲縺溷ｾ後〒縲√ョ繝ｼ繧ｿ繧貞､画峩縺ｧ縺阪∪縺吶?
402             * 螟画峩縺吶ｋ蛟､繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
403             * XML繝輔ぃ繧､繝ｫ縺ｫ繧ｭ繝ｼ縺悟ｭ伜惠縺励※縺?◆蝣ｴ蜷医?縲」als 縺ｧ謖?ｮ壹?蛟､縺ｫ譖ｸ縺肴鋤縺医∪縺吶?
404             * 繧ｭ繝ｼ縺悟ｭ伜惠縺励※縺?↑縺??蜷医?縲√％縺薙〒謖?ｮ壹☆繧九く繝ｼ縺ｨ蛟､縺後?繝??繧ｿ縺ｨ縺励※
405             * 霑ｽ蜉?＆繧後∪縺吶?
406             * 萓九∴縺ｰ縲∫匳骭ｲ譌･繧??逋ｻ骭ｲ閠??縺ｾ縺溘?縲√ユ繝ｳ繝励Ξ繝ｼ繝医ｈ繧雁推繧ｷ繧ｹ繝?ΒID豈弱↓
407             * 逋ｻ骭ｲ縺吶ｋ縺ｪ縺ｩ縺ｮ菴ｿ縺?婿繧呈Φ螳壹＠縺ｦ縺?∪縺吶?
408             * 蛻?ｧ｣譁ｹ豕輔?縲，SV螟画焚繧貞?縺ｫ蛻?ｧ｣縺励※縺九ｉ縲“etRequestParameter 縺ｧ蛟､繧貞叙蠕励＠縺ｾ縺吶?
409             * 縺薙≧縺励↑縺?→繝??繧ｿ閾ｪ霄ｫ縺ｫ繧ｫ繝ｳ繝槭ｒ謖√▲縺ｦ縺?ｋ蝣ｴ蜷医↓蛻?ｧ｣繧偵Α繧ｹ繧狗ぜ縺ｧ縺吶?
410             *
411             * @param       val keys螻樊?縺ｫ蟇ｾ蠢懊☆繧句?
412             * @see         #setKeys( String )
413             */
414            public void setVals( final String val ) {
415                    vals = getCSVParameter( val );
416            }
417    
418            /**
419             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
420             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
421             *
422             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
423             */
424            @Override
425            public String toString() {
426                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
427                                    .println( "VERSION"                     ,VERSION                )
428                                    .println( "dbid"                        ,dbid                   )
429                                    .println( "fileURL"                     ,fileURL                )
430                                    .println( "filename"            ,filename               )
431                                    .println( "displayMsg"          ,displayMsg             )
432                                    .println( "dyStart"                     ,dyStart                )
433                                    .println( "Other..."            ,getAttributes().getAttribute() )
434                                    .fixForm().toString() ;
435            }
436    }