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