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