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