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.taglib;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.hayabusa.common.HybsSystemException;
020    import org.opengion.hayabusa.resource.ResourceManager;
021    import org.opengion.hayabusa.resource.GUIInfo;
022    import org.opengion.hayabusa.db.DBColumn;
023    import org.opengion.fukurou.db.Transaction;
024    import org.opengion.fukurou.db.TransactionReal;
025    import org.opengion.fukurou.util.FileUtil;
026    import org.opengion.fukurou.util.ErrorMessage;
027    import org.opengion.fukurou.util.StringUtil;
028    import org.opengion.fukurou.util.Closer ;
029    import org.opengion.fukurou.model.Formatter;
030    import org.opengion.fukurou.model.ArrayDataModel;
031    
032    import static org.opengion.fukurou.util.StringUtil.nval ;
033    
034    import java.sql.Connection;
035    import java.sql.PreparedStatement;
036    import java.sql.SQLException;
037    
038    import java.io.File;
039    import java.io.BufferedReader;
040    import java.io.IOException;
041    
042    /**
043     * 謖?ｮ壹?繝輔ぃ繧､繝ｫ繧堤峩謗･繝??繧ｿ繝吶?繧ｹ縺ｫ逋ｻ骭ｲ縺吶ｋ繝??繧ｿ蜈･蜉帙ち繧ｰ縺ｧ縺吶?
044     *
045     * 騾壼ｸｸ縺ｮ readTable 縺ｪ縺ｩ縺ｯ縲．BTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ莉九＠縺ｦ蜈ｨ莉ｶ繝｡繝｢繝ｪ縺ｫ
046     * 繝ｭ繝ｼ繝峨＠縺ｦ縺九ｉ陦ｨ遉ｺ縺輔○繧狗ぜ縲∝､ｧ驥上ョ繝ｼ繧ｿ蜃ｦ逅?′縺ｧ縺阪∪縺帙ｓ縲?
047     * 縺薙?繧ｿ繧ｰ縺ｧ縺ｯ縲∫峩謗･繝輔ぃ繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｊ縺ｪ縺後ｉ繝??繧ｿ繝吶?繧ｹ逋ｻ骭ｲ縺吶ｋ縺ｮ縺ｧ
048     * 螟ｧ驥上ョ繝ｼ繧ｿ繧偵ヰ繝?メ逧?↓逋ｻ骭ｲ縺吶ｋ蝣ｴ蜷医↓菴ｿ逕ｨ縺励∪縺吶?
049     *
050     * 隱ｭ縺ｿ蜿悶ｋ繝輔ぃ繧､繝ｫ縺ｯ縲∝?鬆ｭ(縺ｾ縺溘?螳溘ョ繝ｼ繧ｿ縺檎樟繧後ｋ縺ｾ縺ｧ縺ｫ) #NAME 陦後′蠢?ｦ√〒縺吶?
051     * 縺薙ｌ縺ｯ縲√ヵ繧｡繧､繝ｫ繝??繧ｿ縺ｮ繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｦ縺?∪縺吶?縺ｾ縺溘?columns 螻樊?繧剃ｽｿ逕ｨ縺吶ｌ縺ｰ縲?
052     * 繝輔ぃ繧､繝ｫ縺ｮ#NAME 陦後ｈ繧雁━蜈医＠縺ｦ(縺､縺ｾ繧雁ｭ伜惠縺励※縺?↑縺上※繧り憶縺?繝??繧ｿ縺ｮ繧ｫ繝ｩ繝?錐繧?
053     * 謖?ｮ壹☆繧九％縺ｨ縺悟?譚･縺ｾ縺吶?
054     * 縺薙?#NAME 陦後?縲√ヵ繧｡繧､繝ｫ縺ｮ繧ｻ繝代Ξ繝ｼ繧ｿ縺ｨ辟｡髢｢菫ゅ↓蠢?★繧ｿ繝門玄蛻?ｊ縺ｧ逕ｨ諢上＆繧後※縺?∪縺吶?
055     * 繧ｿ繧ｰ縺ｮBODY驛ｨ縺ｫ縲∝ｮ溯｡後☆繧鬼QL譁?ｒ險倩ｿｰ縺励∪縺吶?
056     * 縺薙?SQL譁??縲?
057     * INSERT INTO GE41 (CLM,NAME_JA,SYSTEM_ID,FGJ,DYSET)
058     * VALUES ([CLM],[NAME_JA],[SYSTEM_ID],'1','{&#064;USER.YMDH}')
059     * 縺ｨ縲√＞縺?─縺倥〒縲√ヵ繧｡繧､繝ｫ縺九ｉ隱ｭ縺ｿ霎ｼ繧薙□蛟､縺ｯ縲ー繧ｫ繝ｩ繝?錐]縺ｫ蜑ｲ繧雁ｽ薙※繧峨ｌ縺ｾ縺吶?
060     * 繧ゅ■繧阪ｓ縲??蟶ｸ縺ｮ蝗ｺ螳壼?(FGJ縺ｫ'1'繧偵そ繝?ヨ)繧??繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚(DYSET縺ｮ{&#064;USER.YMDH})
061     * 縺ｪ縺ｩ繧ゆｽｿ逕ｨ縺ｧ縺阪∪縺吶?
062     *
063     * 窶ｻ 縺薙?繧ｿ繧ｰ縺ｯ縲ゝransaction 繧ｿ繧ｰ縺ｮ蟇ｾ雎｡縺ｧ縺吶?
064     *
065     * @og.formSample
066     * 笳丞ｽ｢蠑擾ｼ?lt;og:directTableInsert filename="[?･?･?･]" ?･?･?･ &gt;INSERT INTO ?･?･?･ &lt;/og:directTableInsert &gt;
067     * 笳獣ody?壹≠繧?EVAL_BODY_BUFFERED:BODY繧定ｩ穂ｾ｡縺励?{&#064;XXXX} 繧定ｧ｣譫舌＠縺ｾ縺?
068     *
069     * 笳週ag螳夂ｾｩ??
070     *   &lt;og:directTableInsert
071     *       fileURL            縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?(蛻晄悄蛟､:FILE_URL[=filetemp/])
072     *       filename           縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:FILE_FILENAME[=file.xls])
073     *       encode             縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?(蛻晄悄蛟､:FILE_ENCODE[=UnicodeLittle])
074     *       separator          縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｿ繝?
075     *       displayMsg         縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0040[縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆])
076     *       columns            縲慎AG縲?NAME 螻樊?縺ｮ莉｣繧上ｊ縺ｨ縺ｪ繧九ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?錐繧?CSV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺?
077     *       commitBatch        縲慎AG縲第欠螳壽焚豈弱↓繧ｳ繝溘ャ繝医ｒ逋ｺ陦後＠縺ｾ縺?蛻晄悄蛟､:0 邨ゆｺ?∪縺ｧ繧ｳ繝溘ャ繝医＠縺ｾ縺帙ｓ)
078     *       useColumnAdjust    縲慎AG縲代き繝ｩ繝?､画鋤(DBType螟画鋤)繧定｡後≧縺九←縺?°繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
079     *       useColumnCheck     縲慎AG縲代き繝ｩ繝?メ繧ｧ繝?け(DBType繝√ぉ繝?け)繧定｡後≧縺九←縺?°繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
080     *       nullCheck          縲慎AG縲鮮ULL 繝√ぉ繝?け縺吶∋縺阪き繝ｩ繝??繧偵き繝ｳ繝槫玄蛻?ｊ(CSV蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺?
081     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)
082     *       skipRowCount       縲慎AG縲代ョ繝ｼ繧ｿ縺ｮ隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:0)
083     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
084     *   &gt;   ... Body ...
085     *   &lt;/og:directTableInsert&gt;
086     *
087     * 笳丈ｽｿ逕ｨ萓?
088     *     &lt;og:directTableInsert
089     *         dbid         = "ORCL"                謗･邯壹ョ繝ｼ繧ｿ繝吶?繧ｹID(蛻晄悄蛟､:DEFAULT)
090     *         separator    = ","                   繝輔ぃ繧､繝ｫ縺ｮ蛹ｺ蛻?ｊ譁?ｭ?蛻晄悄蛟､:繧ｿ繝?
091     *         fileURL      = "{&#064;USER.ID}"     隱ｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷?
092     *         filename     = "{&#064;filename}"    隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ蜷?
093     *         encode       = "Shift_JIS"           隱ｭ縺ｿ蜿悶ｊ蜈?ヵ繧｡繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝牙錐
094     *         displayMsg   = "MSG0040"             逋ｻ骭ｲ螳御ｺ?ｾ後?繝｡繝?そ繝ｼ繧ｸ
095     *         columns      = "CLM,NAME_JA,LABEL_NAME,KBSAKU,SYSTEM_ID,LANG"
096     *                                              #NAME 縺ｮ莉｣繧上ｊ縺ｫ菴ｿ逕ｨ縺吶ｋ繧ｫ繝ｩ繝??蜷?
097     *         commitBatch  = "100"                 縺薙?莉ｶ謨ｰ縺壹▽繧ｳ繝溘ャ繝医ｒ逋ｺ陦?蛻晄悄蛟､:辟｡蛻ｶ髯?
098     *         useColumnCheck  = "true"             繧ｫ繝ｩ繝?メ繧ｧ繝?け繧定｡後≧縺九←縺?°(蛻晄悄蛟､:false)
099     *         useColumnAdjust = "true"             繧ｫ繝ｩ繝?､画鋤繧定｡後≧縺九←縺?°(蛻晄悄蛟､:false)
100     *         nullCheck       = "CLM,SYSTEM_ID"    NULL繝√ぉ繝?け繧貞ｮ溯｡後＠縺ｾ縺吶?
101     *     &gt;
102     *          INSERT INTO GE41
103     *              (CLM,NAME_JA,LABEL_NAME,KBSAKU,SYSTEM_ID,LANG,
104     *                 FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD)
105     *          VALUES
106     *              ([CLM],[NAME_JA],[LABEL_NAME],[KBSAKU],[SYSTEM_ID],[LANG],
107     *                '1','{&#064;USER.YMDH}','{&#064;USER.YMDH}','{&#064;USER.ID}','{&#064;USER.ID}','{&#064;GUI.KEY}')
108     *     &lt;/og:directTableInsert &gt;
109     *
110     * @og.group 繝輔ぃ繧､繝ｫ蜈･蜉?
111     *
112     * @version  4.0
113     * @author   Kazuhiko Hasegawa
114     * @since    JDK5.0,
115     */
116    public class DirectTableInsertTag extends CommonTagSupport {
117            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
118            private static final String VERSION = "5.5.7.1 (2012/10/05)" ;
119    
120            private static final long serialVersionUID = 557120121005L ;
121    
122            private static final String TAB_SEPARATOR = "\t" ;
123    
124            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
125    //      private String    dbid                  = "DEFAULT";
126            private String    dbid                  = null;
127            private String    separator             = TAB_SEPARATOR;   // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
128            private String    fileURL               = HybsSystem.sys( "FILE_URL" );         // 4.0.0 (2005/01/31)
129            private String    filename              = HybsSystem.sys( "FILE_FILENAME" );   // 繝輔ぃ繧､繝ｫ蜷?
130            private String    encode                = HybsSystem.sys( "FILE_ENCODE"   );   // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
131            private String    displayMsg    = "MSG0040";    // 縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆縲?
132            private String[]  columns               = null;
133            private String[]  clmKeys               = null;         // SQL譁??[繧ｫ繝ｩ繝?錐]驟榊?
134            private String    sql                   = null;
135            private int               commitBatch   = 0;            // 繧ｳ繝溘ャ繝医☆繧九∪縺ｨ繧∽ｻｶ謨ｰ
136            private boolean   useColumnCheck  = false;      // 3.6.0.2 (2004/10/04)
137            private boolean   useColumnAdjust = false;      // 3.6.0.2 (2004/10/04)
138            private String[]  nullCheck             = null;         // 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
139            private long      dyStart               = 0;    // 螳溯｡梧凾髢捺ｸｬ螳夂畑縺ｮDIV隕∫ｴ?ｒ蜃ｺ蜉帙＠縺ｾ縺吶?
140            private int       skipRowCount  = 0;    // 5.5.7.1 (2012/10/01)
141    
142            /**
143             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
144             *
145             * @return      蠕檎ｶ壼?逅??謖?､ｺ( EVAL_BODY_BUFFERED )
146             */
147            @Override
148            public int doStartTag() {
149                    dyStart = System.currentTimeMillis();           // 譎る俣貂ｬ螳夂畑
150                    return( EVAL_BODY_BUFFERED );   // Body 繧定ｩ穂ｾ｡縺吶ｋ縲? extends BodyTagSupport 譎?
151            }
152    
153            /**
154             * Taglib縺ｮ繧ｿ繧ｰ譛ｬ菴薙ｒ蜃ｦ逅?☆繧?doAfterBody() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
155             *
156             * @og.rev 3.6.0.2 (2004/10/04) SQL譁?? [繧ｫ繝ｩ繝? 蟇ｾ蠢懊→繝代?繧ｵ繝ｼ讖溯?霑ｽ蜉?
157             * @og.rev 3.8.6.3 (2006/11/30) SQL 譁??蜑榊ｾ後?繧ｹ繝壹?繧ｹ繧貞叙繧企勁縺阪∪縺吶?
158             *
159             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
160             */
161            @Override
162            public int doAfterBody() {
163                    sql = getBodyString();
164                    if( sql == null || sql.length() == 0 ) {
165                            String errMsg = "BODY 驛ｨ縺ｮ逋ｻ骭ｲ逕ｨ Insert/Update譁??縲∝ｿ??縺ｧ縺吶?";
166                            throw new HybsSystemException( errMsg );
167                    }
168                    // 3.6.0.2 (2004/10/04) SQL譁?? [繧ｫ繝ｩ繝? 蟇ｾ蠢懊→繝代?繧ｵ繝ｼ讖溯?霑ｽ蜉?
169    //              sql = makeFormat( sql.trim() );         // 縺薙％縺ｧ縲…lmLeys 驟榊?繧ゅそ繝?ヨ縺輔ｌ繧九?
170    
171                    return(SKIP_BODY);                              // Body 繧定ｩ穂ｾ｡縺励↑縺?
172            }
173    
174            /**
175             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
176             *
177             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage > getResource().getLabel )
178             *
179             * @return      蠕檎ｶ壼?逅??謖?､ｺ
180             */
181            @Override
182            public int doEndTag() {
183                    debugPrint();           // 4.0.0 (2005/02/28)
184    
185                    BufferedReader pw = getBufferedReader();
186                    int executeCount = create( pw );
187                    Closer.ioClose( pw );           // 4.0.0 (2006/01/31) close 蜃ｦ逅?凾縺ｮ IOException 繧堤┌隕?
188    
189                    // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ
190                    // 4.0.0 (2005/11/30) 蜃ｺ蜉幃?縺ｮ螟画峩縲ゆｸ?分譛??縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
191                    if( displayMsg != null && displayMsg.length() > 0 ) {
192    //                      String status = executeCount + getResource().getMessage( displayMsg ) ;
193                            String status = executeCount + getResource().getLabel( displayMsg ) ;
194                            jspPrint( status + HybsSystem.BR );
195                    }
196    
197                    // 譎る俣貂ｬ螳夂畑縺ｮ DIV 隕∫ｴ?ｒ蜃ｺ蜉?
198                    long dyTime = System.currentTimeMillis()-dyStart;
199                    jspPrint( "<div id=\"queryTime\" value=\"" + (dyTime) + "\"></div>" );      // 3.5.6.3 (2004/07/12)
200    
201                    // 4.0.0 (2005/01/31) 繧ｻ繧ｭ繝･繝ｪ繝?ぅ繝√ぉ繝?け(繝??繧ｿ繧｢繧ｯ繧ｻ繧ｹ莉ｶ謨ｰ逋ｻ骭ｲ)
202                    GUIInfo guiInfo = (GUIInfo)getSessionAttribute( HybsSystem.GUIINFO_KEY );
203                    if( guiInfo != null ) { guiInfo.addWriteCount( executeCount,dyTime,sql ); }
204    
205                    return(EVAL_PAGE);
206            }
207    
208            /**
209             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
210             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
211             *
212             * @og.rev 3.6.0.2 (2004/10/04) useColumnCheck,useColumnAdjust 螻樊?霑ｽ蜉?
213             * @og.rev 3.8.0.2 (2005/06/30) nullCheck 螻樊?霑ｽ蜉?
214             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
215             * @og.rev 5.5.7.1 (2012/10/05) skipRowCount霑ｽ蜉?
216             */
217            @Override
218            protected void release2() {
219                    super.release2();
220                    dbid                    = null;
221                    separator               = TAB_SEPARATOR;   // 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
222                    fileURL                 = HybsSystem.sys( "FILE_URL" );         // 4.0.0 (2005/01/31)
223                    filename                = HybsSystem.sys( "FILE_FILENAME"        );   // 繝輔ぃ繧､繝ｫ蜷?
224                    encode                  = HybsSystem.sys( "FILE_ENCODE"          );   // 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ  "JISAutoDetect" ,"JIS", "EUC_JP", "MS932", "SJIS" , "Windows-31J" , "Shift_JIS"
225                    displayMsg              = "MSG0040";    // 縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆縲?
226                    columns                 = null;         // 3.5.4.5 (2004/01/23)
227                    useColumnCheck  = false;        // 3.6.0.2 (2004/10/04)
228                    useColumnAdjust = false;        // 3.6.0.2 (2004/10/04)
229                    nullCheck               = null;         // 3.8.0.2 (2005/06/30)
230                    skipRowCount    = 0;            // 5.5.7.1 (2012/10/05)
231            }
232    
233            /**
234             * BufferedReader 繧医ｊ隱ｭ縺ｿ霎ｼ縺ｿ縲√ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｫ譖ｸ縺崎ｾｼ縺ｿ縺ｾ縺吶?
235             *
236             * @og.rev 3.6.0.2 (2004/10/04) 繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医?DBType螻樊?縺ｮ謨ｴ蜷域?繝√ぉ繝?け
237             * @og.rev 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
238             * @og.rev 3.8.5.1 (2006/05/08) 蜿冶ｾｼ繝??繧ｿ縺?name 蛻励ｈ繧雁ｰ代↑縺??蜷医?蟇ｾ蠢懊ｒ霑ｽ蜉?
239             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
240             * @og.rev 4.0.0.0 (2005/01/31) CheckColumnData繧ｯ繝ｩ繧ｹ static 蛹悶?蠑墓焚縺ｫResourceManager霑ｽ蜉?
241             * @og.rev 4.0.0.1 (2007/12/03) try ??catch ??finally 繧偵″縺｡繧薙→陦後≧縲?
242             * @og.rev 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
243             * @og.rev 5.2.2.0 (2010/11/01)) ""縺ｧ蝗ｲ繧上ｌ縺ｦ縺?ｋ繝??繧ｿ縺ｫ謾ｹ陦後′蜈･縺｣縺ｦ縺?◆蝣ｴ蜷医?蟇ｾ蠢?
244             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
245             * @og.rev 5.3.8.0 (2011/08/01) pstmt.setObject 縺ｧ縲「seParamMetaData 縺ｮ蛻､螳壹ｒ驕ｿ縺代ｋ縺溘ａ縲｝stmt.setString 縺ｧ莉｣逕ｨ(PostgreSQL蟇ｾ蠢?
246             * @og.rev 5.5.7.1 (2012/10/05) omitFirstLine蟇ｾ蠢?
247             *
248             * @param   reader BufferedReader繧ｪ繝悶ず繧ｧ繧ｯ繝?
249             *
250             * @return  蜿悶ｊ霎ｼ縺ｿ莉ｶ謨ｰ
251             */
252            private int create( final BufferedReader reader )  {
253    
254                    String[] names = readName( reader );    // 繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?錐
255                    int   nameLen = names.length ;                  // 3.8.5.1 (2006/05/08) 霑ｽ蜉?
256    //              int[] clmNos = getColumnNos( names, clmKeys );  // 繝舌う繝ｳ繝牙､画焚縺ｮ繧｢繝峨Ξ繧ｹ豎ゅａ
257    //              int   clmNosLen = clmNos.length ;
258    
259                    ArrayDataModel nmdata = new ArrayDataModel( names );
260                    Formatter format = new Formatter( nmdata );
261                    format.setFormat( sql.trim() );
262                    sql = format.getQueryFormatString();
263                    int[] clmNos = format.getClmNos();
264                    int   clmNosLen = clmNos.length ;
265                    clmKeys = format.getClmKeys();
266    
267                    CheckColumnData checkClass = new CheckColumnData( clmNos,clmKeys,getResource() );
268    
269                    ArrayDataModel nullData = new ArrayDataModel( names );
270                    int[] nullClmNos = nullData.getColumnNos( nullCheck );  // 繝舌う繝ｳ繝牙､画焚縺ｮ繧｢繝峨Ξ繧ｹ豎ゅａ
271    
272                    // 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
273    //              int[] nullClmNos = getColumnNos( names, nullCheck );    // 繝舌う繝ｳ繝牙､画焚縺ｮ繧｢繝峨Ξ繧ｹ豎ゅａ
274                    int   nullClmNosLen = nullClmNos.length ;
275    
276                    int    executeCount = 0;
277                    int    commitCount  = 0;
278                    char   sep  = separator.charAt(0);
279                    boolean errFlag  = true;
280    //              Connection  conn = null;
281                    Transaction tran = null;        // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
282                    PreparedStatement pstmt = null ;
283                    String[] data   = null ;
284                    int skip = skipRowCount; // 5.5.7.1 (2012/10/05)
285                    try {
286                            // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
287                            TransactionTag tranTag = (TransactionTag)findAncestorWithClass( this,TransactionTag.class );
288                            if( tranTag == null ) {
289    //                              tran = new TransactionReal( dbid,getApplicationInfo() );
290                                    tran = new TransactionReal( getApplicationInfo() );             // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
291                            }
292                            else {
293                                    tran = tranTag.getTransaction();
294                            }
295    //                      conn = ConnectionFactory.connection( dbid,getApplicationInfo() );       // 3.8.7.0 (2006/12/15)
296    
297    //                      try {
298                                    Connection conn = tran.getConnection( dbid );           // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
299                                    pstmt = conn.prepareStatement( sql );
300                                    String line ;
301                                    while((line = reader.readLine()) != null) {
302                                            if( line.length() == 0 || line.charAt( 0 ) == '#' ) { continue; }
303                                            else if( skip > 0 ){ skip--; continue;} // 5.5.7.1 (2012/10/05) 
304                                            else {
305                                                    // 5.2.2.0 (2010/11/01) ""縺ｧ蝗ｲ繧上ｌ縺ｦ縺?ｋ繝??繧ｿ縺ｫ謾ｹ陦後′蜈･縺｣縺ｦ縺?◆蝣ｴ蜷医?蟇ｾ蠢?
306                                                    int quotCount = StringUtil.countChar( line, '"' );
307                                                    if( quotCount % 2 != 0 ) {
308                                                            String addLine = null;
309                                                            StringBuilder buf = new StringBuilder( line );
310                                                            while(quotCount % 2 != 0 && (addLine = reader.readLine()) != null) {
311                                                                    if( line.length() == 0 || line.charAt( 0 ) == '#' ) { continue; }
312                                                                    buf.append( HybsSystem.CR ).append( addLine );
313                                                                    quotCount += StringUtil.countChar( addLine, '"' );
314                                                            }
315                                                            line = buf.toString();
316                                                    }
317    
318                                                    // 3.8.5.1 (2006/05/08) 蜿冶ｾｼ繝??繧ｿ縺?name 蛻励ｈ繧雁ｰ代↑縺??蜷医?蟇ｾ蠢懊ｒ霑ｽ蜉?
319                                                    data = StringUtil.csv2Array( line , sep , nameLen );
320    
321                                                    // 3.6.0.2 (2004/10/04) 繧ｫ繝ｩ繝?､画鋤
322                                                    if( useColumnAdjust ) {
323                                                            data = checkClass.adjustData( data );
324                                                    }
325    
326                                                    // 3.6.0.2 (2004/10/04) 繧ｫ繝ｩ繝?メ繧ｧ繝?け
327                                                    if( useColumnCheck ) {
328                                                            ErrorMessage errMsg = checkClass.checkData( executeCount, data );
329                                                            if( !errMsg.isOK() ) {
330    //                                                              conn.rollback();
331                                                                    tran.rollback();                        // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
332                                                                    jspPrint( TaglibUtil.makeHTMLErrorTable( errMsg,getResource() ) );
333                                                                    return commitCount;
334                                                            }
335                                                    }
336    
337                                                    // 3.8.0.2 (2005/06/30) null繝√ぉ繝?け遒ｺ隱?
338                                                    if( nullClmNosLen > 0 ) {
339                                                            ErrorMessage errMsg = new ErrorMessage( "Null Check Columns Error!" );
340    
341                                                            for( int i=0; i<nullClmNosLen; i++ ) {
342                                                                    int clm = nullClmNos[i];
343                                                                    if( data[clm] == null || data[clm].length() == 0 ) {
344                                                                            String label = getResource().getLabel( nullCheck[i] );
345                                                                            // ERR0012 : 謖?ｮ壹?繝??繧ｿ縺後そ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?NULL繧ｨ繝ｩ繝ｼ)縲Ｌey={0}
346                                                                            errMsg.addMessage( executeCount+1,ErrorMessage.NG,"ERR0012",label );
347                                                                    }
348                                                            }
349                                                            if( !errMsg.isOK() ) {
350    //                                                              conn.rollback();
351                                                                    tran.rollback();                        // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
352                                                                    jspPrint( TaglibUtil.makeHTMLErrorTable( errMsg,getResource() ) );
353                                                                    return commitCount;
354                                                            }
355                                                    }
356    
357                                                    for( int i=0; i<clmNosLen; i++ ) {
358                                                            String val = data[clmNos[i]];
359                                                            if( val != null && val.startsWith( "'0" ) ) {
360                                                                    val = val.substring( 1 );
361                                                            }
362    //                                                      pstmt.setObject( i+1,val );             // 5.3.8.0 (2011/08/01) 蜃ｦ逅??邁｡邏?喧
363                                                            pstmt.setString( i+1,val );
364                                                    }
365    
366                                                    pstmt.execute();
367                                                    if( commitBatch > 0 && ( executeCount%commitBatch == 0 ) ) {
368    //                                                      conn.commit();
369                                                            tran.commit();                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
370                                                            commitCount = executeCount;
371                                                    }
372                                                    executeCount++ ;
373                                            }
374                                    }
375    //                              conn.commit();
376                                    tran.commit();                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
377                                    commitCount = executeCount ;
378                                    errFlag = false;                // 繧ｨ繝ｩ繝ｼ縺ｧ縺ｯ縺ｪ縺?
379    //                      }
380    //                      finally {
381    //                              Closer.stmtClose( pstmt );
382    //                      }
383                    }
384                    catch (IOException ex) {
385                            String errMsg = "繝輔ぃ繧､繝ｫ隱ｭ霎ｼ縺ｿ繧ｨ繝ｩ繝ｼ[" + reader.toString() + "]"
386                                                    + " 陦檎分蜿ｷ=[" + executeCount +"]"
387                                                    + " 逋ｻ骭ｲ莉ｶ謨ｰ=[" + commitCount + "]"  ;
388                            throw new HybsSystemException( errMsg,ex );
389                    }
390                    catch (SQLException ex) {
391                            String errMsg = "sql=[" + sql + "]" + HybsSystem.CR
392                                                    +       "names=[" + StringUtil.array2csv( names ) + "]" + HybsSystem.CR
393                                                    +       "vals =[" + StringUtil.array2csv( data ) + "]" + HybsSystem.CR
394                                                    + " 陦檎分蜿ｷ=[" + executeCount +"]"
395                                                    + " 逋ｻ骭ｲ莉ｶ謨ｰ=[" + commitCount + "]"  + HybsSystem.CR
396                                                    + " errorCode=[" + ex.getErrorCode() + "] State=[" +
397                                                    ex.getSQLState() + "]" + HybsSystem.CR ;
398                            throw new HybsSystemException( errMsg,ex );
399                    }
400                    finally {
401                            Closer.stmtClose( pstmt );
402    //                      tran.close( errFlag );                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
403                            if( tran != null ) {                            // 5.5.2.6 (2012/05/25) findbugs蟇ｾ蠢?
404                                    tran.close( errFlag );                  // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
405                            }
406    //                      if( errFlag ) { ConnectionFactory.remove( conn,dbid ); }        // 蜑企勁
407    //                      else {                  ConnectionFactory.close( conn,dbid );  }        // 霑泌唆
408    //                      conn = null;
409                    }
410    
411                    return commitCount;
412            }
413    
414            /**
415             * BufferedReader 繧医ｊ縲?NAME 陦後?鬆?岼蜷肴ュ蝣ｱ繧定ｪｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
416             * 繝??繧ｿ繧ｫ繝ｩ繝?ｈ繧雁燕縺ｫ縲??逶ｮ蜷肴ュ蝣ｱ繧堤､ｺ縺?"#Name" 縺悟ｭ伜惠縺吶ｋ莉ｮ螳壹〒蜿悶ｊ霎ｼ縺ｿ縺ｾ縺吶?
417             * 縺薙?陦後?縲√ヵ繧｡繧､繝ｫ縺ｮ蠖｢蠑上↓辟｡髢｢菫ゅ↓縲ゝAB 縺ｧ蛹ｺ蛻?ｉ繧後※縺?∪縺吶?
418             * #NAME 驟榊?縺ｮ蜈磯?(陦檎分蜿ｷ縺ｫ縺ゅ◆繧句?謇?縺ｯ縲ヽOW_NO 縺ｨ縺?≧繧ｭ繝ｼ繧貞牡繧雁ｽ薙※縺ｾ縺吶?
419             * columns 縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲?NAME 陦後〒縺ｯ縺ｪ縺上?columns 繧貞━蜈医＠縺ｾ縺吶?
420             *
421             * @og.rev 3.6.0.0 (2004/09/22) #NAME 陦後′隕九▽縺九ｉ縺ｪ縺??蜷医?縲√お繝ｩ繝ｼ縺ｨ縺励∪縺吶?
422             * @og.rev 3.6.0.2 (2004/10/04) columns 縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縲√◎繧後ｒ霑斐＠縺ｾ縺吶?
423             *
424             * @param       reader PrintWriter繧ｪ繝悶ず繧ｧ繧ｯ繝?
425             *
426             * @return      繧ｫ繝ｩ繝?錐驟榊?
427             */
428            private String[] readName( final BufferedReader reader ) {
429                    if( columns != null && columns.length > 0 ) {
430                            return columns ;
431                    }
432    
433                    try {
434                            String line;
435                            while((line = reader.readLine()) != null) {
436                                    if( line.length() == 0 ) { continue; }
437                                    if( line.charAt(0) == '#' ) {
438                                            if( line.length() >= 5 &&
439                                                    "#NAME".equalsIgnoreCase( line.substring( 0,5 ) ) ) {
440                                                    String[] rtn = StringUtil.csv2Array( line ,TAB_SEPARATOR.charAt(0) );
441                                                    rtn[0] = "ROW_NO";      // 蜈磯?繧ｫ繝ｩ繝?↓繧ｫ繝ｩ繝?錐繧剃ｸ弱∴繧九?
442                                                    return rtn ;
443                                            }
444                                            else { continue; }
445                                    }
446                                    else {
447                                            String errMsg = "#NAME 縺瑚ｦ九▽縺九ｋ蜑阪↓繝??繧ｿ縺瑚ｦ九▽縺九ｊ縺ｾ縺励◆縲? + HybsSystem.CR
448                                                            + " LINE=" + line;                      // 5.1.8.0 (2010/07/01) errMsg 菫ｮ豁｣
449                                            throw new HybsSystemException( errMsg );
450                                    }
451                            }
452                    }
453                    catch (IOException ex) {
454                            String errMsg = "繝輔ぃ繧､繝ｫ隱ｭ霎ｼ縺ｿ繧ｨ繝ｩ繝ｼ[" + reader.toString() + "]"  ;
455                            throw new HybsSystemException( errMsg,ex );
456                    }
457    
458                    String errMsg = "#NAME 縺瑚ｦ九▽縺九ｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?;
459                    throw new HybsSystemException( errMsg );
460            }
461    
462            /**
463             * SQL縺ｫ繝舌う繝ｳ繝峨＆繧後ｋ螟画焚縺ｮ繝輔ぃ繧､繝ｫ縺ｫ蟇ｾ縺吶ｋ繧｢繝峨Ξ繧ｹ縺ｮ驟榊?繧定ｿ斐＠縺ｾ縺吶?
464             *
465             * @og.rev 3.6.0.2 (2004/10/04) 蜃ｦ逅?Ο繧ｸ繝?け螟画峩
466             * @og.rev 3.8.0.2 (2005/06/30) clms 縺ｮ null譎ょｯｾ蠢?
467             *
468             * @param       names   繝輔ぃ繧､繝ｫ繝倥ャ繝??縺ｮ蜷咲ｧｰ驟榊?
469             * @param       clms    SQL縺ｫ繝舌う繝ｳ繝峨＆繧後ｋ蜷咲ｧｰ縺ｮCSV譁?ｭ怜?
470             *
471             * @return  int[] SQL縺ｫ繝舌う繝ｳ繝峨＆繧後ｋ螟画焚縺ｮ繝輔ぃ繧､繝ｫ縺ｫ蟇ｾ縺吶ｋ繧｢繝峨Ξ繧ｹ縺ｮ驟榊?
472             */
473    //      private int[] getColumnNos( final String[] names,final String[] clms ) {
474    //              int[] clmNos = new int[0];
475    //
476    //              if( clms != null ) {
477    //                      clmNos = new int[clms.length];
478    //                      for( int i=0; i<clms.length; i++ ) {
479    //                              boolean flag = true;
480    //                              for( int j=0; flag && j<names.length; j++ ) {
481    //                                      if( clms[i].equalsIgnoreCase( names[j] ) ) {
482    //                                              clmNos[i] = j;
483    //                                              flag = false;
484    //                                      }
485    //                              }
486    //                              // 隕九▽縺九ｉ縺ｪ縺??蜷医?繧ｨ繝ｩ繝ｼ
487    //                              if( flag ) {
488    //                                      String errMsg = "謖?ｮ壹?繧ｫ繝ｩ繝?錐縺ｯ縲√ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝??縺ｫ荳??縺励∪縺帙ｓ縲?
489    //                                                              + " 繧ｫ繝ｩ繝?[" + clms[i] + "]"
490    //                                                              + " 繧ｫ繝ｩ繝??=[" + StringUtil.array2csv( names ) + "]" ;
491    //                                      throw new HybsSystemException( errMsg );
492    //                              }
493    //                      }
494    //              }
495    //              return clmNos;
496    //      }
497    
498            /**
499             * BufferedReader 繧貞叙蠕励＠縺ｾ縺吶?
500             *
501             * 縺薙％縺ｧ縺ｯ縲∽ｸ?握逧?↑繝輔ぃ繧､繝ｫ蜃ｺ蜉帙ｒ閠??縺励◆ BufferedReader 繧剃ｽ懈?縺励∪縺吶?
502             *
503             * @return      謖?ｮ壹?隱ｭ縺ｿ蜿悶ｊ逕ｨBufferedReader繧ｪ繝悶ず繧ｧ繧ｯ繝?
504             */
505            private BufferedReader getBufferedReader() {
506                    if( filename == null ) {
507                            String errMsg = "繝輔ぃ繧､繝ｫ蜷阪′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?∪縺帙ｓ縲?;
508                            throw new HybsSystemException( errMsg );
509                    }
510                    String directory = HybsSystem.url2dir( fileURL );
511                    File file = new File( StringUtil.urlAppend( directory,filename ) );
512    
513                    BufferedReader out = FileUtil.getBufferedReader( file,encode );
514    
515                    return out ;
516            }
517    
518            /**
519             * 繝輔か繝ｼ繝槭ャ繝医ｒ繧ｻ繝?ヨ縺励∪縺吶?
520             * UPDATE GExx SET CLMA = [CLMA] WHERE KEY1 = [KEY1] 蠖｢蠑上ｈ繧翫?
521             * [CLMA]縲ーKEY1] 繧帝?縺ｫ縲…lmKeys 驟榊?縺ｫ譬ｼ邏阪＠縺ｾ縺吶?
522             * 縺ｾ縺溘?蜈･蜉帙ヵ繧ｩ繝ｼ繝槭ャ繝医?縺ｯ縲ー繧ｫ繝ｩ繝?錐]縺ｮ蛟区園繧?? 縺ｫ鄂ｮ縺肴鋤縺医◆
523             * 蛟､繧偵?霑斐＠縺ｾ縺吶?縺薙?SQL譁??縲√◎縺ｮ縺ｾ縺ｾ PreparedStatement 縺ｫ貂｡縺励∪縺吶?
524             * 蜈医?SQL譁?↑繧峨?UPDATE GExx SET CLMA = ? WHERE KEY1 = ? 縺ｫ縲∝､画鋤縺励∪縺吶?
525             *
526             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕剰ｿｽ蜉?
527             *
528             * @param       fmt  [繧ｫ繝ｩ繝?錐] 蠖｢蠑上?繝輔か繝ｼ繝槭ャ繝医ョ繝ｼ繧ｿ
529             *
530             * @return       [繧ｫ繝ｩ繝?錐]  繧?? 縺ｫ鄂ｮ縺肴鋤縺医◆譁?ｭ怜?
531             */
532    //      private String makeFormat( final String fmt ) {
533    //              StringBuilder buf = new StringBuilder( fmt.length() );
534    //
535    //              String fmt2 = fmt.replace( '[',']' );
536    //              CSVTokenizer token = new CSVTokenizer( fmt2,']',false );
537    //              int count = token.countTokens() / 2 ;
538    //              clmKeys = new String[ count ];
539    //
540    ////            String format = null;
541    //              for( int i=0; i<count; i++ ) {
542    ////                    format = token.nextToken();
543    ////                    buf.append( format);
544    //                      buf.append( token.nextToken() );        // format
545    //                      clmKeys[i] = token.nextToken();
546    //                      buf.append( "?" );              // [繧ｫ繝ｩ繝? 繧?? 縺ｫ鄂ｮ縺肴鋤縺?
547    //              }
548    ////            format = token.nextToken();
549    ////            buf.append( format );
550    //              buf.append( token.nextToken() );        // format
551    //
552    //              return buf.toString();
553    //      }
554    
555            /**
556             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:DEFAULT)縲?
557             *
558             * @og.tag
559             *   讀懃ｴ｢譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?蛻晄悄蛟､縺ｯ縲．EFAULT 縺ｧ縺吶?
560             *
561             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
562             */
563            public void setDbid( final String id ) {
564                    dbid = nval( getRequestParameter( id ),dbid );
565            }
566    
567            /**
568             * 縲慎AG縲大庄螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:繧ｿ繝?縲?
569             *
570             * @og.tag 蜿ｯ螟蛾聞繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?鬆?岼蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺吶?
571             *
572             * @param   separator 鬆?岼蛹ｺ蛻?ｊ譁?ｭ?
573             */
574            public void setSeparator( final String separator ) {
575                    this.separator = nval( getRequestParameter( separator ),this.separator );
576            }
577    
578            /**
579             * 縲慎AG縲題ｪｭ縺ｿ蜿悶ｊ蜈?ョ繧｣繝ｬ繧ｯ繝医Μ蜷阪ｒ謖?ｮ壹＠縺ｾ縺?
580             *              (蛻晄悄蛟､:FILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
581             *
582             * @og.tag
583             * 縺薙?螻樊?縺ｧ謖?ｮ壹＆繧後ｋ繝?ぅ繝ｬ繧ｯ繝医Μ繧医ｊ縲√ヵ繧｡繧､繝ｫ繧定ｪｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
584             * 謖?ｮ壽婿豕輔?縲??蟶ｸ縺ｮ fileURL 螻樊?縺ｨ蜷梧ｧ倥↓縲∝?鬆ｭ縺後?'/' (UNIX) 縺ｾ縺溘?縲?ｼ呈枚蟄礼岼縺後?
585             * ":" (Windows)縺ｮ蝣ｴ蜷医?縲∵欠螳壹?URL縺昴?縺ｾ縺ｾ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√◎縺?〒縺ｪ縺??蜷医?縲?
586             * fileURL = "{&#064;USER.ID}" 縺ｨ謖?ｮ壹☆繧九→縲：ILE_URL 螻樊?縺ｧ謖?ｮ壹?繝輔か繝ｫ繝??荳九↓縲?
587             * 縺輔ｉ縺ｫ縲∝推蛟倶ｺｺID蛻･縺ｮ繝輔か繝ｫ繝??荳九ｈ繧翫?隱ｭ縺ｿ蜿悶ｊ縺ｾ縺吶?
588             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
589             *
590             * @og.rev 4.0.0.0 (2005/01/31) StringUtil.urlAppend 繝｡繧ｽ繝?ラ縺ｮ蛻ｩ逕ｨ
591             * @og.rev 4.0.0.0 (2007/11/20) 謖?ｮ壹＆繧後◆繝?ぅ繝ｬ繧ｯ繝医Μ蜷阪?譛?ｾ後′"\"or"/"縺ｧ邨ゅｏ縺｣縺ｦ縺?↑縺??蜷医↓縲?/"繧剃ｻ伜刈縺吶ｋ縲?
592             *
593             * @param       url 繝輔ぃ繧､繝ｫURL
594             * @see         org.opengion.hayabusa.common.SystemData#FILE_URL
595             */
596            public void setFileURL( final String url ) {
597                    String furl = nval( getRequestParameter( url ),null );
598                    if( furl != null ) {
599                            char ch = furl.charAt( furl.length()-1 );
600                            if( ch != '/' && ch != '\\' ) { furl = furl + "/"; }
601                            fileURL = StringUtil.urlAppend( fileURL,furl );
602                    }
603            }
604    
605            /**
606             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
607             *              (蛻晄悄蛟､:FILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
608             *
609             * @og.tag
610             * 繝輔ぃ繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺吶?
611             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_FILENAME[={@og.value org.opengion.hayabusa.common.SystemData#FILE_FILENAME}])縲?
612             *
613             * @param   filename 繝輔ぃ繧､繝ｫ蜷?
614             * @see         org.opengion.hayabusa.common.SystemData#FILE_FILENAME
615             */
616            public void setFilename( final String filename ) {
617                    this.filename = nval( getRequestParameter( filename ),this.filename );
618            }
619    
620            /**
621             * 縲慎AG縲代ヵ繧｡繧､繝ｫ繧剃ｽ懈?縺吶ｋ縺ｨ縺阪?繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷阪ｒ繧ｻ繝?ヨ縺励∪縺?
622             *              (蛻晄悄蛟､:FILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
623             *
624             * @og.tag
625             * 蛻晄悄蛟､縺ｯ縲√す繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ 縺ｮ FILE_ENCODE 螻樊?縺ｧ縲∬ｨｭ螳壹＠縺ｦ縺?∪縺吶?
626             * Shift_JIS,MS932,Windows-31J,UTF-8,ISO-8859-1,UnicodeLittle?･?･?･
627             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_ENCODE[={@og.value org.opengion.hayabusa.common.SystemData#FILE_ENCODE}])縲?
628             *
629             * @param   enc 繝輔ぃ繧､繝ｫ繧ｨ繝ｳ繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ蜷?
630             * @see     <a href="http://www.iana.org/assignments/character-sets">IANA Charset Registry</a>
631             * @see         org.opengion.hayabusa.common.SystemData#FILE_ENCODE
632             */
633            public void setEncode( final String enc ) {
634                    encode = nval( getRequestParameter( enc ),encode );
635            }
636    
637            /**
638             * 縲慎AG縲倉uery 縺ｮ邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0040[縲?ｻｶ逋ｻ骭ｲ縺励∪縺励◆])縲?
639             *
640             * @og.tag
641             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
642             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ
643             * 陦ｨ遉ｺ縺励∪縺吶?
644             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
645             * 蛻晄悄蛟､縺ｯ縲∵､懃ｴ｢莉ｶ謨ｰ繧定｡ｨ遉ｺ縺励∪縺吶?
646             * 窶ｻ 縺薙?螻樊?縺ｫ縺ｯ縲√Μ繧ｯ繧ｨ繧ｹ繝亥､画焚({&#064;XXXX})縺ｯ菴ｿ逕ｨ縺ｧ縺阪∪縺帙ｓ縲?
647             *
648             * @param   id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
649             */
650            public void setDisplayMsg( final String id ) {
651                    if( id != null ) { displayMsg = id; }
652            }
653    
654            /**
655             * 縲慎AG縲?NAME 螻樊?縺ｮ莉｣繧上ｊ縺ｨ縺ｪ繧九ヵ繧｡繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?錐繧?CSV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
656             *
657             * @og.tag
658             * 繝??繧ｿ繝輔ぃ繧､繝ｫ縺ｮ蜈磯?陦後↓縲?NAME 陦後′縺ゅｊ縲∬ｪｭ縺ｿ蜿悶ｋ縺ｹ縺阪ヵ繧｡繧､繝ｫ縺ｮ
659             * 繧ｫ繝ｩ繝?錐縺瑚ｨ倩ｿｰ縺輔ｌ縺ｦ縺?∪縺吶?騾壼ｸｸ縺ｯ縲√％縺ｮ繧ｫ繝ｩ繝?錐繧貞叙繧願ｾｼ繧薙〒縲?
660             * 蜷?ョ繝ｼ繧ｿ蛻励?繧ｫ繝ｩ繝?ｒ謖?ｮ壹＠縺ｾ縺吶?
661             * 縺薙?螻樊?縺ｯ縲√ヵ繧｡繧､繝ｫ縺ｫ#NAME 陦後′蟄伜惠縺励↑縺?莉悶す繧ｹ繝?Β縺九ｉ縺ｮ蜈･蜉帙ヵ繧｡繧､繝ｫ遲?
662             * 蝣ｴ蜷医↓縲?NAME 螻樊?縺ｮ莉｣繧上ｊ縺ｫ縲√き繝ｩ繝?錐繧貞､夜Κ繧医ｊ謖?ｮ壹＠縺ｾ縺吶?
663             *
664             * @og.rev 3.8.5.1 (2006/05/08) getCSVParameter 縺ｮ菴ｿ逕ｨ繧剃ｸｭ豁｢
665             *
666             * @param   clms 繝輔ぃ繧､繝ｫ縺ｮ繧ｫ繝ｩ繝?錐(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
667             */
668            public void setColumns( final String clms ) {
669                    columns = StringUtil.csv2Array( nval( getRequestParameter( clms ),null ),',' );
670            }
671    
672            /**
673             * 縲慎AG縲第欠螳壽焚豈弱↓繧ｳ繝溘ャ繝医ｒ逋ｺ陦後＠縺ｾ縺?蛻晄悄蛟､:0 邨ゆｺ?∪縺ｧ繧ｳ繝溘ャ繝医＠縺ｾ縺帙ｓ)縲?
674             *
675             * @og.tag
676             * 騾壼ｸｸ縺ｯ縲∝?縺ｦ縺ｮ蜃ｦ逅?′豁｣蟶ｸ縺ｫ邨ゆｺ?☆繧九°縲√↑縺ｫ繧ゅ＠縺ｪ縺?°(繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ)
677             * 繧貞愛譁ｭ縺吶∋縺阪〒縲??荳ｭ縺ｧ縺ｮ繧ｳ繝溘ャ繝医?縺励∪縺帙ｓ縲?
678             * 縺励°縺励?蝣ｴ蜷医↓繧医▲縺ｦ縲∽ｻｶ謨ｰ縺檎焚蟶ｸ縺ｫ螟壹＞蝣ｴ蜷医ｄ縲∝?螳溯｡悟庄閭ｽ縺ｪ蝣ｴ蜷医?縲?
679             * 騾比ｸｭ縺ｧ繧ｳ繝溘ャ繝医＠縺ｦ縲??蠎ｦ縲∝?逅?〒縺阪ｋ繧ゅ?縺?￠繧貞?逅?＠縺ｦ縺励∪縺?→縺?≧譁ｹ豕輔′縺ゅｊ縺ｾ縺吶?
680             * 縺ｾ縺溘?繝ｭ繝ｼ繝ｫ繝舌ャ繧ｯ繧ｨ繝ｪ繧｢縺ｮ髢｢菫ゅ↑縺ｩ縺ｧ縲√ョ繝ｼ繧ｿ驥上′螟壹＞蝣ｴ蜷医↓縲∝?逅?凾髢薙′逡ｰ蟶ｸ縺ｫ
681             * 髟ｷ縺上↑繧倶ｺ九′縺ゅｊ縲∵欠螳壻ｻｶ謨ｰ縺斐→縺ｮ繧ｳ繝溘ャ繝域ｩ溯?繧堤畑諢上＠縺ｦ縺?∪縺吶?
682             * 0 縺ｫ險ｭ螳壹☆繧九→縲∫ｵゆｺ?∪縺ｧ繧ｳ繝溘ャ繝医＠縺ｾ縺帙ｓ縲ょ?譛溷?縺ｯ縲? 縺ｧ縺吶?
683             *
684             * @param   cmtBat 謖?ｮ壽焚豈弱↓繧ｳ繝溘ャ繝医ｒ逋ｺ陦?蛻晄悄蛟､:0)
685             */
686            public void setCommitBatch( final String cmtBat ) {
687                    commitBatch = nval( getRequestParameter( cmtBat ),commitBatch );
688            }
689    
690            /**
691             * 縲慎AG縲代き繝ｩ繝?メ繧ｧ繝?け(DBType繝√ぉ繝?け)繧定｡後≧縺九←縺?°繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
692             *
693             * @og.tag
694             * 繧ｫ繝ｩ繝??謨ｴ蜷域?繝√ぉ繝?け繧定｡後≧蝣ｴ蜷医?縺薙?螻樊?繧定ｨｭ螳?true)縺励∪縺吶?
695             * 蛻晄悄蛟､縺ｯ縲∬｡後ｏ縺ｪ縺?false)縺ｧ縺吶?
696             * 繝√ぉ繝?け縺吶ｋ繧ｫ繝ｩ繝??縲?NAME 繧?columns 縺ｧ謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?〒縺ｯ縺ｪ縺上?
697             * BODY驛ｨ縺ｮSQL譁?〒謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?錐( [繧ｫ繝ｩ繝?錐] )縺ｧ縺吶?縺薙ｌ縺ｯ縲∫峩謗･縲ヾQL譁?ｸｭ縺ｫ
698             * 險倩ｿｰ縺励※縺?ｋ蛟､繧??{&#064;XXXX}譁?ｭ礼ｭ峨?縲√メ繧ｧ繝?け蜃ｺ譚･縺ｪ縺?ぜ縺ｧ縺吶?
699             *
700             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕剰ｿｽ蜉?蜿悶ｊ霎ｼ縺ｿ譎ょ?繝√ぉ繝?け
701             *
702             * @param   flag 繝√ぉ繝?け繧定｡後≧縺九←縺?°(true:陦後≧/false:陦後ｏ縺ｪ縺?
703             * @see     #setUseColumnAdjust( String )
704             */
705            public void setUseColumnCheck( final String flag ) {
706                    useColumnCheck = nval( getRequestParameter( flag ),useColumnCheck );
707            }
708    
709            /**
710             * 縲慎AG縲代き繝ｩ繝?､画鋤(DBType螟画鋤)繧定｡後≧縺九←縺?°繧定ｨｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
711             *
712             * @og.tag
713             * 繧ｫ繝ｩ繝??螟画鋤繧定｡後≧蝣ｴ蜷医?縺薙?螻樊?繧定ｨｭ螳?true)縺励∪縺吶?
714             * 蛻晄悄蛟､縺ｯ縲∬｡後ｏ縺ｪ縺?false)縺ｧ縺吶?
715             * 螟画鋤縺吶ｋ繧ｫ繝ｩ繝??縲?NAME 繧?columns 縺ｧ謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?〒縺ｯ縺ｪ縺上?
716             * BODY驛ｨ縺ｮSQL譁?〒謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝?錐[繧ｫ繝ｩ繝?錐]縺ｧ縺吶?縺薙ｌ縺ｯ縲∫峩謗･縲ヾQL譁?ｸｭ縺ｫ
717             * 險倩ｿｰ縺励※縺?ｋ蛟､繧??{&#064;XXXX}譁?ｭ礼ｭ峨?縲∝､画鋤蜃ｺ譚･縺ｪ縺?ぜ縺ｧ縺吶?
718             *
719             * @og.rev 3.6.0.2 (2004/10/04) 譁ｰ隕剰ｿｽ蜉?蜿悶ｊ霎ｼ縺ｿ譎ょ､画鋤
720             *
721             * @param   flag 螟画鋤繧定｡後≧縺九←縺?°(true:陦後≧/false:陦後ｏ縺ｪ縺?
722             * @see     #setUseColumnCheck( String )
723             */
724            public void setUseColumnAdjust( final String flag ) {
725                    useColumnAdjust = nval( getRequestParameter( flag ),useColumnAdjust );
726            }
727    
728            /**
729             * 縲慎AG縲鮮ULL 繝√ぉ繝?け縺吶∋縺阪き繝ｩ繝??繧偵き繝ｳ繝槫玄蛻?ｊ(CSV蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
730             *
731             * @og.tag nullCheck="AAA,BBB,CCC,DDD"
732             * <del>蜈医↓驟榊?縺ｫ蛻?ｧ｣縺励※縺九ｉ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ蛟､繧貞叙蠕励☆繧九ｈ縺?↓縺励∪縺吶?
733             * 縺薙≧縺吶ｋ莠九〒縲√Μ繧ｯ繧ｨ繧ｹ繝医↓繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｮ蛟､繧定ｨｭ螳壹〒縺阪ｋ繧医≧縺ｫ縺ｪ繧翫∪縺吶?</del>
734             * 蛻?ｧ｣譁ｹ豕輔?縲??蟶ｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺励∪縺吶?
735             *
736             * @og.rev 3.8.0.2 (2005/06/30) 譁ｰ隕剰ｿｽ蜉?
737             * @og.rev 3.8.8.5 (2007/03/09) 騾壼ｸｸ縺ｮ繝代Λ繝｡繝ｼ繧ｿ蜿門ｾ怜ｾ後↓縲，SV蛻?ｧ｣縺ｫ謌ｻ縺励∪縺吶?
738             *
739             * @param   clms 繧ｫ繝ｩ繝??(CSV蠖｢蠑?
740             */
741            public void setNullCheck( final String clms ) {
742                    nullCheck = StringUtil.csv2Array( getRequestParameter( clms ) );
743                    if( nullCheck.length == 0 ) { nullCheck = null; }
744            }
745            
746            /**
747             * 縲慎AG縲大叙繧願ｾｼ縺ｿ譎ゅ↓髯､螟悶☆繧玖｡後ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:0)縲?
748             *
749             * @og.tag
750             * TAB蛹ｺ蛻?ｊ繝?く繧ｹ繝医ｄEXCEL遲峨?繝??繧ｿ縺ｮ隱ｭ縺ｿ蟋九ａ縺ｮ蛻晄悄蛟､繧呈欠螳壹＠縺ｾ縺吶?
751             * 繝輔ぃ繧､繝ｫ縺ｮ蜈磯?陦後′縲?ｼ占｡後→縺励※繧ｫ繧ｦ繝ｳ繝医＠縺ｾ縺吶?縺ｧ縲∬ｨｭ螳壼?縺ｯ縲∬ｪｭ縺ｿ鬟帙?縺?
752             * 莉ｶ謨ｰ縺ｫ縺ｪ繧翫∪縺吶?(?代→謖?ｮ壹☆繧九→縲?ｼ台ｻｶ隱ｭ縺ｿ鬟帙?縺励??定｡檎岼縺九ｉ隱ｭ縺ｿ霎ｼ縺ｿ縺ｾ縺吶?)
753             * 隱ｭ縺ｿ鬟帙?縺励?縲√さ繝｡繝ｳ繝郁｡後↑縺ｩ縺ｯ縲∫┌隕悶＠縺ｾ縺吶?縺ｧ縲∝ｮ滄圀縺ｮ陦梧焚蛻?ｪｭ縺ｿ鬟帙?縺励∪縺吶?
754             * ?クAME螻樊?繧??columns 螻樊?縺ｯ縲∵怏蜉ｹ縺ｧ縺吶?
755             *
756             * @og.rev 5.5.7.1 (2012/10/05) 譁ｰ隕剰ｿｽ蜉?
757             *
758             * @param   count 蜈磯?陦後ｒ辟｡隕悶☆繧九°縺ｩ縺?°(true:辟｡隕悶☆繧?false:辟｡隕悶＠縺ｪ縺?
759             */
760            public void setSkipRowCount( final String count ) {
761                    skipRowCount = nval( getRequestParameter( count ),skipRowCount );
762            }
763    
764            /**
765             * 繧ｫ繝ｩ繝?､画鋤縲√き繝ｩ繝?メ繧ｧ繝?け繧定｡後≧蜀?Κ繧ｯ繝ｩ繧ｹ
766             *
767             * @og.rev 4.0.0.0 (2005/01/31) static 繧ｯ繝ｩ繧ｹ蛹悶?蠑墓焚縺ｫResourceManager霑ｽ蜉?
768             * @og.group 繝輔ぃ繧､繝ｫ蜈･蜉?
769             *
770             * @version  4.0
771             * @author   Kazuhiko Hasegawa
772             * @since    JDK5.0,
773             */
774            static class CheckColumnData {
775                    private final DBColumn[] dbClm    ;
776                    private final int[]      clmChkNo ;
777                    private final int        len      ;             // 髟ｷ縺包ｼ舌?譎ゅ?縲√↑縺ｫ繧ゅ＠縺ｪ縺??
778                    private final ErrorMessage errMsg = new ErrorMessage( "Check Columns Error!" );
779    
780                    /**
781                     * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
782                     *
783                     * @param       clmNo   繧ｫ繝ｩ繝?分蜿ｷ驟榊?
784                     * @param chkClm String[]
785                     * @param resource ResourceManager
786                     */
787                    CheckColumnData( final int[] clmNo, final String[] chkClm,final ResourceManager resource ) {
788                            if( clmNo  == null || clmNo.length  == 0 ||
789                                    chkClm == null || chkClm.length == 0 ) { // return; }   // 菴輔ｂ縺励↑縺?
790    
791                                    dbClm    = null;
792                                    clmChkNo = null;
793                                    len      = 0;
794                            }
795                            else {
796                                    clmChkNo = clmNo ;
797                                    len = clmNo.length ;
798                                    dbClm = new DBColumn[len];
799                                    for( int i=0; i<len; i++ ) {
800                                            dbClm[i] = resource.makeDBColumn( chkClm[i] );  // 4.0.0 (2005/01/31)
801                                    }
802                            }
803                    }
804    
805                    /**
806                     * 蠑墓焚縺ｮ繝??繧ｿ繧?DBColumn 縺ｧ豁｣隕丞喧(valueSet繝｡繧ｽ繝?ラ邨檎罰)縺励∪縺吶?
807                     *
808                     * @param       data    ?題｡悟?縺ｮ繝??繧ｿ驟榊?
809                     * @return String[]
810                     * @see org.opengion.hayabusa.db.DBColumn#valueSet( String )
811                     */
812                    String[] adjustData( final String[] data ) {
813                            if( len == 0 ) { return data; }
814                            String[] ajstData = new String[len];
815                            for( int i=0; i<len; i++ ) {
816                                    String val = data[clmChkNo[i]];
817                                    ajstData[i] = dbClm[i].valueSet( val );
818                            }
819                            return ajstData ;
820                    }
821    
822                    /**
823                     * 蠑墓焚縺ｮ繝??繧ｿ繧?DBColumn 縺ｧ豁｣隕丞喧(valueSet繝｡繧ｽ繝?ラ邨檎罰)縺励∪縺吶?
824                     *
825                     * @param       row     陦檎分蜿ｷ
826                     * @param       data    ?題｡悟?縺ｮ繝??繧ｿ驟榊?
827                     * @return ErrorMessage
828                     * @see org.opengion.hayabusa.db.DBColumn#valueSet( String )
829                     */
830                    ErrorMessage checkData( final int row,final String[] data ) {
831                            for( int i=0; i<len; i++ ) {
832                                    String val = data[clmChkNo[i]];
833                                    errMsg.append( row+1,dbClm[i].valueCheck( val ) );
834                            }
835                            return errMsg ;
836                    }
837            }
838    
839            /**
840             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
841             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
842             *
843             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
844             */
845            @Override
846            public String toString() {
847                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
848                                    .println( "VERSION"                     ,VERSION                )
849                                    .println( "dbid"                        ,dbid                   )
850                                    .println( "separator"           ,separator              )
851                                    .println( "fileURL"                     ,fileURL                )
852                                    .println( "filename"            ,filename               )
853                                    .println( "encode"                      ,encode                 )
854                                    .println( "displayMsg"          ,displayMsg             )
855                                    .println( "columns"                     ,columns                )
856                                    .println( "clmKeys"                     ,clmKeys                )
857                                    .println( "sql"                         ,sql                    )
858                                    .println( "commitBatch"         ,commitBatch    )
859                                    .println( "useColumnCheck"      ,useColumnCheck )
860                                    .println( "useColumnAdjust"     ,useColumnAdjust)
861                                    .println( "nullCheck"           ,nullCheck              )
862                                    .println( "dyStart"                     ,dyStart                )
863                                    .println( "Other..."            ,getAttributes().getAttribute() )
864                                    .fixForm().toString() ;
865            }
866    }