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.plugin.io;
017    
018    import java.io.PrintWriter;
019    
020    import org.opengion.fukurou.util.StringUtil;
021    import org.opengion.hayabusa.db.DBTableModel;
022    import org.opengion.hayabusa.io.AbstractTableWriter;
023    
024    /**
025     * 蛹ｺ蛻?ｊ譁?ｭ玲欠螳?蛻晄悄蛟､:繧ｿ繝?繧ｼ繝ｭ繧ｫ繝ｳ繝槭ヵ繧｡繧､繝ｫ縺ｮ譖ｸ縺榊?縺励け繝ｩ繧ｹ縺ｧ縺吶?
026     *
027     * 繝ｩ繝吶Ν?悟錐蜑搾ｼ後ョ繝ｼ繧ｿ縺ｮ蜃ｺ蜉幃Κ縺ｮ縺ｿ繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨☆繧後??悟推遞ｮ蜃ｺ蜉帙ヵ繧ｩ繝ｼ繝槭ャ繝医↓蜷医ｏ縺帙◆
028     * 繧ｵ繝悶け繝ｩ繧ｹ繧貞ｮ溽樟縺吶ｋ莠九′蜿ｯ閭ｽ縺ｧ縺吶?
029     * 繧ｼ繝ｭ繧ｫ繝ｳ繝槭ヵ繧｡繧､繝ｫ縺ｨ縺ｯ縲・XCEL縺ｮ繧ｼ繝ｭ繧ｵ繝励Ξ繧ｹ蟇ｾ遲悶→縺励※縲??繧ｼ繝ｭ縺ｮ譁?ｭ怜梛繝??繧ｿ繧貞?蜉帙☆繧?
030     * 譎ゅ↓縲∝?鬆ｭ縺ｫ繧ｫ繝ｳ繝?')繧剃ｻ倥￠縺ｦ縲√ぞ繝ｭ縺悟炎髯､(隕九∴縺ｪ縺上↑繧?迴ｾ雎｡繧呈椛豁｢縺励※縺?ｋ繝輔ぃ繧､繝ｫ縺ｧ縺吶?
031     *
032     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ,蜿ｯ螟蛾聞繧ｿ繝門玄蛻?ｊ譁?ｭ励ヵ繧｡繧､繝ｫ縺ｮ蜃ｺ蜉帶ｩ溯?繧貞ｮ溽樟縺励※縺?∪縺吶?
033     *
034     * @og.group 繝輔ぃ繧､繝ｫ蜃ｺ蜉?
035     *
036     * @version  4.0
037     * @author       Kazuhiko Hasegawa
038     * @since    JDK5.0,
039     */
040    public class TableWriter_Default extends AbstractTableWriter {
041            /** 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
042            private static final String VERSION = "5.3.2.0 (2011/02/01)" ;
043    
044            /**
045             * DBTableModel 縺九ｉ 蜷?ｽ｢蠑上?繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
046             * 縺薙?繝｡繧ｽ繝?ラ縺ｯ縲・XCEL 譖ｸ縺榊?縺玲凾縺ｫ菴ｿ逕ｨ縺励∪縺吶?
047             *
048             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
049             * @see #isExcel()
050             */
051            @Override
052            public void writeDBTable() {
053                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
054                    throw new UnsupportedOperationException( errMsg );
055            }
056    
057            /**
058             * DBTableModel 縺九ｉ 繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
059             *
060             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
061             * @og.rev 3.5.4.2 (2003/12/15) writer 縺ｮ null 繝√ぉ繝?け繧貞ｻ?ｭ｢縺励∪縺吶?
062             * @og.rev 3.5.4.3 (2004/01/05) 蠑墓焚縺ｫ PrintWriter 繧貞女縺大叙繧九ｈ縺?↓螟画峩縺励∪縺吶?
063             *
064             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
065             */
066            @Override
067            public void writeDBTable( final PrintWriter writer )  {
068                    if( ! createDBColumn() ) { return ; }
069    
070                    String headerSequence = getHeaderSequence();
071    
072                    writeHeader( writer ) ;
073            //      String msg = null;
074                    for( int i=0; i<headerSequence.length(); i++ ) {
075                            switch( headerSequence.charAt( i ) ) {
076                                    case 'N':
077            //                              msg = "N:writeName";
078                                            writeName( table,writer ) ;
079                                            break;
080                                    case 'L':
081            //                              msg = "L:writeLabel";
082                                            writeLabel( table,writer ) ;
083                                            break;
084                                    case 'S':
085            //                              msg = "S:writeSize";
086                                            writeSize( table,writer ) ;
087                                            break;
088                                    case 'C':
089            //                              msg = "C:writeClass";
090                                            writeClass( table,writer ) ;
091                                            break;
092                                    case '-':
093            //                              msg = "-:separator";
094                                            writeSeparator( table,writer ) ;
095                                            break;
096                                    case 'D':
097            //                              msg = "D:writeData";
098                                            writeData( table,writer ) ;
099                                            break;
100                                    default:
101                                            break;
102                            }
103                    }
104            }
105    
106            /**
107             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
108             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?後ョ繝ｼ繧ｿ繧?繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ(")縺ｧ蝗ｲ縺ｿ縺ｾ縺吶?
109             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
110             *
111             * @og.rev 2.0.0.5 (2002/09/30) 蜈磯?縺? 縺ｧ縺九▽謨ｰ蟄励ち繧､繝?S9 or R)縺ｧ縺ｪ縺??蜷医↓ ' 繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣縲?
112             * @og.rev 2.3.1.2 (2003/01/28) 繝??繧ｿ蜃ｺ蜉帶凾縺ｫ縲∵隼陦後′菴吝?縺ｫ蜃ｺ縺輔ｌ繧狗ｮ?園繧剃ｿｮ豁｣縲?
113             * @og.rev 3.1.0.0 (2003/03/20) DBColumn 縺九ｉ縲“etDbType() 繧ｭ繝ｼ繧堤峩謗･蜿悶ｊ蜃ｺ縺?
114             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
115             * @og.rev 3.3.3.1 (2003/07/18) 繝輔ぃ繧､繝ｫ繝ｪ繝ｼ繝?繝ｩ繧､繝域凾縺ｫ蠕後ｍ繧ｹ繝壹?繧ｹ縺ｮ髯､蜴ｻ繧定｡後＞縺ｾ縺吶?
116             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
117             * @og.rev 3.8.0.1 (2005/06/17) DBType縺?NVAR 縺ｮ蝣ｴ蜷医?縲∝?縺ｮUnicode縺ｫ謌ｻ縺励∪縺吶?
118             * @og.rev 5.1.6.0 (2010/05/01) DbType 縺ｮ蛻晄悄蛟､(dbType)繧貞茜逕ｨ縺吶ｋ縲?
119             * @og.rev 5.2.1.0 (2010/10/01) useRenderer 蟇ｾ蠢?
120             * @og.rev 5.2.2.0 (2010/11/01) 謾ｹ陦後?繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝育ｭ峨?蜃ｦ逅?
121             * @og.rev 5.3.2.0 (2011/02/01) ","繧剃ｻ伜刈縺吶ｋ譚｡莉ｶ縺悟渚霆｢縺励※縺?ｋ繝舌げ繧剃ｿｮ豁｣
122             *
123             * @param       table  DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
124             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
125             */
126            @Override
127            protected void writeData( final DBTableModel table,final PrintWriter writer ) {
128                    int numberOfRows =      table.getRowCount();
129    
130                    String separator = getSeparator();
131                    boolean useRenderer = isUseRenderer();  // 5.2.1.0 (2010/10/01)
132    
133                    for( int row=0; row<numberOfRows; row++ ) {
134                            if( isUseNumber() ) {
135                                    writer.print( row+1 );
136                                    writer.print( separator );
137                            }
138    
139                            for( int i=0; i<numberOfColumns; i++ ) {
140                                    if( i != 0 ) { writer.print( separator ); }
141    
142                                    int clm = clmNo[i];
143                                    String val = table.getValue(row,clm);
144    //                              if( "NVAR".equals( dbColumn[clm].getDbType()) ) {
145                                    if( dbType[i] == NVAR ) {
146                                            val = StringUtil.getReplaceEscape( val );
147                                    }
148                                    // 5.2.1.0 (2010/10/01) useRenderer 蟇ｾ蠢?
149                                    else if( useRenderer ) {
150                                            val = StringUtil.spanCut( dbColumn[clm].getRendererValue( val ) );
151                                    }
152    
153                                    if( val != null && val.length() > 0 && val.charAt(0) == '0' &&
154    //                                      NUMBER_TYPE_LIST.indexOf( dbColumn[clm].getDbType() ) < 0 ) {
155    //                                      dbType[i] == NUMBER ) {
156                                            dbType[i] != NUMBER ) {
157                                                    writer.print( "'" );            // 髢句ｧ区律縺ｪ縺ｩ縺ｮ 00000000 繧呈枚蟄怜?繧ｿ繧､繝励〒貂｡縺?
158                                    }
159    //                              writer.print( StringUtil.rTrim( val ) );
160                                    writer.print( quotation2( StringUtil.rTrim( val ) ) );  // 5.2.2.0 (2010/11/01) 謾ｹ陦後?繝?ヶ繝ｫ繧ｯ繧ｪ繝ｼ繝育ｭ峨?蜃ｦ逅?
161                            }
162                            writer.println();
163                    }
164            }
165    }