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.io;
017    
018    import java.io.PrintWriter;
019    import java.util.List;
020    import java.util.Locale;
021    import java.util.Map;
022    import java.util.Map.Entry;
023    
024    import org.opengion.hayabusa.common.HybsSystem;
025    import org.opengion.hayabusa.common.HybsSystemException;
026    import org.opengion.hayabusa.db.DBTableModel;
027    import org.opengion.hayabusa.db.DBColumn;
028    import org.opengion.fukurou.util.StringUtil;
029    import org.opengion.fukurou.util.HybsEntry;
030    
031    /**
032     * 蛹ｺ蛻?ｊ譁?ｭ玲欠螳?蛻晄悄蛟､:繧ｿ繝?繧ｼ繝ｭ繧ｫ繝ｳ繝槭ヵ繧｡繧､繝ｫ縺ｮ譖ｸ縺榊?縺励け繝ｩ繧ｹ縺ｧ縺吶?
033     *
034     * 繝ｩ繝吶Ν?悟錐蜑搾ｼ後ョ繝ｼ繧ｿ縺ｮ蜃ｺ蜉幃Κ縺ｮ縺ｿ繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨☆繧後??悟推遞ｮ蜃ｺ蜉帙ヵ繧ｩ繝ｼ繝槭ャ繝医↓蜷医ｏ縺帙◆
035     * 繧ｵ繝悶け繝ｩ繧ｹ繧貞ｮ溽樟縺吶ｋ莠九′蜿ｯ閭ｽ縺ｧ縺吶?
036     * 繧ｼ繝ｭ繧ｫ繝ｳ繝槭ヵ繧｡繧､繝ｫ縺ｨ縺ｯ縲・XCEL縺ｮ繧ｼ繝ｭ繧ｵ繝励Ξ繧ｹ蟇ｾ遲悶→縺励※縲??繧ｼ繝ｭ縺ｮ譁?ｭ怜梛繝??繧ｿ繧貞?蜉帙☆繧?
037     * 譎ゅ↓縲∝?鬆ｭ縺ｫ繧ｫ繝ｳ繝?')繧剃ｻ倥￠縺ｦ縲√ぞ繝ｭ縺悟炎髯､(隕九∴縺ｪ縺上↑繧?迴ｾ雎｡繧呈椛豁｢縺励※縺?ｋ繝輔ぃ繧､繝ｫ縺ｧ縺吶?
038     *
039     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ,蜿ｯ螟蛾聞繧ｿ繝門玄蛻?ｊ譁?ｭ励ヵ繧｡繧､繝ｫ縺ｮ蜃ｺ蜉帶ｩ溯?繧貞ｮ溽樟縺励※縺?∪縺吶?
040     *
041     * @og.group 繝輔ぃ繧､繝ｫ蜃ｺ蜉?
042     *
043     * @version  4.0
044     * @author       Kazuhiko Hasegawa
045     * @since    JDK5.0,
046     */
047    public abstract class AbstractTableWriter implements TableWriter {
048            /** 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
049            private static final String VERSION = "5.7.9.0 (2014/08/08)" ;
050    
051            // 5.1.6.0 (2010/05/01) dbType 縺ｮ邁｡譏鍋噪縺ｪ險ｭ螳?
052            /** dbType 縺ｮ邁｡譏鍋噪縺ｪ險ｭ螳?{@value} */
053            public static final int STRING  = 0;
054            /** dbType 縺ｮ邁｡譏鍋噪縺ｪ險ｭ螳?{@value} */
055            public static final int NVAR    = 1;
056            /** dbType 縺ｮ邁｡譏鍋噪縺ｪ險ｭ螳?{@value} */
057            public static final int NUMBER  = 2;
058    
059            protected DBTableModel    table         = null;
060            protected DBColumn[]      dbColumn      = null;                 // table 縺ｫ蟇ｾ縺吶ｋ繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝?繧ｭ繝｣繝?す繝･)
061            protected int   numberOfColumns         = -1;                   // 4.0.0 (2005/01/31) 蜃ｺ蜉帛ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?焚
062            protected int[]                   clmNo         = null;                 // 蜃ｺ蜉帛ｯｾ雎｡縺ｮ繧ｫ繝ｩ繝?分蜿ｷ驟榊?
063            protected int[]                   dbType        = null;
064    
065            private String  separator               = TAB_SEPARATOR;        // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
066            private String  headerSequence  = HybsSystem.sys( "WRITER_HEADER_SEQUENCE" ) ;
067            private boolean append                  = false;                        // 3.5.4.2 (2003/12/15)
068            private String  lang                    = null;
069            private String  columns                 = null;                         // 4.0.0 (2005/11/30) 螟夜Κ謖?ｮ壹?繧ｫ繝ｩ繝?錐
070            private String  encode                  = null;                         // 3.5.4.5 (2004/01/23) 繧ｨ繝ｳ繧ｳ繝ｼ繝画枚蟄怜?謖?ｮ?
071    
072            private boolean useNumber               = true;                         // 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
073            private boolean useRenderer             = false;                        // 5.2.1.0 (2010/10/01)
074    
075            /**
076             * DBTableModel 縺九ｉ 蜷?ｽ｢蠑上?繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
077             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL 譖ｸ縺榊?縺玲凾縺ｫ菴ｿ逕ｨ縺励∪縺吶?
078             *
079             * @see #isExcel()
080             */
081            abstract public void writeDBTable();
082    
083            /**
084             * DBTableModel 縺九ｉ 繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
085             *
086             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
087             */
088            abstract public void writeDBTable( final PrintWriter writer );
089    
090            /**
091             * numberOfColumns 縺ｨ DBColumn 繧貞?譛溷喧縺励∪縺吶?
092             * 蜀?Κ逧?↓縲．BTableModel縲〕ang , columns 繧剃ｽｿ逕ｨ縺励※縲?
093             * numberOfColumns 縲‥bColumn縲…lmNo縲‥bType 縺ｮ蛟､繧貞?譛溷喧縺励∪縺吶?
094             * 繧ｫ繝ｩ繝?′?鷹?逶ｮ繧ゅ↑縺??蜷医?險?ｪ?lnag)縺梧悴謖?ｮ壹?DBTableModel縺梧悴謖?ｮ?null)
095             * 縺ｮ蝣ｴ蜷医?縲’alse 繧定ｿ斐＠縺ｾ縺吶?縺昴?蝣ｴ蜷医?縲∽ｻ･荳九?蜃ｦ逅??豁｣蟶ｸ縺ｫ陦後∴縺ｾ縺帙ｓ縲?
096             * 繝??繧ｿ縺鯉ｼ蝉ｻｶ縺ｮ蝣ｴ蜷医?縲∝?逅?ｒ陦後＞縺ｾ縺吶?騾壼ｸｸ縲√?繝?ム繝ｼ縺ｮ縺ｿ縺ｮ繝輔ぃ繧､繝ｫ繧?
097             * 菴懈?縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶?(縺薙ｌ繧帝屁蠖｢縺ｨ縺励※縲∝叙霎ｼ繝??繧ｿ繧堤匳骭ｲ縺吶ｋ莠九′蜿ｯ閭ｽ)
098             *
099             * @og.rev 4.0.0.0 (2005/12/31) 螟夜Κ謖?ｮ壹?繧ｫ繝ｩ繝?錐繧剃ｽｿ逕ｨ
100             * @og.rev 5.1.6.0 (2010/05/01) DbType 縺ｮ蛻晄悄蛟､繧定ｨｭ螳壹☆繧九?
101             *
102             * @return      蛻晄悄蛹匁?蜉滂ｼ嗾rue / 螟ｱ謨暦ｼ喃alse
103             */
104            protected boolean createDBColumn() {
105    
106                    boolean rtnFlag = false;
107                    if( lang != null && table != null ) {
108                            if( columns != null ) {
109                                    String[] clms = StringUtil.csv2Array( columns );
110                                    numberOfColumns = clms.length;
111                                    clmNo = new int[numberOfColumns];
112                                    for( int i=0; i<numberOfColumns; i++ ) {
113                                            int no = table.getColumnNo( clms[i] );
114                                            clmNo[i] = no;
115                                    }
116                            }
117                            else {
118                                    numberOfColumns = table.getColumnCount();
119                                    clmNo = new int[numberOfColumns];
120                                    for( int i=0; i<numberOfColumns; i++ ) {
121                                            clmNo[i] = i;
122                                    }
123                            }
124    
125                            dbColumn = table.getDBColumns();
126                            rtnFlag = (numberOfColumns > 0);     // 繧ｫ繝ｩ繝?′?鷹?逶ｮ莉･荳翫≠繧後?謌仙粥
127    
128                            // 5.1.6.0 (2010/05/01) DbType 縺ｮ蛻晄悄蛟､繧定ｨｭ螳壹☆繧九?
129                            dbType = new int[numberOfColumns];
130                            for( int i=0; i<numberOfColumns; i++ ) {
131                                    String type = dbColumn[clmNo[i]].getDbType();
132    
133                                    if( "NVAR".equals( type ) ) {
134                                            dbType[i] = NVAR;
135                                    }
136                                    else if( "S9".equals( type ) || "R".equals( type )  ) {
137                                            dbType[i] = NUMBER;
138                                    }
139                                    else {
140                                            dbType[i] = STRING;
141                                    }
142                            }
143                    }
144                    return rtnFlag;
145            }
146    
147            /**
148             * PrintWriter 縺ｫ DBTableModel縺ｮ繝倥ャ繝??諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
149             *
150             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
151             *
152             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
153             */
154            protected void writeHeader( final PrintWriter writer ) {
155                    // 縺薙％縺ｧ縺ｯ蜃ｦ逅?ｒ陦後＞縺ｾ縺帙ｓ縲?
156            }
157    
158            /**
159             * PrintWriter 縺ｫ DBTableModel縺ｮ繝ｩ繝吶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
160             * 隨ｬ荳?き繝ｩ繝?岼縺ｯ縲√Λ繝吶Ν諠??繧堤､ｺ縺?"#Label" 繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
161             * 縺薙?陦後?縲∝?蜉帛ｽ｢蠑上↓辟｡髢｢菫ゅ↓縲ゝableWriter.TAB_SEPARATOR 縺ｧ蛹ｺ蛻?ｉ繧後∪縺吶?
162             *
163             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
164             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
165             * @og.rev 4.0.0.0 (2005/12/31) 螟夜Κ謖?ｮ壹?繧ｫ繝ｩ繝?錐繧剃ｽｿ逕ｨ
166             *
167             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
168             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
169             */
170            protected void writeLabel( final DBTableModel table,final PrintWriter writer ) {
171                    if( useNumber ) {
172                            writer.print( "#Label" );
173                            writer.print( separator );
174                    }
175                    else {
176                            writer.print( "#" );
177                    }
178    
179                    for( int i=0; i<numberOfColumns; i++ ) {
180                            if( i != 0 ) { writer.print( separator ); }
181                            int clm = clmNo[i];
182                            writer.print( dbColumn[clm].getLabel() );
183                    }
184                    writer.println();
185            }
186    
187            /**
188             * PrintWriter 縺ｫ DBTableModel縺ｮ鬆?岼蜷肴ュ蝣ｱ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
189             * 隨ｬ荳?き繝ｩ繝?岼縺ｯ縲??逶ｮ蜷肴ュ蝣ｱ繧堤､ｺ縺?"#Name" 繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
190             * 縺薙?陦後?縲∝?蜉帛ｽ｢蠑上↓辟｡髢｢菫ゅ↓縲ゝableWriter.TAB_SEPARATOR 縺ｧ蛹ｺ蛻?ｉ繧後∪縺吶?
191             *
192             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
193             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
194             *
195             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
196             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
197             */
198            protected void writeName( final DBTableModel table,final PrintWriter writer ) {
199                    if( useNumber ) {
200                            writer.print( "#Name" );
201                            writer.print( separator );
202                    }
203                    else {
204                            writer.print( "#" );
205                    }
206    
207                    for( int i=0; i<numberOfColumns; i++ ) {
208                            if( i != 0 ) { writer.print( separator ); }
209                            int clm = clmNo[i];
210                            writer.print( table.getColumnName(clm) );
211                    }
212                    writer.println();
213            }
214    
215            /**
216             * PrintWriter 縺ｫ DBTableModel縺ｮ繧ｵ繧､繧ｺ諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
217             * 隨ｬ荳?き繝ｩ繝?岼縺ｯ縲√し繧､繧ｺ諠??繧堤､ｺ縺?"#Size" 繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
218             * 縺薙?陦後?縲∝?蜉帛ｽ｢蠑上↓辟｡髢｢菫ゅ↓縲ゝableWriter.TAB_SEPARATOR 縺ｧ蛹ｺ蛻?ｉ繧後∪縺吶?
219             *
220             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
221             * @og.rev 3.5.5.5 (2004/04/23) DBColumn 縺ｮ size 縺ｨ maxlength 縺ｮ 諢丞袖繧貞､画峩
222             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
223             *
224             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
225             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
226             */
227            protected void writeSize( final DBTableModel table,final PrintWriter writer ) {
228                    if( useNumber ) {
229                            writer.print( "#Size" );
230                            writer.print( separator );
231                    }
232                    else {
233                            writer.print( "#" );
234                    }
235    
236                    for( int i=0; i<numberOfColumns; i++ ) {
237                            if( i != 0 ) { writer.print( separator ); }
238                            int clm = clmNo[i];
239                            writer.print( dbColumn[clm].getTotalSize() );   // 4.0.0 (2005/01/31) 繝｡繧ｽ繝?ラ蜷榊､画峩
240                    }
241                    writer.println();
242            }
243    
244            /**
245             * PrintWriter 縺ｫ DBTableModel縺ｮ繧ｯ繝ｩ繧ｹ蜷肴ュ蝣ｱ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
246             * 隨ｬ荳?き繝ｩ繝?岼縺ｯ縲√し繧､繧ｺ諠??繧堤､ｺ縺?"#Class" 繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
247             * 縺薙?陦後?縲∝?蜉帛ｽ｢蠑上↓辟｡髢｢菫ゅ↓縲ゝableWriter.TAB_SEPARATOR 縺ｧ蛹ｺ蛻?ｉ繧後∪縺吶?
248             *
249             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
250             *
251             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
252             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
253             */
254            protected void writeClass( final DBTableModel table,final PrintWriter writer ) {
255                    if( useNumber ) {
256                            writer.print( "#Class" );
257                            writer.print( separator );
258                    }
259                    else {
260                            writer.print( "#" );
261                    }
262    
263                    for( int i=0; i<numberOfColumns; i++ ) {
264                            if( i != 0 ) { writer.print( separator ); }
265                            int clm = clmNo[i];
266                            writer.print( dbColumn[clm].getClassName() );
267                    }
268                    writer.println();
269            }
270    
271            /**
272             * PrintWriter 縺ｫ 繧ｻ繝代Ξ繝ｼ繧ｿ繝ｼ繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
273             * 隨ｬ荳?き繝ｩ繝?岼縺ｯ縲√し繧､繧ｺ諠??繧堤､ｺ縺?"#----" 繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
274             * 縺薙?陦後?縲∝?蜉帛ｽ｢蠑上↓辟｡髢｢菫ゅ↓縲ゝableWriter.TAB_SEPARATOR 縺ｧ蛹ｺ蛻?ｉ繧後∪縺吶?
275             *
276             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
277             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
278             *
279             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
280             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
281             */
282            protected void writeSeparator( final DBTableModel table,final PrintWriter writer ) {
283                    String sep = "----" ;
284                    if( useNumber ) {
285                            writer.print( "#----" );
286                            writer.print( separator );
287                    }
288                    else {
289                            writer.print( "#" );
290                    }
291    
292                    for( int i=0; i<numberOfColumns; i++ ) {
293                            if( i != 0 ) { writer.print( separator ); }
294                            writer.print( sep );
295                    }
296                    writer.println();
297            }
298    
299            /**
300             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
301             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?後ョ繝ｼ繧ｿ繧?繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ(")縺ｧ蝗ｲ縺ｿ縺ｾ縺吶?
302             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
303             *
304             * @og.rev 2.0.0.5 (2002/09/30) 蜈磯?縺? 縺ｧ縺九▽謨ｰ蟄励ち繧､繝?S9 or R)縺ｧ縺ｪ縺??蜷医↓ ' 繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣縲?
305             * @og.rev 2.3.1.2 (2003/01/28) 繝??繧ｿ蜃ｺ蜉帶凾縺ｫ縲∵隼陦後′菴吝?縺ｫ蜃ｺ縺輔ｌ繧狗ｮ?園繧剃ｿｮ豁｣縲?
306             * @og.rev 3.1.0.0 (2003/03/20) DBColumn 縺九ｉ縲“etDbType() 繧ｭ繝ｼ繧堤峩謗･蜿悶ｊ蜃ｺ縺?
307             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
308             * @og.rev 3.3.3.1 (2003/07/18) 繝輔ぃ繧､繝ｫ繝ｪ繝ｼ繝?繝ｩ繧､繝域凾縺ｫ蠕後ｍ繧ｹ繝壹?繧ｹ縺ｮ髯､蜴ｻ繧定｡後＞縺ｾ縺吶?
309             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
310             * @og.rev 3.8.0.1 (2005/06/17) DBType縺?NVAR 縺ｮ蝣ｴ蜷医?縲∝?縺ｮUnicode縺ｫ謌ｻ縺励∪縺吶?
311             * @og.rev 5.1.6.0 (2010/05/01) DbType 縺ｮ蛻晄悄蛟､(dbType)繧貞茜逕ｨ縺吶ｋ縲?
312             * @og.rev 5.2.1.0 (2010/10/01) 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲∥bstract 蛹悶＠縺ｾ縺吶?
313             *
314             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
315             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
316             */
317            abstract protected void writeData( final DBTableModel table,final PrintWriter writer ) ;
318    //      protected void writeData( final DBTableModel table,final PrintWriter writer ) {
319    //              int numberOfRows =      table.getRowCount();
320    //
321    //              for( int row=0; row<numberOfRows; row++ ) {
322    //                      if( useNumber ) {
323    //                              writer.print( row+1 );
324    //                              writer.print( separator );
325    //                      }
326    //
327    //                      for( int i=0; i<numberOfColumns; i++ ) {
328    //                              if( i != 0 ) { writer.print( separator ); }
329    //
330    //                              int clm = clmNo[i];
331    //                              String val = table.getValue(row,clm);
332    ////                            if( "NVAR".equals( dbColumn[clm].getDbType()) ) {
333    //                              if( dbType[i] == NVAR ) {
334    //                                      val = StringUtil.getReplaceEscape( val );
335    //                              }
336    //
337    //                              if( val != null && val.length() > 0 && val.charAt(0) == '0' &&
338    ////                                    NUMBER_TYPE_LIST.indexOf( dbColumn[clm].getDbType() ) < 0 ) {
339    //                                      dbType[i] == NUMBER ) {
340    //                                              writer.print( "'" );            // 髢句ｧ区律縺ｪ縺ｩ縺ｮ 00000000 繧呈枚蟄怜?繧ｿ繧､繝励〒貂｡縺?
341    //                              }
342    //                              writer.print( StringUtil.rTrim( val ) );
343    //                      }
344    //                      writer.println();
345    //              }
346    //      }
347    
348            /**
349             * DBTableModel 繧偵そ繝?ヨ縺励∪縺吶?
350             *
351             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
352             * @og.rev 3.5.4.2 (2003/12/15) lang 蠑墓焚繧ょ酔譎ゅ↓險ｭ螳壹＠縺ｾ縺吶?
353             *
354             * @param       table DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
355             * @param       lang 險?ｪ槭さ繝ｼ繝?
356             */
357            public void setDBTableModel( final DBTableModel table, final String lang ) {
358                    this.table = table;
359                    this.lang = lang;
360            }
361    
362            /**
363             * 蜀?Κ縺ｮ DBTableModel 繧定ｿ斐＠縺ｾ縺吶?
364             *
365             * @return      DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
366             */
367            public DBTableModel getDBTableModel() {
368                    return table;
369            }
370    
371            /**
372             * DBTableModel縺ｮ蜃ｺ蜉幃?繧偵そ繝?ヨ縺励∪縺吶?
373             * Label,Name,Size,Class,Data 縺ｮ蜷?ヵ繧｣繝ｼ繝ｫ繝峨?鬆ｭ譁?ｭ励?繧｢繝ｫ繝輔ぃ繝吶ャ繝医〒
374             * 蜃ｺ蜉幃?繧定ｨｭ螳壹＠縺ｾ縺吶?
375             *
376             * 縺ｪ縺奇ｼ悟?蜉幃?縺ｫ謖?ｮ壹＠縺ｪ縺??逶ｮ縺ｯ蜃ｺ蜉帙＆繧後∪縺帙ｓ
377             *
378             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
379             *
380             * @param       hs 蜃ｺ蜉幃? (LNSCD 縺ｪ縺ｩ)
381             */
382            public void setHeaderSequence( final String hs ) {
383                    if( hs != null ) { headerSequence = hs ; }
384            }
385    
386            /**
387             * DBTableModel縺ｮ蜃ｺ蜉幃?繧定ｿ斐＠縺ｾ縺吶?
388             * Label,Name,Size,Class,Data 縺ｮ蜷?ヵ繧｣繝ｼ繝ｫ繝峨?鬆ｭ譁?ｭ励?繧｢繝ｫ繝輔ぃ繝吶ャ繝医〒
389             * 蜃ｺ蜉幃?繧定ｨｭ螳壹＠縺ｾ縺吶?
390             *
391             * 縺ｪ縺奇ｼ悟?蜉幃?縺ｫ謖?ｮ壹＠縺ｪ縺??逶ｮ縺ｯ蜃ｺ蜉帙＆繧後∪縺帙ｓ
392             *
393             * @return      蜃ｺ蜉幃? (LNSCD 縺ｪ縺ｩ)
394             */
395            public String getHeaderSequence() {
396                    return headerSequence ;
397            }
398    
399            /**
400             * 繝??繧ｿ繧呈嶌縺崎ｾｼ繧??蜷医?,蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
401             *
402             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
403             *
404             * @param       sep 蛹ｺ蛻?ｊ譁?ｭ?
405             */
406            public void setSeparator( final String sep ) {
407                    if( sep != null ) { this.separator = sep; }
408            }
409    
410            /**
411             * 繝??繧ｿ繧呈嶌縺崎ｾｼ繧??蜷医?,蛹ｺ蛻?ｊ譁?ｭ励ｒ霑斐＠縺ｾ縺吶?
412             *
413             * @return      蛹ｺ蛻?ｊ譁?ｭ?
414             */
415            public String getSeparator() {
416                    return separator;
417            }
418    
419            /**
420             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※譖ｸ縺崎ｾｼ繧?→縺阪↓縲∬ｿｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ繧?°縺ｩ縺?°繧定ｨｭ螳壹＠縺ｾ縺吶?
421             * 蛻晄悄蛟､縺ｯ縲’alse(譁ｰ隕上Δ繝ｼ繝?縺ｧ縺吶?
422             *
423             * @og.rev 3.5.4.2 (2003/12/15) 譁ｰ隕剰ｿｽ蜉?
424             *
425             * @param       flag    [true:霑ｽ蜉?Δ繝ｼ繝?false:譁ｰ隕上Δ繝ｼ繝云
426             */
427            public void setAppend( final boolean flag ) {
428                    append = flag;
429            }
430    
431            /**
432             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※譖ｸ縺崎ｾｼ繧?→縺阪↓縲∬ｿｽ蜉?Δ繝ｼ繝峨〒譖ｸ縺崎ｾｼ繧?°縺ｩ縺?°繧貞叙蠕励＠縺ｾ縺吶?
433             * 蛻晄悄蛟､縺ｯ縲’alse(譁ｰ隕上Δ繝ｼ繝?縺ｧ縺吶?
434             *
435             * @og.rev 3.5.4.2 (2003/12/15) 譁ｰ隕剰ｿｽ蜉?
436             *
437             * @return      true(霑ｽ蜉?Δ繝ｼ繝?/false(譁ｰ隕上Δ繝ｼ繝?
438             */
439            public boolean isAppend() {
440                    return append ;
441            }
442    
443            /**
444             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※隱ｭ縺ｿ霎ｼ繧?→縺阪?繧ｷ繝ｼ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺吶?
445             * 蛻晄悄蛟､縺ｯ縲?Sheet1" 縺ｧ縺吶?
446             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
447             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
448             *
449             * @og.rev 3.5.4.2 (2003/12/15) 譁ｰ隕剰ｿｽ蜉?
450             * @og.rev 3.5.4.3 (2004/01/05) 螳溯｣?ｻ?ｭ｢(TableWriter_Excel 縺ｸ遘ｻ蜍?
451             *
452             * @param   sheetName 繧ｷ繝ｼ繝亥錐
453             */
454            public void setSheetName( final String sheetName ) {
455                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
456                    throw new UnsupportedOperationException( errMsg );
457            }
458    
459            /**
460             * EXCEL髮帛梛蜿り?繝輔ぃ繧､繝ｫ縺ｮ繧ｷ繝ｼ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺吶?
461             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
462             *
463             * EXCEL繝輔ぃ繧､繝ｫ繧呈嶌縺榊?縺呎凾縺ｫ縲?屁蝙九→縺励※蜿ら?縺吶ｋ繧ｷ繝ｼ繝亥錐繧呈欠螳壹＠縺ｾ縺吶?
464             * 縺薙ｌ縺ｫ繧医ｊ縲∬､?焚縺ｮ蠖｢蠑上?逡ｰ縺ｪ繧九ョ繝ｼ繧ｿ繧帝?谺｡譖ｸ縺榊?縺励◆繧?append繝｢繝ｼ繝峨ｒ菴ｵ逕ｨ)縺吶ｋ
465             * 縺薙→繧??繧ｷ繝ｼ繝医ｒ謖?ｮ壹＠縺ｦ譁ｰ隕上↓EXCEL繧剃ｽ懈?縺吶ｋ蝣ｴ蜷医↓繝輔か繝ｼ繝?ｒ險ｭ螳壹☆繧倶ｺ九′蜿ｯ閭ｽ縺ｫ縺ｪ繧翫∪縺吶?
466             * 蛻晄悄蛟､縺ｯ縲］ull(隨ｬ荳?す繝ｼ繝? 縺ｧ縺吶?
467             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
468             *
469             * @og.rev 3.5.4.3 (2004/01/05) 譁ｰ隕剰ｿｽ蜉?
470             *
471             * @param   sheetName 繧ｷ繝ｼ繝亥錐
472             */
473            public void setRefSheetName( final String sheetName )  {
474                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
475                    throw new UnsupportedOperationException( errMsg );
476            }
477    
478            /**
479             * 縺薙?繧ｯ繝ｩ繧ｹ縺後?EXCEL蟇ｾ蠢懈ｩ溯?繧呈戟縺｣縺ｦ縺?ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
480             *
481             * EXCEL蟇ｾ蠢懈ｩ溯?縺ｨ縺ｯ縲√す繝ｼ繝亥錐縺ｮ繧ｻ繝?ヨ縲?屁蝙句盾辣ｧ繝輔ぃ繧､繝ｫ蜷阪?繧ｻ繝?ヨ縲?
482             * 譖ｸ縺崎ｾｼ縺ｿ蜈?ヵ繧｡繧､繝ｫ縺ｮFile繧ｪ繝悶ず繧ｧ繧ｯ繝亥叙蠕励↑縺ｩ縺ｮ縲∫音谿頑ｩ溯?縺ｧ縺吶?
483             * 譛ｬ譚･縺ｯ縲√う繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧貞?縺代ｋ縺ｹ縺阪→閠?∴縺ｾ縺吶′縲》aglib 繧ｯ繝ｩ繧ｹ遲峨?
484             * 髢｢菫ゅ′縺ゅｊ縲∝撫縺?粋繧上○縺ｫ繧医ｋ譚｡莉ｶ蛻?ｲ舌〒蟇ｾ蠢懊＠縺ｾ縺吶?
485             *
486             * @og.rev 3.5.4.3 (2004/01/05) 譁ｰ隕剰ｿｽ蜉?
487             *
488             * @return      EXCEL蟇ｾ蠢懈ｩ溯?繧呈戟縺｣縺ｦ縺?ｋ縺九←縺?°(縺薙％縺ｧ縺ｯ縲’alse蝗ｺ螳壹〒縺?
489             */
490            public boolean isExcel() {
491                    return false;
492            }
493    
494            /**
495             * 蜃ｺ蜉帛?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?(DIR + Filename)
496             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
497             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
498             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∝ｿ?★縲ゞnsupportedOperationException 縺後?throw 縺輔ｌ縺ｾ縺吶?
499             *
500             * @og.rev 3.5.4.3 (2004/01/05) 譁ｰ隕丈ｽ懈?
501             *
502             * @param   filename EXCEL髮帛梛蜿り?繝輔ぃ繧､繝ｫ蜷?
503             */
504            public void setFilename( final String filename ) {
505                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
506                    throw new UnsupportedOperationException( errMsg );
507            }
508    
509            /**
510             * EXCEL髮帛梛蜿り?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?(DIR + Filename)
511             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
512             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
513             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∝ｿ?★縲ゞnsupportedOperationException 縺後?throw 縺輔ｌ縺ｾ縺吶?
514             *
515             * @og.rev 3.5.4.3 (2004/01/05) 譁ｰ隕丈ｽ懈?
516             *
517             * @param   filename EXCEL髮帛梛蜿り?繝輔ぃ繧､繝ｫ蜷?
518             */
519            public void setRefFilename( final String filename ) {
520                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
521                    throw new UnsupportedOperationException( errMsg );
522            }
523    
524            /**
525             * EXCEL蜃ｺ蜉帶凾縺ｮ繝?ヵ繧ｩ繝ｫ繝医ヵ繧ｩ繝ｳ繝亥錐繧定ｨｭ螳壹＠縺ｾ縺吶?
526             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
527             *
528             * EXCEL繝輔ぃ繧､繝ｫ繧呈嶌縺榊?縺呎凾縺ｫ縲√ョ繝輔か繝ｫ繝医ヵ繧ｩ繝ｳ繝亥錐繧呈欠螳壹＠縺ｾ縺吶?
529             * 繝輔か繝ｳ繝亥錐縺ｯ縲・XCEL縺ｮ繝輔か繝ｳ繝亥錐繧偵◎縺ｮ縺ｾ縺ｾ菴ｿ逕ｨ縺励※縺上□縺輔＞縲?
530             * 蜀?Κ逧?↓縲￣OI 縺ｮ org.apache.poi.hssf.usermodel.HSSFFont#setFontName( String )
531             * 縺ｫ險ｭ螳壹＆繧後∪縺吶?
532             * 蛻晄悄蛟､縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ 縺ｮ TABLE_WRITER_DEFAULT_FONT_NAME 縺ｧ縺吶?
533             *
534             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
535             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∝ｿ?★縲ゞnsupportedOperationException 縺後?throw 縺輔ｌ縺ｾ縺吶?
536             *
537             * @og.rev 3.8.5.3 (2006/08/07) 譁ｰ隕剰ｿｽ蜉?
538             *
539             * @param   fontName 繝輔か繝ｳ繝亥錐
540             */
541            public void setFontName( final String fontName ) {
542                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
543                    throw new UnsupportedOperationException( errMsg );
544            }
545    
546            /**
547             * EXCEL蜃ｺ蜉帶凾縺ｮ繝?ヵ繧ｩ繝ｫ繝医ヵ繧ｩ繝ｳ繝医?繧､繝ｳ繝域焚繧定ｨｭ螳壹＠縺ｾ縺吶?
548             * 縺薙ｌ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｨ縺励※螳溯｣?＆繧後※縺?∪縺吶?
549             *
550             * EXCEL繝輔ぃ繧､繝ｫ繧呈嶌縺榊?縺呎凾縺ｫ縲√ョ繝輔か繝ｫ繝医?繧､繝ｳ繝域焚繧呈欠螳壹＠縺ｾ縺吶?
551             * 蜀?Κ逧?↓縲￣OI 縺ｮ org.apache.poi.hssf.usermodel.HSSFFont#setFontHeightInPoints( short )
552             * 縺ｫ險ｭ螳壹＆繧後∪縺吶?
553             * 蛻晄悄蛟､縺ｯ縲√す繧ｹ繝?Β繝ｪ繧ｽ繝ｼ繧ｹ 縺ｮ TABLE_WRITER_DEFAULT_FONT_POINTS 縺ｧ縺吶?
554             *
555             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
556             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∝ｿ?★縲ゞnsupportedOperationException 縺後?throw 縺輔ｌ縺ｾ縺吶?
557             *
558             * @og.rev 3.8.5.3 (2006/08/07) 譁ｰ隕剰ｿｽ蜉?
559             *
560             * @param       point   繝輔か繝ｳ繝医?繧､繝ｳ繝域焚
561             */
562            public void setFontPoint( final short point ) {
563                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
564                    throw new UnsupportedOperationException( errMsg );
565            }
566    
567            /**
568             * 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｨ繝ｳ繧ｳ繝ｼ繝画枚蟄怜?繧呈欠螳壹＠縺ｾ縺吶?
569             * 繝輔ぃ繧､繝ｫ縺ｯ縲。ufferedReader 縺ｧ蜿励￠蜿悶ｋ轤ｺ縲∵悽譚･縺ｯ縲√お繝ｳ繧ｳ繝ｼ繝峨?荳崎ｦ√〒縺吶′縲?
570             * 蝗ｺ螳夐聞繝輔ぃ繧､繝ｫ縺ｮ隱ｭ縺ｿ蜿悶ｊ譎ゅ?繝舌う繝医さ繝ｼ繝牙?蜑ｲ譎ゅ↓縲∵欠螳壹?繧ｨ繝ｳ繧ｳ繝ｼ繝峨〒
571             * 蛻?牡縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?(萓九∴縺ｰ縲∝濠隗呈枚蟄励?縲ヾhift_JIS 縺ｧ縺ｯ縲?ｼ代ヰ繧､繝?
572             *
573             * @og.rev 3.5.4.5 (2004/01/23) 譁ｰ隕丈ｽ懈?
574             *
575             * @param   enc 繝輔ぃ繧､繝ｫ縺ｮ繧ｨ繝ｳ繧ｳ繝ｼ繝画枚蟄怜?
576             */
577            public void setEncode( final String enc ) {
578                    encode = enc;
579            }
580    
581            /**
582             * 隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ縺ｮ繧ｨ繝ｳ繧ｳ繝ｼ繝画枚蟄怜?繧貞叙蠕励＠縺ｾ縺吶?
583             * 繝輔ぃ繧､繝ｫ縺ｯ縲。ufferedReader 縺ｧ蜿励￠蜿悶ｋ轤ｺ縲∵悽譚･縺ｯ縲√お繝ｳ繧ｳ繝ｼ繝峨?荳崎ｦ√〒縺吶′縲?
584             * 蝗ｺ螳夐聞繝輔ぃ繧､繝ｫ縺ｮ隱ｭ縺ｿ蜿悶ｊ譎ゅ?繝舌う繝医さ繝ｼ繝牙?蜑ｲ譎ゅ↓縲∵欠螳壹?繧ｨ繝ｳ繧ｳ繝ｼ繝峨〒
585             * 蛻?牡縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?(萓九∴縺ｰ縲∝濠隗呈枚蟄励?縲ヾhift_JIS 縺ｧ縺ｯ縲?ｼ代ヰ繧､繝?
586             *
587             * @og.rev 3.5.4.5 (2004/01/23) 譁ｰ隕丈ｽ懈?
588             *
589             * @return      繝輔ぃ繧､繝ｫ縺ｮ繧ｨ繝ｳ繧ｳ繝ｼ繝画枚蟄怜?
590             */
591            protected String getEncode() {
592                    return encode;
593            }
594    
595            /**
596             * 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳壹＠縺ｾ縺吶?
597             *
598             * 騾壼ｸｸ縺ｮ繝輔か繝ｼ繝槭ャ繝医〒縺ｯ縲∝推陦後?蜈磯?縺ｫ陦檎分蜿ｷ繧貞?蜉帙＠縺ｾ縺吶?
599             * 縺薙ｌ縺ｯ縲?NAME 螻樊?繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医↓縺ｯ縲∝ｿ?★蜃ｺ蜉帙☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?
600             * (#NAME 螻樊?縺ｯ縲∬ｪｭ縺ｿ蜿悶ｊ譎ゅ↓縺ｯ縲∝ｿ??縺ｧ縺吶?)
601             * 縺薙?縲∝?鬆ｭ縺ｮ陦檎分蜿ｷ縺御ｸ崎ｦ√↑蝣ｴ蜷?縺､縺ｾ繧翫?莉悶?繧ｷ繧ｹ繝?Β縺ｸ縺ｮ繝??繧ｿ蜃ｺ蜉帙?
602             * 縺薙?繧ｷ繧ｹ繝?Β縺ｧ縺ｯ縲?NAME 螻樊?縺悟?蜉帙＆繧後↑縺?◆繧√?隱ｭ縺ｿ霎ｼ縺ｿ縺ｧ縺阪∪縺帙ｓ縲?
603             * 縺薙?陦檎分蜿ｷ繧貞?蜉帙＠縺ｪ縺?ｈ縺?↓縺ｧ縺阪∪縺吶?
604             * 蛻晄悄蛟､縺ｯ縲》rue(蜃ｺ蜉帙☆繧? 縺ｧ縺吶?
605             *
606             * @og.rev 3.7.0.2 (2005/02/14) 譁ｰ隕剰ｿｽ蜉?
607             *
608             * @param   useNumber 陦檎分蜿ｷ諠??繧?[true:蜃ｺ蜉帙☆繧?false:縺励↑縺Ь
609             */
610            public void setUseNumber( final boolean useNumber ) {
611                    this.useNumber = useNumber;
612            }
613    
614            /**
615             * 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧定ｿ斐＠縺ｾ縺吶?
616             *
617             * 騾壼ｸｸ縺ｮ繝輔か繝ｼ繝槭ャ繝医〒縺ｯ縲∝推陦後?蜈磯?縺ｫ陦檎分蜿ｷ繧貞?蜉帙＠縺ｾ縺吶?
618             * 縺薙ｌ縺ｯ縲?NAME 螻樊?繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医↓縺ｯ縲∝ｿ?★蜃ｺ蜉帙☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?
619             * (#NAME 螻樊?縺ｯ縲∬ｪｭ縺ｿ蜿悶ｊ譎ゅ↓縺ｯ縲∝ｿ??縺ｧ縺吶?)
620             * 縺薙?縲∝?鬆ｭ縺ｮ陦檎分蜿ｷ縺御ｸ崎ｦ√↑蝣ｴ蜷?縺､縺ｾ繧翫?莉悶?繧ｷ繧ｹ繝?Β縺ｸ縺ｮ繝??繧ｿ蜃ｺ蜉帙?
621             * 縺薙?繧ｷ繧ｹ繝?Β縺ｧ縺ｯ縲?NAME 螻樊?縺悟?蜉帙＆繧後↑縺?◆繧√?隱ｭ縺ｿ霎ｼ縺ｿ縺ｧ縺阪∪縺帙ｓ縲?
622             * 縺薙?陦檎分蜿ｷ繧貞?蜉帙＠縺ｪ縺?ｈ縺?↓縺ｧ縺阪∪縺吶?
623             * 蛻晄悄蛟､縺ｯ縲》rue(蜃ｺ蜉帙☆繧? 縺ｧ縺吶?
624             *
625             * @og.rev 3.7.0.2 (2005/02/14) 譁ｰ隕剰ｿｽ蜉?
626             *
627             * @return   陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)
628             */
629            protected boolean isUseNumber() {
630                    return useNumber;
631            }
632    
633            /**
634             * 繝代Λ繝｡繝ｼ繧ｿ繝ｼ繝ｪ繧ｹ繝医ｒ繧ｻ繝?ヨ縺励∪縺吶?
635             * 蜀?Κ縺ｯ縲？ybsEntry 繧ｯ繝ｩ繧ｹ繧呈戟縺｣縺ｦ縺?∪縺吶?
636             * 蠑墓焚縺後?null 縺ｮ蝣ｴ蜷医?縲∽ｽ輔ｂ縺励∪縺帙ｓ縲?
637             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
638             *
639             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕剰ｿｽ蜉?
640             *
641             * @param   listParam   繝代Λ繝｡繝ｼ繧ｿ繝ｼ繝ｪ繧ｹ繝?
642             */
643            public void setParam( final List<HybsEntry> listParam ) {
644                    String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲々ML霑ｽ蜉?ｩ溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
645                    throw new UnsupportedOperationException( errMsg );
646            }
647    
648            /**
649             * 蜃ｺ蜉帛?繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??繧偵?螟夜Κ(繧ｿ繧ｰ)繧医ｊCSV蠖｢蠑上?譁?ｭ怜?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
650             * 縺溘□縺励?謖?ｮ壹?繧ｫ繝ｩ繝?錐縺ｯ縲．BTableModel荳翫↓蟄伜惠縺励※縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
651             *
652             * @og.rev 4.0.0.0 (2005/11/30) 譁ｰ隕剰ｿｽ蜉?
653             *
654             * @param   clms 蜃ｺ蜉帛?繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
655             */
656            public void setColumns( final String clms ) {
657                    columns = clms ;
658            }
659    
660            /**
661             * 繝??繧ｿ縺ｮ譖ｸ縺崎ｾｼ縺ｿ髢句ｧ玖｡檎分蜿ｷ繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:0)縲?
662             *
663             * TAB蛹ｺ蛻?ｊ繝?く繧ｹ繝医ｄEXCEL遲峨?繝??繧ｿ縺ｮ譖ｸ縺崎ｾｼ縺ｿ縺ｮ髢句ｧ玖｡檎分蜿ｷ繧呈欠螳壹＠縺ｾ縺吶?
664             * 螻樊?蜷阪?縲∬｡後ｒ鬟帙?縺吝?逅?→縺?≧縺薙→縺ｧ縲〉eadTable 繧ｿ繧ｰ縺ｨ蜷後§蜷咲ｧｰ縺ｧ縺吶?
665             * 繝輔ぃ繧､繝ｫ縺ｮ蜈磯?陦後′縲?ｼ占｡後→縺励※繧ｫ繧ｦ繝ｳ繝医＠縺ｾ縺吶?縺ｧ縲∬ｨｭ螳壼?縺ｯ縲∬ｪｭ縺ｿ鬟帙?縺?
666             * 莉ｶ謨ｰ縺ｫ縺ｪ繧翫∪縺吶?(?代→謖?ｮ壹☆繧九→縲?ｼ台ｻｶ隱ｭ縺ｿ鬟帙?縺励??定｡檎岼縺九ｉ隱ｭ縺ｿ霎ｼ縺ｿ縺ｾ縺吶?)
667             * 陦後?隱ｭ縺ｿ鬟帙?縺励→縲√き繝ｩ繝??隱ｭ縺ｿ鬟帙?縺?columns)縲〉efFileURL縲〉efFilename縲?
668             * refSheetName 縺ｨ縺ｨ繧ゅ↓菴ｿ逕ｨ縺吶ｌ縺ｰ縲√≠繧狗ｨ句ｺｦ縺ｮ繝ｬ繧､繧｢繧ｦ繝郁ｨｭ螳壹′蜿ｯ閭ｽ縺ｧ縺吶?
669             * 縺ｪ縺翫?縺薙?讖溯?縺ｯ縲ゝableWriter_Excel 縺ｮ縺ｿ縺ｫ螳溯｣?＠縺ｾ縺吶?
670             *
671             * @og.rev 5.7.9.0 (2014/08/08) 譁ｰ隕丈ｽ懈?
672             *
673             * @param       skipRowCount 譖ｸ縺崎ｾｼ縺ｿ髢句ｧ玖｡檎分蜿ｷ
674             */
675            public void setSkipRowCount( final int skipRowCount ) {
676                    if( skipRowCount != 0 ) {
677                            String errMsg = "縺薙?繝｡繧ｽ繝?ラ縺ｯ縲ゝableWriter_Excel 縺ｮ縺ｿ縺ｮ讖溯?縺ｧ縺吶?縺ｧ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?;
678                            throw new UnsupportedOperationException( errMsg );
679                    }
680            }
681    
682            /**
683             * 譖ｸ霎ｼ蜃ｦ逅?〒繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?°[true/false]繧呈欠螳壹＠縺ｾ縺吶?
684             *
685             * 繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ繧偵◎縺ｮ縺ｾ縺ｾ縺ｮ蛟､縺ｧ蜃ｺ蜉帙☆繧九→縲∵焚蟄励ｄ險伜捷縺ｫ縺ｪ繧贋ｽ輔′譖ｸ縺九ｌ縺ｦ縺?ｋ縺ｮ縺?
686             * 荳肴?縺ｫ縺ｪ繧翫∪縺吶?
687             * 縺薙ｌ縺ｯ縲√さ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ繧偵Λ繝吶Ν縺ｫ螟画鋤縺励※蜃ｺ蜉帙☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺吶?
688             * 蠖鍋┯縲√さ繝ｼ繝峨?繝ｦ繝九?繧ｯ縺ｧ縺吶′縲√Λ繝吶Ν縺ｯ繝ｦ繝九?繧ｯ縺ｫ縺ｪ繧九°縺ｩ縺?°菫晞囿縺ｯ縺輔ｌ縺ｦ縺?∪縺帙ｓ縺ｮ縺ｧ
689             * TableReader 邉ｻ縺ｧ隱ｭ縺ｿ霎ｼ繧??蜷医↓縺ｯ縲√Μ繧ｹ繧ｯ縺檎匱逕溘＠縺ｾ縺吶?
690             * 縺ｾ縺溘?TableReader 邉ｻ縺ｧ隱ｭ縺ｿ霎ｼ繧??蜷医↓繧ゅ?繝ｩ繝吶Ν縺九ｉ繧ｳ繝ｼ繝峨ｒ豎ゅａ繧矩?螟画鋤繧定｡後≧繧医≧縺ｫ縲?
691             * setUseRenderer 繝｡繧ｽ繝?ラ縺ｧ謖?ｮ壹☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?
692             *
693             * 蠕捺擂縺ｯ縲ゝableWriter 邉ｻ縺ｫ縲ゝableWriter_Renderer 邉ｻ縺ｮ繧ｯ繝ｩ繧ｹ繧剃ｽ懊▲縺ｦ蟇ｾ蠢懊＠縺ｦ縺?∪縺励◆縺後?
694             * 縺薙?繝｡繧ｽ繝?ラ縺ｮ螻樊?蛟､縺ｮ繝輔Λ繧ｰ縺ｧ縲∝宛蠕｡縺励∪縺吶?
695             *
696             * @og.rev 5.2.1.0 (2010/10/01) 譁ｰ隕丈ｽ懈?
697             *
698             * @param       useRenderer     繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?° [true:陦後≧/false:陦後ｏ縺ｪ縺Ь
699             */
700            public void setUseRenderer( final boolean useRenderer ) {
701                    this.useRenderer = useRenderer;
702            }
703    
704            /**
705             * 譖ｸ縺榊?縺怜?逅?〒繧ｳ繝ｼ繝峨Μ繧ｽ繝ｼ繧ｹ縺ｮ繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
706             * 蛻晄悄蛟､縺ｯ縲’alse(陦後ｏ縺ｪ縺? 縺ｧ縺吶?
707             *
708             * @og.rev 5.2.1.0 (2010/10/01) 譁ｰ隕丈ｽ懈?
709             *
710             * @return      繝ｩ繝吶Ν螟画鋤繧定｡後≧縺九←縺?°(true:陦後≧/false:陦後ｏ縺ｪ縺?
711             */
712            protected boolean isUseRenderer() {
713                    return useRenderer ;
714            }
715    
716            /**
717             * 繝??繧ｿ繧?繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ(")縺ｧ蝗ｲ縺ｿ縺ｾ縺吶?
718             *
719             * 縺薙?蜃ｦ逅?〒縺ｯ縲∝燕蠕後ｒ繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医〒蝗ｲ縺?◆繧√?謾ｹ陦後?譛臥┌縺ｯ蛻､螳壹☆繧?
720             * 蠢?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲?
721             * 繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ蜷ｫ繧??蜷医?縲√◎縺ｮ逶ｴ蜑阪↓繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ蠑ｷ蛻ｶ逧?↓霑ｽ蜉?＠縺ｾ縺吶?
722             *
723             * @param        data 蜈??String譁?ｭ怜?
724             *
725             * @return       繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ縺ｧ蝗ｲ縺ｾ繧後◆譁?ｭ怜?
726             */
727            protected String quotation( final String data ) {
728                    return "\"" + StringUtil.replace( data,"\"","\"\"" ) + "\"" ;
729            }
730    
731            /**
732             * 繝??繧ｿ縺ｫ蟇ｾ縺励※ 謾ｹ陦後?繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝育ｭ峨?蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
733             *
734             * 縺薙ｌ縺ｯ縲√ョ繝ｼ繧ｿ縺ｮ蜑榊ｾ後ｒ繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医〒諡ｬ繧?quotation(String)縺ｨ逡ｰ縺ｪ繧?
735             * 蜑榊ｾ後↓縺ｯ縲√ム繝悶Ν繧ｯ繧ｪ繝ｼ繝?繧定ｿｽ蜉?＠縺ｾ縺帙ｓ縲?
736             * 縺溘□縺励?莉･荳九??偵▽縺ｮ譚｡莉ｶ縺ｧ蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
737             * ?托ｼ取隼陦後ｒ蜷ｫ繧??蜷医?縲√ム繝悶Ν繧ｯ繧ｪ繝ｼ繝医ｒ蠑ｷ蛻ｶ逧?↓蜑榊ｾ後↓霑ｽ蜉?☆繧九?
738             * ?抵ｼ弱ム繝悶Ν繧ｯ繧ｪ繝ｼ繝医ｒ蜷ｫ繧??蜷医?縲√◎縺ｮ逶ｴ蜑阪↓繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ蠑ｷ蛻ｶ逧?↓霑ｽ蜉?☆繧九?
739             *
740             * @og.rev 5.2.2.0 (2010/11/01) 譁ｰ隕剰ｿｽ蜉?
741             *
742             * @param        data 蜈??String譁?ｭ怜?
743             *
744             * @return       謾ｹ陦後?繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝育ｭ峨?蜃ｦ逅?
745             */
746            protected String quotation2( final String data ) {
747                    String rtn = StringUtil.replace( data,"\"","\"\"" );
748                    if( rtn != null && rtn.indexOf( HybsSystem.CR ) >= 0 ) {
749                            rtn = "\"" + rtn + "\"" ;
750                    }
751    
752                    return rtn ;
753            }
754    
755            /**
756             * keys 縺ｮ謨ｴ蜷域?繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
757             *
758             * 繧ｭ繝ｼ縺橘eysMap縺ｮ縺ｩ縺｡繧峨°縺?null 縺ｮ蝣ｴ蜷医?縲∽ｽ輔ｂ縺励∪縺帙ｓ縲?
759             * 繝√ぉ繝?け縺吶ｋ繧ｭ繝ｼ縺ｯ縲∝?驛ｨ縺ｧ螟ｧ譁?ｭ励↓螟画鋤縺励※縺翫″縺ｾ縺吶?
760             * keysMap 縺ｫ逋ｻ骭ｲ縺吶ｋ繧ｭ繝ｼ縺ｯ縲∝､ｧ譁?ｭ励〒逋ｻ骭ｲ縺励※縺翫＞縺ｦ縺上□縺輔＞縲?
761             * 縺薙％縺ｮ繝√ぉ繝?け縺ｧ縺ｯ縲√く繝ｼ繝槭ャ繝励↓蟄伜惠縺励↑縺代ｌ縺ｰ縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
762             *
763             * @og.rev 5.6.6.1 (2013/07/12) keys 縺ｮ謨ｴ蜷域?繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
764             *
765             * @param   key 繝√ぉ繝?け縺吶ｋ繧ｭ繝ｼ譁?ｭ怜?(null 縺ｮ蝣ｴ蜷医?縲∝?逅?＠縺ｪ縺?
766             * @param   keysMap 蛻ｩ逕ｨ蜿ｯ閭ｽ縺ｪ繧ｭ繝ｼ縺ｮ繝槭ャ繝?螟ｧ譁?ｭ励↓邨ｱ荳?
767             */
768            protected void checkParam( final String key,final Map<String,String> keysMap ) {
769                    // key 縺?keysMap 縺九←縺｡繧峨°縺?null 縺ｮ蝣ｴ蜷医?縲∝?逅?ｒ陦後ｏ縺ｪ縺??
770                    if( key == null || keysMap == null ) { return; }
771    
772                    String upKey = key.toUpperCase(Locale.JAPAN);
773    
774                    if( ! keysMap.containsKey( upKey ) ) {
775                            String BR = "<br />" + HybsSystem.CR ;
776                            StringBuilder errMsg = new StringBuilder();
777                            errMsg.append( BR )
778                                      .append( "謖?ｮ壹?繧ｭ繝ｼ縺ｯ縲√％縺ｮ tableWriter 縺ｧ縺ｯ縲∽ｽｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲? ).append( BR )
779                                      .append( "  class=[" ).append( getClass().getName() ).append( "]" ).append( BR )
780                                      .append( "  key  =[" ).append( key                              ).append( "]" ).append( BR )
781                                      .append( "  ======== usage keys ======== " ).append( BR ) ;
782                            for( Map.Entry<String, String> entry : keysMap.entrySet() ) {
783                                    errMsg.append( "  " ).append( entry.getKey() ).append( " : " )
784                                                                             .append( entry.getValue() ).append( BR ) ;
785                            }
786                            errMsg.append( "  ============================ " ).append( BR );
787    
788                            throw new HybsSystemException( errMsg.toString() );
789                    }
790            }
791    }