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