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.DBTableModel;
021    import org.opengion.hayabusa.db.DBColumn;
022    import org.opengion.hayabusa.io.TableReader;
023    import org.opengion.fukurou.util.ErrorMessage;
024    import org.opengion.fukurou.util.FileUtil;
025    import org.opengion.fukurou.util.Closer ;
026    import org.opengion.fukurou.util.StringUtil ;
027    import static org.opengion.fukurou.util.StringUtil.nval ;
028    
029    import java.io.File;
030    import java.io.BufferedReader;
031    import java.util.Locale ;
032    import java.io.ObjectOutputStream;
033    import java.io.ObjectInputStream;
034    import java.io.IOException;
035    
036    /**
037     * 謖?ｮ壹?繝輔ぃ繧､繝ｫ繧?DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医↓隱ｭ縺ｿ蜿悶ｋ繝輔ぃ繧､繝ｫ蜈･蜉帙ち繧ｰ縺ｧ縺吶?
038     *
039     * 繝??繧ｿ(DBTableModel)縺ｨ縲√さ繝ｳ繝医Ο繝ｼ繝ｩ(ReadTable繧ｿ繧ｰ)繧剃ｸ弱∴縺ｦ縲∝､夜Κ縺九ｉ繧ｳ繝ｳ繝医Ο繝ｼ繝ｫ縺吶ｋ縺薙→縺ｧ縲?
040     * 蜷?ｨｮ蠖｢蠑上〒 繝??繧ｿ(DBTableModel)繧定｡ｨ遉ｺ縺輔○繧九％縺ｨ縺?縺ｧ縺阪∪縺吶?
041     * ReadTable繧ｿ繧ｰ 縺ｫ蟇ｾ縺励※縲√さ繝槭Φ繝峨ｒ荳弱∴繧九％縺ｨ縺ｫ繧医ｊ縲∝?驛ｨ縺ｮ繧ｳ繝ｳ繝医Ο繝ｼ繝ｩ縺ｮ螳溯｣?↓蟇ｾ蠢懊＠縺?
042     * 蠖｢蠑上〒繝??繧ｿ繧剃ｽ懈?縺励∪縺吶?
043     * 縺吶∋縺ｦ縺ｮ隱ｭ蜿悶?蛻晄悄繧ｯ繝ｩ繧ｹ蜷阪ｒ 繝ｪ繧ｽ繝ｼ繧ｹ繝輔ぃ繧､繝ｫ縺ｮ TABLE_READER_DEFAULT_CLASS 縺ｧ謖?ｮ壼庄閭ｽ縺ｧ縺吶?
044     * 縺昴?蝣ｴ蜷医?AutoReader 繧呈欠螳壹☆繧九→縲・xcel 縺ｨ Default(繝?く繧ｹ繝? 繧帝?逡ｪ縺ｫ隧ｦ縺励∪縺吶?
045     *
046     * 蜈･蜉帑ｻｶ謨ｰ繧?DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺励※縺?∪縺吶?
047     *
048     * @og.formSample
049     * 笳丞ｽ｢蠑擾ｼ?
050     *     &lt;og:readTable
051     *         command      = "NEW"
052     *         fileURL      = "{&#064;USER.ID}"     隱ｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷?
053     *         filename     = "{&#064;filename}"    隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷?
054     *         encode       = "UnicodeLittle"       隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝牙錐
055     *         maxRowCount  = "10000"               隱ｭ蜿匁怙螟ｧ莉ｶ謨ｰ(0:[辟｡蛻ｶ髯疹)
056     *     /&gt;
057     * 笳獣ody?壹↑縺?
058     *
059     * 笳週ag螳夂ｾｩ??
060     *   &lt;og:readTable
061     *       readerClass        縲慎AG縲大ｮ滄圀縺ｫ隱ｭ縺ｿ蜃ｺ縺吶け繝ｩ繧ｹ蜷阪?逡･遘ｰ(TableReader_**** 縺ｮ ****)繧偵そ繝?ヨ縺励∪縺?{@og.doc03Link readerClass 蛻晄悄蛟､:Default})
062     *       fileURL            縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:FILE_URL)
063     *       filename           縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:FILE_FILENAME[=file.xls])
064     *       encode             縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:FILE_ENCODE)
065     *       maxRowCount        縲慎AG縲題ｪｭ蜿匁凾縺ｮ譛?､ｧ蜿悶ｊ霎ｼ縺ｿ莉ｶ謨ｰ繧偵そ繝?ヨ縺励∪縺?(蛻晄悄蛟､:DB_MAX_ROW_COUNT[=1000])(0:[辟｡蛻ｶ髯疹)
066     *       separator          縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?
067     *       tableId            縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)session縺九ｉ謇?ｾ励☆繧?DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医? ID
068     *       command            縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)
069     *       modifyType         縲慎AG縲代ヵ繧｡繧､繝ｫ蜿悶ｊ霎ｼ縺ｿ譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝?A(霑ｽ蜉?,C(譖ｴ譁ｰ),D(蜑企勁))繧呈欠螳壹＠縺ｾ縺?
070     *       displayMsg         縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0033[縲?ｻｶ讀懃ｴ｢縺励∪縺励◆])
071     *       notfoundMsg        縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])
072     *       sheetName          縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:謖?ｮ壹↑縺?
073     *       sheetNos           縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝育分蜿ｷ繧定､?焚險ｭ螳壹〒縺阪∪縺?蛻晄悄蛟､:0)
074     *       sheetConstKeys     縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐(CSV蠖｢蠑?
075     *       sheetConstAdrs     縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?蝗ｺ螳壼?縺ｨ縺ｪ繧九い繝峨Ξ繧ｹ(陦?蛻?陦?蛻?繝ｻ繝ｻ繝ｻ)
076     *       nullBreakClm       縲慎AG縲代き繝ｩ繝??縺ｫ NULL 縺檎樟繧後◆譎らせ縺ｧ隱ｭ縺ｿ蜿悶ｊ繧剃ｸｭ豁｢縺励∪縺?隍?焚Sheet縺ｮ蝣ｴ蜷医?縲∵ｬ｡縺ｮSheet繧定ｪｭ縺ｿ縺ｾ縺?縲?
077     *       columns            縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??繧偵?螟夜Κ(繧ｿ繧ｰ)繧医ｊ謖?ｮ壹＠縺ｾ縺?
078     *       useNumber          縲慎AG縲題｡檎分蜿ｷ諠??繧偵?菴ｿ逕ｨ縺励※縺?ｋ/縺励※縺?↑縺Ъtrue/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
079     *       adjustColumns      縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繝??繧ｿ螟画鋤繧定｡後≧繧ｫ繝ｩ繝??繧偵き繝ｳ繝樊欠螳壹＠縺ｾ縺?
080     *       checkColumns       縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ謨ｴ蜷域?繝√ぉ繝?け繧定｡後≧繧ｫ繝ｩ繝??繧偵き繝ｳ繝樊欠螳壹＠縺ｾ縺?
081     *       nullCheck          縲慎AG縲鮮ULL 繝√ぉ繝?け縺吶∋縺阪き繝ｩ繝??繧偵き繝ｳ繝槫玄蛻?ｊ(CVS蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺?
082     *       language           縲慎AG縲代ち繧ｰ蜀?Κ縺ｧ菴ｿ逕ｨ縺吶ｋ險?ｪ槭さ繝ｼ繝閏ja/en/zh/窶ｦ]繧呈欠螳壹＠縺ｾ縺?
083     *       stopZero           縲慎AG縲題ｪｭ霎ｼ莉ｶ謨ｰ縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺榊?逅?ｒ邯夊｡後☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[邯夊｡後☆繧犠)
084     *       scope              縲慎AG縲代く繝｣繝?す繝･縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝夕request/page/session/applicaton]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
085     *       mainTrans          縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
086     *       skipRowCount       縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ繧定ｨｭ螳壹＠縺ｾ縺?
087     *       useRenderer        縲慎AG縲題ｪｭ蜿門?逅?〒繝ｩ繝吶Ν繧偵さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｫ騾?､画鋤繧定｡後≧縺九←縺?°繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:USE_TABLE_READER_RENDERER[=false])
088     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null) 5.7.7.2 (2014/06/20)
089     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null) 5.7.7.2 (2014/06/20)
090     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true) 5.7.7.2 (2014/06/20)
091     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true) 5.7.7.2 (2014/06/20)
092     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
093     *   /&gt;
094     *
095     * 笳丈ｽｿ逕ｨ萓?
096     *
097     *     &lt;og:readTable
098     *         command        = "NEW"
099     *         readerClass    = "Fixed"               蝗ｺ螳夐聞繝??繧ｿ縺ｮ隱ｭ縺ｿ蜿悶ｊ
100     *         modifyType     = "{&#064;modifyType}"  隱ｭ蜿匁凾縺ｮ繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝?A,C遲?
101     *         fileURL        = "{&#064;USER.ID}"     隱ｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷?
102     *         filename       = "{&#064;filename}"    隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷?
103     *         encode         = "Shift_JIS"           隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝牙錐
104     *         maxRowCount    = "10000"               隱ｭ蜿匁怙螟ｧ莉ｶ謨ｰ(0:[辟｡蛻ｶ髯疹)
105     *         columns        = "OYA,KO,HJO,SU,DYSTR,DYEND"   #NAME 縺ｫ蟇ｾ蠢懊☆繧九き繝ｩ繝??
106     *         useNumber      = "false"               陦檎分蜿ｷ縺ｮ蟄伜惠縺励↑縺?ョ繝ｼ繧ｿ繧定ｪｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
107     *         adjustColumns  = "OYA,KO,HJO,SU"       繝??繧ｿ螟画鋤縺吶ｋ繧ｫ繝ｩ繝??("*" 縺ｧ蜈ｨ繧ｫ繝ｩ繝?
108     *         checkColumns   = "OYA,KO,HJO,SU"       謨ｴ蜷域?繝√ぉ繝?け縺吶ｋ繧ｫ繝ｩ繝??("*" 縺ｧ蜈ｨ繧ｫ繝ｩ繝?
109     *         nullCheck      = "OYA,KO,SU"           NULL繝√ぉ繝?け繧貞ｮ溯｡後＠縺ｾ縺?"*" 縺ｧ蜈ｨ繧ｫ繝ｩ繝?
110     *         stopZero       = "true"                蜿門ｾ?莉ｶ縺ｮ蝣ｴ蜷医↓莉･髯阪?蜃ｦ逅?ｒ蛛懈ｭ｢縺励∪縺?
111     *         skipRowCount   = "4"                   繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ(隱ｭ縺ｿ霎ｼ縺ｿ髢句ｧ九?縲√％縺ｮ謨ｰ蟄暦ｼ具ｼ題｡檎岼縺九ｉ)
112     *     /&gt;
113     *
114     * @og.group 繝輔ぃ繧､繝ｫ蜈･蜉?
115     *
116     * @version  4.0
117     * @author   Kazuhiko Hasegawa
118     * @since    JDK5.0,
119     */
120    public class ReadTableTag extends CommonTagSupport {
121            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
122            private static final String VERSION = "5.7.7.2 (2014/06/20)" ;
123    
124            private static final long serialVersionUID = 577220140620L ;
125    
126            private static final int ERROR_ROW_COUNT = 200 ;        // 4.0.0 (2007/05/25)
127    
128            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 譁ｰ隕丈ｽ懈? {@value} */
129            public static final String CMD_NEW   = "NEW" ;
130            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 蜀肴､懃ｴ｢ {@value} */
131            public static final String CMD_RENEW = "RENEW" ;
132    
133            private static final String[] COMMAND_LIST = new String[] { CMD_NEW , CMD_RENEW };
134    
135            private String  separator               = TableReader.TAB_SEPARATOR;     // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
136            private String  fileURL                 = HybsSystem.sys( "FILE_URL" );
137            private String  filename                = HybsSystem.sys( "FILE_FILENAME"               );       // 繝輔ぃ繧､繝ｫ蜷?
138            private String  encode                  = HybsSystem.sys( "FILE_ENCODE"                 );       // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
139            private String  readerClass     = HybsSystem.sys( "TABLE_READER_DEFAULT_CLASS" );               // 3.8.5.3 (2006/08/07)
140            private int             maxRowCount             = -1;
141            private String  displayMsg              = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
142            private String  notfoundMsg             = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
143            private int     executeCount    = -1;                   // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
144            private String  modifyType              = null;
145            private String adjustColumns    = null;         // 3.6.0.2 (2004/10/04) 蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け
146            private String checkColumns             = null;         // 3.6.0.2 (2004/10/04) 蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け
147            private String nullCheck                = null;         // 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
148    
149            private transient DBTableModel table      = null;
150            private String          command         = CMD_NEW;
151            private String          tableId         = HybsSystem.TBL_MDL_KEY ;
152            private String          sheetName       = null ;                // 3.5.4.2 (2003/12/15)
153            private String          sheetNos        = null ;                // 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医ｒ謖?ｮ壹〒縺阪ｋ繧医≧縺ｫ繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲?
154            private String          sheetConstKeys  = null ;        // 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐(CSV蠖｢蠑?
155            private String          sheetConstAdrs  = null ;        // 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九い繝峨Ξ繧ｹ(陦?蛻?陦?蛻?繝ｻ繝ｻ繝ｻ)
156            private String          nullBreakClm    = null;         // 5.5.8.2 (2012/11/09) 蜿冶ｾｼ縺ｿ譚｡莉ｶ/Sheet BREAK譚｡莉ｶ
157    
158            // 3.5.4.5 (2004/01/23) 螟夜Κ繧医ｊ繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ)繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲?
159            private String          columns         = null;
160            private boolean         useNumber       = true;                 // 3.7.0.5 (2005/04/11)
161    
162            private boolean         stopZero        = false;                // 4.3.7.0 (2009/06/01) stopZero螻樊?霑ｽ蜉?
163    
164            // 5.1.8.0 (2010/07/01) AutoReader縺ｮCalc蟇ｾ蠢?
165            private static final String[] AUTO_READER_CLASS  = new String[] { "Excel","Calc","Default"      ,"Default"     };
166            private static final String[] AUTO_READER_ENCODE = new String[] { null   ,null  ,"UnicodeLittle","Windows-31J" };
167    
168            private boolean isMainTrans             = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
169            private int             skipRowCount    = 0;                    // 5.1.6.0 (2010/05/01) 繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺苓ｨｭ螳?
170    
171            // 5.2.1.0 (2010/10/01) 隱ｭ蜿門?逅?〒繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?°
172            private boolean useRenderer             = HybsSystem.sysBool( "USE_TABLE_READER_RENDERER" );    // 5.2.1.0 (2010/10/01)
173    
174            /**
175             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
176             *
177             * @og.rev 3.0.1.4 (2003/03/17) displayMsg 縺??殖yte縺ｮ蝣ｴ蜷医?縲∽ｻｶ謨ｰ繧り｡ｨ遉ｺ縺励↑縺?ｈ縺?↓螟画峩縲?
178             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
179             * @og.rev 3.5.4.1 (2003/12/01) 蠑墓焚縺ｮ BufferedReader 繧偵?InputStream 縺ｫ螟画峩縲?
180             * @og.rev 3.5.4.3 (2004/01/05) 蠑墓焚縺ｮ InputStream 繧偵? BufferedReader 縺ｫ謌ｻ縺吶?
181             * @og.rev 3.5.6.5 (2004/08/09) 證ｫ螳夂噪縺ｫ縲．BTableModel繧貞?陦悟炎髯､縺励∪縺吶?
182             * @og.rev 3.6.0.0 (2004/09/24) DBTableModel 縺ｮ蜈郁｡悟炎髯､縺ｯ縲《cope="session" 縺ｮ蝣ｴ蜷医?縺ｿ縲?
183             * @og.rev 3.6.0.2 (2004/10/04) 蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け逕ｨ縺ｫ縲…heckColumns,adjustColumns 螻樊?霑ｽ蜉?
184             * @og.rev 3.6.0.8 (2004/11/19) DBTableModel 繧偵そ繝ｼ繝悶☆繧区凾縺ｫ縲√ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
185             * @og.rev 3.8.5.3 (2006/08/07) readerClass縺?"Excel"縺ｧ繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺溘→縺阪?繧ゅ≧荳?ｺｦDefault縺ｧ蜀崎ｪｭ蜿悶ｒ陦後＞縺ｾ縺吶?
186             * @og.rev 4.0.0.0 (2007/10/12) checkTableColumn 蜑阪↓縲［odifyType 險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
187             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
188             * @og.rev 4.3.1.1 (2008/10/08) columns縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲、utoReader遖∵ｭ｢
189             * @og.rev 4.3.7.0 (2009/06/01) stopZero讖溯?,DB.COUNT繝ｪ繧ｯ繧ｨ繧ｹ繝医く繝ｼ縺ｸ隱ｭ霎ｼ莉ｶ謨ｰ繧ｻ繝?ヨ繧定ｿｽ蜉?
190             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
191             * @og.rev 5.1.8.0 (2010/07/01) AutoReader縺ｮCalc蟇ｾ蠢?
192             * @og.rev 5.1.9.0 (2010/08/01) AutoReader縺ｧ縺ｮException縺ｮ蛻､螳壹ｒThrowable縺ｫ螟画峩
193             * @og.rev 5.7.1.2 (2013/12/20) tempMsg.toString() 竍?errMsg 螟画峩
194             * @og.rev 5.7.7.2 (2014/06/20) caseKey,caseVal,caseNN,caseNull 螻樊?繧定ｿｽ蜉?
195             *
196             * @return      蠕檎ｶ壼?逅??謖?､ｺ
197             */
198            @Override
199            public int doEndTag() {
200                    debugPrint();           // 4.0.0 (2005/02/28)
201                    // 5.7.7.2 (2014/06/20) caseKey,caseVal,caseNN,caseNull 螻樊?繧定ｿｽ蜉?
202                    if( !useTag() ) { return EVAL_PAGE ; }
203    
204                    if( check( command, COMMAND_LIST ) ) {
205                            useMainTrans( isMainTrans );                    // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
206                            startQueryTransaction( tableId );               // 3.6.0.8 (2004/11/19)
207    
208                            // 3.5.6.5 (2004/08/09) 蜑企勁縺吶ｋ縺ｮ縺ｯ縲√そ繝?す繝ｧ繝ｳ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医〒繧医＞縲?
209                            // 3.6.0.0 (2004/09/24) 蜑企勁縺吶ｋ縺ｮ縺ｯ縲《cope="session" 縺ｮ蝣ｴ蜷医?縺ｿ縲?
210                            if( "session".equals( getScope() ) ) {
211                                    removeSessionAttribute( tableId );
212                                    removeSessionAttribute( HybsSystem.VIEWFORM_KEY );
213                            }
214    
215                            if( maxRowCount < 0 ) {
216                                    maxRowCount     = sysInt( "DB_MAX_ROW_COUNT" );
217                            }
218    
219                            // 繝輔ぃ繧､繝ｫ 縺ｮ隱ｭ縺ｿ霎ｼ縺ｿ?哂utoReader 蜃ｦ逅?
220                            BufferedReader pw = null;
221                            final String[] READER_CLASS  ;
222                            final String[] READER_ENCODE ;
223                            if( "AutoReader".equalsIgnoreCase( readerClass ) ) {
224                                    // 4.3.1.1 (2008/10/08)
225                                    if( columns != null && columns.length() > 0 ) {
226                                            String errMsg = "columns縺梧欠螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲〉eaderClass=\"AutoReader\"縺ｯ菴ｿ縺医∪縺帙ｓ";
227                                            throw new HybsSystemException( errMsg ); // 4.3.4.4 (2009/01/01)
228                                    }
229                                    READER_CLASS  = AUTO_READER_CLASS ;
230                                    READER_ENCODE = AUTO_READER_ENCODE;
231                            }
232                            else {
233                                    READER_CLASS  = new String[] { readerClass };
234                                    READER_ENCODE = new String[] { encode };
235                            }
236    
237                            StringBuilder tempMsg = new StringBuilder();
238                            for( int i=0; i<READER_CLASS.length; i++ ) {
239                                    readerClass = READER_CLASS[i];
240                                    encode      = READER_ENCODE[i];
241    
242                                    try {
243                                            // 5.1.8.0 (2010/07/01) AutoReader縺ｮCalc蟇ｾ蠢?
244                                            if( "Excel".equalsIgnoreCase( readerClass ) || "Calc".equalsIgnoreCase( readerClass ) ) {
245                                                    create( null );
246                                            }
247                                            else {
248                                                    pw = getBufferedReader();
249                                                    create( pw );
250                                            }
251                                            // 謌仙粥縺吶ｌ縺ｰ縲√お繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸ繧偵け繝ｪ繧｢縺励※縲√◎縺ｮ蝣ｴ縺ｧ謚懊￠繧九?
252                                            tempMsg = null;
253                                            break;
254                                    }
255                                    // 3.8.5.3 (2006/08/07) readerClass縺?"Excel"縺ｧ繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺溘→縺阪?繧ゅ≧荳?ｺｦDefault縺ｧ蜀崎ｪｭ蜿悶ｒ陦後＞縺ｾ縺吶?
256                                    // 5.1.9.0 (2010/08/01) RuntimeException邉ｻ縺ｮException縺後く繝｣繝?メ縺ｧ縺阪↑縺?◆繧√?Throwable縺ｧ蜿励￠繧?
257                                    catch( Throwable th ) {
258                                            tempMsg.append( "readerClass=["  ).append( readerClass )
259                                                            .append( "],encode=["    ).append( encode )
260                                                            .append( "] Error!"      ).append( HybsSystem.CR )
261                                                            .append( th.getMessage() ).append( HybsSystem.CR ) ;
262                                    }
263                                    finally {
264                                            Closer.ioClose( pw );           // 4.0.0 (2006/01/31) close 蜃ｦ逅?凾縺ｮ IOException 繧堤┌隕?
265                                    }
266                            }
267    
268                            if( tempMsg != null ) { // 譛?ｾ後∪縺ｧ繧ｨ繝ｩ繝ｼ縺後≠繧後?縲∽ｾ句､門?逅?ｒ逋ｺ陦後＠縺ｾ縺吶?
269                                    String errMsg = tempMsg.toString();
270                                    System.err.print( errMsg );
271                                    throw new HybsSystemException( errMsg );                // 5.7.1.2 (2013/12/20) msg 竍?errMsg 螟画峩
272                            }
273    
274                            if( table != null ) {
275                                    // 3.6.0.2 (2004/10/04)
276                                    // 4.0.0.0 (2007/10/12) checkTableColumn 蜑阪↓縲［odifyType 險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
277                                    executeCount = table.getRowCount();
278                                    if( modifyType != null ) {
279                                            for( int row=0; row<executeCount; row++ ) {
280                                                    table.setModifyType( row,modifyType );
281                                            }
282                                    }
283    
284                                    ErrorMessage errMsg = checkTableColumn( table );
285                                    if( errMsg != null && ! errMsg.isOK()) {
286                                            jspPrint( TaglibUtil.makeHTMLErrorTable( errMsg,getResource() ) );
287                                            return SKIP_PAGE ;
288                                    }
289    
290                            }
291                            // 3.6.0.8 (2004/11/19) 繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
292                            if( ! commitTableObject( tableId, table ) ) {
293                                    jspPrint( "ReadTableTag Query蜃ｦ逅?′蜑ｲ繧願ｾｼ縺ｾ繧後∪縺励◆縲?BTableModel 縺ｯ逋ｻ骭ｲ縺励∪縺帙ｓ縲? );
294                                    return SKIP_PAGE ;
295                            }
296    
297                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
298    
299                            // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ command="NEW" 縺ｮ縺ｨ縺阪?縺ｿ縲‥isplayMsg 繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
300                            // 4.0.0 (2005/11/30) 蜃ｺ蜉幃?縺ｮ螟画峩縲ゆｸ?分譛??縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
301                            if( CMD_NEW.equals( command ) ) {
302                                    if( executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
303                                            buf.append( executeCount );
304                                            buf.append( getResource().getLabel( displayMsg ) );
305                                            buf.append( HybsSystem.BR );
306                                    }
307                                    else if( executeCount == 0 && notfoundMsg != null && notfoundMsg.length() > 0 ) {
308                                            buf.append( getResource().getLabel( notfoundMsg ) );
309                                            buf.append( HybsSystem.BR );
310                                    }
311                            }
312    
313                            // 4.3.7.0 (2009/06/01) 隱ｭ霎ｼ莉ｶ謨ｰ繧偵?"DB.COUNT" 繧ｭ繝ｼ縺ｧ繝ｪ繧ｯ繧ｨ繧ｹ繝医↓繧ｻ繝?ヨ縺吶ｋ縲?
314                            setRequestAttribute( "DB.COUNT"   , String.valueOf( executeCount ) );
315    
316                            jspPrint( buf.toString() );
317                    }
318    
319                    // 4.3.7.0 (2009/06/01) stopZero讖溯?繧定ｿｽ蜉?
320                    final int rtnCode ;
321                    if( executeCount == 0 && stopZero )     {
322                            rtnCode = SKIP_PAGE;
323                    }
324                    else {
325                            rtnCode = EVAL_PAGE;
326                    }
327    
328                    return rtnCode ;
329            }
330    
331            /**
332             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
333             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
334             *
335             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
336             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
337             * @og.rev 3.1.3.0 (2003/04/10) FILE_ENCODE 縺九ｉ縲√お繝ｳ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙蠕励☆繧九?
338             * @og.rev 3.1.4.0 (2003/04/18) command 螻樊?縺ｫ縲∝?譛溷?(NEW)繧定ｨｭ螳壹☆繧九?
339             * @og.rev 3.5.4.2 (2003/12/15) EXCEL縺ｮ繧ｷ繝ｼ繝亥錐繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ螟画峩縲?
340             * @og.rev 3.5.4.5 (2004/01/23) 螟夜Κ繧医ｊ繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ)繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲?
341             * @og.rev 3.6.0.2 (2004/10/04) checkColumns,adjustColumns,allColumnCheck 螻樊?霑ｽ蜉?
342             * @og.rev 3.7.0.5 (2005/04/11) useNumber 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
343             * @og.rev 3.8.0.2 (2005/06/30) nullCheck 螻樊?霑ｽ蜉?
344             * @og.rev 3.8.5.3 (2006/08/07) readerClass 螻樊?縺ｮ蛻晄悄蛟､繧偵す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ繧医ｊ蜿門ｾ励＠縺ｾ縺吶?
345             * @og.rev 4.3.7.0 (2009/06/01) stopZero螻樊?霑ｽ蜉?
346             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
347             * @og.rev 5.1.6.0 (2010/05/01) 繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺苓ｨｭ螳?skipRowCount 螻樊?霑ｽ蜉?
348             * @og.rev 5.2.1.0 (2010/10/01) 隱ｭ蜿門?逅?〒繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?° useRenderer 螻樊?霑ｽ蜉?
349             * @og.rev 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医ｒ謖?ｮ壹〒縺阪ｋ繧医≧縺ｫ繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縲《heetNos螻樊?霑ｽ蜉?
350             * @og.rev 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐縲√い繝峨Ξ繧ｹ縺ｮ謖?ｮ壹?縺溘ａ縺ｮ縲《heetConstKeys縲《heetConstAdrs螻樊?霑ｽ蜉?
351             * @og.rev 5.5.8.2 (2012/11/09) 繧ｫ繝ｩ繝??縺ｫ NULL 縺檎樟繧後◆譎らせ縺ｧ隱ｭ縺ｿ蜿悶ｊ繧剃ｸｭ豁｢縺吶ｋ縲］ullBreakClm螻樊?霑ｽ蜉?
352             */
353            @Override
354            protected void release2() {
355                    super.release2();
356                    separator               = TableReader.TAB_SEPARATOR;   // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
357                    fileURL                 = HybsSystem.sys( "FILE_URL" );
358                    filename                = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
359                    encode                  = HybsSystem.sys( "FILE_ENCODE"   );   // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
360                    readerClass             = HybsSystem.sys( "TABLE_READER_DEFAULT_CLASS" );               // 3.8.5.3 (2006/08/07)
361                    maxRowCount             = -1;
362                    displayMsg              = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
363                    notfoundMsg             = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
364                    executeCount    = -1;                   // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
365                    modifyType              = null;
366                    command                 = CMD_NEW;
367                    table                   = null;
368                    tableId                 = HybsSystem.TBL_MDL_KEY ;
369                    sheetName               = null;         // 3.5.4.2 (2003/12/15)
370                    sheetNos                = null ;        // 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医ｒ謖?ｮ壹〒縺阪ｋ繧医≧縺ｫ繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲?
371                    sheetConstKeys  = null ;        // 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐(CSV蠖｢蠑?
372                    sheetConstAdrs  = null ;        // 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九い繝峨Ξ繧ｹ(陦?蛻?陦?蛻?繝ｻ繝ｻ繝ｻ)
373                    nullBreakClm    = null;         // 5.5.8.2 (2012/11/09) 蜿冶ｾｼ縺ｿ譚｡莉ｶ/Sheet BREAK譚｡莉ｶ
374                    columns                 = null;         // 3.5.4.5 (2004/01/23)
375                    useNumber               = true;         // 3.7.0.5 (2005/04/11)
376                    adjustColumns   = null;         // 3.6.0.2 (2004/10/04) 蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け
377                    checkColumns    = null;         // 3.6.0.2 (2004/10/04) 蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け
378                    nullCheck               = null;         // 3.8.0.2 (2005/06/30)
379                    stopZero                = false;        // 4.3.7.0 (2009/06/01) soptZero霑ｽ蜉?
380                    isMainTrans             = true;         // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
381                    skipRowCount    = 0;            // 5.1.6.0 (2010/05/01) 繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺苓ｨｭ螳?
382                    useRenderer             = HybsSystem.sysBool( "USE_TABLE_READER_RENDERER" );    // 5.2.1.0 (2010/10/01)
383            }
384    
385            /**
386             * TableReader 縺ｮ螳溘が繝悶ず繧ｧ繧ｯ繝医ｒ逕滓?縺励※?沓ufferedReader 縺ｫ譖ｸ縺崎ｾｼ縺ｿ縺ｾ縺吶?
387             *
388             * @og.rev 3.5.4.1 (2003/12/01) 蠑墓焚縺ｮ BufferedReader 繧偵?InputStream 縺ｫ螟画峩縲?
389             * @og.rev 3.5.4.2 (2003/12/15) TableReader 縺ｮ繧ｵ繝悶け繝ｩ繧ｹ蜷榊､画峩縲?
390             * @og.rev 3.5.4.2 (2003/12/15) EXCEL縺ｮ繧ｷ繝ｼ繝亥錐繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ螟画峩縲?
391             * @og.rev 3.5.4.3 (2004/01/05) 蠑墓焚縺ｮ InputStream 繧偵? BufferedReader 縺ｫ謌ｻ縺吶?
392             * @og.rev 3.5.4.5 (2004/01/23) TableReader 縺ｫ縲‘ncode 繧呈ｸ｡縺吶ｈ縺?↓螟画峩縲?
393             * @og.rev 3.5.6.0 (2004/06/18) 蜷?ｨｮ繝励Λ繧ｰ繧､繝ｳ髢｢騾｣莉倥￠險ｭ螳壹ｒ縲√す繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ 縺ｫ險倩ｿｰ縺励∪縺吶?
394             * @og.rev 3.7.0.5 (2005/04/11) useNumber 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
395             * @og.rev 4.0.0.0 (2005/01/31) 繧ｭ繝ｼ縺ｮ謖?ｮ壹ｒ縲ゝableReader. 縺九ｉ縲ゝableReader_ 縺ｫ螟画峩縺励∪縺吶?
396             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
397             * @og.rev 5.1.6.0 (2010/05/01) 繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺苓ｨｭ螳?skipRowCount 螻樊?霑ｽ蜉?
398             * @og.rev 5.2.1.0 (2010/10/01) 隱ｭ蜿門?逅?〒繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?°險ｭ螳?useRenderer 螻樊?霑ｽ蜉?
399             * @og.rev 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医ｒ謖?ｮ壹〒縺阪ｋ繧医≧縺ｫ繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縲《heetNos螻樊?霑ｽ蜉?
400             * @og.rev 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐縲√い繝峨Ξ繧ｹ縺ｮ謖?ｮ壹?縺溘ａ縺ｮ縲《heetConstKeys縲《heetConstAdrs螻樊?霑ｽ蜉?
401             * @og.rev 5.5.8.2 (2012/11/09) 繧ｫ繝ｩ繝??縺ｫ NULL 縺檎樟繧後◆譎らせ縺ｧ隱ｭ縺ｿ蜿悶ｊ繧剃ｸｭ豁｢縺吶ｋ縲］ullBreakClm螻樊?霑ｽ蜉?
402             *
403             * @param       out     蜃ｺ蜉帙☆繧毅ufferedReader繧ｪ繝悶ず繧ｧ繧ｯ繝?
404             */
405            protected void create( final BufferedReader out )  {
406    
407                    String className = HybsSystem.sys( "TableReader_" + readerClass ) ;             // 4.0.0 (2005/01/31)
408                    TableReader reader = (TableReader)HybsSystem.newInstance( className );  // 3.5.5.3 (2004/04/09)
409    
410                    reader.setResourceManager( getResource() );     // 4.0.0 (2005/01/31)
411                    reader.setSeparator( separator );
412                    reader.setEncode( encode );                                             // 3.5.4.5 (2004/01/23)
413                    reader.setColumns( columns );                                   // 3.5.4.5 (2004/01/23)
414                    reader.setUseNumber( useNumber );                               // 3.7.0.5 (2005/04/11)
415                    reader.setMaxRowCount( maxRowCount );
416                    reader.setSkipRowCount( skipRowCount );                 // 5.1.6.0 (2010/05/01)
417                    reader.setUseRenderer( useRenderer );                   // 5.2.1.0 (2010/10/01)
418                    reader.setDebug( isDebug() );                                   // 5.5.7.2 (2012/10/09) 繝?ヰ繝?げ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°繧呈欠螳?
419                    if( reader.isExcel() ) {                                                // 3.5.4.3 (2004/01/05)
420                            reader.setFilename( HybsSystem.url2dir( StringUtil.urlAppend( fileURL,filename )));
421                            reader.setSheetName( sheetName );                       // 3.5.4.2 (2003/12/15)
422                            reader.setSheetNos( sheetNos );                         // 5.5.7.2 (2012/10/09) 隍?焚繧ｷ繝ｼ繝医ｒ謖?ｮ壹〒縺阪ｋ繧医≧縺ｫ繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縲?
423                            reader.setSheetConstData( sheetConstKeys,sheetConstAdrs ) ;             // 5.5.8.2 (2012/11/09) 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐縲√い繝峨Ξ繧ｹ縺ｮ謖?ｮ?
424                            reader.setNullBreakClm( nullBreakClm ) ;        // 5.5.8.2 (2012/11/09) 蜿冶ｾｼ縺ｿ譚｡莉ｶ/Sheet BREAK譚｡莉ｶ
425                            reader.readDBTable();
426                    }
427                    else {
428                            reader.readDBTable( out );
429                    }
430                    table = reader.getDBTableModel();
431            }
432    
433            /**
434             * BufferedReader 繧貞叙蠕励＠縺ｾ縺吶?
435             *
436             * 縺薙％縺ｧ縺ｯ縲∽ｸ?握逧?↑繝輔ぃ繧､繝ｫ蜃ｺ蜉帙ｒ閠??縺励◆ BufferedReader 繧剃ｽ懈?縺励∪縺吶?
437             *
438             * @og.rev 2.2.0.0 (2002/12/17) 荳ｭ蝗ｽ隱?蝗ｽ髫帛喧)蟇ｾ蠢?繧ｨ繝ｳ繧ｳ繝ｼ繝峨?蜿門ｾ玲婿豕募､画峩
439             * @og.rev 3.1.3.0 (2003/04/10) FILE_ENCODE 縺九ｉ縲√お繝ｳ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙蠕励☆繧九?
440             * @og.rev 3.5.4.1 (2003/12/01) 蠑墓焚縺ｮ BufferedReader 繧偵?InputStream 縺ｫ螟画峩縲?
441             * @og.rev 3.5.4.3 (2004/01/05) 蠑墓焚縺ｮ InputStream 繧偵? BufferedReader 縺ｫ謌ｻ縺吶?
442             * @og.rev 3.5.5.9 (2004/06/07) FileUtil.getBufferedReader 繧剃ｽｿ逕ｨ
443             *
444             * @return      繝輔ぃ繧､繝ｫ隱ｭ蜿烹ufferedReader繧ｪ繝悶ず繧ｧ繧ｯ繝?
445             */
446            private BufferedReader getBufferedReader() {
447                    if( filename == null ) {
448                            String errMsg = "繝輔ぃ繧､繝ｫ蜷阪′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?;
449                            throw new HybsSystemException( errMsg );
450                    }
451                    String directory = HybsSystem.url2dir( fileURL );
452                    File file = new File( StringUtil.urlAppend( directory,filename ) );
453    
454                    BufferedReader out = FileUtil.getBufferedReader( file,encode );
455    
456                    return out ;
457            }
458    
459            /**
460             * 繧ｫ繝ｩ繝?枚蟄怜?(CSV蠖｢蠑?縺九ｉ縲√き繝ｩ繝?分蜿ｷ驟榊?繧剃ｽ懈?縺励∪縺吶?
461             * 邁｡譏薙Γ繧ｽ繝?ラ縺ｧ縺吶?
462             * 蠑墓焚縺後?"*" 縺ｮ蝣ｴ蜷医?縲∝?繧ｫ繝ｩ繝?ｒ謖?ｮ壹＠縺溘％縺ｨ縺ｫ縺ｪ繧翫∪縺吶?
463             * null 縺ｮ蝣ｴ蜷医?縲√し繧､繧ｺ縺???縺ｮ驟榊?繧定ｿ斐＠縺ｾ縺吶?
464             *
465             * @og.rev 4.0.0.0 (2007/05/25) 譁ｰ隕丈ｽ懈?
466             *
467             * @param       clms    繧ｫ繝ｩ繝?枚蟄怜?(CSV蠖｢蠑?
468             * @param       table   DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
469             *
470             * @return      繧ｫ繝ｩ繝?分蜿ｷ驟榊?(辟｡縺??蜷医?縲?聞縺包ｼ舌?驟榊?)
471             */
472            private int[] makeClmNos( final String clms,final DBTableModel table ) {
473                    final int[] clmNo;
474    
475                    if( clms == null ) {
476                            clmNo = new int[0];
477                    }
478                    else if( "*".equals( clms ) ) {
479                            int size = table.getColumnCount();
480                            clmNo = new int[size];
481                            for( int i=0; i<size; i++ ) {
482                                    clmNo[i] = i;
483                            }
484                    }
485                    else {
486                            String[] clmStr = StringUtil.csv2Array( clms );
487                            int size = clmStr.length;
488                            clmNo = new int[size];
489                            for( int i=0; i<size; i++ ) {
490                                    clmNo[i] = table.getColumnNo( clmStr[i] );
491                            }
492                    }
493    
494                    return clmNo;
495            }
496    
497            /**
498             * checkColumns 縺ｫ謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?ｒ繝√ぉ繝?け縺励∪縺吶?
499             * 繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医?DBType螻樊?縺ｫ蟇ｾ蠢懊＠縺溘メ繧ｧ繝?け繧定｡後＞縺ｾ縺吶?
500             * 繝√ぉ繝?け邨先棡縺ｧ縲√お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷医?縲・rrorMessage 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ
501             * 霑斐＠縺ｾ縺吶?
502             * DBColumn#valueCheck( String ) 縺ｮ邨先棡縺ｮErrorMessage繧偵☆縺ｹ縺ｦ append
503             * 縺励※縺?″縺ｾ縺吶?
504             * useAdjust==true 縺ｧ縲√°縺､縲√お繝ｩ繝ｼ縺後↑縺??蜷医?縲∥djustColumns 蜃ｦ逅?ｵ先棡繧?
505             * DBTableModel 縺ｫ蜿肴丐縺輔○縺ｾ縺吶?
506             * debug=true 縺ｧ縲√お繝ｩ繝ｼ譎ゅ?隧ｳ邏ｰ縺ｪ繝??繧ｿ繧貞?蜉帙＠縺ｾ縺吶?
507             *
508             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕丈ｽ懈?
509             * @og.rev 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
510             * @og.rev 4.0.0.0 (2007/05/25) 蜃ｦ逅??蠎乗嶌縺肴鋤縺?
511             *
512             * @param       table   DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
513             *
514             * @return      繧ｫ繝ｩ繝?く繝ｼ ??蛟､ 縺ｮ繧ｨ繝ｩ繝ｼ繝｡繝?そ繝ｼ繧ｸ繧ｪ繝悶ず繧ｧ繧ｯ繝?
515             */
516            private ErrorMessage checkTableColumn( final DBTableModel table ) {
517                    ErrorMessage errMsg = new ErrorMessage( "Check Columns Error!" );
518    
519                    int rowCnt = table.getRowCount();
520                    int[] adjClmNo = makeClmNos( adjustColumns,table );
521                    int[] chkClmNo = makeClmNos( checkColumns,table );
522                    int[] nllclmNo = makeClmNos( nullCheck,table );
523    
524                    boolean useAdjust = adjClmNo.length > 0 ;
525    
526                    for( int row=0; row<rowCnt; row++ ) {
527                            String[]   vals   = table.getValues( row );
528                            DBColumn[] dbClms = table.getDBColumns();
529                            boolean isError = false;                                                // 5.5.7.2 (2012/10/09) 繧ｨ繝ｩ繝ｼ譎ゅ?繝輔Λ繧ｰ縲ゅΝ繝ｼ繝励〒繧ｯ繝ｪ繧｢縺吶ｋ縲?
530    
531                            // adjustColumns 蜃ｦ逅?
532                            for( int i=0; i<adjClmNo.length; i++ ) {
533                                    int no = adjClmNo[i];
534                                    vals[no] = dbClms[no].valueSet( vals[no] );
535                            }
536    
537                            // checkColumns 蜃ｦ逅?
538                            for( int i=0; i<chkClmNo.length; i++ ) {
539                                    int no = chkClmNo[i];
540                                    ErrorMessage msg = dbClms[no].valueCheck( vals[no] );
541                                    if( msg.getKekka() > ErrorMessage.OK ) {
542                                            isError = true;
543                                            errMsg.append( row+1,dbClms[no].valueCheck( vals[no] ) );
544                                    }
545                            }
546    
547                            // nullCheck 蜃ｦ逅?
548                            for( int i=0; i<nllclmNo.length; i++ ) {
549                                    int no = nllclmNo[i];
550                                    if( vals[no] == null || vals[no].length() == 0 ) {
551                                            isError = true;
552                                            String label = dbClms[no].getLabel();
553                                            // ERR0012 : 謖?ｮ壹?繝??繧ｿ縺後そ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?NULL繧ｨ繝ｩ繝ｼ)縲Ｌey={0}
554                                            errMsg.addMessage( row+1,ErrorMessage.NG,"ERR0012",label );
555                                    }
556                            }
557    
558                            // 5.5.7.2 (2012/10/09) 繧ｨ繝ｩ繝ｼ譎ゅ?繝?ヰ繝?げ蜃ｺ蜉?
559                            if( isDebug() && isError ) {
560                                    errMsg.addMessage( row+1,ErrorMessage.OK,"Debug Info",java.util.Arrays.toString(table.getValues(row) ) );
561                            }
562    
563                            // adjustColumns 蜃ｦ逅?ｵ先棡繧貞渚譏?＆縺帙∪縺吶?
564                            if( useAdjust && !isError ) { table.setValues( vals,row ); }
565                            if( errMsg.size() > ERROR_ROW_COUNT ) { break; }
566                    }
567    
568                    return errMsg;
569            }
570    
571            /**
572             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡縺ｮDBTableModel繧偵?session縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
573             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
574             *
575             * @og.tag
576             * 讀懃ｴ｢邨先棡繧医ｊ縲．BTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?縺薙ｌ繧偵?荳区ｵ√?view繧ｿ繧ｰ遲峨↓
577             * 貂｡縺吝?蜷医↓縲??蟶ｸ縺ｯ縲《ession 繧貞茜逕ｨ縺励∪縺吶?縺昴?蝣ｴ蜷医?逋ｻ骭ｲ繧ｭ繝ｼ縺ｧ縺吶?
578             * query 繧ｿ繧ｰ繧貞酔譎ゅ↓螳溯｡後＠縺ｦ縲∫ｵ先棡繧呈ｱゅａ繧句?蜷医?蜷御ｸ?Γ繝｢繝ｪ縺ｫ驟咲ｽｮ縺輔ｌ繧狗ぜ縲?
579             * 縺薙? tableId 螻樊?繧貞茜逕ｨ縺励※縲√Γ繝｢繝ｪ遨ｺ髢薙ｒ蛻?￠縺ｾ縺吶?
580             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
581             *
582             * @param       id session縺ｫ逋ｻ骭ｲ縺吶ｋ譎ゅ? ID
583             */
584            public void setTableId( final String id ) {
585                    tableId = nval( getRequestParameter( id ), tableId );
586            }
587    
588            /**
589             * 縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
590             *
591             * @og.tag 蜿ｯ螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
592             *
593             * @param   separator 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
594             */
595            public void setSeparator( final String separator ) {
596                    this.separator = nval( getRequestParameter( separator ),this.separator );
597            }
598    
599            /**
600             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?
601             *              (蛻晄悄蛟､:FILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
602             *
603             * @og.tag
604             * 縺薙?螻樊?縺ｧ謖?ｮ壹＆繧後ｋ繝?ぅ繝ｬ繧ｯ繝医Μ繧医ｊ縲√ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
605             * 謖?ｮ壽婿豕輔?縲??蟶ｸ縺ｮ fileURL 螻樊?縺ｨ蜷梧ｧ倥↓縲∝?鬆ｭ縺後?'/' (UNIX) 縺ｾ縺溘?縲?ｼ呈枚蟄礼岼縺後?
606             * ":" (Windows)縺ｮ蝣ｴ蜷医?縲∵欠螳壹?URL縺昴?縺ｾ縺ｾ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√◎縺?〒縺ｪ縺??蜷医?縲?
607             * fileURL = "{&#064;USER.ID}" 縺ｨ謖?ｮ壹☆繧九→縲：ILE_URL 螻樊?縺ｧ謖?ｮ壹?繝輔か繝ｫ繝??荳九↓縲?
608             * 縺輔ｉ縺ｫ縲∝推蛟倶ｺｺID蛻･縺ｮ繝輔か繝ｫ繝?ｒ菴懈?縺励※縲√◎縺薙ｒ謫堺ｽ懊＠縺ｾ縺吶?
609             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
610             *
611             * @og.rev 4.0.0.0 (2005/01/31) StringUtil.urlAppend 繝｡繧ｽ繝?ラ縺ｮ蛻ｩ逕ｨ
612             * @og.rev 4.0.0.0 (2007/11/20) 謖?ｮ壹＆繧後◆繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪?譛?ｾ後′"\"or"/"縺ｧ邨ゅｏ縺｣縺ｦ縺?↑縺??蜷医↓縲?/"繧剃ｻ伜刈縺吶ｋ縲?
613             *
614             * @param       url 隱ｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷?
615             * @see         org.opengion.hayabusa.common.SystemData#FILE_URL
616             */
617            public void setFileURL( final String url ) {
618                    String furl = nval( getRequestParameter( url ),null );
619                    if( furl != null ) {
620                            char ch = furl.charAt( furl.length()-1 );
621                            if( ch != '/' && ch != '\\' ) { furl = furl + "/"; }
622                            fileURL = StringUtil.urlAppend( fileURL,furl );
623                    }
624            }
625    
626            /**
627             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
628             *              (蛻晄悄蛟､:FILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
629             *
630             * @og.tag 繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
631             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
632             *
633             * @param   filename 繝輔ぃ繧､繝ｫ蜷?
634             * @see         org.opengion.hayabusa.common.SystemData#USE_SQL_INJECTION_CHECK
635             */
636            public void setFilename( final String filename ) {
637                    this.filename = nval( getRequestParameter( filename ),this.filename );
638            }
639    
640            /**
641             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
642             *              (蛻晄悄蛟､:FILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
643             *
644             * @og.tag
645             * Shift_JIS,MS932,Windows-31J,UTF-8,ISO-8859-1,UnicodeLittle
646             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
647             *
648             * @og.rev 2.2.0.0 (2002/12/17) 荳ｭ蝗ｽ隱?蝗ｽ髫帛喧)蟇ｾ蠢?繧ｨ繝ｳ繧ｳ繝ｼ繝峨?蜿門ｾ玲婿豕募､画峩
649             * @og.rev 3.1.3.0 (2003/04/10) FILE_ENCODE 縺九ｉ縲√お繝ｳ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙蠕励☆繧九?
650             *
651             * @param   enc 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷?
652             * @see     <a href="http://www.iana.org/assignments/character-sets">IANA Charset Registry</a>
653             * @see         org.opengion.hayabusa.common.SystemData#FILE_ENCODE
654             */
655            public void setEncode( final String enc ) {
656                    encode = nval( getRequestParameter( enc ),encode );
657            }
658    
659            /**
660             * 縲慎AG縲大ｮ滄圀縺ｫ隱ｭ縺ｿ蜃ｺ縺吶け繝ｩ繧ｹ蜷阪?逡･遘ｰ(TableReader_**** 縺ｮ ****)繧偵そ繝?ヨ縺励∪縺?{@og.doc03Link readerClass 蛻晄悄蛟､:Default})縲?
661             *
662             * @og.tag
663             * 螳滄圀縺ｫ隱ｭ縺ｿ蜃ｺ縺吶け繝ｩ繧ｹ蜷?縺ｮ逡･遘ｰ)繧偵そ繝?ヨ縺励∪縺吶?
664             * 縺薙ｌ縺ｯ縲｛rg.opengion.hayabusa.io 莉･荳九? TableReader_**** 繧ｯ繝ｩ繧ｹ縺ｮ **** 繧?
665             * 荳弱∴縺ｾ縺吶?縺薙ｌ繧峨?縲ゝableReader 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧堤ｶ呎価縺励◆繧ｵ繝悶け繝ｩ繧ｹ縺ｧ縺吶?
666             * 螻樊?繧ｯ繝ｩ繧ｹ螳夂ｾｩ縺ｮ {@link org.opengion.hayabusa.io.TableReader TableReader} 繧貞盾辣ｧ鬘倥＞縺ｾ縺吶?
667             * {@og.doc03Link readerClass TableReader_**** 繧ｯ繝ｩ繧ｹ}
668             *
669             * @param   readerClass 繧ｯ繝ｩ繧ｹ蜷?縺ｮ逡･遘ｰ)
670             * @see         org.opengion.hayabusa.io.TableReader  TableReader縺ｮ繧ｵ繝悶け繝ｩ繧ｹ
671             */
672            public void setReaderClass( final String readerClass ) {
673                    this.readerClass = nval( getRequestParameter( readerClass ),this.readerClass );
674            }
675    
676            /**
677             * 縲慎AG縲題ｪｭ蜿匁凾縺ｮ譛?､ｧ蜿悶ｊ霎ｼ縺ｿ莉ｶ謨ｰ繧偵そ繝?ヨ縺励∪縺?
678             *              (蛻晄悄蛟､:DB_MAX_ROW_COUNT[={@og.value org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT}])縲?
679             *
680             * @og.tag
681             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺吶ｋ譛?､ｧ莉ｶ謨ｰ繧偵％縺ｮ蛟､縺ｫ險ｭ螳壹＠縺ｾ縺吶?
682             * 繧ｵ繝ｼ繝舌?縺ｮ繝｡繝｢繝ｪ雉?ｺ舌→蠢懃ｭ疲凾髢薙?遒ｺ菫昴?轤ｺ縺ｧ縺吶?
683             * 0 繧偵そ繝?ヨ縺吶ｋ縺ｨ縲∫┌蛻ｶ髯?Integer.MAX_VALUE)縺ｫ縺ｪ繧翫∪縺吶?
684             * (蛻晄悄蛟､:繝ｦ繝ｼ繧ｶ繝ｼ螳壽焚縺ｮDB_MAX_ROW_COUNT[={@og.value org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT}])縲?
685             *
686             * @og.rev 5.5.8.5 (2012/11/27) 0繧堤┌蛻ｶ髯舌→縺励※蜃ｦ逅?＠縺ｾ縺吶?
687             *
688             * @param   count 隱ｭ蜿匁凾縺ｮ譛?､ｧ蜿悶ｊ霎ｼ縺ｿ莉ｶ謨ｰ
689             * @see         org.opengion.hayabusa.common.SystemData#DB_MAX_ROW_COUNT
690             */
691            public void setMaxRowCount( final String count ) {
692                    maxRowCount = nval( getRequestParameter( count ),maxRowCount );
693                    if( maxRowCount == 0 ) { maxRowCount = Integer.MAX_VALUE ; }            // 5.5.8.5 (2012/11/27)
694            }
695    
696            /**
697             * 縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)縲?
698             *
699             * @og.tag
700             * 繧ｳ繝槭Φ繝峨?,HTML縺九ｉ(get/post)謖?ｮ壹＆繧後∪縺吶?縺ｧ,CMD_xxx 縺ｧ險ｭ螳壹＆繧後ｋ
701             * 繝輔ぅ繝ｼ繝ｫ繝牙ｮ壽焚蛟､縺ｮ縺?▼繧後°繧偵?謖?ｮ壹〒縺阪∪縺吶?
702             * 菴輔ｂ險ｭ螳壹＆繧後↑縺??縺ｾ縺溘?縲］ull 縺ｮ蝣ｴ蜷医?縲?NEW" 縺悟?譛溷?縺ｫ繧ｻ繝?ヨ縺輔ｌ縺ｾ縺吶?
703             *
704             * @param       cmd 繧ｳ繝槭Φ繝?public static final 螳｣險?＆繧後※縺?ｋ譁?ｭ怜?)
705             * @see         <a href="../../../../constant-values.html#org.opengion.hayabusa.taglib.ReadTableTag.CMD_NEW">繧ｳ繝槭Φ繝牙ｮ壽焚</a>
706             */
707            public void setCommand( final String cmd ) {
708                    String cmd2 = getRequestParameter( cmd );
709                    if( cmd2 != null && cmd2.length() > 0 ) { command = cmd2.toUpperCase(Locale.JAPAN); }
710            }
711    
712            /**
713             * 縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0033[縲?ｻｶ讀懃ｴ｢縺励∪縺励◆])縲?
714             *
715             * @og.tag
716             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
717             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ
718             * 陦ｨ遉ｺ縺励∪縺吶?
719             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
720             * 蛻晄悄蛟､縺ｯ縲∵､懃ｴ｢莉ｶ謨ｰ繧定｡ｨ遉ｺ縺励∪縺吶?
721             *
722             * @param   id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
723             */
724            public void setDisplayMsg( final String id ) {
725                    if( id != null ) { displayMsg = id; }
726            }
727    
728            /**
729             * 縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])縲?
730             *
731             * @og.tag
732             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ縲∫音蛻･縺ｪ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
733             * 蠕捺擂縺ｯ縲‥isplayMsg 縺ｨ蜈ｼ逕ｨ縺ｧ縲√?0縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲上→縺?≧陦ｨ遉ｺ縺ｧ縺励◆縺後?
734             * displayMsg 縺ｮ蛻晄悄陦ｨ遉ｺ縺ｯ縲＾FF 縺ｫ縺ｪ繧翫∪縺励◆縺ｮ縺ｧ縲√ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ蛻･縺ｫ陦ｨ遉ｺ縺輔○縺ｾ縺吶?
735             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, notfoundMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
736             * 蛻晄悄蛟､縺ｯ縲｀SG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆]縺ｧ縺吶?
737             *
738             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
739             */
740            public void setNotfoundMsg( final String id ) {
741                    String ids = getRequestParameter( id );
742                    if( ids != null ) { notfoundMsg = ids; }
743            }
744    
745            /**
746             * 縲慎AG縲代ヵ繧｡繧､繝ｫ蜿悶ｊ霎ｼ縺ｿ譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝?A(霑ｽ蜉?,C(譖ｴ譁ｰ),D(蜑企勁))繧呈欠螳壹＠縺ｾ縺吶?
747             *
748             * @og.tag
749             * 繝輔ぃ繧､繝ｫ隱ｭ縺ｿ霎ｼ縺ｿ譎ゅ↓縲√◎縺ｮ繝??繧ｿ繧但(霑ｽ蜉?縲，(譖ｴ譁ｰ)縲．(蜑企勁)縺ｮ
750             * 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝励ｒ縺､縺代◆迥ｶ諷九↓縺励∪縺吶?
751             * 縺昴?迥ｶ諷九〒縲√◎縺ｮ縺ｾ縺ｾ縲「pdate 縺吶ｋ莠九′蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
752             *
753             * @param   type 繝輔ぃ繧､繝ｫ蜿悶ｊ霎ｼ縺ｿ譎ゅ? 繝｢繝?ぅ繝輔ぃ繧､繧ｿ繧､繝?A,C,D螻樊?)
754             */
755            public void setModifyType( final String type ) {
756                    modifyType = getRequestParameter( type );
757            }
758    
759            /**
760             * 縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:謖?ｮ壹↑縺?縲?
761             *
762             * @og.tag
763             * EXCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?凾縺ｫ縲√す繝ｼ繝亥錐繧呈欠螳壹＠縺ｾ縺吶?縺薙ｌ縺ｫ繧医ｊ縲∬､?焚縺ｮ蠖｢蠑上?
764             * 逡ｰ縺ｪ繧九ョ繝ｼ繧ｿ繧帝?谺｡隱ｭ縺ｿ霎ｼ繧?％縺ｨ繧??繧ｷ繝ｼ繝医ｒ謖?ｮ壹＠縺ｦ隱ｭ縺ｿ蜿悶ｋ縺薙→縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
765             * sheetNos 縺ｨ sheetName 縺悟酔譎ゅ↓謖?ｮ壹＆繧後◆蝣ｴ蜷医?縲《heetNos 縺悟━蜈医＆繧後∪縺吶?繧ｨ繝ｩ繝ｼ縺ｫ縺ｯ縺ｪ繧峨↑縺??縺ｧ縺疲ｳｨ諢上￥縺?＆縺??
766             * 蛻晄悄蛟､縺ｯ縲∵欠螳壹↑縺励〒縺吶?
767             *
768             * @og.rev 3.5.4.2 (2003/12/15) 譁ｰ隕剰ｿｽ蜉?
769             *
770             * @param   sheet EXCEL繝輔ぃ繧､繝ｫ縺ｮ繧ｷ繝ｼ繝亥錐
771             * @see         #setSheetNos( String ) 
772             */
773            public void setSheetName( final String sheet ) {
774                    sheetName = nval( getRequestParameter( sheet ),sheetName );
775            }
776    
777            /**
778             * 縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝育分蜿ｷ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:0)縲?
779             *
780             * @og.tag
781             * EXCEL隱ｭ縺ｿ霎ｼ縺ｿ譎ゅ↓隍?焚繧ｷ繝ｼ繝医ｒ繝槭?繧ｸ縺励※蜿悶ｊ霎ｼ縺ｿ縺ｾ縺吶?
782             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｯ縲? 縺九ｉ蟋九∪繧区焚蟄励〒陦ｨ縺励∪縺吶?
783             * 繝倥ャ繝??縺ｯ縲∵怙蛻昴?繧ｷ繝ｼ繝医?繧ｫ繝ｩ繝?ｽ咲ｽｮ縺ｫ蜷医ｏ縺帙∪縺吶??医?繝?ム繝ｼ繧ｿ繧､繝医Ν縺ｮ閾ｪ蜍戊ｪ崎ｭ倥?縺ゅｊ縺ｾ縺帙ｓ縲ゑｼ?
784             * 繧医▲縺ｦ縲∵欠螳壹☆繧九す繝ｼ繝医?縲√☆縺ｹ縺ｦ蜷御ｸ?Ξ繧､繧｢繧ｦ繝医〒縺ｪ縺?→蜿悶ｊ霎ｼ縺ｿ譎ゅ↓繧ｫ繝ｩ繝??縺壹ｌ縺檎匱逕溘＠縺ｾ縺吶?
785             * 
786             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｮ謖?ｮ壹?縲√き繝ｳ繝槫玄蛻?ｊ縺ｧ縲∬､?焚謖?ｮ壹〒縺阪∪縺吶?縺ｾ縺溘?N-M 縺ｮ讒倥↓繝上う繝輔Φ縺ｧ郢九￡繧九％縺ｨ縺ｧ縲?
787             * N 逡ｪ縺九ｉ縲｀ 逡ｪ縺ｮ繧ｷ繝ｼ繝育ｯ?峇繧剃ｸ?峡謖?ｮ壼庄閭ｽ縺ｧ縺吶?縺ｾ縺溘?"*" 縺ｫ繧医ｋ縲∝?繧ｷ繝ｼ繝域欠螳壹′蜿ｯ閭ｽ縺ｧ縺吶?
788             * 縺薙ｌ繧峨?邨?∩蜷医ｏ縺帙ｂ蜿ｯ閭ｽ縺ｧ縺吶???0,1,3,5-8,10-* ??
789             * 縺溘□縺励?"*" 縺ｫ髢｢縺励※縺ｯ萓句､也噪縺ｫ縲∽ｸ?枚蟄励□縺代〒縲√☆縺ｹ縺ｦ縺ｮ繧ｷ繝ｼ繝医ｒ陦ｨ縺吶°縲¨-* 繧呈怙蠕後↓謖?ｮ壹☆繧九°縺ｮ
790             * 縺ｩ縺｡繧峨°縺ｧ縺吶?騾比ｸｭ縺ｫ縺ｯ縲?*" 縺ｯ縲∫樟繧後∪縺帙ｓ縲?
791             * 繧ｷ繝ｼ繝育分蜿ｷ縺ｯ縲?㍾隍?1,1,2,2)縲??霆｢(3,2,1) 縺ｧ縺ｮ謖?ｮ壹′蜿ｯ閭ｽ縺ｧ縺吶?縺薙ｌ縺ｯ縲√◎縺ｮ謖?ｮ夐?縺ｧ縲∬ｪｭ縺ｿ霎ｼ縺ｾ繧後∪縺吶?
792             * sheetNos 縺ｨ sheetName 縺悟酔譎ゅ↓謖?ｮ壹＆繧後◆蝣ｴ蜷医?縲《heetNos 縺悟━蜈医＆繧後∪縺吶?繧ｨ繝ｩ繝ｼ縺ｫ縺ｯ縺ｪ繧峨↑縺??縺ｧ縺疲ｳｨ諢上￥縺?＆縺??
793             * 
794             * 蛻晄悄蛟､縺ｯ縲??育ｬｬ荳?す繝ｼ繝茨ｼ?縺ｧ縺吶?
795             *
796             * @og.rev 5.5.7.2 (2012/10/09) 譁ｰ隕剰ｿｽ蜉?
797             *
798             * @param   sheet EXCEL繝輔ぃ繧､繝ｫ縺ｮ繧ｷ繝ｼ繝育分蜿ｷ??縺九ｉ蟋九∪繧具ｼ?
799             * @see         #setSheetName( String ) 
800             */
801            public void setSheetNos( final String sheet ) {
802                    sheetNos = nval( getRequestParameter( sheet ),sheetNos );
803                    if( sheetNos != null && sheetNos.length() > 0 ) {
804                            boolean errFlag = false;
805                            for( int i=0; i<sheetNos.length(); i++ ) {
806                                    char ch = sheetNos.charAt(i);
807                                    if( ch == '-' || ch == ',' ) { continue; }
808                                    if( ch == '*' && ( i==0 || i==sheetNos.length()-1 ) ) { continue; }
809                                    if( ch < '0' || ch > '9' ) { errFlag = true; break; }
810                            }
811                            if( errFlag ) {
812                                    String errMsg = "sheetNos 縺ｮ謖?ｮ壹ｒ隕狗峩縺励※縺上□縺輔＞縲ＴheetNos=[" + sheetNos + "]";
813                                    throw new HybsSystemException( errMsg );
814                            }
815                    }
816            }
817    
818            /**
819             * 縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥腰菴阪?蝗ｺ螳壼?繧定ｨｭ螳壹☆繧九◆繧√?繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｾ縺吶?
820             *
821             * @og.tag
822             * 繧ｫ繝ｩ繝?錐縺ｯ縲√き繝ｳ繝槫玄蛻?ｊ縺ｧ謖?ｮ壹＠縺ｾ縺吶?
823             * 縺薙ｌ縺ｫ繧医ｊ縲√す繝ｼ繝医?荳?°謇?↓譖ｸ縺九ｌ縺ｦ縺?ｋ諠??繧偵?DBTableModel 縺ｮ繧ｫ繝ｩ繝?↓蝗ｺ螳壼?縺ｨ縺励※
824             * 險ｭ螳壹☆繧九％縺ｨ縺後〒縺阪∪縺吶?
825             * 萓九→縺励※縲．B螳夂ｾｩ譖ｸ縺ｧ縲√ユ繝ｼ繝悶Ν蜷阪ｒ繧ｷ繝ｼ繝医?蜈ｨ繝ｬ繧ｳ繝ｼ繝峨↓險ｭ螳壹＠縺溘＞蝣ｴ蜷医↑縺ｩ縺ｫ菴ｿ縺?∪縺吶?
826             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲（sExcel() == true 縺ｮ蝣ｴ蜷医?縺ｿ蛻ｩ逕ｨ縺輔ｌ縺ｾ縺吶?
827             *
828             * @og.rev 5.5.8.2 (2012/11/09) 譁ｰ隕剰ｿｽ蜉?
829             *
830             * @param   constKeys 蝗ｺ螳壼?縺ｨ縺ｪ繧九き繝ｩ繝?錐(CSV蠖｢蠑?
831             * @see         #setSheetConstAdrs( String ) 
832             */
833            public void setSheetConstKeys( final String constKeys ) {
834                    sheetConstKeys = nval( getRequestParameter( constKeys ),null );
835            }
836    
837            /**
838             * 縲慎AG縲薦XCEL繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥腰菴阪?蝗ｺ螳壼?繧定ｨｭ螳壹☆繧九◆繧√?繧ｫ繝ｩ繝?錐縺ｫ蟇ｾ蠢懊☆繧九い繝峨Ξ繧ｹ繧呈欠螳壹＠縺ｾ縺吶?
839             *
840             * @og.tag
841             * 繧｢繝峨Ξ繧ｹ縺ｯ縲・XCEL荳翫?陦?蛻励ｒ繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ謖?ｮ壹＠縺ｾ縺吶?
842             * 陦悟?縺ｯ縲・XCEL繧ｪ繝悶ず繧ｧ繧ｯ繝医↓貅匁侠縺吶ｋ縺溘ａ縲?ｼ舌°繧牙ｧ九∪繧区紛謨ｰ縺ｧ縺吶?
843             * 0-0 竍?A1 , 1-0 竍?A2 , 0-1 竍?B1 縺ｫ縺ｪ繧翫∪縺吶?
844             * 縺薙ｌ縺ｫ繧医ｊ縲√す繝ｼ繝医?荳?°謇?↓譖ｸ縺九ｌ縺ｦ縺?ｋ諠??繧偵?DBTableModel 縺ｮ繧ｫ繝ｩ繝?↓蝗ｺ螳壼?縺ｨ縺励※
845             * 險ｭ螳壹☆繧九％縺ｨ縺後〒縺阪∪縺吶?
846             * 萓九→縺励※縲．B螳夂ｾｩ譖ｸ縺ｧ縲√ユ繝ｼ繝悶Ν蜷阪ｒ繧ｷ繝ｼ繝医?蜈ｨ繝ｬ繧ｳ繝ｼ繝峨↓險ｭ螳壹＠縺溘＞蝣ｴ蜷医↑縺ｩ縺ｫ菴ｿ縺?∪縺吶?
847             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲（sExcel() == true 縺ｮ蝣ｴ蜷医?縺ｿ蛻ｩ逕ｨ縺輔ｌ縺ｾ縺吶?
848             *
849             * 5.7.6.3 (2014/05/23) 繧医ｊ縲?
850             *   竭?XCEL陦ｨ險倥↓貅匁侠縺励◆縲、1,A2,B1 縺ｮ險倩ｿｰ繧ょ?逅?〒縺阪ｋ繧医≧縺ｫ蟇ｾ蠢懊＠縺ｾ縺吶?
851             *     縺ｪ縺翫?A1,A2,B1 縺ｮ險倩ｿｰ縺ｯ縲∝ｿ?★縲∬恭蟄?譁?ｭ暦ｼ区焚蟄?縺ｫ縺励※縺上□縺輔＞縲?A?杙縺ｾ縺ｧ)
852             *   竭｡蜃ｦ逅?ｸｭ縺ｮEXCEL繧ｷ繝ｼ繝亥錐繧偵き繝ｩ繝?↓蜑ｲ繧雁ｽ薙※繧九◆繧√↓縲?SHEET" 縺ｨ縺?≧險伜捷縺ｫ蟇ｾ蠢懊＠縺ｾ縺吶?
853             * 萓九∴縺ｰ縲《heetConstKeys="CLM,LANG,NAME" 縺ｨ縺励?sheetConstAdrs="0-0,A2,SHEET" 縺ｨ縺吶ｋ縺ｨ縲?
854             * NAME繧ｫ繝ｩ繝?↓縺ｯ縲√す繝ｼ繝亥錐繧定ｪｭ縺ｿ霎ｼ繧?％縺ｨ縺後〒縺阪∪縺吶?
855             * 縺薙ｌ縺ｯ縲∝?驛ｨ蜃ｦ逅??邁｡邏?喧縺ｮ縺溘ａ縺ｧ縺吶?
856             *
857             * 縺｡縺ｪ縺ｿ縺ｫ縲・XCEL縺ｮ繧ｻ繝ｫ縺ｫ縲√す繝ｼ繝亥錐繧定｡ｨ遉ｺ縺輔○繧句?蜷医?髢｢謨ｰ縺ｯ縲∽ｸ玖ｨ倥?讒倥↓縺ｪ繧翫∪縺吶?
858             * =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))
859             *
860             * @og.rev 5.5.8.2 (2012/11/09) 譁ｰ隕剰ｿｽ蜉?
861             *
862             * @param   constAdrs 蝗ｺ螳壼?縺ｨ縺ｪ繧九い繝峨Ξ繧ｹ(陦?蛻?陦?蛻?繝ｻ繝ｻ繝ｻ)
863             * @see         #setSheetConstKeys( String ) 
864             */
865            public void setSheetConstAdrs( final String constAdrs ) {
866                    sheetConstAdrs = nval( getRequestParameter( constAdrs ),null );
867            }
868    
869            /**
870             * 縲慎AG縲代％縺薙↓謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝??縺ｫ NULL 縺檎樟繧後◆譎らせ縺ｧ隱ｭ縺ｿ蜿悶ｊ繧剃ｸｭ豁｢縺励∪縺吶?
871             *
872             * @og.tag
873             * 縺薙ｌ縺ｯ縲∵欠螳壹?繧ｫ繝ｩ繝??蠢??縺ｨ縺?≧莠九ｒ譚｡莉ｶ縺ｫ縲√◎縺ｮ繝ｬ繧ｳ繝ｼ繝峨□縺代ｒ隱ｭ縺ｿ蜿悶ｋ蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
874             * 隍?焚Sheet縺ｮ蝣ｴ蜷医?縲∵ｬ｡縺ｮSheet繧定ｪｭ縺ｿ縺ｾ縺吶?
875             * 迴ｾ譎らせ縺ｧ縺ｯ縲・xcel 縺ｮ蝣ｴ蜷医?縺ｿ譛牙柑縺ｧ縺吶?
876             *
877             * @og.rev 5.5.8.2 (2012/11/09) 譁ｰ隕剰ｿｽ蜉?
878             *
879             * @param   clm 繧ｫ繝ｩ繝??
880             */
881            public void setNullBreakClm( final String clm ) {
882                    nullBreakClm = nval( getRequestParameter( clm ),null );
883            }
884    
885            /**
886             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??繧偵?螟夜Κ(繧ｿ繧ｰ)繧医ｊ謖?ｮ壹＠縺ｾ縺吶?
887             *
888             * @og.tag
889             * 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??繧偵?螟夜Κ(繧ｿ繧ｰ)繧医ｊ謖?ｮ壹＠縺ｾ縺吶?
890             * 繝輔ぃ繧､繝ｫ縺ｫ險倩ｿｰ縺輔ｌ縺?#NAME 繧医ｊ蜆ｪ蜈医＠縺ｦ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
891             * 縺薙ｌ縺ｯ縲∝?繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?ｒ鬆?分縺ｫ謖?ｮ壹?繧ｫ繝ｩ繝?錐縺ｫ蜑ｲ繧雁ｽ薙※繧区ｩ溯?縺ｧ
892             * 繝輔ぃ繧､繝ｫ縺ｮ迚ｹ螳壹?繧ｫ繝ｩ繝??繧呈栢縺榊?縺励※蜿悶ｊ霎ｼ繧?ｩ溯?縺ｧ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縲?
893             *
894             * @og.rev 3.5.4.5 (2004/01/23) 譁ｰ隕丈ｽ懈?
895             *
896             * @param   clms 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
897             */
898            public void setColumns( final String clms ) {
899                    columns = nval( getRequestParameter( clms ),columns );
900            }
901    
902            /**
903             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ謨ｴ蜷域?繝√ぉ繝?け繧定｡後≧繧ｫ繝ｩ繝??繧偵き繝ｳ繝樊欠螳壹＠縺ｾ縺吶?
904             *
905             * @og.tag
906             * 繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医?DBType螻樊?縺ｫ蟇ｾ蠢懊＠縺溘メ繧ｧ繝?け繧定｡後＞縺ｾ縺吶?
907             * 謖?ｮ壹?繧ｫ繝ｩ繝?錐繧偵き繝ｳ繝槫玄蛻?ｊ(CSV)縺ｧ隍?焚謖?ｮ壹〒縺阪∪縺吶?
908             * 蜈ｨ縺ｦ縺ｮ繧ｫ繝ｩ繝??繝√ぉ繝?け繧定｡後≧蝣ｴ蜷医?縲∥llColumnCheck = "true" 繧?
909             * 謖?ｮ壹＠縺ｦ荳九＆縺??
910             * 蛻?ｧ｣譁ｹ豕輔?縲??蟶ｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺励∪縺吶?
911             *
912             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕剰ｿｽ蜉?蜿悶ｊ霎ｼ縺ｿ譎ゅメ繧ｧ繝?け逕ｨ
913             * @og.rev 3.8.8.5 (2007/03/09) 騾壼ｸｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺ｫ謌ｻ縺励∪縺吶?
914             *
915             * @param   clms 謨ｴ蜷域?繝√ぉ繝?け繧定｡後≧繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
916             */
917            public void setCheckColumns( final String clms ) {
918                    checkColumns = nval( getRequestParameter( clms ),checkColumns );
919            }
920    
921            /**
922             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繝??繧ｿ螟画鋤繧定｡後≧繧ｫ繝ｩ繝??繧偵き繝ｳ繝樊欠螳壹＠縺ｾ縺吶?
923             *
924             * @og.tag
925             * 繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医?DBType螻樊?縺ｫ蟇ｾ蠢懊＠縺溘ョ繝ｼ繧ｿ螟画鋤繧定｡後＞縺ｾ縺吶?
926             * 謖?ｮ壹?繧ｫ繝ｩ繝?錐繧偵き繝ｳ繝槫玄蛻?ｊ(CSV)縺ｧ隍?焚謖?ｮ壹〒縺阪∪縺吶?
927             * 蛻?ｧ｣譁ｹ豕輔?縲??蟶ｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺励∪縺吶?
928             *
929             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕剰ｿｽ蜉?蜿悶ｊ霎ｼ縺ｿ譎ゅョ繝ｼ繧ｿ螟画鋤
930             * @og.rev 3.8.8.5 (2007/03/09) 騾壼ｸｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺ｫ謌ｻ縺励∪縺吶?
931             *
932             * @param   clms 繝??繧ｿ螟画鋤繧定｡後≧繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
933             */
934            public void setAdjustColumns( final String clms ) {
935                    adjustColumns = nval( getRequestParameter( clms ),adjustColumns );
936            }
937    
938            /**
939             * 縲慎AG縲鮮ULL 繝√ぉ繝?け縺吶∋縺阪き繝ｩ繝??繧偵き繝ｳ繝槫玄蛻?ｊ(CVS蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
940             *
941             * @og.tag nullCheck="AAA,BBB,CCC,DDD"
942             * 蛻?ｧ｣譁ｹ豕輔?縲??蟶ｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺励∪縺吶?
943             *
944             * @og.rev 3.8.0.2 (2005/06/30) 譁ｰ隕剰ｿｽ蜉?
945             * @og.rev 3.8.8.5 (2007/03/09) 騾壼ｸｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺ｫ謌ｻ縺励∪縺吶?
946             *
947             * @param   clms 繧ｫ繝ｩ繝??(CVS蠖｢蠑?
948             */
949            public void setNullCheck( final String clms ) {
950                    nullCheck = nval( getRequestParameter( clms ),nullCheck );
951            }
952    
953            /**
954             * 縲慎AG縲題｡檎分蜿ｷ諠??繧偵?菴ｿ逕ｨ縺励※縺?ｋ/縺励※縺?↑縺Ъtrue/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
955             *
956             * @og.tag
957             * 騾壼ｸｸ縺ｮ繝輔か繝ｼ繝槭ャ繝医〒縺ｯ縲∝推陦後?蜈磯?縺ｫ陦檎分蜿ｷ縺悟?蜉帙＆繧後※縺?∪縺吶?
958             * 隱ｭ縺ｿ蜿悶ｊ譎ゅ↓縲?NAME 螻樊?繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?縲√％縺ｮ陦檎分蜿ｷ繧堤┌隕悶＠縺ｦ縺?∪縺吶?
959             * #NAME 螻樊?繧剃ｽｿ逕ｨ縺帙★縲…olumns 螻樊?縺ｧ繧ｫ繝ｩ繝?錐繧呈欠螳壹☆繧句?蜷?莉悶す繧ｹ繝?Β縺ｮ
960             * 蜃ｺ蜉帙ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｋ繧ｱ繝ｼ繧ｹ遲?縺ｧ縺ｯ縲∬｡檎分蜿ｷ繧ょｭ伜惠縺励↑縺?こ繝ｼ繧ｹ縺後≠繧翫?
961             * 縺昴?讒倥↑蝣ｴ蜷医↓縲「seNumber="false" 繧呈欠螳壹☆繧後?縲√ョ繝ｼ繧ｿ縺ｮ譛??縺九ｉ隱ｭ縺ｿ蜿悶ｊ蟋九ａ縺ｾ縺吶?
962             * 縺薙?蝣ｴ蜷医?蜃ｺ蜉帙ョ繝ｼ繧ｿ縺ｮ繧ｫ繝ｩ繝??荳ｦ縺ｳ鬆?′螟画峩縺輔ｌ縺溷?蜷医?columns 螻樊?繧?
963             * 謖?ｮ壹＠縺ｪ縺翫☆蠢?ｦ√′縺ゅｊ縺ｾ縺吶?縺ｧ縲√〒縺阪ｋ縺?￠縲?NAME 螻樊?繧剃ｽｿ逕ｨ縺吶ｋ繧医≧縺ｫ
964             * 縺励※縺上□縺輔＞縲?
965             * 縺ｪ縺翫?EXCEL 蜈･蜉帙↓縺ｯ縲√％縺ｮ險ｭ螳壹?驕ｩ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?證ｫ螳壼ｯｾ蠢?
966             * 蛻晄悄蛟､縺ｯ縲》rue(菴ｿ逕ｨ縺吶ｋ) 縺ｧ縺吶?
967             *
968             * @og.rev 3.7.0.5 (2005/04/11) 譁ｰ隕剰ｿｽ蜉?
969             *
970             * @param   useNo 陦檎分蜿ｷ諠?? [true:菴ｿ逕ｨ縺吶ｋ/false:菴ｿ逕ｨ縺励↑縺Ь
971             */
972            public void setUseNumber( final String useNo ) {
973                    useNumber = nval( getRequestParameter( useNo ),useNumber );
974            }
975    
976            /**
977             * 縲慎AG縲題ｪｭ霎ｼ莉ｶ謨ｰ縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺榊?逅?ｒ邯夊｡後☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false[邯夊｡後☆繧犠)縲?
978             *
979             * @og.tag
980             * 蛻晄悄蛟､縺ｯ縲’alse(邯夊｡後☆繧?縺ｧ縺吶?
981             *
982             * @og.rev 4.3.7.0 (2009/06/01) 譁ｰ隕剰ｿｽ蜉?
983             *
984             * @param  cmd 隱ｭ霎ｼ莉ｶ謨ｰ縺鯉ｼ蝉ｻｶ縺ｮ縺ｨ縺阪?蜃ｦ逅?ｒ [true:荳ｭ豁｢縺吶ｋ/false:邯夊｡後☆繧犠
985             */
986            public void setStopZero( final String cmd ) {
987                    stopZero = nval( getRequestParameter( cmd ), stopZero );
988            }
989    
990            /**
991             * 縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
992             *
993             * @og.tag
994             * 縺薙?蛟､縺ｯ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅?↓蠖ｱ髻ｿ縺励∪縺吶?縺薙?蛟､縺荊rue縺ｫ謖?ｮ壹＆繧後◆譎ゅ↓commit縺輔ｌ縺櫂BTableModel縺?
995             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨?蟇ｾ雎｡縺ｮ陦ｨ縺ｫ縺ｪ繧翫∪縺吶?
996             *
997             * 縺薙?繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｯ縲??蟶ｸ縲∝推繧ｿ繧ｰ縺ｫ繧医ｊ螳溯｣?＆繧後?繝ｦ繝ｼ繧ｶ繝ｼ縺梧欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲?
998             * 菴?＠縲?縺､縺ｮJSP蜀?〒DBTableModel縺瑚､?焚逕滓?縺輔ｌ繧句?蜷医↓縲∝燕縺ｫ蜃ｦ逅?＠縺櫂BTableModel縺ｫ縺､縺?※繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨ｒ縺輔○縺溘＞
999             * 蝣ｴ蜷医?縲∝ｾ後ｍ縺ｧDBTableModel繧堤函謌舌☆繧九ち繧ｰ縺ｧ縲∵?遉ｺ逧?↓縺薙?蛟､繧断alse縺ｫ謖?ｮ壹☆繧九％縺ｨ縺ｧ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅??蟇ｾ雎｡縺九ｉ
1000             * 髯､螟悶☆繧九％縺ｨ縺後〒縺阪∪縺吶?
1001             *
1002             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
1003             *
1004             * @param  flag 繝｡繧､繝ｳ繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ縺九←縺?°
1005             */
1006            public void setMainTrans( final String flag ) {
1007                    isMainTrans = nval( getRequestParameter( flag ),isMainTrans );
1008            }
1009    
1010            /**
1011             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繝??繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ繧定ｨｭ螳壹＠縺ｾ縺吶?
1012             *
1013             * @og.tag
1014             * TAB蛹ｺ蛻?ｊ繝?く繧ｹ繝医ｄEXCEL遲峨?繝??繧ｿ縺ｮ隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､繧呈欠螳壹＠縺ｾ縺吶?
1015             * 繝輔ぃ繧､繝ｫ縺ｮ蜈磯?陦後′縲?ｼ占｡後→縺励※繧ｫ繧ｦ繝ｳ繝医＠縺ｾ縺吶?縺ｧ縲∬ｨｭ螳壼?縺ｯ縲∬ｪｭ縺ｿ鬟帙?縺?
1016             * 莉ｶ謨ｰ縺ｫ縺ｪ繧翫∪縺吶?(?代→謖?ｮ壹☆繧九→縲?ｼ台ｻｶ隱ｭ縺ｿ鬟帙?縺励??定｡檎岼縺九ｉ隱ｭ縺ｿ霎ｼ縺ｿ縺ｾ縺吶?)
1017             * 隱ｭ縺ｿ鬟帙?縺励?縲√さ繝｡繝ｳ繝郁｡後↑縺ｩ縺ｯ縲∫┌隕悶＠縺ｾ縺吶?縺ｧ縲∝ｮ滄圀縺ｮ陦梧焚蛻?ｪｭ縺ｿ鬟帙?縺励∪縺吶?
1018             * ?クAME螻樊?繧??columns 螻樊?縺ｯ縲∵怏蜉ｹ縺ｧ縺吶?
1019             *
1020             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
1021             *
1022             * @param       count 隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､
1023             */
1024            public void setSkipRowCount( final String count ) {
1025                    skipRowCount = nval( getRequestParameter( count ),skipRowCount );
1026            }
1027    
1028            /**
1029             * 縲慎AG縲題ｪｭ蜿門?逅?〒繝ｩ繝吶Ν繧偵さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｫ騾?､画鋤繧定｡後≧縺九←縺?°繧呈欠螳壹＠縺ｾ縺?
1030             *              (蛻晄悄蛟､:USE_TABLE_READER_RENDERER[={@og.value org.opengion.hayabusa.common.SystemData#USE_TABLE_READER_RENDERER}])縲?
1031             *
1032             * @og.tag
1033             * TableWriter_Renderer 邉ｻ縺ｮ繧ｯ繝ｩ繧ｹ縺ｧ蜃ｺ蜉帙＠縺溷?蜷医?縲√さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺後Λ繝吶Ν縺ｧ蜃ｺ蜉帙＆繧後∪縺吶?
1034             * 縺昴?繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｋ縺ｨ縲∝ｽ鍋┯縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
1035             * 縺薙％縺ｧ縺ｯ縲√さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繧ｫ繝ｩ繝?↓蟇ｾ縺励※縲√Λ繝吶Ν縺九ｉ繧ｳ繝ｼ繝峨ｒ豎ゅａ繧矩?螟画鋤繧定｡後≧縺薙→縺ｧ縲?
1036             * Renderer 邉ｻ縺ｧ蜃ｺ蜉帙＠縺溘ヵ繧｡繧､繝ｫ繧貞叙繧願ｾｼ繧?％縺ｨ縺後〒縺阪ｋ繧医≧縺ｫ縺励∪縺吶?
1037             *
1038             * 縺薙％縺ｧ縺ｯ縲ゝableWriter 邉ｻ縺ｨ蜷梧ｧ倥↓縲ゝableReader_Renderer 邉ｻ縺ｮ繧ｯ繝ｩ繧ｹ繧剃ｽ懊ｋ縺ｮ縺ｧ縺ｯ縺ｪ縺上?
1039             * 螻樊?蛟､縺ｮ繝輔Λ繧ｰ縺ｧ縲∝宛蠕｡縺励∪縺吶?
1040             * 蟆?擂逧?↓縺ｯ縲ゝableWriter 邉ｻ繧ょｻ?ｭ｢縺励※縲∝酔讒倥?繝輔Λ繧ｰ縺ｧ蛻ｶ蠕｡縺吶ｋ繧医≧縺ｫ螟画峩縺吶ｋ莠亥ｮ壹〒縺吶?
1041             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮUSE_TABLE_READER_RENDERER[={@og.value org.opengion.hayabusa.common.SystemData#USE_TABLE_READER_RENDERER}])縲?
1042             *
1043             * @og.rev 5.2.1.0 (2010/10/01) 譁ｰ隕丈ｽ懈?
1044             *
1045             * @param  flag 繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν騾?､画鋤繧定｡後≧縺九←縺?°
1046             * @see         org.opengion.hayabusa.common.SystemData#USE_TABLE_READER_RENDERER
1047             */
1048            public void setUseRenderer( final String flag ) {
1049                    useRenderer = nval( getRequestParameter( flag ),useRenderer );
1050            }
1051    
1052            /**
1053             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
1054             *
1055             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
1056             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
1057             *
1058             * @param       strm    ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
1059             * @throws IOException  蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
1060             */
1061            private void writeObject( final ObjectOutputStream strm ) throws IOException {
1062                    strm.defaultWriteObject();
1063            }
1064    
1065            /**
1066             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
1067             *
1068             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
1069             *
1070             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
1071             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
1072             *
1073             * @param       strm    ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
1074             * @see #release2()
1075             * @throws IOException  繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ縺ｫ髢｢縺吶ｋ蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
1076             * @throws ClassNotFoundException       繧ｯ繝ｩ繧ｹ繧定ｦ九▽縺代ｋ縺薙→縺後〒縺阪↑縺九▲縺溷?蜷?
1077             */
1078            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
1079                    strm.defaultReadObject();
1080            }
1081    
1082            /**
1083             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
1084             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
1085             *
1086             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
1087             */
1088            @Override
1089            public String toString() {
1090                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
1091                                    .println( "VERSION"                     ,VERSION        )
1092                                    .println( "separator"           ,separator              )
1093                                    .println( "fileURL"             ,fileURL                )
1094                                    .println( "filename"            ,filename               )
1095                                    .println( "encode"                      ,encode                 )
1096                                    .println( "readerClass"         ,readerClass    )
1097                                    .println( "maxRowCount"         ,maxRowCount    )
1098                                    .println( "displayMsg"          ,displayMsg             )
1099                                    .println( "executeCount"        ,executeCount   )
1100                                    .println( "modifyType"          ,modifyType             )
1101                                    .println( "checkColumns"        ,checkColumns   )
1102                                    .println( "adjustColumns"       ,adjustColumns  )
1103                                    .println( "nullCheck"           ,nullCheck              )
1104                                    .println( "command"                     ,command                )
1105                                    .println( "tableId"                     ,tableId                )
1106                                    .println( "sheetName"           ,sheetName              )
1107                                    .println( "sheetNos"            ,sheetNos               )               // 5.5.7.2 (2012/10/09)
1108                                    .println( "columns"                     ,columns                )
1109                                    .println( "useNumber"           ,useNumber              )
1110                                    .println( "Other..."    ,getAttributes().getAttribute() )
1111                                    .fixForm().toString() ;
1112            }
1113    }