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    
023    /**
024     * 繧ｫ繝ｳ繝槫玄蛻?ｊ繝?ヶ繝ｫ繧ｯ繧ｩ繝ｼ繝医ぞ繝ｭ繧ｫ繝ｳ繝槭ヵ繧｡繧､繝ｫ(CSV)蠖｢蠑乗嶌縺崎ｾｼ縺ｿ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
025     *
026     * DefaultTableWriter 繧堤ｶ呎価縺励※縺?∪縺吶?縺ｧ?後Λ繝吶Ν?悟錐蜑搾ｼ後ョ繝ｼ繧ｿ縺ｮ蜃ｺ蜉幃Κ縺ｮ縺ｿ
027     * 繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｦ?悟庄螟蛾聞繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ励ヵ繧｡繧､繝ｫ縺ｮ蜃ｺ蜉帶ｩ溯?繧貞ｮ溽樟縺励※縺?∪縺吶?
028     *
029     * @og.group 繝輔ぃ繧､繝ｫ蜃ｺ蜉?
030     *
031     * @version  4.0
032     * @author       Kazuhiko Hasegawa
033     * @since    JDK5.0,
034     */
035    public class TableWriter_CSV extends TableWriter_Default {
036            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
037            private static final String VERSION = "5.6.9.4 (2013/10/31)" ;
038    
039            // 4.3.4.4 (2009/01/01)
040    //      /**
041    //       * 繝?ヵ繧ｩ繝ｫ繝医さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
042    //       *
043    //       */
044    //      public TableWriter_CSV() {
045    //              super();
046    //      }
047    
048            /**
049             * DBTableModel 縺九ｉ 繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
050             *
051             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
052             * @og.rev 3.5.4.3 (2004/01/05) 蠑墓焚縺ｫ PrintWriter 繧貞女縺大叙繧九ｈ縺?↓螟画峩縺励∪縺吶?
053             *
054             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
055             */
056            @Override
057            public void writeDBTable( final PrintWriter writer )  {
058                    super.setSeparator( CSV_SEPARATOR );    // 3.5.6.0 (2004/06/18)
059                    super.writeDBTable( writer );
060            }
061    
062            /**
063             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
064             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?後ョ繝ｼ繧ｿ繧?繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ(")縺ｧ蝗ｲ縺ｿ縺ｾ縺吶?
065             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
066             *
067             * @og.rev 2.0.0.1 (2002/09/20) 蜈磯?縺? 縺ｧ縺九▽謨ｰ蟄励ち繧､繝?S9)縺ｧ縺ｪ縺??蜷医↓ ' 繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣
068             * @og.rev 2.0.0.5 (2002/09/30) 蜈磯?縺? 縺ｧ縺九▽謨ｰ蟄励ち繧､繝?S9 or R)縺ｧ縺ｪ縺??蜷医↓ ' 繧貞?蜉帙☆繧九ｈ縺?↓菫ｮ豁｣縲?
069             * @og.rev 2.3.1.2 (2003/01/28) 繝??繧ｿ蜃ｺ蜉帶凾縺ｫ縲∵隼陦後′菴吝?縺ｫ蜃ｺ縺輔ｌ繧狗ｮ?園繧剃ｿｮ豁｣縲?
070             * @og.rev 3.1.0.0 (2003/03/20) DBColumn 縺九ｉ縲“etDbType() 繧ｭ繝ｼ繧堤峩謗･蜿悶ｊ蜃ｺ縺?
071             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
072             * @og.rev 3.7.0.2 (2005/02/14) 陦檎分蜿ｷ諠??繧偵?蜃ｺ蜉帙☆繧?true)/縺励↑縺?false)繧呈欠螳?
073             * @og.rev 3.8.0.1 (2005/06/17) DBType縺?NVAR 縺ｮ蝣ｴ蜷医?縲∝?縺ｮUnicode縺ｫ謌ｻ縺励∪縺吶?
074             * @og.rev 5.1.6.0 (2010/05/01) DbType 縺ｮ蛻晄悄蛟､(dbType)繧貞茜逕ｨ縺吶ｋ縲?
075             * @og.rev 5.2.1.0 (2010/10/01) useRenderer 蟇ｾ蠢?
076             * @og.rev 5.6.9.4 (2013/10/31) 謨ｰ蟄怜梛縺ｧ縺ｪ縺??蜷医?蜈磯?縺?0 縺ｮ譎?
077             *
078             * @param       table  DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
079             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
080             */
081            @Override
082            protected void writeData( final DBTableModel table,final PrintWriter writer ) {
083                    int numberOfRows =      table.getRowCount();
084                    boolean useNumber = isUseNumber();
085                    boolean useRenderer = isUseRenderer();  // 5.2.1.0 (2010/10/01)
086    
087                    for( int row=0; row<numberOfRows; row++ ) {
088                            if( useNumber ) {
089                                    writer.print( quotation( String.valueOf( row+1 ) ) );
090                                    writer.print( CSV_SEPARATOR );
091                            }
092    
093                            for( int i=0; i<numberOfColumns; i++ ) {
094                                    if( i != 0 ) { writer.print( CSV_SEPARATOR ); }
095                                    int clm = clmNo[i];
096                                    String val = table.getValue(row,clm);
097    //                              if( "NVAR".equals( dbColumn[clm].getDbType()) ) {
098                                    if( dbType[i] == NVAR ) {
099                                            val = StringUtil.getReplaceEscape( val );
100                                    }
101                                    // 5.2.1.0 (2010/10/01) useRenderer 蟇ｾ蠢?
102                                    else if( useRenderer ) {
103                                            val = StringUtil.spanCut( dbColumn[clm].getRendererValue( val ) );
104                                    }
105    
106                                    // 髢句ｧ区律縺ｪ縺ｩ縺ｮ 00000000 繧呈枚蟄怜?繧ｿ繧､繝励〒貂｡縺?
107                                    if( val != null && val.length() > 0 && val.charAt(0) == '0' &&
108    //                                      NUMBER_TYPE_LIST.indexOf( dbColumn[clm].getDbType() ) < 0 ) {
109    //                                      dbType[i] == NUMBER ) {
110                                            dbType[i] != NUMBER ) {                 // 5.6.9.4 (2013/10/31) 謨ｰ蟄怜梛縺ｧ縺ｪ縺??蜷医?蜈磯?縺?0 縺ｮ譎?
111                                                    writer.print( quotation( "'" + val ) );
112                                    }
113                                    else {
114                                            writer.print( quotation( val ) );
115                                    }
116                            }
117                            writer.println();
118                    }
119            }
120    
121            /**
122             * 繝??繧ｿ繧呈嶌縺崎ｾｼ繧??蜷医?,蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
123             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?靴SV 蝗ｺ螳壹?轤ｺ,蛹ｺ蛻?ｊ譁?ｭ励?繧ｻ繝?ヨ縺ｯ辟｡蜉ｹ縺ｫ縺ｪ繧翫∪縺吶?
124             *
125             * @og.rev 3.1.1.0 (2003/03/28) 蜷梧悄繝｡繧ｽ繝?ラ(synchronized莉倥″)繧帝撼蜷梧悄縺ｫ螟画峩縺吶ｋ縲?
126             *
127             * @param       sprt 蛹ｺ蛻?ｊ譁?ｭ?
128             */
129            @Override
130            public void setSeparator( final String sprt ) {
131                    super.setSeparator( CSV_SEPARATOR ) ;   // 3.5.6.0 (2004/06/18)
132            }
133    }