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