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     * 繧ｼ繝ｭ繧ｫ繝ｳ繝槭ｂ莉倥￠縺ｾ縺帙ｓ縲?
027     *
028     * DefaultTableWriter 繧堤ｶ呎価縺励※縺?∪縺吶?縺ｧ?後Λ繝吶Ν?悟錐蜑搾ｼ後ョ繝ｼ繧ｿ縺ｮ蜃ｺ蜉幃Κ縺ｮ縺ｿ
029     * 繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｦ?悟庄螟蛾聞繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ励ヵ繧｡繧､繝ｫ縺ｮ蜃ｺ蜉帶ｩ溯?繧貞ｮ溽樟縺励※縺?∪縺吶?
030     *
031     * @og.rev 5.6.9.4 (2013/10/31) 譁ｰ隕丈ｽ懈?
032     * @og.group 繝輔ぃ繧､繝ｫ蜃ｺ蜉?
033     *
034     * @version  4.0
035     * @author       Kazuhiko Hasegawa
036     * @since    JDK5.0,
037     */
038    public class TableWriter_CSV3 extends TableWriter_Default {
039            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
040            private static final String VERSION = "5.6.9.4 (2013/10/31)" ;
041    
042            /**
043             * DBTableModel 縺九ｉ 繝??繧ｿ繧剃ｽ懈?縺励※,PrintWriter 縺ｫ譖ｸ縺榊?縺励∪縺吶?
044             *
045             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
046             */
047            @Override
048            public void writeDBTable( final PrintWriter writer )  {
049                    super.setSeparator( CSV_SEPARATOR );    // 3.5.6.0 (2004/06/18)
050                    super.writeDBTable( writer );
051            }
052    
053            /**
054             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
055             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?後ョ繝ｼ繧ｿ繧?繝?ヶ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ(")縺ｧ蝗ｲ縺ｿ縺ｾ縺吶?
056             * PrintWriter 縺ｫ DBTableModel縺ｮ繝??繝悶Ν諠??繧呈嶌縺崎ｾｼ縺ｿ縺ｾ縺吶?
057             *
058             * @param       table  DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
059             * @param       writer PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
060             */
061            @Override
062            protected void writeData( final DBTableModel table,final PrintWriter writer ) {
063                    int numberOfRows =      table.getRowCount();
064                    boolean useNumber = isUseNumber();
065                    boolean useRenderer = isUseRenderer();  // 5.2.1.0 (2010/10/01)
066    
067                    for( int row=0; row<numberOfRows; row++ ) {
068                            if( useNumber ) {
069                                    writer.print( quotation( String.valueOf( row+1 ) ) );
070                                    writer.print( CSV_SEPARATOR );
071                            }
072    
073                            for( int i=0; i<numberOfColumns; i++ ) {
074                                    if( i != 0 ) { writer.print( CSV_SEPARATOR ); }
075                                    int clm = clmNo[i];
076                                    String val = table.getValue(row,clm);
077                                    if( dbType[i] == NVAR ) {
078                                            val = StringUtil.getReplaceEscape( val );
079                                    }
080                                    // 5.2.1.0 (2010/10/01) useRenderer 蟇ｾ蠢?
081                                    else if( useRenderer ) {
082                                            val = StringUtil.spanCut( dbColumn[clm].getRendererValue( val ) );
083                                    }
084    
085                                    // 謨ｰ蟄怜梛縺ｫ縺ｯ縲√ム繝悶Ν繧ｯ繧ｪ繝ｼ繝医?莉倥￠縺ｾ縺帙ｓ縲?
086                                    if( dbType[i] == NUMBER ) {
087                                                    writer.print( val );
088                                    }
089                                    else {
090                                            writer.print( quotation( val ) );
091                                    }
092                            }
093                            writer.println();
094                    }
095            }
096    
097            /**
098             * 繝??繧ｿ繧呈嶌縺崎ｾｼ繧??蜷医?,蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
099             * 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ?靴SV 蝗ｺ螳壹?轤ｺ,蛹ｺ蛻?ｊ譁?ｭ励?繧ｻ繝?ヨ縺ｯ辟｡蜉ｹ縺ｫ縺ｪ繧翫∪縺吶?
100             *
101             * @param       sprt 蛹ｺ蛻?ｊ譁?ｭ?
102             */
103            @Override
104            public void setSeparator( final String sprt ) {
105                    super.setSeparator( CSV_SEPARATOR ) ;   // 3.5.6.0 (2004/06/18)
106            }
107    }