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