001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.hayabusa.taglib;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    import org.opengion.hayabusa.db.DBErrMsg;
021    import org.opengion.hayabusa.resource.GUIInfo;
022    import org.opengion.hayabusa.resource.ResourceManager;
023    import org.opengion.fukurou.db.Transaction;
024    import org.opengion.fukurou.db.TransactionReal;
025    import org.opengion.fukurou.util.ErrorMessage;
026    import org.opengion.fukurou.util.FileUtil;
027    import org.opengion.fukurou.util.StringUtil;
028    import org.opengion.fukurou.util.Closer ;
029    import static org.opengion.fukurou.util.StringUtil.nval ;
030    
031    import java.util.Locale ;
032    
033    import java.sql.Connection;
034    import java.sql.Statement;
035    import java.sql.CallableStatement;
036    import java.sql.ResultSet;
037    import java.sql.ResultSetMetaData;
038    import java.sql.SQLException;
039    import java.sql.Types;
040    // import java.sql.Array;                                                       // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝? 蟇ｾ蠢懊?oracle.sql.ARRAY 縺ｮ鄂ｮ縺肴鋤縺?
041    import oracle.sql.ARRAY;                                                        // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝? 蟇ｾ蠢?
042    import oracle.sql.ArrayDescriptor;                                      // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝? 蟇ｾ蠢?
043    // import oracle.jdbc.OracleConnection;                         // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝? 蟇ｾ蠢?
044    
045    import oracle.jdbc.OracleTypes;                                         // CURSOR 縺梧ｮ九ｋ
046    import oracle.jdbc.OracleCallableStatement;                     // CURSOR 縺梧ｮ九ｋ
047    
048    import java.io.File;
049    import java.io.PrintWriter;
050    import java.io.FileOutputStream;
051    import java.io.IOException;
052    import java.io.ObjectOutputStream;
053    import java.io.ObjectInputStream;
054    import java.util.zip.ZipOutputStream;
055    import java.util.zip.ZipEntry;
056    
057    import java.util.Map;
058    
059    /**
060     * SELECT譁?ｒ逶ｴ謗･螳溯｡後＠縺ｦ縲∵欠螳壹?繝輔ぃ繧､繝ｫ縺ｫ蜃ｺ蜉帙☆繧九ち繧ｰ縺ｧ縺吶?
061     *
062     * 荳ｭ髢薙?縲√ョ繝ｼ繧ｿ(DBTableModel)繧剃ｽ懈?縺励↑縺?◆繧√?菴呵ｨ医↑繝｡繝｢繝ｪ繧貞叙繧峨★縲?
063     * 鬮倬?縺ｫ繝??繧ｿ繧呈栢縺榊?縺吶％縺ｨ縺悟庄閭ｽ縺ｧ縺吶?
064     * 荳?婿縲∵栢縺榊?縺吶ョ繝ｼ繧ｿ縺ｯ逕溘ョ繝ｼ繧ｿ縺ｮ縺溘ａ縲√ョ繝ｼ繧ｿ縺ｮ蜀榊茜逕ｨ遲峨?繧ｷ繧ｹ繝?Β逧?↑
065     * 菴ｿ逕ｨ繧呈Φ螳壹＠縺ｦ縺?∪縺吶?
066     * JDBCErrMsg 蠖｢蠑上?PL/SQL 繧偵さ繝ｼ繝ｫ縺励※縲√◎縺ｮ讀懃ｴ｢邨先棡(繧ｫ繝ｼ繧ｽ繝ｫ)繧呈栢縺阪％縺ｨ繧ゅ〒縺阪∪縺吶?
067     *
068     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
069     *
070     * @og.formSample
071     * 笳丞ｽ｢蠑擾ｼ?lt;og:directWriteTable filename="[?･?･?･]" ?･?･?･ &gt;SELECT * FROM ZYXX &lt;/og:directWriteTable &gt;
072     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
073     *
074     * 笳週ag螳夂ｾｩ??
075     *   &lt;og:directWriteTable
076     *       fileURL            縲慎AG縲台ｿ晏ｭ伜?繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?(蛻晄悄蛟､:FILE_URL[=filetemp/])
077     *       filename           縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｷ繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ縺ｮFILE_FILENAME)
078     *       zipFilename        縲慎AG縲岨IP繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?ZIP繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:filename + ".zip")
079     *       encode             縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:FILE_ENCODE[=UnicodeLittle])
080     *       fileAppend         縲慎AG縲題ｿｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ繧?°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[騾壼ｸｸ繝｢繝ｼ繝云)
081     *       zip                縲慎AG縲醍ｵ先棡繧偵ヵ繧｡繧､繝ｫ縺ｫ蜃ｺ蜉帙☆繧九→縺阪↓縲〇IP縺ｧ蝨ｧ邵ｮ縺吶ｋ縺九←縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
082     *       separator          縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:TAB_SEPARATOR[= ])
083     *       useHeader          縲慎AG縲代?繝?ム繝ｼ繧呈嶌縺崎ｾｼ繧?°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
084     *       displayMsg         縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0033[縲?ｻｶ讀懃ｴ｢縺励∪縺励◆])
085     *       notfoundMsg        縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])
086     *       fetchSize          縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ繝輔ぉ繝?メ繧ｵ繧､繧ｺ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:100)
087     *       names              縲慎AG縲善L/SQL繧貞茜逕ｨ縺吶ｋ蝣ｴ蜷医?蠑墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
088     *       queryType          縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID(JDBC,JDBCErrMsg)繧呈欠螳壹＠縺ｾ縺?{@og.doc03Link queryType 蛻晄悄蛟､:JDBC})
089     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)
090     *       useNumber          縲慎AG縲題｡檎分蜿ｷ繧貞?蜉帙☆繧九°縺ｩ縺?°(蛻晄悄蛟､:true)
091     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
092     *   &gt;   ... Body ...
093     *   &lt;/og:directWriteTable&gt;
094     *
095     * 笳丈ｽｿ逕ｨ萓?
096     *     &lt;og:directWriteTable
097     *         dbid        = "ORCL"               謗･邯壹ョ繝ｼ繧ｿ繝吶?繧ｹID(蛻晄悄蛟､:DEFAULT)
098     *         separator   = ","                  繝輔ぃ繧､繝ｫ縺ｮ蛹ｺ蛻?ｊ譁?ｭ?蛻晄悄蛟､:繧ｿ繝?
099     *         fileURL     = "{&#064;USER.ID}"    菫晏ｭ伜?繝?ぅ繝ｬ繧ｯ繝医Μ蜷?
100     *         filename    = "{&#064;filename}"   菫晏ｭ倥ヵ繧｡繧､繝ｫ蜷?
101     *         encode      = "UnicodeLittle"      菫晏ｭ倥ヵ繧｡繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝牙錐
102     *         useHeader   = "true"               菫晏ｭ倥ヵ繧｡繧､繝ｫ縺ｫ繝倥ャ繝??繧貞?蜉帙☆繧九°縺ｩ縺?°
103     *         zip         = "true"               ZIP繝輔ぃ繧､繝ｫ縺ｫ蝨ｧ邵ｮ縺吶ｋ縺九←縺?°
104     *         zipFilename = "Sample.zip"         ZIP繝輔ぃ繧､繝ｫ縺ｮ繝輔ぃ繧､繝ｫ蜷?
105     *         fileAppend  = "true"               繝輔ぃ繧､繝ｫ繧定ｿｽ蜉?Δ繝ｼ繝峨〒逋ｻ骭ｲ縺吶ｋ縺九←縺?°
106     *         displayMsg  = "MSG0033"            螳溯｡悟ｾ後?陦ｨ遉ｺ繝｡繝?そ繝ｼ繧ｸ
107     *         fetchSize   = "200"                DB讀懃ｴ｢縺吶ｋ蝣ｴ蜷医?繝輔ぉ繝?メ縺吶ｋ繧ｵ繧､繧ｺ
108     *     &gt;
109     *         SELECT * FROM ZYXX 
110     *     &lt;/og:directWriteTable &gt;
111     *
112     *     &lt;og:directWriteTable
113     *         fileURL     = "{&#064;USER.ID}"    菫晏ｭ伜?繝?ぅ繝ｬ繧ｯ繝医Μ蜷?
114     *         filename    = "{&#064;filename}"   菫晏ｭ倥ヵ繧｡繧､繝ｫ蜷?
115     *         names       = "AAA,BBB,CCC,?･?･?･"    謖?ｮ壹?繧ｭ繝ｼ縺ｫ蟇ｾ蠢懊☆繧九Μ繧ｯ繧ｨ繧ｹ繝亥?繧?ARG_ARRAY 縺ｫ繧ｻ繝?ヨ縺励∪縺吶?
116     *         queryType   = "JDBCErrMsg"         JDBCErrMsg 蠖｢蠑上?PL/SQL 繧偵さ繝ｼ繝ｫ縺励∪縺吶?
117     *     &gt;
118     *        { call PL/SQL(?,?,?,? ) } 
119     *     &lt;/og:directWriteTable &gt;
120     *
121     * @og.rev 3.5.6.0 (2004/06/18) 譁ｰ隕丈ｽ懈?
122     * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｮ螳溯｡後ｒ霑ｽ蜉?
123     * @og.group 繝輔ぃ繧､繝ｫ蜃ｺ蜉?
124     *
125     * @version  4.0
126     * @author   Kazuhiko Hasegawa
127     * @since    JDK5.0,
128     */
129    public class DirectWriteTableTag extends CommonTagSupport {
130            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
131            private static final String VERSION = "5.7.2.3 (2014/01/31)" ;
132    
133            private static final long serialVersionUID = 572320140131L ;
134    
135            private static final String TAB_SEPARATOR       = "\t" ;
136            private static final String errMsgId            = HybsSystem.ERR_MSG_KEY;
137    
138            private final int DB_MAX_QUERY_TIMEOUT          = HybsSystem.sysInt( "DB_MAX_QUERY_TIMEOUT" ) ;
139    //      private static final String ARG_ARRAY           = HybsSystem.sys( "ARG_ARRAY" ) ;
140    //      private static final String ERR_MSG                     = HybsSystem.sys( "ERR_MSG" ) ;
141    //      private static final String ERR_MSG_ARRAY       = HybsSystem.sys( "ERR_MSG_ARRAY" ) ;
142            private static final String ARG_ARRAY           = "ARG_ARRAY" ;
143            private static final String ERR_MSG                     = "ERR_MSG" ;
144            private static final String ERR_MSG_ARRAY       = "ERR_MSG_ARRAY" ;
145    
146            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
147    //      private String  dbid            = "DEFAULT";
148            private String  dbid            = null;
149            private String  separator       = TAB_SEPARATOR;   // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
150            private boolean useHeader       = true;         // 繝倥ャ繝??縺ｮ菴ｿ逕ｨ蜿ｯ蜷ｦ
151            private String  fileURL         = HybsSystem.sys( "FILE_URL" );
152            private String  filename        = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
153            private String  zipFilename     = null;         // ZIP繝輔ぃ繧､繝ｫ蜷?
154            private String  sql                     = null;
155            private String  encode          = HybsSystem.sys( "FILE_ENCODE"   );   // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "DEFAULT","JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
156            private boolean fileAppend      = false;        // 繝輔ぃ繧､繝ｫ繧但PPEND繝｢繝ｼ繝峨〒蜃ｺ蜉帙☆繧九°
157            private boolean zip                     = false;        // 繝輔ぃ繧､繝ｫ繧短IP縺吶ｋ縺?
158    //      private String  displayMsg      = "MSG0033";    // 縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲?
159            private String  displayMsg      = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
160            private String  notfoundMsg     = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
161            private long    dyStart         = 0;    // 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｮDIV隕∫ｴ?ｒ蜃ｺ蜉帙＠縺ｾ縺吶?
162            private int             fetchSize       = 100 ; // 繝輔ぉ繝?メ縺吶ｋ陦梧焚(蛻晄悄蛟､:100)
163            private boolean useNumber       = true;  // 5.5.7.1(2012/10/05) 陦檎分蜿ｷ蜃ｺ蜉?
164    
165            // 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
166            private boolean queryType       = true; // 繝弱?繝槭Ν縺ｯ縲》rue/ JDBCErrMsg 縺ｮ譎ゅ?縲’alse
167            private String  names           = null; // 謖?ｮ壹?繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚繧偵?ARG_ARRAY 縺ｫ繧ｻ繝?ヨ縺励∪縺吶?
168            private int             errCode         = ErrorMessage.OK;
169            private transient ErrorMessage errMessage = null;
170    
171            /**
172             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
173             *
174             * @return      蠕檎ｶ壼?逅??謖?､ｺ( EVAL_BODY_BUFFERED )
175             */
176            @Override
177            public int doStartTag() {
178                    dyStart = System.currentTimeMillis();           // 譎る俣貂ｬ螳夂畑
179                    return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
180            }
181    
182            /**
183             * Taglib縺ｮ繧ｿ繧ｰ譛ｬ菴薙ｒ蜃ｦ逅?☆繧?doAfterBody() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
184             *
185             * @og.rev 3.8.6.3 (2006/11/30) SQL 譁??蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺阪∪縺吶?
186             *
187             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
188             */
189            @Override
190            public int doAfterBody() {
191                    sql = getBodyString();
192                    if( sql == null || sql.length() == 0 ) {
193                            String errMsg = "BODY 驛ｨ縺ｮ讀懃ｴ｢逕ｨ Select譁??縲∝ｿ??縺ｧ縺吶?";
194                            throw new HybsSystemException( errMsg );
195                    }
196                    sql = sql.trim();
197                    return(SKIP_BODY);                              // Body 繧定ｩ穂ｾ｡縺励↑縺?
198            }
199    
200            /**
201             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
202             *
203             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
204             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
205             *
206             * @return      蠕檎ｶ壼?逅??謖?､ｺ
207             */
208            @Override
209            public int doEndTag() {
210                    debugPrint();           // 4.0.0 (2005/02/28)
211    
212                    PrintWriter pw = null;
213                    final int executeCount;
214                    try {
215                            if( zip ) {
216                                    String directory = HybsSystem.url2dir( fileURL );
217    
218                                    if( zipFilename == null ) { zipFilename = filename + ".zip"; }
219                                    ZipOutputStream gzip = null;
220                                    try {
221                                            gzip = new ZipOutputStream(
222                                                                    new FileOutputStream(
223                                                                                    StringUtil.urlAppend( directory,zipFilename )));
224                                            gzip.putNextEntry( new ZipEntry( filename ) );
225                                            pw = new PrintWriter( gzip );
226                                            executeCount = create( pw ) ;
227    
228                                            pw.flush();
229                                            gzip.closeEntry();
230                                            gzip.finish() ;
231                                    }
232                                    finally {
233                                            Closer.ioClose( gzip );         // 4.0.0 (2006/01/31) close 蜃ｦ逅?凾縺ｮ IOException 繧堤┌隕?
234                                    }
235                            }
236                            else {
237                                    pw = getPrintWriter();
238                                    executeCount = create( pw );
239                            }
240                    } catch( IOException ex ) {
241                            String errMsg = "Error in DirectWriteTableTag: " + toString();
242                            throw new HybsSystemException( errMsg,ex );             // 3.5.5.4 (2004/04/15) 蠑墓焚縺ｮ荳ｦ縺ｳ鬆?､画峩
243                    } finally {
244                            Closer.ioClose( pw );           // 4.0.0 (2006/01/31) close 蜃ｦ逅?凾縺ｮ IOException 繧堤┌隕?
245                    }
246    
247                    // 3.6.1.0 (2005/01/05) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧偵?"DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
248                    setRequestAttribute( "DB.COUNT"   , String.valueOf( executeCount ) );
249                    setRequestAttribute( "DB.ERR_CODE", String.valueOf( errCode ) );
250    
251                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
252    
253                    // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ
254    //              boolean useStatusBar = HybsSystem.sysBool( "VIEW_USE_DISPLAY_MSG" );
255    //              if( useStatusBar && executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
256                    if( executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
257                            buf.append( executeCount );
258    //                      buf.append( getResource().getMessage( displayMsg ) );
259                            buf.append( getResource().getLabel( displayMsg ) );
260                            buf.append( HybsSystem.BR );
261                    }
262                    else if( executeCount == 0 && notfoundMsg != null && notfoundMsg.length() > 0 ) {
263    //                      buf.append( getResource().getMessage( notfoundMsg ) );
264                            buf.append( getResource().getLabel( notfoundMsg ) );
265                            buf.append( HybsSystem.BR );
266                    }
267    
268                    // 3.6.1.0 (2005/01/05) TaglibUtil.makeHTMLErrorTable 繝｡繧ｽ繝?ラ繧貞茜逕ｨ
269                    String err = TaglibUtil.makeHTMLErrorTable( errMessage,getResource() );
270                    if( err != null && err.length() > 0 ) {
271                            buf.append( err );
272                            setSessionAttribute( errMsgId,errMessage );
273                    }
274                    else {
275                            removeSessionAttribute( errMsgId );
276                    }
277    
278                    jspPrint( buf.toString() );
279    
280                    // 譎る俣貂ｬ螳夂畑縺ｮ DIV 隕∫ｴ?ｒ蜃ｺ蜉?
281                    long dyTime = System.currentTimeMillis()-dyStart;
282                    jspPrint( "<div id=\"queryTime\" value=\"" + (dyTime) + "\"></div>" );      // 3.5.6.3 (2004/07/12)
283    
284                    // 3.6.1.0 (2005/01/05) 隴ｦ蜻頑凾縺ｫ蛛懈ｭ｢縺励※縺?∪縺励◆縺後?邯咏ｶ壼?逅?＆縺帙∪縺吶?
285                    int rtnCode = EVAL_PAGE;
286                    if( errCode >= ErrorMessage.NG )  {  // 逡ｰ蟶ｸ
287                            rtnCode = SKIP_PAGE;
288                    }
289    
290                    // 4.0.0 (2005/01/31) 繧ｻ繧ｭ繝･繝ｪ繝?ぅ繝√ぉ繝?け(繝??繧ｿ繧｢繧ｯ繧ｻ繧ｹ莉ｶ謨ｰ逋ｻ骭ｲ)
291                    GUIInfo guiInfo = (GUIInfo)getSessionAttribute( HybsSystem.GUIINFO_KEY );
292                    if( guiInfo != null ) { guiInfo.addReadCount( executeCount,dyTime,sql ); }
293    
294                    return( rtnCode );
295            }
296    
297            /**
298             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
299             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
300             *
301             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
302             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
303             * @og.rev 5.5.7.1 (2012/10/05) useNumber霑ｽ蜉?
304             */
305            @Override
306            protected void release2() {
307                    super.release2();
308                    separator       = TAB_SEPARATOR;   // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
309                    fileURL         = HybsSystem.sys( "FILE_URL" );
310                    filename        = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
311                    zipFilename     = null;         // ZIP繝輔ぃ繧､繝ｫ蜷?
312                    sql                     = null;
313                    encode          = HybsSystem.sys( "FILE_ENCODE" );   // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "DEFAULT","JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
314                    fileAppend      = false;        // 繝輔ぃ繧､繝ｫ繧但PPEND繝｢繝ｼ繝峨〒蜃ｺ蜉帙☆繧九°
315                    zip                     = false;        // 繝輔ぃ繧､繝ｫ繧短IP縺吶ｋ縺?
316    //              displayMsg      = "MSG0033";    // 縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲?
317                    displayMsg      = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
318                    notfoundMsg     = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
319    //              dbid            = "DEFAULT";
320                    dbid            = null;
321                    fetchSize       = 100 ; // 繝輔ぉ繝?メ縺吶ｋ陦梧焚(蛻晄悄蛟､:0 蜿り?縺ｫ縺励↑縺?
322                    dyStart         = 0;
323                    queryType       = true; // 繝弱?繝槭Ν縺ｯ縲》rue/ JDBCErrMsg 縺ｮ譎ゅ?縲’alse
324                    names           = null; // 謖?ｮ壹?繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚繧偵?ARG_ARRAY 縺ｫ繧ｻ繝?ヨ縺励∪縺吶?
325                    errCode         = ErrorMessage.OK;
326                    errMessage      = null;
327                    useNumber       = true; // 5.5.7.1 (2012/10/05)
328            }
329    
330            /**
331             * 螳溘が繝悶ず繧ｧ繧ｯ繝医ｒ逕滓?縺励※?薫utputStream 縺ｫ譖ｸ縺崎ｾｼ縺ｿ縺ｾ縺吶?
332             *
333             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
334             * @og.rev 3.8.6.0 (2006/09/29) 繝倥ャ繝??縺ｫ繝ｩ繝吶Ν繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣
335             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
336             * @og.rev 4.3.4.3 (2008/12/22) (Oracle11gDriver蟇ｾ蠢?PL/SQL繧ｳ繝ｼ繝ｫ縺ｮ蝣ｴ蜷医↓縲?繧ｯ繝ｭ繝ｼ繧ｺ縺輔ｌ縺滓枚縺ｧ縺吶?"縺ｮ繧ｨ繝ｩ繝ｼ縺檎匱逕溘☆繧句撫鬘後↓蟇ｾ蠢?
337             * @og.rev 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
338             * @og.rev 5.2.2.0 (2010/11/01) 謾ｹ陦後ｒ蜷ｫ繧??蜷医?縲√ム繝悶Ν繧ｯ繧ｪ繝ｼ繝医ｒ蠑ｷ蛻ｶ逧?↓蜑榊ｾ後↓霑ｽ蜉?☆繧九?
339             * @og.rev 5.2.2.0 (2010/11/01) 繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ蜷ｫ繧??蜷医?縲√◎縺ｮ逶ｴ蜑阪↓繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ蠑ｷ蛻ｶ逧?↓霑ｽ蜉?☆繧九?
340             * @og.rev 5.3.0.0 (2010/12/01) executeCall 繝｡繧ｽ繝?ラ縺ｮ蠑墓焚隕狗峩縺?
341             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
342             * @og.rev 5.5.7.1 (2012/10/05) useNumber縺ｮ霑ｽ蜉?
343             *
344             * @param   out PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
345             *
346             * @return      讀懃ｴ｢莉ｶ謨ｰ
347             */
348            private int create( final PrintWriter out )  {
349                    final int executeCount;
350                    Statement stmt = null;
351                    CallableStatement callStmt = null; // 4.3.4.3 (2008/12/22)
352                    ResultSet resultSet = null ;
353                    boolean errFlag = true;
354    //              Connection conn  = null;
355                    Transaction tran = null;        // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
356                    try {
357                            // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
358                            TransactionTag tranTag = (TransactionTag)findAncestorWithClass( this,TransactionTag.class );
359                            if( tranTag == null ) {
360    //                              tran = new TransactionReal( dbid,getApplicationInfo() );
361                                    tran = new TransactionReal( getApplicationInfo() );             // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
362                            }
363                            else {
364                                    tran = tranTag.getTransaction();
365                            }
366    //                      conn = ConnectionFactory.connection( dbid,getApplicationInfo() );       // 3.8.7.0 (2006/12/15)
367    
368                            Connection conn = tran.getConnection( dbid );                   // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
369                            // 3.6.1.0 (2005/01/05)
370                            if( queryType ) {               // JDBC 騾壼ｸｸ縺ｮ SELECT 譁?
371                                    stmt = conn.createStatement();
372                                    if( fetchSize > 0 ) { stmt.setFetchSize( fetchSize ); }
373                                    resultSet = stmt.executeQuery( sql );
374                            }
375                            else {                                  // PL/SQL Call 譁?
376                                    String[] values = null;
377                                    if( names != null ) {
378                                            String[] nameArray = StringUtil.csv2Array( names );
379                                            values = getRequest( nameArray );
380                                    }
381                                    callStmt  = conn.prepareCall( sql );
382    //                              resultSet = executeCall( conn,callStmt,sql,values );    // 4.3.4.3 (2008/12/22)
383                                    resultSet = executeCall( conn,callStmt,values );                // 5.3.0.0 (2010/12/01)
384                            }
385                            if( resultSet == null ) { return 0; }
386    
387                            ResultSetMetaData metaData  = resultSet.getMetaData();
388                            int numberOfColumns =  metaData.getColumnCount();
389    
390                            // 繝倥ャ繝??驛ｨ縺ｮ蜃ｺ蜉?
391                            if( useHeader && numberOfColumns > 0 ) {
392                                    StringBuilder headName  = new StringBuilder();
393                                    StringBuilder headLabel = new StringBuilder();
394                                    headName.append( "#Name" );
395                                    headLabel.append( "#Label" );
396                                    String clm ;
397                                    ResourceManager resource = getResource();
398                                    for(int column = 1; column <= numberOfColumns; column++) {
399                                            clm = (metaData.getColumnLabel(column)).toUpperCase(Locale.JAPAN);
400                                            headName.append( TAB_SEPARATOR ).append( clm );
401                                            headLabel.append( TAB_SEPARATOR ).append( resource.getLabel( clm ) );
402                                    }
403                                    out.println( headName.toString() );
404                                    out.println( headLabel.toString() );
405                            }
406    
407                            int rowNo = 0;
408                            Object obj ;
409                            while( resultSet.next() ) {
410                                    if( useNumber ){ // 5.5.7.1 (2012/10/05)
411                                            out.print( rowNo );                             // 陦檎分蜿ｷ
412                                    }
413                                    for(int column = 1; column <= numberOfColumns; column++) {
414                                            if( column == 1 && !useNumber && !useHeader ){ // 5.5.7.1 (2012/10/05)
415                                                    //縺薙?蝣ｴ蜷医□縺代そ繝代Ξ繝ｼ繧ｿ蜃ｺ蜉帙＠縺ｪ縺?
416                                            }
417                                            else{
418                                                    out.print( separator );
419                                            }
420                                            obj = resultSet.getObject(column);
421                                            if( obj != null ) {
422    //                                              out.print( obj );
423                                                    // 5.2.2.0 (2010/11/01) 謾ｹ陦後?繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝育ｭ峨?蜃ｦ逅?
424                                                    String sval = obj.toString();
425                                                    if( sval.indexOf( '"' ) >= 0 ) { sval = sval.replaceAll( "\"" ,"\"\"" ) ; }
426                                                    if( sval.indexOf( HybsSystem.CR ) >= 0 ) {
427                                                            sval = "\"" + sval + "\"" ;
428                                                    }
429                                                    out.print( sval );
430                                            }
431                                    }
432                                    out.println();
433                                    rowNo++ ;
434                            }
435                            executeCount = rowNo ;
436                            errFlag = false;                // 繧ｨ繝ｩ繝ｼ縺ｧ縺ｯ縺ｪ縺?
437                    }
438                    catch ( SQLException ex ) {             // 3.6.1.0 (2005/01/05)
439                            String errMsg = "繝??繧ｿ繝吶?繧ｹ蜃ｦ逅?ｒ螳溯｡後〒縺阪∪縺帙ｓ縺ｧ縺励◆縲?
440                                                     + HybsSystem.CR + stmt + HybsSystem.CR
441                                                     + "err=[" + ex.getSQLState() + "]"
442                                                     + ex.getMessage();
443                            throw new HybsSystemException( errMsg,ex );
444                    }
445                    finally {
446                            Closer.resultClose( resultSet );
447                            Closer.stmtClose( stmt );
448                            Closer.stmtClose( callStmt );   // 4.3.4.3 (2008/12/22)
449                            if( tran != null ) {                            // 5.5.2.6 (2012/05/25) findbugs蟇ｾ蠢?
450                                    tran.close( errFlag );                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
451                            }
452    //                      if( errFlag ) { ConnectionFactory.remove( conn,dbid ); }        // 蜑企勁
453    //                      else {                  ConnectionFactory.close( conn,dbid );  }        // 霑泌唆
454    //                      conn = null;
455                    }
456    
457                    return executeCount ;
458            }
459    
460            /**
461             * 蠑墓焚驟榊?莉倥?繧ｯ繧ｨ繝ｪ繝ｼ繧貞ｮ溯｡後＠縺ｾ縺吶?
462             * 蜃ｦ逅??菴薙?, #execute() 縺ｨ蜷梧ｧ倥↓縲∝推繧ｵ繝悶け繝ｩ繧ｹ縺ｮ螳溯｣?↓萓晏ｭ倥＠縺ｾ縺吶?
463             * 縺薙ｌ縺ｯ縲，allableStatement 繧堤畑縺?※縲√ョ繝ｼ繧ｿ繝吶?繧ｹ讀懃ｴ｢蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
464             * {call TYPE3B01.TYPE3B01(?,?,?,?)} 縺ｧ縲?ｼ皮分逶ｮ縺ｮ蠑墓焚縺ｫ縺ｯ縲?
465             * names 縺ｧ謖?ｮ壹＠縺溘Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺後?ARG_ARRAY 驟榊?縺ｫ鬆?ｬ｡繧ｻ繝?ヨ縺輔ｌ縺ｾ縺吶?
466             * 菴ｿ逕ｨ縺吶ｋ蝣ｴ蜷医?縲∽ｸ?率繧上°繧頑?縺?､画焚縺ｫ蜿励￠縺ｦ蛻ｩ逕ｨ縺励※縺上□縺輔＞縲?
467             * 蜻ｼ縺ｳ蜃ｺ縺?PL/SQL 縺ｧ縺ｯ縲∵､懃ｴ｢邉ｻPL/SQL 縺ｧ縺吶?
468             *
469             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
470             * @og.rev 4.3.4.3 (2008/12/22) (Oracle11gDriver蟇ｾ蠢?PL/SQL繧ｳ繝ｼ繝ｫ縺ｮ蝣ｴ蜷医↓縲?繧ｯ繝ｭ繝ｼ繧ｺ縺輔ｌ縺滓枚縺ｧ縺吶?"縺ｮ繧ｨ繝ｩ繝ｼ縺檎匱逕溘☆繧句撫鬘後↓蟇ｾ蠢?
471             * @og.rev 5.3.0.0 (2010/12/01) executeCall 繝｡繧ｽ繝?ラ縺ｮ蠑墓焚隕狗峩縺?
472             * @og.rev 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
473             * @og.rev 5.7.2.3 (2014/01/31) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢懊?縲〃er5 縺ｧ縺ｯ陦後ｏ縺ｪ縺?謌ｻ縺?縲?
474             *
475             * @param       conn            繧ｳ繝阪け繧ｷ繝ｧ繝ｳ
476             * @param   callStmt    繧ｳ繝ｼ繝ｩ繝悶Ν繧ｹ繝??繝医Γ繝ｳ繝?
477             * @param   args                繧ｪ繝悶ず繧ｧ繧ｯ繝医?蠑墓焚驟榊?
478             *
479             * @return      邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝?
480             */
481    //      private ResultSet executeCall( final Connection conn,final CallableStatement callStmt,final String sql,final String[] args ) throws SQLException {
482            private ResultSet executeCall( final Connection conn,final CallableStatement callStmt,final String[] args ) throws SQLException {
483    //              CallableStatement callStmt = null ; // 4.3.4.3 (2008/12/22)
484                    ResultSet resultSet = null;
485    //              try {
486    //                      callStmt  = conn.prepareCall( sql );
487                            callStmt.setQueryTimeout( DB_MAX_QUERY_TIMEOUT );
488                            if( fetchSize > 0 ) { callStmt.setFetchSize( fetchSize ); }
489                            Map<String,Class<?>> map = conn.getTypeMap();
490                            try {
491                                    map.put( ERR_MSG,Class.forName( "org.opengion.hayabusa.db.DBErrMsg" ) );
492                            }
493                            catch( ClassNotFoundException ex ) {
494                                    String errMsg = "org.opengion.hayabusa.db.DBErrMsg 繧ｯ繝ｩ繧ｹ縺瑚ｦ九▽縺九ｊ縺ｾ縺帙ｓ縲? + HybsSystem.CR
495                                                    + ex.getMessage();                      // // 5.1.8.0 (2010/07/01) errMsg 菫ｮ豁｣
496                                    throw new HybsSystemException( errMsg,ex );             // 3.5.5.4 (2004/04/15) 蠑墓焚縺ｮ荳ｦ縺ｳ鬆?､画峩
497                            }
498    
499                            // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?http://docs.oracle.com/cd/E28389_01/web.1111/b60995/thirdparty.htm
500                            ArrayDescriptor sd = ArrayDescriptor.createDescriptor( ARG_ARRAY, conn );
501                            ARRAY newArray = new ARRAY( sd,conn,StringUtil.rTrims( args ) );
502    //                      Array newArray = ((OracleConnection)conn).createOracleArray( ARG_ARRAY, StringUtil.rTrims( args ));             // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
503    
504                            callStmt.registerOutParameter(1, Types.INTEGER);
505                            callStmt.registerOutParameter(2, OracleTypes.ARRAY,ERR_MSG_ARRAY);      // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
506    //                      callStmt.registerOutParameter(2, Types.ARRAY,ERR_MSG_ARRAY);            // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
507                            callStmt.registerOutParameter(3, OracleTypes.CURSOR);
508                            ((OracleCallableStatement)callStmt).setARRAY( 4,newArray );                     // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
509    //                      callStmt.setArray( 4,newArray );                                                                        // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
510    
511                            callStmt.execute();
512    
513                            errCode = callStmt.getInt(1);
514    
515                            if( errCode < ErrorMessage.NG ) {            // 逡ｰ蟶ｸ莉･螟悶?蝣ｴ蜷?
516                                    resultSet = ((OracleCallableStatement)callStmt).getCursor(3);
517                            }
518                            if( errCode > ErrorMessage.OK ) {            // 豁｣蟶ｸ莉･螟悶?蝣ｴ蜷?
519                                    ARRAY rtn3 = ((OracleCallableStatement)callStmt).getARRAY(2);   // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
520    //                              Array rtn3 = callStmt.getArray(2);                                                              // 5.7.2.2 (2014/01/24) Oracle11g(11.2.0.3縺ｮ繝峨Λ繧､繝?蟇ｾ蠢?
521                                    Object[] rtnval3 = (Object[])rtn3.getArray();
522                                    errMessage = new ErrorMessage( "Query_JDBCErrMsg Error!!" );
523                                    for( int i=0; i<rtnval3.length; i++ ) {
524                                            DBErrMsg er = (DBErrMsg)rtnval3[i];
525                                            if( er == null ) { break; }
526                                            errMessage.addMessage( er.getErrMsg() );
527                                    }
528                            }
529    //              }
530    //              finally {
531    //                      Closer.stmtClose( callStmt );
532    //                      callStmt = null;
533    //              }
534                    return resultSet;
535            }
536    
537            /**
538             * PrintWriter 繧貞叙蠕励＠縺ｾ縺吶?
539             *
540             * 縺薙％縺ｧ縺ｯ縲∽ｸ?握逧?↑繝輔ぃ繧､繝ｫ蜃ｺ蜉帙ｒ閠??縺励◆ PrintWriter 繧剃ｽ懈?縺励∪縺吶?
541             *
542             * @og.rev 3.7.1.1 (2005/05/23) 繝輔か繝ｫ繝?′縺ｪ縺??蜷医?縲∬､?焚髫主ｱ､蛻??繝輔か繝ｫ繝?ｒ閾ｪ蜍輔〒菴懈?縺励∪縺吶?
543             * @og.rev 3.8.0.0 (2005/06/07) FileUtil#getPrintWriter 繧貞茜逕ｨ縲?
544             * @og.rev 5.6.1.0 (2013/02/01) 3.7.1.1縺ｮ繧ｳ繝｡繝ｳ繝医↓蜈･縺｣縺ｦ縺?ｋ縺悟ｯｾ蠢懊＆繧後※縺?↑縺??縺ｧ繝輔か繝ｫ繝?ｽ懈?霑ｽ蜉?
545             *
546             * @return       蜃ｺ蜉帷畑PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
547             */
548            private PrintWriter getPrintWriter() {
549                    if( filename == null ) {
550                            String errMsg = "繝輔ぃ繧､繝ｫ蜷阪′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?;
551                            throw new HybsSystemException( errMsg );
552                    }
553                    String directory = HybsSystem.url2dir( fileURL );
554                    
555                    // 5.6.1.0 (2013/02/01) 
556                    File dir = new File(directory);
557                    if( ! dir.exists() && ! dir.mkdirs() ) {
558                            String errMsg = "繝?ぅ繝ｬ繧ｯ繝医Μ縺ｮ菴懈?縺ｫ螟ｱ謨励＠縺ｾ縺励◆縲?" + directory + "]";
559                            throw new HybsSystemException( errMsg );
560                    }
561    
562    
563                    // 窶ｻ 豕ｨ諢?StringUtil.urlAppend 繧堤ｵ?∩霎ｼ繧薙〒縺?ｋ諢丞峙縺御ｸ肴?縲ゆｸ?率蜑企勁縺励※縺?∪縺吶′縲∵ｳｨ諢?
564                    // 3.8.0.0 (2005/06/07) FileUtil#getPrintWriter 繧貞茜逕ｨ縲?
565            //      out = FileUtil.getPrintWriter( StringUtil.urlAppend( directory,filename ),fileAppend,encode);
566    
567    //              蜃ｦ逅?ｒ邁｡邏?喧縺励∪縺吶?
568    //              PrintWriter out = FileUtil.getPrintWriter( new File( directory,filename ),encode,fileAppend );
569    //              return out ;
570                    return FileUtil.getPrintWriter( new File( directory,filename ),encode,fileAppend );
571            }
572    
573            /**
574             * 蜷咲ｧｰ驟榊?繧貞?縺ｫ縲√Μ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ縺ｮ繝??繧ｿ繧貞叙蠕励＠縺ｾ縺吶?
575             *
576             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
577             *
578             * @param       nameArray       繧ｭ繝ｼ縺ｨ縺ｪ繧句錐遘ｰ縺ｮ驟榊?
579             *
580             * @return      縺昴?繝ｪ繧ｯ繧ｨ繧ｹ繝域ュ蝣ｱ
581             */
582            private String[] getRequest( final String[] nameArray ) {
583                    String[] rtn = new String[nameArray.length];
584    
585                    for( int i=0; i<rtn.length; i++ ) {
586                            rtn[i] = getRequestValue( nameArray[i] );
587                    }
588    
589                    return rtn;
590            }
591    
592            /**
593             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)縲?
594             *
595             * @og.tag
596             *   讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?蛻晄悄蛟､縺ｯ縲．EFAULT 縺ｧ縺吶?
597             *
598             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
599             */
600            public void setDbid( final String id ) {
601                    dbid = nval( getRequestParameter( id ),dbid );
602            }
603    
604            /**
605             * 縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?
606             *              (蛻晄悄蛟､:TAB_SEPARATOR[={@og.value #TAB_SEPARATOR}])縲?
607             *
608             * @og.tag 蜿ｯ螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
609             * (蛻晄悄蛟､:繝ｭ繝ｼ繧ｫ繝ｫ螳夂ｾｩ縺ｮTAB_SEPARATOR[={@og.value #TAB_SEPARATOR}])縲?
610             *
611             * @param   sep 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
612             * @see         #TAB_SEPARATOR
613             */
614            public void setSeparator( final String sep ) {
615                    separator = nval( getRequestParameter( sep ),TAB_SEPARATOR );
616            }
617    
618            /**
619             * 縲慎AG縲台ｿ晏ｭ伜?繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?
620             *              (蛻晄悄蛟､:FILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
621             *
622             * @og.tag
623             * 縺薙?螻樊?縺ｧ謖?ｮ壹＆繧後ｋ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√ヵ繧｡繧､繝ｫ繧偵そ繝ｼ繝悶＠縺ｾ縺吶?
624             * 謖?ｮ壽婿豕輔?縲??蟶ｸ縺ｮ fileURL 螻樊?縺ｨ蜷梧ｧ倥↓縲∝?鬆ｭ縺後?'/' (UNIX) 縺ｾ縺溘?縲?ｼ呈枚蟄礼岼縺後?
625             * ":" (Windows)縺ｮ蝣ｴ蜷医?縲∵欠螳壹?URL縺昴?縺ｾ縺ｾ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√◎縺?〒縺ｪ縺??蜷医?縲?
626             * fileURL = "{&#064;USER.ID}" 縺ｨ謖?ｮ壹☆繧九→縲：ILE_URL 螻樊?縺ｧ謖?ｮ壹?繝輔か繝ｫ繝??荳九↓縲?
627             * 縺輔ｉ縺ｫ縲∝推蛟倶ｺｺID蛻･縺ｮ繝輔か繝ｫ繝?ｒ菴懈?縺励※縲√◎縺薙↓繧ｻ繝ｼ繝悶＠縺ｾ縺吶?
628             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
629             *
630             * @og.rev 3.5.4.3 (2004/01/05) 蜀?Κ蜃ｦ逅?ｒ縲［akeFileURL 縺ｫ遘ｻ蜍輔?
631             * @og.rev 4.0.0.0 (2005/01/31) StringUtil.urlAppend 繝｡繧ｽ繝?ラ縺ｮ蛻ｩ逕ｨ
632             * @og.rev 4.0.0.0 (2007/11/20) 謖?ｮ壹＆繧後◆繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪?譛?ｾ後′"\"or"/"縺ｧ邨ゅｏ縺｣縺ｦ縺?↑縺??蜷医↓縲?/"繧剃ｻ伜刈縺吶ｋ縲?
633             *
634             * @param       url 菫晏ｭ伜?繝?ぅ繝ｬ繧ｯ繝医Μ蜷?
635             * @see         org.opengion.hayabusa.common.SystemData#FILE_URL
636             */
637            public void setFileURL( final String url ) {
638                    String furl = nval( getRequestParameter( url ),null );
639                    if( furl != null ) {
640                            char ch = furl.charAt( furl.length()-1 );
641                            if( ch != '/' && ch != '\\' ) { furl = furl + "/"; }
642                            fileURL = StringUtil.urlAppend( fileURL,furl );
643                    }
644            }
645    
646            /**
647             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｷ繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ縺ｮFILE_FILENAME)縲?
648             *
649             * @og.tag 繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
650             *
651             * @param   fname 繝輔ぃ繧､繝ｫ蜷?
652             */
653            public void setFilename( final String fname ) {
654                    filename = nval( getRequestParameter( fname ),filename );
655            }
656    
657            /**
658             * 縲慎AG縲岨IP繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?ZIP繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:filename + ".zip")縲?
659             *
660             * @og.tag
661             * zip 螻樊?縺ｫ縲》rue 繧呈欠螳壹＠縺溷?蜷医↓縲〇IP繝輔ぃ繧､繝ｫ蛹悶＠縺ｾ縺吶?縺昴?蝣ｴ蜷医?繝輔ぃ繧､繝ｫ蜷阪ｒ謖?ｮ壹＠縺ｾ縺吶?
662             * 縺ｪ縺ｫ繧よ欠螳壹＠縺ｪ縺??蜷医?縲’ilename + ".zip" 縺ｫ縺ｪ繧翫∪縺吶?
663             *
664             * @param   zipFile ZIP繝輔ぃ繧､繝ｫ蜷?
665             * @see #setZip( String )
666             */
667            public void setZipFilename( final String zipFile ) {
668                    zipFilename = nval( getRequestParameter( zipFile ),zipFilename );
669            }
670    
671            /**
672             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
673             *              (蛻晄悄蛟､:FILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
674             *
675             * @og.tag
676             * "DEFAULT","JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
677             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
678             *
679             * @og.rev 2.2.0.0 (2002/12/17) 荳ｭ蝗ｽ隱?蝗ｽ髫帛喧)蟇ｾ蠢?繧ｨ繝ｳ繧ｳ繝ｼ繝峨?蜿門ｾ玲婿豕募､画峩
680             * @og.rev 3.1.3.0 (2003/04/10) FILE_ENCODE 縺九ｉ縲√お繝ｳ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙蠕励☆繧九?
681             *
682             * @param   enc 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷?
683             * @see     <a href="http://www.iana.org/assignments/character-sets">IANA Charset Registry</a>
684             * @see         org.opengion.hayabusa.common.SystemData#FILE_ENCODE
685             */
686            public void setEncode( final String enc ) {
687                    encode = nval( getRequestParameter( enc ),encode );
688            }
689    
690            /**
691             * 縲慎AG縲代?繝?ム繝ｼ繧呈嶌縺崎ｾｼ繧?°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
692             *
693             * @og.tag
694             *  #Name ?･?･?･?･ 繝倥ャ繝??縺ｮ譖ｸ縺崎ｾｼ縺ｿ繧呈欠螳壹＠縺ｾ縺吶?
695             * 騾壼ｸｸ縺ｯ縲∵嶌縺崎ｾｼ縺ｿ(true)縺ｫ縺励※縺翫″縲∽ｽｿ逕ｨ蛛ｴ縺ｧ繧ｳ繝｡繝ｳ繝医→隗｣驥医☆繧九ｈ縺?↓
696             * 蜃ｦ逅?ｒ陦後≧縺ｹ縺阪〒縺吶?繧ｳ繝｡繝ｳ繝医?縺溘ａ縲∥ppend 繝｢繝ｼ繝峨〒騾比ｸｭ縺ｫ迴ｾ繧後※繧?
697             * 辟｡隕悶〒縺阪∪縺吶?縺ｾ縺溘?繧ｨ繝ｳ繧ｸ繝ｳ讓呎ｺ悶〒繝??繧ｿ繧貞叙繧願ｾｼ繧??蜷医↓縲√ョ繝ｼ繧ｿ縺ｮ驟咲ｽｮ縺?
698             * 螟画峩縺輔ｌ縺ｦ繧ょ叙繧願ｾｼ縺ｿ繝励Ο繧ｰ繝ｩ繝??縺昴?縺ｾ縺ｾ菴ｿ逕ｨ縺ｧ縺阪∪縺吶?
699             * 蛻晄悄蛟､縺ｯ縲》rue(譖ｸ縺崎ｾｼ繧?縺ｧ縺吶?
700             *
701             * @param   flag 繝倥ャ繝??繧呈嶌縺崎ｾｼ繧?°縺ｩ縺?° [true:譖ｸ縺崎ｾｼ繧?false:譖ｸ縺崎ｾｼ縺ｾ縺ｪ縺Ь
702             */
703            public void setUseHeader( final String flag ) {
704                    useHeader = nval( getRequestParameter( flag ),useHeader );
705            }
706    
707            /**
708             * 縲慎AG縲題ｿｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ繧?°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[騾壼ｸｸ繝｢繝ｼ繝云)縲?
709             *
710             * @og.tag
711             * 繝輔ぃ繧､繝ｫ繧呈嶌縺崎ｾｼ繧??蜷医?霑ｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ繧?°縺ｩ縺?°繧偵そ繝?ヨ縺励∪縺吶?
712             * 譁ｰ隕上Δ繝ｼ繝?true)縺ｮ蝣ｴ蜷医?譌｢蟄倥?繝輔ぃ繧､繝ｫ縺悟ｭ伜惠縺励?縺九▽譖ｸ縺崎ｾｼ縺ｿ險ｱ蜿ｯ縺後≠繧後?縲?
713             * 荳頑嶌縺阪〒譁ｰ隕上↓菴懈?縺励∪縺吶?
714             * 蛻晄悄蛟､縺ｯ縲’alse(譁ｰ隕上Δ繝ｼ繝?縺ｧ縺吶?
715             *
716             * @param   flag [true:霑ｽ蜉?Δ繝ｼ繝?false:譁ｰ隕上Δ繝ｼ繝云
717             */
718            public void setFileAppend( final String flag ) {
719                    fileAppend = nval( getRequestParameter( flag ),fileAppend );
720            }
721    
722            /**
723             * 縲慎AG縲醍ｵ先棡繧偵ヵ繧｡繧､繝ｫ縺ｫ蜃ｺ蜉帙☆繧九→縺阪↓縲〇IP縺ｧ蝨ｧ邵ｮ縺吶ｋ縺九←縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
724             *
725             * @og.tag
726             * 螟ｧ驥上↓謚懊″蜃ｺ縺吝?蜷医?縺昴?縺ｾ縺ｾ縲√し繝ｼ繝舌?縺九ｉ蜿悶ｊ蜃ｺ縺吶□縺代〒繧ょ､ｧ螟峨〒縺吶?
727             * zip 螻樊?繧偵?true 縺ｫ縺吶ｋ縺ｨ縲；ZIP 縺ｧ蝨ｧ邵ｮ縺励◆繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺励∪縺吶?
728             * 蛻晄悄蛟､縺ｯ縲’alse(蝨ｧ邵ｮ縺励↑縺?縺ｧ縺吶?
729             *
730             * @param  flag ZIP縺ｧ蝨ｧ邵ｮ [true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
731             * @see    #setZipFilename( String )
732             */
733            public void setZip( final String flag ) {
734                    zip = nval( getRequestParameter( flag ),zip );
735            }
736    
737            /**
738             * 縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0033[縲?ｻｶ讀懃ｴ｢縺励∪縺励◆])縲?
739             *
740             * @og.tag
741             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
742             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ
743             * 陦ｨ遉ｺ縺励∪縺吶?
744             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
745             * 蛻晄悄蛟､縺ｯ縲∵､懃ｴ｢莉ｶ謨ｰ繧定｡ｨ遉ｺ縺励∪縺吶?
746             *
747             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
748             */
749            public void setDisplayMsg( final String id ) {
750                    String ids = getRequestParameter( id );
751                    if( ids != null ) { displayMsg = ids; }
752            }
753    
754            /**
755             * 縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])縲?
756             *
757             * @og.tag
758             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ縲∫音蛻･縺ｪ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
759             * 蠕捺擂縺ｯ縲‥isplayMsg 縺ｨ蜈ｼ逕ｨ縺ｧ縲√?0縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲上→縺?≧陦ｨ遉ｺ縺ｧ縺励◆縺後?
760             * displayMsg 縺ｮ蛻晄悄陦ｨ遉ｺ縺ｯ縲＾FF 縺ｫ縺ｪ繧翫∪縺励◆縺ｮ縺ｧ縲√ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ蛻･縺ｫ陦ｨ遉ｺ縺輔○縺ｾ縺吶?
761             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, notfoundMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
762             * 蛻晄悄蛟､縺ｯ縲｀SG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆]縺ｧ縺吶?
763             *
764             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
765             */
766            public void setNotfoundMsg( final String id ) {
767                    String ids = getRequestParameter( id );
768                    if( ids != null ) { notfoundMsg = ids; }
769            }
770    
771            /**
772             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ繝輔ぉ繝?メ繧ｵ繧､繧ｺ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:100)縲?
773             *
774             * @og.tag
775             * 繧医ｊ螟壹￥縺ｮ陦後′蠢?ｦ√↑縺ｨ縺阪↓縲√ョ繝ｼ繧ｿ繝吶?繧ｹ縺九ｉ蜿悶ｊ蜃ｺ縺吝ｿ?ｦ√′縺ゅｋ陦梧焚縺ｫ
776             * 縺､縺?※縺ｮ繝偵Φ繝医ｒ JDBC 繝峨Λ繧､繝舌↓謠蝉ｾ帙＠縺ｾ縺吶?
777             * 謖?ｮ壹＆繧後◆陦梧焚縺ｯ縲√％縺ｮ Statement 繧剃ｽｿ縺｣縺ｦ菴懈?縺輔ｌ縺溽ｵ先棡繧ｻ繝?ヨ縺ｫ縺?￠蠖ｱ髻ｿ縺励∪縺吶?
778             * 謖?ｮ壹＆繧後◆蛟､縺?0 縺ｮ蝣ｴ蜷医?繝偵Φ繝医?辟｡隕悶＆繧後∪縺吶?
779             * 蛻晄悄蛟､縺ｯ縲?00 縺ｧ縺吶?
780             *
781             * @param       size 繝輔ぉ繝?メ縺吶ｋ陦梧焚(蛻晄悄蛟､:100)
782             */
783            public void setFetchSize( final String size ) {
784                    fetchSize = nval( getRequestParameter( size ),fetchSize );
785            }
786    
787            /**
788             * 縲慎AG縲善L/SQL繧貞茜逕ｨ縺吶ｋ蝣ｴ蜷医?蠑墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
789             *
790             * @og.tag
791             * 隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ励〒貂｡縺励∪縺吶?
792             * PL/SQL 繧剃ｽｿ逕ｨ縺励↑縺??蜷医?縲∫┌隕悶＆繧後∪縺吶?
793             *
794             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
795             *
796             * @param       nm 蠑墓焚縺ｮ蜷咲ｧｰ(隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ?
797             */
798            public void setNames( final String nm ) {
799                    names = nval( getRequestParameter( nm ),names );
800            }
801    
802            /**
803             * 縲慎AG縲漸uery 繧堤匱陦後☆繧狗ぜ縺ｮ繧ｯ繝ｩ繧ｹID(JDBC,JDBCErrMsg)繧呈欠螳壹＠縺ｾ縺?{@og.doc03Link queryType 蛻晄悄蛟､:JDBC})縲?
804             *
805             * @og.tag
806             * 繧ｹ繝医い繝峨?繝ｭ繧ｷ繝ｼ繧ｸ繝｣遲峨ｒ螳溯｡後☆繧句?蜷医↓縲〈ueryType="JDBCErrMsg" 繧?
807             * 謖?ｮ壹☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?(縺昴ｌ莉･螟悶?謖?ｮ壹?縲∝?譛溷?縺ｮ JDBC 縺ｫ縺ｪ繧翫∪縺吶?)
808             * 蛻晄悄蛟､縺ｯ縲?JDBC" 縺ｧ縺吶?
809             * {@og.doc03Link queryType Query_**** 繧ｯ繝ｩ繧ｹ}
810             *
811             * @og.rev 3.6.1.0 (2005/01/05) PL/SQL繧ｳ繝ｼ繝ｫ(JDBCErrMsg 蠖｢蠑?縺ｸ縺ｮ蟇ｾ蠢?
812             *
813             * @param       id Query 繧堤匱陦後☆繧狗ぜ縺ｮ螳溘け繝ｩ繧ｹ ID
814             */
815            public void setQueryType( final String id ) {
816                    // 蜀?Κ逧?↓縺ｯ縲゛DBCErrMsg:false / 縺昴ｌ莉･螟?true 縺ｧ邂｡逅?＠縺ｦ縺?∪縺吶?
817                    queryType = ! "JDBCErrMsg".equalsIgnoreCase( getRequestParameter( id ) );
818            }
819    
820            /**
821             * 縲慎AG縲代ヵ繧｡繧､繝ｫ縺ｫ陦檎分蜿ｷ繧貞?蜉帙☆繧九°縺ｩ縺?°(蛻晄悄蛟､:true)
822             *
823             * @og.tag
824             * 繝輔ぃ繧､繝ｫ縺ｫ陦檎分蜿ｷ繧貞?蜉帙☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺吶?
825             * 蛻晄悄蛟､縺ｯ縲》rue(蜃ｺ蜉帙☆繧?縺ｧ縺吶?
826             * 
827             * @og.rev 5.5.7.1 (2012/10/05) 譁ｰ隕剰ｿｽ蜉?
828             * @param  flag 陦檎分蜿ｷ蜃ｺ蜉?[true:縺吶ｋ/縺昴ｌ莉･螟?縺励↑縺Ь
829             */
830            public void setUseNumber( final String flag ) {
831                    useNumber = nval( getRequestParameter( flag ),useNumber );
832            }
833            
834            /**
835             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
836             *
837             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
838             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
839             *
840             * @param strm ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
841             * @throws IOException  繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ縺ｫ髢｢縺吶ｋ蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
842             */
843            private void writeObject( final ObjectOutputStream strm ) throws IOException {
844                    strm.defaultWriteObject();
845            }
846    
847            /**
848             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
849             *
850             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
851             *
852             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
853             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
854             *
855             * @param strm ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
856             * @see #release2()
857             */
858            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
859                    strm.defaultReadObject();
860            }
861    
862            /**
863             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
864             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
865             *
866             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
867             */
868            @Override
869            public String toString() {
870                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
871                                    .println( "VERSION"             ,VERSION        )
872                                    .println( "dbid"                ,dbid           )
873                                    .println( "separator"   ,separator      )
874                                    .println( "useHeader"   ,useHeader      )
875                                    .println( "fileURL"             ,fileURL        )
876                                    .println( "filename"    ,filename       )
877                                    .println( "zipFilename" ,zipFilename)
878                                    .println( "sql"                 ,sql            )
879                                    .println( "encode"              ,encode         )
880                                    .println( "fileAppend"  ,fileAppend     )
881                                    .println( "zip"                 ,zip            )
882                                    .println( "displayMsg"  ,displayMsg     )
883                                    .println( "dyStart"             ,dyStart        )
884                                    .println( "fetchSize"   ,fetchSize      )
885                                    .println( "queryType"   ,queryType      )
886                                    .println( "names"               ,names          )
887                                    .println( "errCode"             ,errCode        )
888                                    .println( "Other..."    ,getAttributes().getAttribute() )
889                                    .fixForm().toString() ;
890            }
891    }