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.db.DBColumn;
021    import org.opengion.hayabusa.db.DBTableModel;
022    import org.opengion.hayabusa.db.DBTableModelUtil;
023    
024    import org.opengion.fukurou.util.StringUtil;
025    import static org.opengion.fukurou.util.StringUtil.nval ;
026    
027    import java.util.Map;
028    import java.util.LinkedHashMap;
029    import java.util.Locale ;
030    
031    /**
032     * ?偵▽縺ｮ DBTableModel 縺ｮ 髮?粋蜃ｦ逅?ｒ陦後≧繧ｿ繧ｰ縺ｧ縺吶?
033     *
034     * 繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?縺昴ｌ縺槭ｌ縺ｮ DBTableModel 繧貞叙蠕励＠縲√?繝ｼ繧ｸ縲∝ｷｮ蛻??謗剃ｻ悶↑縺ｩ縺ｮ
035     * 繝??繧ｿ蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?邨先棡繧偵?謖?ｮ壹? tableId 縺ｨ scope 縺ｫ譖ｸ縺榊?縺励∪縺吶?
036     * 繝槭せ繧ｿ繝??繝悶Ν縺ｯ縲［asterTableId 縺ｨ masterScope 繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ縲?
037     * slaveTableId 縺ｨ slaveScope 繧医ｊ蜿悶ｊ蜃ｺ縺励∪縺吶?
038     * 蜿悶ｊ蜃ｺ縺輔ｌ縺?DBTableModel 縺ｯ縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｫ蟇ｾ縺励※縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν諠??繧貞盾辣ｧ縺吶ｋ蠖｢縺ｧ陦後ｏ繧後?
039     * 邨先棡縺ｯ繝槭せ繧ｿ繝??繝悶Ν縺ｫ荳頑嶌縺阪＆繧後ｋ蠖｢縺ｧ陦後ｏ繧後∪縺吶?
040     * 謖?ｮ壹〒縺阪ｋ繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺ｯ縲∝?菴馴寔蜷?UNION_ALL)縲∝柱髮?粋(UNION)縲∫ｩ埼寔蜷?INTERSECT)縲?
041     * 蟾ｮ髮?粋(MINUS)縲∝ｷｮ蛻?寔蜷?DIFFERENCE)縲∝?蜷域?(UNION_CLM)縲?蛻苓ｿｽ蜉?ADD_CLM)縲?繧ｰ繝ｫ繝ｼ繝?GROUP)縺ｧ縺吶?
042     * 蛻怜粋謌舌→蛻苓ｿｽ蜉??繧ｰ繝ｫ繝ｼ繝嶺ｻ･螟悶?蜃ｦ逅?〒縺ｯ縲√き繝ｩ繝??縺ｨ繧ｫ繝ｩ繝?焚縺ｯ蜷梧焚縺ｧ縺ｪ縺代ｌ縺ｰ縺ｪ繧翫∪縺帙ｓ縲?
043     * primaryKeys 繧?unionClms 縺ｪ縺ｩ縺ｮ謖?ｮ壹?繧ｭ繝ｼ蜷阪?縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｫ蟄伜惠縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
044     * 繝槭せ繧ｿ繝??繝悶Ν縺ｨ蜷後§繧ｫ繝ｩ繝?分蜿ｷ縺ｧ繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧医ｊ繝??繧ｿ繧定ｪｭ縺ｿ蜃ｺ縺励∪縺吶?
045     * (繧ｫ繝ｩ繝?錐繧?ｱ樊?縺ｯ縲∫焚縺ｪ縺｣縺ｦ繧ゅ°縺ｾ縺?∪縺帙ｓ縺後?繝槭せ繧ｿ繝??繝悶Ν縺ｫ貅匁侠縺励∪縺吶?)
046     * 縺ｾ縺溘?蜊倡峡(繝槭せ繧ｿ繝??繝悶Ν縺ｮ縺ｿ)縺ｧ縲∝柱髮?粋縺ｨ蜷檎ｭ峨?縲√げ繝ｫ繝ｼ繝?GROUP)繧剃ｽｿ逕ｨ縺吶ｋ縺ｨ縲∵欠螳壹?
047     * 繧ｫ繝ｩ繝?〒縺ｮ繝ｦ繝九?繧ｯ蛹悶ｒ陦後≧縺薙→縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?繧ｰ繝ｫ繝ｼ繝怜?逅?〒縺ｯ縲∝?陦悟━蜈医→縺励?
048     * ?貞屓逶ｮ縺ｫ迴ｾ繧後◆諠??繧貞炎髯､縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶?繧ｰ繝ｫ繝ｼ繝?縺梧欠螳壹＆繧後◆蝣ｴ蜷医?縲?
049     * 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ辟｡隕悶＆繧後∪縺吶?縺?★繧後?蜃ｦ逅?↓縺翫＞縺ｦ繧ゅ?髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ縺ｧ
050     * 荳?率繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ縺ｾ縺吶?蜈ｨ菴馴寔蜷?UNION_ALL)縺ｧ蜃ｦ逅?☆繧句?蜷医〒繧ゅ?荳ｻ繧ｭ繝ｼ縺後Θ繝九?繧ｯ縺ｧ
051     * 縺ｪ縺??蜷医?縲√?繧ｹ繧ｿ繝ｼ縲√せ繝ｬ繝ｼ繝悶?蜷?ユ繝ｼ繝悶Ν縺ｧ荳?率繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ縺溷ｾ後〒縲√?繝ｼ繧ｸ縺輔ｌ縺ｾ縺吶?
052     * (繝槭?繧ｸ蠕後↓縺ｯ縲∝酔荳?ｸｻ繧ｭ繝ｼ繧呈戟縺､陦後?蟄伜惠縺励∪縺吶?)
053     * 蜈ｨ菴馴寔蜷?UNION_ALL)縺ｮ蝣ｴ蜷医?縺ｿ縲［ergeKeys 繧呈欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲ゅ◎縺ｮ蝣ｴ蜷医?縲?
054     * 繧ｭ繝ｼ縺ｪ縺励?縺溘ａ縲√?繧ｹ繧ｿ繝ｼ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繝??繝悶Ν繧貞腰縺ｫ蜷域?縺吶ｋ縺?￠縺ｫ縺ｪ繧翫∪縺吶?
055     *
056     * 蜃ｦ逅?燕蠕後〒縺ｮDBTableModel縺ｮ莉ｶ謨ｰ縺ｯ縲∽ｻ･荳九?螟画焚縺ｧ蜿門ｾ励☆繧九％縺ｨ縺悟庄閭ｽ縺ｧ縺吶?
057     *  蜃ｦ逅?燕縺ｮ繝槭せ繧ｿ繝ｼ繝??繝悶Ν : {&#064;DB.MASTER_COUNT}
058     *  蜃ｦ逅?燕縺ｮ繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν : {&#064;DB.SLAVE_COUNT}
059     *  蜃ｦ逅?ｾ?                  : {&#064;DB.COUNT}
060     *
061     * @og.formSample
062     * 笳丞ｽ｢蠑擾ｼ?
063     *       繝ｻ&lt;og:tableMerge
064     *             action        = "UNION_ALL|UNION|INTERSECT|MINUS|DIFFERENCE|UNION_CLM|ADD_CLM|GROUP|UNION_SELROW"
065     *             tableId       = "DEFAULT"        蜃ｺ蜉帙ユ繝ｼ繝悶Ν縺ｮ tableId
066     *             scope         = "session"        蜃ｺ蜉帙ユ繝ｼ繝悶Ν縺ｮ scope
067     *             masterTableId = "DEFAULT"        繝槭せ繧ｿ繝??繝悶Ν縺ｮ tableId
068     *             masterScope   = "session"        繝槭せ繧ｿ繝??繝悶Ν縺ｮ scope
069     *             slaveTableId  = "DEFAULT"        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ tableId
070     *             slaveScope    = "request"        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ scope
071     *             masterKeys    = "AA,BB,CC"       繝槭せ繧ｿ繝??繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ
072     *             slaveKeys     = "AA,BB,CC"       繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ(null譎?masterKeys)
073     *             diffKeys      = "DD,EE"          繝槭せ繧ｿ繝??繝悶Ν縺ｮDIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐
074     *             unionClms     = "DD,EE"          UNION_CLM,ADD_CLM譎ゅ↓繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ霑ｽ蜉?☆繧九き繝ｩ繝?錐
075     *             modifyClms    = "FF,GG"          DIFFERENCE譎ゅ↓繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐
076     *             noSideEffect  = "false"          繝??繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑(true:縺ｪ縺?false:縺ゅｋ)
077     *             useDiffData   = "true"           DIFFERENCE譎ゅ↓蟾ｮ蛻??繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧定ｿｽ蜉?☆繧九°縺ｩ縺?°
078     *             useCheckOnly  = "false"          繝槭せ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°
079     *             groupAddClms  = "FF,GG"          masterKeys縺ｧ髮?粋蜃ｦ逅?☆繧九→縺阪↓縲∫嶌驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐
080     *             display       = "true"           蜃ｦ逅?ｦりｦ√ｒ陦ｨ遉ｺ縺吶ｋ縺九←縺?°
081     *         /&gt;
082     * 笳獣ody?壹↑縺?
083     *
084     * 笳週ag螳夂ｾｩ??
085     *   &lt;og:tableMerge
086     *       command            縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)
087     *       action             縲慎AG縲代い繧ｯ繧ｷ繝ｧ繝ｳ繧呈欠螳壹＠縺ｾ縺?UNION_ALL|UNION|INTERSECT|MINUS|DIFFERENCE|UNION_CLM|ADD_CLM|GROUP|UNION_SELROW)
088     *       tableId            縲慎AG縲大?蜉帛?縺ｮtableId繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[=h_tblmdl])
089     *       scope              縲慎AG縲大?蜉帛?縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
090     *       masterTableId      縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮtableId繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[=h_tblmdl])
091     *       masterScope        縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
092     *       slaveTableId       縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮtableId繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[=h_tblmdl])
093     *       slaveScope         縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
094     *       masterKeys         縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
095     *       slaveKeys          縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
096     *       diffKeys           縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮDIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐繧?CSV蠖｢蠑?謖?ｮ壹＠縺ｾ縺?
097     *       unionClms          縲慎AG縲代せ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ霑ｽ蜉?☆繧九き繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺?
098     *       modifyClms         縲慎AG縲代せ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺?
099     *       groupAddClms       縲慎AG縲鷹寔蜷亥?逅?☆繧九→縺阪↓縲∫嶌驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺?
100     *       noSideEffect       縲慎AG縲代ユ繝ｼ繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑縺ｮ譛臥┌[true:縺ｪ縺?false:縺ゅｋ]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false:縺ゅｋ)
101     *       useDiffData        縲慎AG縲大ｷｮ蛻??繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧堤ｵ先棡繝??繝悶Ν縺ｫ霑ｽ蜉?☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
102     *       useCheckOnly       縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
103     *       display            縲慎AG縲代?繝ｼ繧ｸ縺ｮ邨先棡繧定｡ｨ遉ｺ縺吶ｋ縺九←縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)
104     *       mainTrans          縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
105     *       caseKey            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
106     *       caseVal            縲慎AG縲代％縺ｮ繧ｿ繧ｰ閾ｪ菴薙ｒ蛻ｩ逕ｨ縺吶ｋ縺九←縺?°縺ｮ譚｡莉ｶ蛟､繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:null)
107     *       caseNN             縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｧ縺ｪ縺??蜷?Not Null=NN)縺ｯ縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
108     *       caseNull           縲慎AG縲第欠螳壹?蛟､縺後?null/繧ｼ繝ｭ譁?ｭ怜? 縺ｮ蝣ｴ蜷医?縲√％縺ｮ繧ｿ繧ｰ縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺?蛻晄悄蛟､:true)
109     *       separator          縲慎AG縲組roupAddClms縺ｧ譁?ｭ怜?繧帝?邨舌☆繧矩?逶ｮ蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:",")
110     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
111     *   /&gt;
112     *
113     * 笳丈ｽｿ逕ｨ萓?
114     *     萓具ｼ?繝?ヵ繧ｩ繝ｫ繝井ｻ･螟悶↓蠢?ｦ√↑螻樊?縺ｮ縺ｿ謖?ｮ壹☆繧九し繝ｳ繝励Ν
115     *     &lt;og:tableMerge action="UNION"
116     *           slaveScope = "request" masterKeys = "AA,BB,CC"
117     *     /&gt;
118     *
119     *         繝ｻ蜃ｺ蜉帛?縲√?繧ｹ繧ｿ繝ｼ縺ｨ繧ゅ↓蛻晄悄蛟､縺ｯ縲》ableId="DEFAULT" scope="session" 縺ｧ縺吶?
120     *           繧ｹ繝ｬ繝ｼ繝悶?縲》ableId 縺?scope 繧偵￠繧句ｿ?ｦ√′縺ゅｋ轤ｺ縲《cope="request" 繧呈欠螳壹＠縺ｦ縺?∪縺吶?
121     *           豈碑ｼ?☆繧九き繝ｩ繝?錐縺ｯ縲√?繧ｹ繧ｿ縲√せ繝ｬ繝ｼ繝門酔縺倥〒縺ゅｌ縺ｰ縲√?繧ｹ繧ｿ縺ｮ縺ｿ謖?ｮ壹〒縺九∪縺?∪縺帙ｓ縲?
122     *
123     *     萓具ｼ?繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝悶→繧ゅΓ繝｢繝ｪ縺ｫ谿九ｉ縺ｪ縺?ｈ縺?↓ request 縺ｧ菴懈?縺励∪縺吶?
124     *     &lt;og:tableMerge action="INTERSECT"
125     *           masterScope  = "request"
126     *           slaveScope   = "request"
127     *           slaveTableId = "SLAVE"
128     *           masterKeys   = "AA,BB,CC"
129     *     /&gt;
130     *
131     *         繝ｻ繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝悶→繧ゅΓ繝｢繝ｪ縺ｫ谿九ｉ縺ｪ縺?ｈ縺?↓ request 縺ｧ菴懈?縺励◆蝣ｴ蜷医?縲?
132     *           縺ｩ縺｡繧峨°縺ｮ TableId 繧貞､峨∴繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?
133     *           蜃ｺ蜉帛?縺ｯ蛻晄悄蛟､縺ｮ縲》ableId="DEFAULT" scope="session" 縺ｧ縺吶?
134     *
135     * @og.rev 3.8.0.9 (2005/10/17) 譁ｰ隕剰ｿｽ蜉?
136     * @og.group ?､?｢逋ｻ骭ｲ
137     *
138     * @version  0.9.0      2000/10/17
139     * @author       Kazuhiko Hasegawa
140     * @since    JDK5.0,
141     */
142    public class TableMergeTag extends CommonTagSupport {
143            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
144            private static final String VERSION = "5.5.8.5 (2012/11/27)" ;
145    
146            private static final long serialVersionUID = 558520121127L ;
147    
148            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蜈ｨ菴馴寔蜷?{@value} */
149            public static final String ACT_UNION_ALL        = "UNION_ALL" ;
150            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蜥碁寔蜷?{@value} */
151            public static final String ACT_UNION            = "UNION" ;
152            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 遨埼寔蜷?{@value} */
153            public static final String ACT_INTERSECT        = "INTERSECT" ;
154            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蟾ｮ髮?粋{@value} */
155            public static final String ACT_MINUS            = "MINUS" ;
156            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蟾ｮ蛻?寔蜷?@value} */
157            public static final String ACT_DIFFERENCE       = "DIFFERENCE" ;
158            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蛻怜粋謌須@value} */
159            public static final String ACT_UNION_CLM        = "UNION_CLM" ;
160            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 蛻怜粋謌須@value} */
161            public static final String ACT_ADD_CLM          = "ADD_CLM" ;
162            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 繧ｰ繝ｫ繝ｼ繝?{@value} */
163            public static final String ACT_GROUP            = "GROUP" ;
164            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝? 繧ｰ繝ｫ繝ｼ繝?{@value} */
165            public static final String ACT_UNION_SELROW     = "UNION_SELROW" ;// 4.3.2.0 (2008/09/11)
166    
167            /** action 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
168            private static final String[] ACTION_LIST = new String[] {
169                    ACT_UNION_ALL , ACT_UNION , ACT_INTERSECT , ACT_MINUS , ACT_DIFFERENCE , ACT_UNION_CLM , ACT_ADD_CLM , ACT_GROUP, ACT_UNION_SELROW };
170    
171            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 譁ｰ隕?{@value} */
172            public static final String CMD_NEW       = "NEW" ;
173            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 蜀肴､懃ｴ｢ {@value} */
174            public static final String CMD_RENEW = "RENEW" ;
175            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
176            private static final String[] COMMAND_LIST = new String[] { CMD_NEW , CMD_RENEW };
177    
178            private String  command         = CMD_NEW;
179    
180            private String  action          = null;
181            private String  tableId         = HybsSystem.TBL_MDL_KEY;               // 蜃ｺ蜉帛?縺ｮ tableId
182            private String  scope           = "session";                                            // 蜃ｺ蜉帛?縺ｮ scope
183    
184            private String  masterTableId   = HybsSystem.TBL_MDL_KEY;       // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ tableId
185            private String  masterScope             = "session";                                    // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ scope
186            private String  slaveTableId    = HybsSystem.TBL_MDL_KEY;       // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ tableId
187            private String  slaveScope              = "request";                                    // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ scope
188            private String  masterKeys              = null;                                                 // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ
189            private String  slaveKeys               = null;                                                 // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ(null譎?masterKeys)
190            private String  diffKeys                = null;                                                 // 繝槭せ繧ｿ繝??繝悶Ν縺ｮDIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐
191            private String  unionClms               = null;                                                 // UNION_CLM譎ゅ↓繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ霑ｽ蜉?☆繧九き繝ｩ繝?錐
192            private String  modifyClms              = null;                                                 // DIFFERENCE譎ゅ↓繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐
193            private String  groupAddClms    = null;                                                 // 5.1.4.0 (2010/03/01) masterKeys縺ｧ髮?粋蜃ｦ逅?☆繧九→縺阪↓縲∫嶌驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐
194            private boolean noSideEffect    = false;                                                // 繝??繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑(true:縺ｪ縺?false:縺ゅｋ)
195            private boolean useDiffData             = true;                                                 // DIFFERENCE譎ゅ↓蟾ｮ蛻??繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧定ｿｽ蜉?☆繧九°縺ｩ縺?°
196            private boolean useCheckOnly    = false;                                                // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°
197            private boolean display                 = true;
198            private boolean isMainTrans             = true;                                                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
199            private String  separator               = ",";                                                  // 5.3.1.0 (2011/01/01) groupAddClmns縺ｧ邨仙粋縺吶ｋ髫帙?蛹ｺ蛻?ｊ譁?ｭ?
200    
201            /**
202             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
203             *
204             * @og.rev 4.3.2.0 (2008/09/11) UNION_SELROW繧｢繧ｯ繧ｷ繝ｧ繝ｳ蟇ｾ蠢?
205             * @og.rev 4.3.3.0 (2008/10/01) 蜃ｦ逅?燕蠕後?繝??繝悶Ν莉ｶ謨ｰ繧貞叙蠕励〒縺阪ｋ繧医≧縺ｫ縺吶ｋ
206             * @og.rev 4.3.3.1 (2008/10/08) 繧ｹ繝ｬ繝ｼ繝悶?null繝√ぉ繝?け霑ｽ蜉?
207             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
208             * @og.rev 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
209             *
210             * @return      蠕檎ｶ壼?逅??謖?､ｺ
211             */
212            @Override
213            public int doEndTag() {
214                    debugPrint();           // 4.0.0 (2005/02/28)
215                    // 5.2.2.0 (2010/11/01) caseKey 縲…aseVal 螻樊?蟇ｾ蠢?
216    //              if( ! check( command, COMMAND_LIST ) ) { return(EVAL_PAGE); }
217                    if( !useTag() || ! check( command, COMMAND_LIST ) ) { return(EVAL_PAGE); }
218    
219                    // 謨ｴ蜷域?繝√ぉ繝?け?壹い繧ｯ繧ｷ繝ｧ繝ｳ繝ｪ繧ｹ繝医→縺ｮ蟄伜惠繝√ぉ繝?け
220                    if( !check( action, ACTION_LIST ) ) {
221                            String errMsg = "謖?ｮ壹?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺ｯ螳溯｡後〒縺阪∪縺帙ｓ縲ゅい繧ｯ繧ｷ繝ｧ繝ｳ繧ｨ繝ｩ繝ｼ"
222                                                            + HybsSystem.CR
223                                                            + "action=[" + action + "] "
224                                                            + HybsSystem.CR
225                                                            + "謖?ｮ壼庄閭ｽ縺ｪ繧｢繧ｯ繧ｷ繝ｧ繝ｳ:"
226                                                            + StringUtil.array2csv( ACTION_LIST ) ;
227                            throw new HybsSystemException( errMsg );
228                    }
229    
230                    // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ(null譎?masterKeys)
231                    if( slaveKeys == null ) { slaveKeys = masterKeys; }
232    
233                    super.setScope( masterScope );
234                    DBTableModel masterTable = (DBTableModel)getObject( masterTableId );
235    
236                    // 謨ｴ蜷域?繝√ぉ繝?け?壹?繧ｹ繧ｿ繝??繝悶Ν縺ｯ蠢??
237                    if( masterTable == null ) {
238                            String errMsg = "繝槭せ繧ｿ繝??繝悶Ν縺ｯ蠢??縺ｧ縺吶?"
239                                                    + HybsSystem.CR
240                                                    + "action=[" + action + "] "
241                                                    + "masterTableId=[" + masterTableId + "] "
242                                                    + "masterScope=[" + masterScope + "] " ;
243                            throw new HybsSystemException( errMsg );
244                    }
245                    if( noSideEffect ) { masterTable = cloneTable( masterTable ); }
246                    Map<String,Integer> masterMap = makeKeyMap( masterTable,masterKeys,useCheckOnly );
247    
248                    DBTableModel slaveTable = null;
249                    Map<String,Integer> slaveMap = null;
250    
251                    // 謨ｴ蜷域?繝√ぉ繝?け?啾ction="GROUP" 縺ｨ "ADD_CLM" 莉･螟悶〒縺ｯ縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ蠢??
252                    if( ! ACT_GROUP.equalsIgnoreCase( action ) && !ACT_ADD_CLM.equalsIgnoreCase( action ) ) {
253                            super.setScope( slaveScope );
254                            slaveTable = (DBTableModel)getObject( slaveTableId );
255    
256                            if( slaveTable == null ) {
257                                    String errMsg = "action=\"" + action + "\" 譎ゅ↓縺ｯ縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺悟ｿ?ｦ√〒縺吶?"
258                                                            + HybsSystem.CR
259                                                            + "slaveTableId=[" + slaveTableId + "] "
260                                                            + "slaveScope=[" + slaveScope + "] " ;
261                                    throw new HybsSystemException( errMsg );
262                            }
263                            if( noSideEffect ) { slaveTable = cloneTable( slaveTable ); }
264                            slaveMap = makeKeyMap( slaveTable,slaveKeys,false );    // 繧ｹ繝ｬ繝ｼ繝悶?useCheckOnly辟｡髢｢菫?
265    
266                            // 縺昴?蝣ｴ蜷医?繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶′蜷御ｸ?Γ繝｢繝ｪ荳翫?繝??繝悶Ν(迚ｩ逅?噪縺ｫ蜷後§)縺ｧ縺ｪ縺?ｺ九?
267                            if( slaveTable == masterTable ) {
268                                    String errMsg = "繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶′蜷御ｸ?Γ繝｢繝ｪ縺ｫ縺ｪ縺｣縺ｦ縺?∪縺吶?"
269                                                            + "騾壼ｸｸ縲∵､懃ｴ｢邨先棡縺ｯ TableId 縺ｨ Scope 繧貞挨縲?↓謖?ｮ壹＠縺ｾ縺吶?"
270                                                            + HybsSystem.CR
271                                                            + "action=[" + action + "] "
272                                                            + "masterTableId=[" + masterTableId + "] "
273                                                            + "slaveTableId=[" + slaveTableId + "] "
274                                                            + "masterScope=[" + masterScope + "] "
275                                                            + "slaveScope=[" + slaveScope + "] " ;
276                                    throw new HybsSystemException( errMsg );
277                            }
278                    }
279    
280                    super.setScope( scope );
281                    useMainTrans( isMainTrans );                    // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
282                    startQueryTransaction( tableId );               // 3.6.0.8 (2004/11/19)
283    
284                    // 險ｭ螳壼?縺ｮ謨ｴ蜷域?繝√ぉ繝?け
285                    // 謨ｴ蜷域?繝√ぉ繝?け?啾ction="UNION_ALL" 縺ｨ "GROUP"縺ｨ "ADD_CLM"縺ｨ "UNION_CLM" 莉･螟悶〒縺ｯ縲［asterKeys 縺悟ｿ??
286                    if( ! ACT_UNION_ALL.equalsIgnoreCase( action )
287                            && !ACT_UNION_SELROW.equalsIgnoreCase( action ) // 4.3.2.0 (2008/09/11)
288                            && !ACT_GROUP.equalsIgnoreCase( action )
289                            && !ACT_ADD_CLM.equalsIgnoreCase( action )
290                            && !ACT_UNION_CLM.equalsIgnoreCase( action )
291                            && masterKeys == null ) {
292                                    String errMsg = "action=\"" + action + "\" 譎ゅ↓縺ｯ縲［asterKeys 縺悟ｿ??縺ｧ縺吶?"
293                                                            + HybsSystem.CR
294                                                            + "masterKeys=[" + masterKeys + "] ";
295                                    throw new HybsSystemException( errMsg );
296                    }
297    
298                    // 險ｭ螳壼?縺ｮ謨ｴ蜷域?繝√ぉ繝?け
299                    // 謨ｴ蜷域?繝√ぉ繝?け?啾ction="DIFFERENCE" 縺ｧ縺ｯ縲‥iffKeys 縺悟ｿ??
300                    if( ACT_DIFFERENCE.equalsIgnoreCase( action ) && diffKeys == null ) {
301                            String errMsg = "action=\"" + action + "\" 譎ゅ↓縺ｯ縲‥iffKeys 縺悟ｿ??縺ｧ縺吶?"
302                                                    + HybsSystem.CR
303                                                    + "diffKeys=[" + diffKeys + "] ";
304                            throw new HybsSystemException( errMsg );
305                    }
306    
307                    // 險ｭ螳壼?縺ｮ謨ｴ蜷域?繝√ぉ繝?け
308                    // 謨ｴ蜷域?繝√ぉ繝?け?壼?蜷域?(UNION_CLM) 縺ｨ 繧ｰ繝ｫ繝ｼ繝?GROUP) 縺ｨ 蛻苓ｿｽ蜉?ADD_CLM) 莉･螟悶〒縺ｯ縲√ユ繝ｼ繝悶Ν繧ｫ繝ｩ繝?焚縺悟酔縺倥〒縺ゅｋ蠢?ｦ√′縺ゅｋ縲?
309                    if( ! ACT_UNION_CLM.equalsIgnoreCase( action )
310                             && !ACT_GROUP.equalsIgnoreCase( action )
311                             && !ACT_ADD_CLM.equalsIgnoreCase( action ) ) {
312                            int mClmSize = masterTable.getColumnCount();
313                            int sClmSize = slaveTable.getColumnCount();
314    
315                            if( mClmSize != sClmSize ) {
316                                    String errMsg = "action=\"" + action + "\" 譎ゅ↓縺ｯ縲√ユ繝ｼ繝悶Ν繧ｫ繝ｩ繝?焚縺檎焚縺ｪ縺｣縺ｦ縺ｯ縺?￠縺ｾ縺帙ｓ縲?
317                                                            + HybsSystem.CR
318                                                            + "Master=" + mClmSize + " ,["
319                                                            + StringUtil.array2csv( masterTable.getNames() ) + "]"
320                                                            + HybsSystem.CR
321                                                            + "Slave =" + sClmSize + " ,["
322                                                            + StringUtil.array2csv( slaveTable.getNames() ) + "]";
323                                    throw new HybsSystemException( errMsg );
324                            }
325                    }
326    
327                    StringBuilder buf = null;
328                    if( display ) {
329                            buf = new StringBuilder();
330                            buf.append( action ).append( "(" );
331                            buf.append( " M[" ).append( masterTable.getRowCount() ).append( "]" );
332                            if( slaveTable != null ) {
333                                    buf.append( ",S[" ).append( slaveTable.getRowCount() ).append( "]" );
334                            }
335                    }
336    
337                    // 4.3.3.0 (2008/10/01)
338                    setRequestAttribute( "DB.MASTER_COUNT"   , String.valueOf( masterTable.getRowCount() ) );
339                    // 4.3.3.1 (2008/10/08) null繝√ぉ繝?け
340                    if( slaveTable != null ) {
341                            setRequestAttribute( "DB.SLAVE_COUNT", String.valueOf( slaveTable.getRowCount() ) );
342                    }
343    
344                    DBTableModel table = null;
345                    if( ACT_UNION_ALL.equalsIgnoreCase( action ) ) {                        // 蜈ｨ菴馴寔蜷?
346                            table = makeUnionAll( masterTable,slaveTable );
347                    }
348                    else if( ACT_UNION_SELROW.equalsIgnoreCase( action ) ) {        // 4.3.2.0 (2008/09/11) 蜈ｨ菴馴寔蜷?slave陦ｨ繧知aster陦ｨ縺ｮ繝√ぉ繝?け陦後°繧芽ｿｽ蜉?
349                            table = makeUnionSelrow( masterTable,slaveTable );
350                    }
351                    else if( ACT_UNION.equalsIgnoreCase( action ) ) {                       // 蜥碁寔蜷?
352                            table = makeUnion( masterTable,masterMap,slaveTable,slaveMap );
353                    }
354                    else if( ACT_INTERSECT.equalsIgnoreCase( action ) ) {           // 遨埼寔蜷?
355                            table = makeIntersect( masterTable,masterMap,slaveMap );
356                    }
357                    else if( ACT_MINUS.equalsIgnoreCase( action ) ) {                       // 蟾ｮ髮?粋
358                            table = makeMinus( masterTable,masterMap,slaveMap );
359                    }
360                    else if( ACT_DIFFERENCE.equalsIgnoreCase( action ) ) {          // 蟾ｮ蛻?寔蜷?
361                            table = makeDifference( masterTable,masterMap,slaveTable,slaveMap );
362                    }
363                    else if( ACT_UNION_CLM.equalsIgnoreCase( action ) ) {           // 蛻怜粋謌?
364                            if( unionClms == null ) {
365                                    String errMsg = "action=\"UNION_CLM\" 譎ゅ↓縺ｯ縲「nionClms 縺悟ｿ??縺ｧ縺吶?" ;
366                                    throw new HybsSystemException( errMsg );
367                            }
368    
369                            table = makeUnionClm( masterTable,slaveKeys,slaveTable,slaveMap );
370                    }
371                    else if( ACT_ADD_CLM.equalsIgnoreCase( action ) ) {             // 蛻苓ｿｽ蜉?
372                            if( unionClms == null ) {
373                                    String errMsg = "action=\"ADD_CLM\" 譎ゅ↓縺ｯ縲「nionClms 縺悟ｿ??縺ｧ縺吶?" ;
374                                    throw new HybsSystemException( errMsg );
375                            }
376    
377                            table = makeAddClm( masterTable );
378                    }
379                    else if( ACT_GROUP.equalsIgnoreCase( action ) ) {                       // 繧ｰ繝ｫ繝ｼ繝?
380                            table = makeGroup( masterTable );
381                    }
382    
383                    if( table != null ) {
384                            // 3.6.0.8 (2004/11/19) 繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
385                            super.setScope( scope );
386                            if( ! commitTableObject( tableId, table ) ) {
387                                    return (SKIP_PAGE);
388                            }
389                    }
390    
391                    if( display ) {
392                            buf.append( " ) = [" ).append( table.getRowCount() ).append( "]" );
393                            jspPrint( buf.toString() );
394                    }
395    
396                    // 4.3.3.0 (2008/10/01)
397                    // 4.3.4.4 (2009/01/01)
398                    setRequestAttribute( "DB.COUNT"   , ( table == null ? 0 :String.valueOf( table.getRowCount() ) ) );
399    
400                    return(EVAL_PAGE);              // 繝壹?繧ｸ縺ｮ谿九ｊ繧定ｩ穂ｾ｡縺吶ｋ縲?
401            }
402    
403            /**
404             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
405             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
406             *
407             * @og.rev 5.1.4.0 (2010/03/01) groupAddClms 霑ｽ蜉?
408             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
409             * @og.rev 5.3.1.0 (2011/01/01) separator霑ｽ蜉?
410             */
411            @Override
412            protected void release2() {
413                    super.release2();
414                    command                 = CMD_NEW;
415                    action                  = null;
416                    tableId                 = HybsSystem.TBL_MDL_KEY;               // 蜃ｺ蜉帛?縺ｮ tableId
417                    scope                   = "session";                                            // 蜃ｺ蜉帛?縺ｮ scope
418                    masterTableId   = HybsSystem.TBL_MDL_KEY;               // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ tableId
419                    masterScope             = "session";                                            // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ scope
420                    slaveTableId    = HybsSystem.TBL_MDL_KEY;               // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ tableId
421                    slaveScope              = "request";                                            // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ scope
422                    masterKeys              = null;                                                         // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ
423                    slaveKeys               = null;                                                         // 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ(null譎?masterKeys)
424                    diffKeys                = null;                                                         // 繝槭せ繧ｿ繝??繝悶Ν縺ｮDIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐
425                    unionClms               = null;                                                         // 繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ霑ｽ蜉?☆繧九き繝ｩ繝?錐
426                    modifyClms              = null;                                                         // 繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐
427                    groupAddClms    = null;                                                         // 5.1.4.0 (2010/03/01) masterKeys縺ｧ髮?粋蜃ｦ逅?☆繧九→縺阪↓縲∫嶌驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐
428                    noSideEffect    = false;                                                        // 繝??繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑(true:縺ｪ縺?false:縺ゅｋ)
429                    useDiffData             = true;                                                         // DIFFERENCE譎ゅ↓蟾ｮ蛻??繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧定ｿｽ蜉?☆繧九°縺ｩ縺?°
430                    useCheckOnly    = false;                                                        // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°
431                    display                 = true;
432                    isMainTrans             = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
433                    separator               = ",";
434            }
435    
436            /**
437             * 謖?ｮ壹?繝??繝悶Ν縺ｮ謖?ｮ壹?繧ｫ繝ｩ繝?CSV)繧医ｊ縲∬｡檎分蜿ｷ繧偵?繝??蛹悶＠縺ｾ縺吶?
438             * 縺ｪ縺翫?蠑墓焚縺ｮ繝??繝悶Ν縺ｫ縺､縺?※縺ｯ縲∽ｸｻ繧ｭ繝ｼ縺ｫ繧医ｋ繧ｰ繝ｫ繝ｼ繝怜?逅?′陦後ｏ繧後∪縺吶?(蜑ｯ菴懃畑縺ゅｊ)
439             *
440             * @og.rev 4.3.2.0 (2008/09/11) 繝槭せ繧ｿ繧ｭ繝ｼ譛ｪ謖?ｮ壽凾縺ｯ菴輔ｂ縺励↑縺?
441             * @og.rev 5.1.4.0 (2010/03/01) groupAddClms 霑ｽ蜉?
442             * @og.rev 5.3.1.0 (2011/01/01) groupAddClms 縺ｮ separator謖?ｮ壼ｯｾ蠢?
443             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
444             *
445             * @param       table   繝槭ャ繝嶺ｽ懈?蜈??繝??繧ｿ繝??繝悶Ν(蜑ｯ菴懃畑縺ゅｊ)
446             * @param       keys    繝槭ャ繝嶺ｽ懈?縺ｮ荳ｻ繧ｭ繝ｼ(CSV蠖｢蠑?
447             * @param       useCheckOnly    繝√ぉ繝?け陦後?縺ｿ繧貞ｯｾ雎｡縺ｫ縺吶ｋ縺九←縺?°
448             *
449             * @return 繝槭ャ繝怜喧縺輔ｌ縺滉ｸｻ繧ｭ繝ｼ縺ｨ陦檎分蜿ｷ
450             */
451            private Map<String,Integer> makeKeyMap( final DBTableModel table, final String keys, final boolean useCheckOnly ) {
452    
453                    // 繧ｫ繝ｩ繝?錐繧偵き繝ｩ繝?分蜿ｷ縺ｫ螟画鋤縺励∪縺吶?
454                    int[] clmNo = makeColumnNo( table,keys );
455                    int   clmSize = clmNo.length;
456                    if( clmSize == 0 ) {    // 繝槭せ繧ｿ繧ｭ繝ｼ譛ｪ謖?ｮ壽凾縺ｫ縺ｯ蜈ｨ繧ｫ繝ｩ繝?ｒ菴ｿ逕ｨ縺励∪縺吶?
457    //                      clmSize = table.getColumnCount();
458    //                      clmNo = new int[clmSize];
459    //                      for( int i=0; i<clmSize; i++ ) {
460    //                              clmNo[i] = i;
461    //                      }
462                            return null; // 4.3.2.0 (2008/09/11)
463                    }
464    
465                    // groupAddClms 繧偵き繝ｩ繝?分蜿ｷ縺ｫ螟画鋤縺励∪縺吶?
466                    int[] grpClmNo = makeColumnNo( table,groupAddClms );
467                    int   grpClmSize = grpClmNo.length;
468    
469                    Map<String,Integer> tempMap = new LinkedHashMap<String,Integer>();
470    
471                    // 豕ｨ諢擾ｼ哦ROUP蛹悶?驕守ｨ九〒 繝??繝悶Ν莉ｶ謨ｰ縺悟虚逧?↓螟牙喧縺励∪縺吶?
472                    StringBuilder buf ;
473                    for( int row=0; row<table.getRowCount(); row++ ) {
474                            if( useCheckOnly && table.getModifyType( row ).length() == 0 ) {
475                                    continue;
476                            }
477    
478                            buf = new StringBuilder();
479                            for( int i=0; i<clmSize; i++ ) {
480                                    buf.append( table.getValue( row,clmNo[i] ) ).append( "|" );
481                            }
482                            // 荳ｻ繧ｭ繝ｼ騾｣邨先枚蟄怜?
483    //                      String key = buf.toString();    // 荳ｻ繧ｭ繝ｼ騾｣邨先枚蟄怜?
484                            String key = buf.toString().toUpperCase(Locale.JAPAN);          // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
485                            if( tempMap.containsKey( key ) ) {
486                                    // 5.1.4.0 (2010/03/01) groupAddClms 霑ｽ蜉?
487                                    int orgRow = tempMap.get( key ).intValue() ;                            // 霑ｽ蜉?ｸ医∩縺ｮ陦檎分蜿ｷ繧貞叙蠕?
488                                    for( int i=0; i<grpClmSize; i++ ) {
489                                            int clm    = grpClmNo[i];
490                                            String val1 = table.getValue( orgRow,clm ) ;                    // 譌｢蟄倥?陦後?繧ｫ繝ｩ繝??繝??繧ｿ
491                                            String val2 = table.getValue( row,clm ) ;                               // 蜑企勁縺吶ｋ陦後?繧ｫ繝ｩ繝??繝??繧ｿ
492                                            // 5.3.1.0 (2011/01/01)
493    //                                      table.setValueAt( val1 + "," + val2,orgRow,clm );               // CSV 騾｣邨舌?繝??繧ｿ繧呈綾縺吶?
494                                            table.setValueAt( val1 + separator + val2,orgRow,clm );         // CSV 騾｣邨舌?繝??繧ｿ繧呈綾縺吶?
495                                    }
496                                    table.removeValue( row );
497                                    row-- ;
498                            }
499                            else {                                                  // 縺ｾ縺??譛ｪ逋ｻ骭ｲ縺ｮ蝣ｴ蜷?
500                                    tempMap.put( key,Integer.valueOf( row ) );
501                            }
502                    }
503    
504                    return tempMap;
505            }
506    
507            /**
508             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蜈ｨ菴馴寔蜷?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
509             *
510             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
511             * @param       slaveTbl        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繝｢繝?Ν
512             *
513             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
514             */
515            private DBTableModel makeUnionAll( final DBTableModel masterTbl,final DBTableModel slaveTbl ) {
516                    DBTableModel table = masterTbl;
517    
518                    for( int row=0; row<slaveTbl.getRowCount(); row++ ) {
519                            String[] vals = slaveTbl.getValues( row );
520                            table.addColumnValues( vals );
521                    }
522    
523                    return table;
524            }
525    
526            /**
527             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蜈ｨ菴馴寔蜷?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
528             * 繧ｹ繝ｬ繝ｼ繝冶｡ｨ縺ｯ縲√?繧ｹ繧ｿ陦ｨ縺ｮ繝√ぉ繝?け縺輔ｌ縺溯｡後ｒ襍ｷ轤ｹ縺ｨ縺励※逋ｻ骭ｲ縺輔ｌ縺ｾ縺吶?
529             * 繝√ぉ繝?け縺輔ｌ縺ｦ縺?↑縺??蜷医?縲√せ繝ｬ繝ｼ繝冶｡ｨ縺ｯ蜈磯?縺九ｉ霑ｽ蜉?＆繧後∪縺吶?
530             *
531             * @og.rev 4.3.2.0 (2008/09/11) 譁ｰ隕丈ｽ懈?
532             *
533             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
534             * @param       slaveTbl        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繝｢繝?Ν
535             *
536             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
537             */
538            private DBTableModel makeUnionSelrow( final DBTableModel masterTbl,final DBTableModel slaveTbl ) {
539                    DBTableModel table = masterTbl;
540    
541                    int insRowNo = ( getParameterRows().length > 0 ) ? getParameterRows()[0] + 1 : 0 ;
542                    for( int row=0; row<slaveTbl.getRowCount(); row++ ) {
543                            String[] vals = slaveTbl.getValues( row );
544                            table.addValues( vals, insRowNo + row, false );
545                    }
546    
547                    return table;
548            }
549    
550            /**
551             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蜥碁寔蜷?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
552             *
553             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
554             *
555             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
556             * @param       masterMap       繝槭せ繧ｿ繝ｼ繝??繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
557             * @param       slaveTbl        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繝｢繝?Ν
558             * @param       slaveMap        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
559             *
560             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
561             */
562            private DBTableModel makeUnion( final DBTableModel masterTbl,final Map<String,Integer> masterMap,
563                                                                            final DBTableModel slaveTbl,final Map<String,Integer> slaveMap ) {
564                    DBTableModel table = masterTbl;
565    
566                    @SuppressWarnings("rawtypes")
567                    Map.Entry[] entry = slaveMap.entrySet().toArray( new Map.Entry[slaveMap.size()] );
568    
569                    int size = entry.length;
570                    for( int i=0; i<size; i++ ) {
571                            String key  = (String)entry[i].getKey();
572                            if( key != null ) { key = key.toUpperCase(Locale.JAPAN); }              // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
573                            if( ! masterMap.containsKey( key ) ) {          // 繝槭せ繧ｿ縺ｫ繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ縺悟ｭ伜惠縺励↑縺?
574                                    int row =  ((Integer)entry[i].getValue()).intValue();
575                                    String[] vals = slaveTbl.getValues( row );
576                                    table.addColumnValues( vals );
577                            }
578                    }
579                    return table;
580            }
581    
582            /**
583             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 遨埼寔蜷?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
584             *
585             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
586             *
587             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
588             * @param       masterMap       繝槭せ繧ｿ繝ｼ繝??繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
589             * @param       slaveMap        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
590             *
591             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
592             */
593            private DBTableModel makeIntersect( final DBTableModel masterTbl,final Map<String,Integer> masterMap, final Map<String,Integer> slaveMap ) {
594                    DBTableModel table = masterTbl;
595    
596                    @SuppressWarnings("rawtypes")
597                    Map.Entry[] entry = masterMap.entrySet().toArray( new Map.Entry[masterMap.size()] );
598    
599                    int size = entry.length;
600                    for( int i=0; i<size; i++ ) {
601                            String key  = (String)entry[i].getKey();
602                            if( key != null ) { key = key.toUpperCase(Locale.JAPAN); }              // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
603                            if( ! slaveMap.containsKey( key ) ) {           // 繧ｹ繝ｬ繝ｼ繝悶↓繝槭せ繧ｿ縺悟ｭ伜惠縺励↑縺?
604                                    int row =  ((Integer)entry[i].getValue()).intValue();
605                                    table.rowDelete( row );                         // 隲也炊蜑企勁
606                            }
607                    }
608    
609                    // 陦檎分蜿ｷ縺悟､峨ｏ繧峨↑縺?ｈ縺?↓騾??蜑企勁縺励∪縺吶?
610                    for( int row=table.getRowCount()-1; row>=0; row-- ) {
611    //                      if( DBTableModel.DELETE_TYPE.equals( table.getModifyType( row ) ) ) {
612                            if( DBTableModel.DELETE_TYPE.equalsIgnoreCase( table.getModifyType( row ) ) ) {         // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
613                                    table.removeValue( row );
614                            }
615                    }
616    
617                    return table;
618            }
619    
620            /**
621             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蟾ｮ髮?粋 蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
622             *
623             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
624             *
625             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
626             * @param       masterMap       繝槭せ繧ｿ繝ｼ繝??繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
627             * @param       slaveMap        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
628             *
629             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
630             */
631            private DBTableModel makeMinus( final DBTableModel masterTbl,final Map<String,Integer> masterMap,
632                                                                            final Map<String,Integer> slaveMap ) {
633                    DBTableModel table = masterTbl;
634    
635                    @SuppressWarnings("rawtypes")
636                    Map.Entry[] entry = masterMap.entrySet().toArray( new Map.Entry[masterMap.size()] );
637    
638                    int size = entry.length;
639                    for( int i=0; i<size; i++ ) {
640                            String key  = (String)entry[i].getKey();
641                            if( key != null ) { key = key.toUpperCase(Locale.JAPAN); }              // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
642                            if( slaveMap.containsKey( key ) ) {             // 繧ｹ繝ｬ繝ｼ繝悶↓繝槭せ繧ｿ縺悟ｭ伜惠縺吶ｋ
643                                    int row =  ((Integer)entry[i].getValue()).intValue();
644                                    table.rowDelete( row );                         // 隲也炊蜑企勁
645                            }
646                    }
647    
648                    // 陦檎分蜿ｷ縺悟､峨ｏ繧峨↑縺?ｈ縺?↓騾??蜑企勁縺励∪縺吶?
649                    for( int row=table.getRowCount()-1; row>=0; row-- ) {
650    //                      if( DBTableModel.DELETE_TYPE.equals( table.getModifyType( row ) ) ) {
651                            if( DBTableModel.DELETE_TYPE.equalsIgnoreCase( table.getModifyType( row ) ) ) {         // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
652                                    table.removeValue( row );
653                            }
654                    }
655    
656                    return table;
657            }
658    
659            /**
660             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蟾ｮ蛻?寔蜷?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
661             *
662             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
663             *
664             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
665             * @param       masterMap       繝槭せ繧ｿ繝ｼ繝??繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
666             * @param       slaveTbl        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繝｢繝?Ν
667             * @param       slaveMap        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
668             *
669             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
670             */
671            private DBTableModel makeDifference( final DBTableModel masterTbl,final Map<String,Integer> masterMap,
672                                                                                     final DBTableModel slaveTbl ,final Map<String,Integer> slaveMap ) {
673                    DBTableModel table = masterTbl;
674    
675                    // 繝??繝悶Ν縺ｮ蟾ｮ蛻?ｱ樊?縺ｮ繧ｫ繝ｩ繝?分蜿ｷ繧呈ｱゅａ縺ｾ縺吶?(繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝門?騾?
676                    int[] diffClmNo = makeColumnNo( table,diffKeys );
677                    int diffClmSize = diffClmNo.length;
678    
679                    // 繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､縺ｮ蜀阪そ繝?ヨ繧定｡後≧繧ｫ繝ｩ繝?分蜿ｷ繧呈ｱゅａ縺ｾ縺吶?(繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝門?騾?
680                    int[] modClmNo = makeColumnNo( table,modifyClms );
681                    int modClmSize = modClmNo.length;
682    
683                    int clmSize = table.getColumnCount();
684                    DBTableModel newTable = DBTableModelUtil.newDBTable();
685                    newTable.init( clmSize );
686    
687                    // 繝??繝悶Ν縺ｮ蜈ｨ繧ｫ繝ｩ繝?ｒ譁ｰ縺溘↓菴懈?縺吶ｋ繝??繝悶Ν縺ｫ繧ｳ繝斐?縺励∪縺吶?
688                    for( int i=0; i<clmSize; i++ ) {
689                            newTable.setDBColumn( i,table.getDBColumn( i ) );
690                    }
691    
692                    // 繧ｹ繝ｬ繝ｼ繝悶?蜈磯?繧ｫ繝ｩ繝?′縲仝RITABLE 縺九←縺?°
693                    boolean writeFlag = "WRITABLE".equalsIgnoreCase( slaveTbl.getColumnName(0) );
694    
695                    @SuppressWarnings("rawtypes")
696                    Map.Entry[] entry = masterMap.entrySet().toArray( new Map.Entry[masterMap.size()] );
697    
698                    int size = entry.length;
699                    for( int i=0; i<size; i++ ) {
700                            String key  = (String)entry[i].getKey();
701                            if( key != null ) { key = key.toUpperCase(Locale.JAPAN); }              // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
702                            if( slaveMap.containsKey( key ) ) {             // 繧ｹ繝ｬ繝ｼ繝悶↓繝槭せ繧ｿ縺悟ｭ伜惠縺吶ｋ
703                                    int mrow =  ((Integer)entry[i].getValue()).intValue();
704                                    int srow =  (slaveMap.get( key )).intValue();
705                                    boolean unmatched = false;
706                                    for( int j=0; j<diffClmSize; j++ ) {
707                                            String mval = table.getValue( mrow,diffClmNo[j] );
708                                            String sval = slaveTbl.getValue( srow,diffClmNo[j] );
709    //                                      if( mval != null && !mval.equals( sval ) ) { unmatched = true; break; }
710                                            if( mval != null && !mval.equalsIgnoreCase( sval ) ) { unmatched = true; break; }               // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
711                                    }
712    
713                                    if( unmatched ) {               // 螻樊?諠??縺檎焚縺ｪ繧句?蜷医?縺ｿ蜃ｦ逅?
714                                            // 繝??繧ｿ縺ｮ繧ｳ繝斐?
715                                            String[] mvals = new String[clmSize];
716                                            System.arraycopy( table.getValues( mrow ),0,mvals,0 ,clmSize );
717    
718                                            // 繧ｹ繝ｬ繝ｼ繝悶?蛟､繧偵?繧ｹ繧ｿ縺ｮ蛟､縺ｫ繧ｻ繝?ヨ縺吶ｋ縲?
719                                            for( int j=0; j<modClmSize; j++ ) {
720                                                    String val = slaveTbl.getValue( srow,modClmNo[j] );
721                                                    mvals[modClmNo[j]] = val;
722                                            }
723                                            newTable.addColumnValues( mvals );
724    
725                                            if( useDiffData ) {
726                                                    // 繝??繧ｿ縺ｮ繧ｳ繝斐?
727                                                    String[] svals = new String[clmSize];
728                                                    System.arraycopy( slaveTbl.getValues( srow ),0,svals,0 ,clmSize );
729                                                    if( writeFlag ) { svals[0] = "0"; }     // 譖ｸ縺崎ｾｼ縺ｿ荳崎ｨｱ蜿ｯ
730                                                    for( int j=0; j<diffClmSize; j++ ) {
731                                                            int dclmNo = diffClmNo[j];
732                                                            String mval = mvals[dclmNo];
733                                                            String sval = svals[dclmNo];
734    //                                                      if( mval != null && !mval.equals( sval ) ) {
735                                                            if( mval != null && !mval.equalsIgnoreCase( sval ) ) {          // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
736                                                                    svals[dclmNo] = "<span class=\"unmatched\">" + sval + "</span>" ;
737                                                            }
738                                                    }
739                                                    newTable.addColumnValues( svals );
740            //                                      newTable.setRowWritable( newTable.getRowCount()-1,false );      // 譖ｸ縺崎ｾｼ縺ｿ荳崎ｨｱ蜿ｯ
741                                            }
742                                    }
743                            }
744                    }
745                    return newTable;
746            }
747    
748            /**
749             * 謖?ｮ壹?繝槭せ繧ｿ,繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧剃ｽｿ逕ｨ縺励※ 蛻怜粋謌?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
750             *
751             * 縺吶〒縺ｫ縲√?繧ｹ繧ｿ 縺ｫ繧ｫ繝ｩ繝?′蟄伜惠縺励※縺?ｋ蝣ｴ蜷医?縲∝?縺ｮ譖ｸ縺肴鋤縺医ｒ縲?
752             * 繧ｫ繝ｩ繝?′蟄伜惠縺励↑縺代ｌ縺ｰ縲√き繝ｩ繝?ｒ霑ｽ蜉?＠縺ｾ縺吶?
753             * 繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繝??繧ｿ遯∝粋縺帶凾縺ｮ繧ｭ繝ｼ縺ｯ縲《laveKeys 縺ｫ縺ｪ繧翫∪縺吶?
754             * 縺薙ｌ縺ｯ縲［asterMap 繧剃ｽｿ逕ｨ縺励↑縺?％縺ｨ繧呈э蜻ｳ縺励∪縺吶?(masterKeys 謖?ｮ壹↓繧医ｋGROUP蛹悶?
755             * 陦後＞縺ｾ縺吶?masterKeys 繧呈欠螳壹＠縺ｪ縺??蜷医?縲√し繝槭Λ繧､繧ｺ縺ｪ縺励〒蜃ｦ逅?＠縺ｾ縺吶?)
756             * 蜈ｷ菴鍋噪縺ｫ縺ｯ縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｮ隍?焚縺ｮ陦後↓蟇ｾ縺励※縲√せ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ縺ｮ蛟､縺瑚ｨｭ螳?
757             * 縺輔ｌ繧句庄閭ｽ諤ｧ縺後≠繧九％縺ｨ繧呈э蜻ｳ縺励∪縺吶?
758             *
759             * @og.rev 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
760             *
761             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
762             * @param       slaveKeys       繧ｹ繝ｬ繝ｼ繝悶く繝ｼ
763             * @param       slaveTbl        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繝｢繝?Ν
764             * @param       slaveMap        繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繝槭ャ繝?
765             *
766             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
767             */
768            private DBTableModel makeUnionClm( final DBTableModel masterTbl ,final String slaveKeys ,
769                                                                                    final DBTableModel slaveTbl ,final Map<String,Integer> slaveMap ) {
770    
771                    DBTableModel table = makeAddClm( masterTbl );
772    
773                    // 繧ｫ繝ｩ繝?錐繧偵き繝ｩ繝?分蜿ｷ縺ｫ螟画鋤縺励∪縺吶?
774                    int[] keyClmNo = makeColumnNo( table,slaveKeys );
775    
776                    int[] mClmNo = makeColumnNo( table   ,unionClms );
777                    int[] sClmNo = makeColumnNo( slaveTbl,unionClms );
778                    int   addSize = mClmNo.length;          // unionClms 縺ｮ蛟区焚縺ｪ縺ｮ縺ｧ縲√?繧ｹ繧ｿ縲√せ繝ｬ繝ｼ繝悶?蜷御ｸ?
779    
780                    // 遯∝粋縺帙ｒ陦後＞縲√?繝?メ縺吶ｋ繧ｫ繝ｩ繝?↓縺､縺?※縲∝?繧偵そ繝?ヨ縺礼峩縺励∪縺吶?
781    //              Map.Entry[] entry = slaveMap.entrySet().toArray( new Map.Entry[slaveMap.size()] );
782    
783                    for( int row=0; row<table.getRowCount(); row++ ) {
784                            String[] mvals = table.getValues( row );
785                            StringBuilder buf = new StringBuilder();
786                            for( int i=0; i<keyClmNo.length; i++ ) {
787                                    buf.append( mvals[keyClmNo[i]] ).append( "|" );
788                            }
789                            // 荳ｻ繧ｭ繝ｼ騾｣邨先枚蟄怜?
790    //                      String key = buf.toString();    // 荳ｻ繧ｭ繝ｼ騾｣邨先枚蟄怜?
791                            String key = buf.toString().toUpperCase(Locale.JAPAN);          // 5.5.8.5 (2012/11/27) 螟ｧ譁?ｭ励?蟆乗枚蟄励ｒ蛹ｺ蛻･縺励↑縺??
792                            if( slaveMap.containsKey( key ) ) {             // 繧ｹ繝ｬ繝ｼ繝悶↓繝槭せ繧ｿ縺ｫ蟇ｾ蠢懊☆繧九ョ繝ｼ繧ｿ縺悟ｭ伜惠縺吶ｋ
793                                    int slvRow =  (slaveMap.get( key )).intValue();
794                                    String[] svals = slaveTbl.getValues( slvRow );          // 繧ｹ繝ｬ繝ｼ繝悶?陦檎分蜿ｷ
795                                    for( int j=0; j<addSize; j++ ) {
796                                            mvals[mClmNo[j]] = svals[sClmNo[j]];
797                                    }
798                                    table.setValues( mvals,row );
799                            }
800                    }
801                    table.resetModify();
802    
803                    return table;
804            }
805    
806            /**
807             * 謖?ｮ壹?繝槭せ繧ｿ繝??繝悶Ν縺ｫ 蛻苓ｿｽ蜉?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
808             *
809             * 縺吶〒縺ｫ縲√?繧ｹ繧ｿ 縺ｫ繧ｫ繝ｩ繝?′蟄伜惠縺励※縺?ｋ蝣ｴ蜷医?縲∝?縺ｮ譖ｸ縺肴鋤縺医ｒ縲?
810             * 繧ｫ繝ｩ繝?′蟄伜惠縺励↑縺代ｌ縺ｰ縲√き繝ｩ繝?ｒ霑ｽ蜉?＠縺ｾ縺吶?
811             *
812             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
813             *
814             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
815             */
816            private DBTableModel makeAddClm( final DBTableModel masterTbl ) {
817                    String[]  addClms        = StringUtil.csv2Array( unionClms );
818                    int       addClmSize = addClms.length;
819                    boolean[] useAdd         = new boolean[addClmSize];
820                    int addSize = 0;
821                    for( int i=0; i<addClmSize; i++ ) {
822                            if( masterTbl.getColumnNo( addClms[i],false ) < 0 ) {        // 蟄伜惠縺励↑縺代ｌ縺ｰ -1
823                                    useAdd[i] = true;
824                                    addSize++ ;
825                            }
826                            else {
827                                    useAdd[i] = false;              // 繝槭せ繧ｿ縺ｫ蟄伜惠縺吶ｌ縺ｰ縲∬ｿｽ蜉?ｸ崎ｦ?
828                            }
829                    }
830    
831                    int mstrClmSize = masterTbl.getColumnCount();
832                    int clmSize = mstrClmSize + addSize;
833    
834                    DBTableModel table = DBTableModelUtil.newDBTable();
835                    table.init( clmSize );
836                    int clmNo = 0;
837                    // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ蜈ｨ繧ｫ繝ｩ繝?ｒ譁ｰ縺溘↓菴懈?縺吶ｋ繝??繝悶Ν縺ｫ繧ｳ繝斐?縺励∪縺吶?
838                    for( int i=0; i<mstrClmSize; i++ ) {
839                            table.setDBColumn( clmNo++,masterTbl.getDBColumn( i ) );
840                    }
841                    // 霑ｽ蜉?☆繧九き繝ｩ繝?ｒ譁ｰ縺溘↓菴懈?縺吶ｋ繝??繝悶Ν縺ｫ霑ｽ蜉?＠縺ｾ縺吶?
842                    String[] addClmVal = new String[addSize];       // 霑ｽ蜉??縺ｮ縺ｿ
843                    int addCnt = 0;
844                    for( int i=0; i<addClmSize; i++ ) {
845                            if( useAdd[i] ) {
846                                    DBColumn column = getDBColumn( addClms[i] );
847                                    addClmVal[addCnt++] = nval( column.getDefault(),"" );
848                                    table.setDBColumn( clmNo++,column );
849                            }
850                    }
851                    // 荳?率縲√☆縺ｹ縺ｦ縺ｮ繝槭せ繧ｿ繝??繧ｿ繧呈眠繝??繝悶Ν縺ｫ繧ｳ繝斐?縺励∪縺吶?
852                    for( int row=0; row<masterTbl.getRowCount(); row++ ) {
853                            String[] vals = new String[clmSize];
854                            System.arraycopy( masterTbl.getValues( row ),0,vals,0 ,mstrClmSize );   // 繝槭せ繧ｿ繝??繧ｿ縺ｮ繧ｳ繝斐?
855                            System.arraycopy( addClmVal,0,vals,mstrClmSize ,addSize );                              // 霑ｽ蜉??諠??縺ｮ蛻晄悄蛟､
856                            table.addColumnValues( vals );
857                    }
858    
859                    return table;
860            }
861    
862            /**
863             * 謖?ｮ壹?繝槭せ繧ｿ繝??繝悶Ν繧剃ｽｿ逕ｨ縺励※ 繧ｰ繝ｫ繝ｼ繝?蜃ｦ逅?ｒ螳溯｡後＠縺ｾ縺吶?
864             *
865             * @param       masterTbl       繝槭せ繧ｿ繝ｼ繝??繝悶Ν繝｢繝?Ν
866             *
867             * @return      蜃ｦ逅?ｵ先棡縺ｮ繝??繝悶Ν繝｢繝?Ν
868             */
869            private DBTableModel makeGroup( final DBTableModel masterTbl ) {
870                    DBTableModel table = masterTbl;
871    
872                    return table;
873            }
874    
875            /**
876             * 謖?ｮ壹?繝??繝悶Ν縺ｨ蜷後§繝??繝悶Ν繧貞挨繧ｪ繝悶ず繧ｧ繧ｯ繝医→縺励※菴懈?縺励∪縺吶?
877             *
878             * @param       tbl     繧ｳ繝斐?蜈?ユ繝ｼ繝悶Ν繝｢繝?Ν
879             *
880             * @return      繧ｳ繝斐?縺輔ｌ縺滓眠繝??繝悶Ν繝｢繝?Ν
881             */
882            private DBTableModel cloneTable( final DBTableModel tbl ) {
883                    int clmSize = tbl.getColumnCount();
884    
885                    DBTableModel table = DBTableModelUtil.newDBTable();
886                    table.init( clmSize );
887    
888                    // 繝??繝悶Ν縺ｮ蜈ｨ繧ｫ繝ｩ繝?ｒ譁ｰ縺溘↓菴懈?縺吶ｋ繝??繝悶Ν縺ｫ繧ｳ繝斐?縺励∪縺吶?
889                    for( int i=0; i<clmSize; i++ ) {
890                            table.setDBColumn( i,tbl.getDBColumn( i ) );
891                    }
892                    // 縺吶∋縺ｦ縺ｮ繝??繧ｿ繧呈眠繝??繝悶Ν縺ｫ繧ｳ繝斐?縺励∪縺吶?
893                    for( int row=0; row<tbl.getRowCount(); row++ ) {
894                            String[] vals = new String[clmSize];
895                            System.arraycopy( tbl.getValues( row ),0,vals,0 ,clmSize );     // 繝??繧ｿ縺ｮ繧ｳ繝斐?
896                            table.addColumnValues( vals );
897                    }
898                    return table;
899            }
900    
901            /**
902             * 謖?ｮ壹?繝??繝悶Ν繧医ｊ縲√き繝ｩ繝??蜷阪↓蟇ｾ蠢懊☆繧九き繝ｩ繝?分蜿ｷ驟榊?繧剃ｽ懈?縺励∪縺吶?
903             *
904             * 繧ｫ繝ｩ繝?錐縺ｮCSV繝??繧ｿ縺?謖?ｮ壹＆繧後↑縺??蜷?clmcsv == null)縺ｯ縲?聞縺包ｼ舌?驟榊?繧定ｿ斐＠縺ｾ縺吶?
905             *
906             * @param       table   繝??繝悶Ν繝｢繝?Ν
907             * @param       clmcsv  繧ｫ繝ｩ繝?錐縺ｮCSV繝??繧ｿ
908             *
909             * @return      繧ｫ繝ｩ繝?錐縺ｫ蟇ｾ蠢懊☆繧九?蛻礼分蜿ｷ驟榊?(縺ｪ縺代ｌ縺ｰ縲?聞縺包ｼ宣?蛻?
910             */
911            private int[] makeColumnNo( final DBTableModel table,final String clmcsv ) {
912    
913                    // 繝槭せ繧ｿ繝??繝悶Ν縺ｮ蟾ｮ蛻?ｱ樊?縺ｮ繧ｫ繝ｩ繝?分蜿ｷ繧呈ｱゅａ縺ｾ縺吶?
914                    String[] clms = StringUtil.csv2Array( clmcsv );
915                    int[] clmNo = new int[clms.length];
916    
917                    // 繧ｫ繝ｩ繝?錐繧偵き繝ｩ繝?分蜿ｷ縺ｫ螟画鋤縺励∪縺吶?
918                    for( int i=0; i<clms.length; i++ ) {
919                            clmNo[i] = table.getColumnNo( clms[i] );
920                    }
921    
922                    return clmNo;
923            }
924    
925            /**
926             * 縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)縲?
927             *
928             * @og.tag
929             * 繧ｳ繝槭Φ繝峨?,HTML縺九ｉ(get/post)謖?ｮ壹＆繧後∪縺吶?縺ｧ,CMD_xxx 縺ｧ險ｭ螳壹＆繧後ｋ
930             * 繝輔ぅ繝ｼ繝ｫ繝牙ｮ壽焚蛟､縺ｮ縺?▼繧後°繧偵?謖?ｮ壹〒縺阪∪縺吶?
931             * 蛻晄悄蛟､縺ｯ NEW 縺ｧ縺吶?
932             *
933             * @param       cmd     繧ｳ繝槭Φ繝?public static final 螳｣險?＆繧後※縺?ｋ譁?ｭ怜?)
934             * @see         <a href="../../../../constant-values.html#org.opengion.hayabusa.taglib.TableMergeTag.CMD_NEW">繧ｳ繝槭Φ繝牙ｮ壽焚</a>
935             */
936            public void setCommand( final String cmd ) {
937                    String cmd2 = getRequestParameter( cmd );
938                    if( cmd2 != null && cmd2.length() > 0 ) { command = cmd2.toUpperCase(Locale.JAPAN); }
939            }
940    
941            /**
942             * 縲慎AG縲代い繧ｯ繧ｷ繝ｧ繝ｳ繧呈欠螳壹＠縺ｾ縺?UNION_ALL|UNION|INTERSECT|MINUS|DIFFERENCE|UNION_CLM|ADD_CLM|GROUP|UNION_SELROW)縲?
943             *
944             * @og.tag
945             * 謖?ｮ壹〒縺阪ｋ繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺ｯ縲∝?菴馴寔蜷?UNION_ALL)縲∝?菴馴寔蜷?謖ｿ蜈･菴咲ｽｮ謖?ｮ?(UNION_SELROW)縲∝柱髮?粋(UNION)
946             * 縲∫ｩ埼寔蜷?INTERSECT)縲∝ｷｮ髮?粋(MINUS)縲∝ｷｮ蛻?寔蜷?DIFFERENCE)縲∝?蜷域?(UNION_CLM)縲∝?霑ｽ蜉?ADD_CLM)縲?繧ｰ繝ｫ繝ｼ繝?GROUP)縺ｧ縺吶?
947             * 蛻怜粋謌舌→繧ｰ繝ｫ繝ｼ繝嶺ｻ･螟悶?蜃ｦ逅?〒縺ｯ縲√き繝ｩ繝??縺ｨ繧ｫ繝ｩ繝?焚縺ｯ蜷梧焚縺ｧ縺ｪ縺代ｌ縺ｰ縺ｪ繧翫∪縺帙ｓ縲?
948             * primaryKeys 繧?unionClms 縺ｪ縺ｩ縺ｮ謖?ｮ壹?繧ｭ繝ｼ蜷阪?縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｫ蟄伜惠縺吶ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
949             * 繝槭せ繧ｿ繝??繝悶Ν縺ｨ蜷後§繧ｫ繝ｩ繝?分蜿ｷ縺ｧ繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧医ｊ繝??繧ｿ繧定ｪｭ縺ｿ蜃ｺ縺励∪縺吶?
950             * (繧ｫ繝ｩ繝?錐繧?ｱ樊?縺ｯ縲∫焚縺ｪ縺｣縺ｦ繧ゅ°縺ｾ縺?∪縺帙ｓ縺後?繝槭せ繧ｿ繝??繝悶Ν縺ｫ貅匁侠縺励∪縺吶?)
951             * 縺ｾ縺溘?蜊倡峡(繝槭せ繧ｿ繝??繝悶Ν縺ｮ縺ｿ)縺ｧ縲∝柱髮?粋縺ｨ蜷檎ｭ峨?縲√げ繝ｫ繝ｼ繝?GROUP)繧剃ｽｿ逕ｨ縺吶ｋ縺ｨ縲∵欠螳壹?
952             * 繧ｫ繝ｩ繝?〒縺ｮ繝ｦ繝九?繧ｯ蛹悶ｒ陦後≧縺薙→縺悟庄閭ｽ縺ｫ縺ｪ繧翫∪縺吶?繧ｰ繝ｫ繝ｼ繝怜?逅?〒縺ｯ縲∝?陦悟━蜈医→縺励?
953             * ?貞屓逶ｮ縺ｫ迴ｾ繧後◆諠??繧貞炎髯､縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶?繧ｰ繝ｫ繝ｼ繝?縺梧欠螳壹＆繧後◆蝣ｴ蜷医?縲?
954             * 繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ辟｡隕悶＆繧後∪縺吶?縺?★繧後?蜃ｦ逅?↓縺翫＞縺ｦ繧ゅ?髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ縺ｧ
955             * 荳?率繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ縺ｾ縺吶?蜈ｨ菴馴寔蜷?UNION_ALL)縺ｧ蜃ｦ逅?☆繧句?蜷医〒繧ゅ?荳ｻ繧ｭ繝ｼ縺後Θ繝九?繧ｯ縺ｧ
956             * 縺ｪ縺??蜷医?縲√?繧ｹ繧ｿ繝ｼ縲√せ繝ｬ繝ｼ繝悶?蜷?ユ繝ｼ繝悶Ν縺ｧ荳?率繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ縺溷ｾ後〒縲√?繝ｼ繧ｸ縺輔ｌ縺ｾ縺吶?
957             * (繝槭?繧ｸ蠕後↓縺ｯ縲∝酔荳?ｸｻ繧ｭ繝ｼ繧呈戟縺､陦後?蟄伜惠縺励∪縺吶?)
958             * 蜈ｨ菴馴寔蜷?UNION_ALL)縺ｮ蝣ｴ蜷医?縺ｿ縲［ergeKeys 繧呈欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲ゅ◎縺ｮ蝣ｴ蜷医?縲?
959             * 繧ｭ繝ｼ縺ｪ縺励?縺溘ａ縲√?繧ｹ繧ｿ繝ｼ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繝??繝悶Ν繧貞腰縺ｫ蜷域?縺吶ｋ縺?￠縺ｫ縺ｪ繧翫∪縺吶?
960             *
961             * <table border="1" frame="box" rules="all" >
962             *   <caption>繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺ｮ隱ｬ譏?/caption>
963             *   <tr><th>action      </th><th>蜷咲ｧｰ    </th><th>蜃ｦ逅?ｦりｦ?                                                                                 </th><th>??/th><th>??/th><th>??/th><th>??/th><tr>
964             *   <tr><td>UNION_ALL   </td><td>蜈ｨ菴馴寔蜷?/td><td>繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶ｒ蜷域?
965             *   <tr><td>UNION_SELROW</td><td>蜈ｨ菴馴寔蜷?/td><td>繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶ｒ蜷域?(繝槭せ繧ｿ陦ｨ縺ｮ繝√ぉ繝?け陦後ｒ襍ｷ轤ｹ縺ｫ霑ｽ蜉?/td><td>笳?/td><td>縲?/td><td>縲?/td><td>縲?/td><tr>
966             *   <tr><td>UNION       </td><td>蜥碁寔蜷? </td><td>繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繝ｦ繝九?繧ｯ驛ｨ縺ｮ縺ｿ蜷域?                                   </td><td>笳?/td><td>笳?/td><td>縲?/td><td>縲?/td><tr>
967             *   <tr><td>INTERSECT   </td><td>遨埼寔蜷? </td><td>繝槭せ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繝ｦ繝九?繧ｯ驛ｨ縺御ｸ??縺吶ｋ繝槭せ繧ｿ縺ｮ縺ｿ驕ｸ謚?</td><td>笳?/td><td>笳?/td><td>縲?/td><td>縲?/td><tr>
968             *   <tr><td>MINUS       </td><td>蟾ｮ髮?粋  </td><td>繝槭せ繧ｿ縺九ｉ繧ｹ繝ｬ繝ｼ繝悶↓蟄伜惠縺吶ｋ繝ｦ繝九?繧ｯ驛ｨ繧貞炎髯､縺励◆谿九ｊ       </td><td>笳?/td><td>笳?/td><td>縲?/td><td>縲?/td><tr>
969             *   <tr><td>DIFFERENCE  </td><td>蟾ｮ蛻?寔蜷?/td><td>繝ｦ繝九?繧ｯ驛ｨ縺御ｸ??縺励?蟾ｮ蛻?き繝ｩ繝?′逡ｰ縺ｪ繧九?繧ｹ繧ｿ縺ｮ縺ｿ驕ｸ謚?</td><td>笳?/td><td>笳?/td><td>縲?/td><td>笳?/td><tr>
970             *   <tr><td>UNION_CLM   </td><td>蛻怜粋謌? </td><td>繝槭せ繧ｿ縺ｨ繧ｭ繝ｼ荳??縺吶ｋ繧ｹ繝ｬ繝ｼ繝悶?繧ｫ繝ｩ繝?ュ蝣ｱ繧定ｿｽ蜉?  </td><td>笳?/td><td>笳?/td><td>笳?/td><td>縲?/td><tr>
971             *   <tr><td>ADD_CLM     </td><td>蛻苓ｿｽ蜉? </td><td>UNION_CLM縺ｨ縺ｮ驕輔＞縺ｯ縲√き繝ｩ繝??縺ｿ霑ｽ蜉?☆繧九％縺ｨ縺ｧ縺吶?       </td><td>縲?/td><td>縲?/td><td>笳?/td><td>縲?/td><tr>
972             *   <tr><td>GROUP       </td><td>繧ｰ繝ｫ繝ｼ繝?/td><td>繝槭せ繧ｿ縺ｮ繝ｦ繝九?繧ｯ驛ｨ蛹?                                                           </td><td>縲?/td><td>縲?/td><td>縲?/td><td>縲?/td><tr>
973             * </table>
974             *
975             * 窶ｻ?壹?繧ｹ繧ｿ繝??繝悶Ν繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲∝ｸｸ縺ｫ蠢??
976             * ?托ｼ壹せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν繧ｪ繝悶ず繧ｧ繧ｯ繝亥ｿ??
977             * ?抵ｼ嗄asterKeys 螻樊?蠢??
978             * ?難ｼ嗽nionClms 螻樊?蠢??(繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ繧ｫ繝ｩ繝?錐縺ｾ縺溘?霑ｽ蜉?☆繧九き繝ｩ繝?錐)
979             * ?費ｼ單iffKeys 螻樊?蠢??(DIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐)縲［odifyClms 螻樊?菴ｿ逕ｨ蜿ｯ閭ｽ
980             *
981             * @param       action 繧｢繧ｯ繧ｷ繝ｧ繝ｳ(UNION_ALL|UNION|INTERSECT|MINUS|DIFFERENCE|UNION_CLM|ADD_CLM|GROUP|UNION_SELROW)
982             */
983            public void setAction( final String action ) {
984                    this.action = nval( getRequestParameter( action ),this.action );
985            }
986    
987            /**
988             * 縲慎AG縲大?蜉帛?縺ｮtableId繧呈欠螳壹＠縺ｾ縺?
989             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
990             *
991             * @og.tag
992             * 髮?粋蜃ｦ逅?ｵ先棡縺ｮ DBTableModel 繧偵Γ繝｢繝ｪ縺ｫ繧ｻ繝?ヨ縺吶ｋ蝣ｴ蜷医?繧ｭ繝ｼ(tableId)繧呈欠螳壹＠縺ｾ縺吶?
993             * (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
994             *
995             * @param       tableId 蜃ｺ蜉帛?縺ｮtableId
996             * @see         org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY
997             */
998            public void setTableId( final String tableId ) {
999                    this.tableId = nval( getRequestParameter( tableId ),this.tableId );
1000            }
1001    
1002            /**
1003             * 縲慎AG縲大?蜉帛?縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)縲?
1004             *
1005             * @og.tag
1006             * 髮?粋蜃ｦ逅?ｵ先棡縺ｮ DBTableModel 繧偵Γ繝｢繝ｪ縺ｫ繧ｻ繝?ヨ縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝励ｒ謖?ｮ壹＠縺ｾ縺吶?
1007             * 縺薙％縺ｧ縺ｯ縲√?繧ｹ繧ｿ繧?せ繝ｬ繝ｼ繝悶?繧ｹ繧ｳ繝ｼ繝苓ｨｭ螳壹′蠢?ｦ√↑轤ｺ縲《uper繧ｯ繝ｩ繧ｹ縺ｮ繝｡繧ｽ繝?ラ繧?
1008             * 繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｦ縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝亥?縺ｧ繧ｭ繝ｼ繝励＠縺ｦ縺?∪縺吶?
1009             * 蛻晄悄蛟､縺ｯ縲《ession 縺ｧ縺吶?
1010             *
1011             * @param       scope   蜃ｺ蜉帛?縺ｮscope
1012             */
1013            @Override
1014            public void setScope( final String scope ) {
1015                    this.scope = nval( getRequestParameter( scope ),this.scope );
1016            }
1017    
1018            /**
1019             * 縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮtableId繧呈欠螳壹＠縺ｾ縺?
1020             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
1021             *
1022             * @og.tag
1023             * 髮?粋蜃ｦ逅??繝槭せ繧ｿ縺ｨ縺ｪ繧?DBTableModel 繧偵Γ繝｢繝ｪ縺九ｉ蜿悶ｊ蜃ｺ縺吝?蜷医?繧ｭ繝ｼ(tableId)繧呈欠螳壹＠縺ｾ縺吶?
1024             * (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
1025             *
1026             * @param       masterTableId   繝槭せ繧ｿ繝??繝悶Ν縺ｮtableId
1027             * @see         org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY
1028             */
1029            public void setMasterTableId( final String masterTableId ) {
1030                    this.masterTableId = nval( getRequestParameter( masterTableId ),this.masterTableId );
1031            }
1032    
1033            /**
1034             * 縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)縲?
1035             *
1036             * @og.tag
1037             * 髮?粋蜃ｦ逅??繝槭せ繧ｿ縺ｨ縺ｪ繧?DBTableModel 繧偵Γ繝｢繝ｪ縺九ｉ蜿悶ｊ蜃ｺ縺吝?蜷医?繧ｹ繧ｳ繝ｼ繝励ｒ謖?ｮ壹＠縺ｾ縺吶?
1038             * 蛻晄悄蛟､縺ｯ縲《ession 縺ｧ縺吶?
1039             *
1040             * @param       masterScope     繝槭せ繧ｿ繝??繝悶Ν縺ｮscope
1041             */
1042            public void setMasterScope( final String masterScope ) {
1043                    this.masterScope = nval( getRequestParameter( masterScope ),this.masterScope );
1044            }
1045    
1046            /**
1047             * 縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
1048             *
1049             * @og.tag
1050             * 髮?粋蜃ｦ逅?ｒ陦後≧蝣ｴ蜷医?縲√き繝ｩ繝?錐繧偵?繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?CSV蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
1051             * 縺薙?繧ｭ繝ｼ縺ｮ邨?∩蜷医ｏ縺帙ｒ蜈?↓縲?寔蜷亥?逅??遯∝粋縺帙ｒ陦後＞縺ｾ縺吶?
1052             * 縺ｪ縺翫?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後げ繝ｫ繝ｼ繝?GROUP)莉･螟悶?蜃ｦ逅?〒縺ｯ縲√?繧ｹ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繧ｫ繝ｩ繝?焚縺ｨ
1053             * 荳ｦ縺ｳ鬆??縲∝酔縺倥〒縺ｪ縺代ｌ縺ｰ縺ｪ繧翫∪縺帙ｓ縲ゅき繝ｩ繝?錐縺ｯ縲∝推縲?挨縲?〒繧ゅ°縺ｾ縺?∪縺帙ｓ縲?
1054             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟?菴馴寔蜷?UNION_ALL)莉･螟悶?蝣ｴ蜷医?縲∝ｿ??螻樊?縺ｫ縺ｪ繧翫∪縺吶?
1055             *
1056             * @param       masterKeys      繝槭せ繧ｿ繝??繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繧辰SV蠖｢蠑上〒謖?ｮ?
1057             */
1058            public void setMasterKeys( final String masterKeys ) {
1059                    this.masterKeys = nval( getRequestParameter( masterKeys ),this.masterKeys );
1060            }
1061    
1062            /**
1063             * 縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ髮?粋蜃ｦ逅?ｒ陦後≧荳ｻ繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
1064             *
1065             * @og.tag
1066             * 髮?粋蜃ｦ逅?ｒ陦後≧蝣ｴ蜷医?縲√き繝ｩ繝?錐繧偵?繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?CSV蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
1067             * 縺薙?繧ｭ繝ｼ縺ｮ邨?∩蜷医ｏ縺帙ｒ蜈?↓縲?寔蜷亥?逅??遯∝粋縺帙ｒ陦後＞縺ｾ縺吶?
1068             * 縺ｪ縺翫?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後げ繝ｫ繝ｼ繝?GROUP)莉･螟悶?蜃ｦ逅?〒縺ｯ縲√?繧ｹ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?繧ｫ繝ｩ繝?焚縺ｨ
1069             * 荳ｦ縺ｳ鬆??縲∝酔縺倥〒縺ｪ縺代ｌ縺ｰ縺ｪ繧翫∪縺帙ｓ縲ゅき繝ｩ繝?錐縺ｯ縲∝推縲?挨縲?〒繧ゅ°縺ｾ縺?∪縺帙ｓ縲?
1070             * null 縺ｮ蝣ｴ蜷医?縲［asterKeys 縺ｨ蜷後§縺ｨ縺励∪縺吶?
1071             *
1072             * @param       slaveKeys       繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮ荳ｻ繧ｭ繝ｼ繧辰SV蠖｢蠑上〒謖?ｮ?
1073             */
1074            public void setSlaveKeys( final String slaveKeys ) {
1075                    this.slaveKeys = nval( getRequestParameter( slaveKeys ),this.slaveKeys );
1076            }
1077    
1078            /**
1079             * 縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮDIFFERENCE譎ゅ?蟾ｮ蛻?き繝ｩ繝?錐繧?CSV蠖｢蠑?謖?ｮ壹＠縺ｾ縺吶?
1080             *
1081             * @og.tag
1082             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟ｷｮ蛻??逅?DIFFERENCE)縺ｮ蝣ｴ蜷医↓縲∝ｷｮ蛻?メ繧ｧ繝?け繧定｡後≧繧ｫ繝ｩ繝?錐繧偵?
1083             * 繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?CSV蠖｢蠑?縺ｧ謖?ｮ壹＠縺ｾ縺吶?
1084             * 蟾ｮ蛻??逅?→縺ｯ縲［asterKeys 縺ｧ謖?ｮ壹＆繧後◆繧ｭ繝ｼ縺ｧ縺ｯ縲√?繧ｹ繧ｿ縲√せ繝ｬ繝ｼ繝悶→繧ゅ↓蟄伜惠縺?
1085             * 縺九▽縲√％縺ｮ繧ｭ繝ｼ(diffKeys)縺ｧ謖?ｮ壹＆繧後◆繧ｭ繝ｼ縺ｮ蛟､縺檎焚縺ｪ繧九?繧ｹ繧ｿ繝ｬ繧ｳ繝ｼ繝峨ｒ
1086             * 謚懊″蜃ｺ縺励∪縺吶?
1087             * 縺､縺ｾ繧翫?荳ｻ繧ｭ繝ｼ縺ｯ蟄伜惠縺励?螻樊?縺檎焚縺ｪ繧区ュ蝣ｱ縺ｮ繝斐ャ繧ｯ繧｢繝??縺ｫ縺ｪ繧翫∪縺吶?縺ｧ縲?
1088             * 繝??繧ｿ譖ｴ譁ｰ(UPDATE)蟇ｾ雎｡繧定ｦ九▽縺代ｋ蝣ｴ蜷医↓菴ｿ逕ｨ縺ｧ縺阪∪縺吶?
1089             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟ｷｮ蛻??逅?DIFFERENCE)縺ｮ蝣ｴ蜷医?縲∝ｿ??螻樊?縺ｫ縺ｪ繧翫∪縺吶?
1090             *
1091             * @param       diffKeys        繝槭せ繧ｿ繝??繝悶Ν縺ｮ蟾ｮ蛻?き繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ?
1092             * @see         #setMasterKeys( String )
1093             */
1094            public void setDiffKeys( final String diffKeys ) {
1095                    this.diffKeys = nval( getRequestParameter( diffKeys ),this.diffKeys );
1096            }
1097    
1098            /**
1099             * 縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮtableId繧呈欠螳壹＠縺ｾ縺?
1100             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
1101             *
1102             * @og.tag
1103             * 髮?粋蜃ｦ逅??繧ｹ繝ｬ繝ｼ繝悶→縺ｪ繧?DBTableModel 繧偵Γ繝｢繝ｪ縺九ｉ蜿悶ｊ蜃ｺ縺吝?蜷医?繧ｭ繝ｼ(tableId)繧呈欠螳壹＠縺ｾ縺吶?
1104             * 縺ｪ縺翫?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後げ繝ｫ繝ｼ繝?GROUP)縺ｮ蝣ｴ蜷医?縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
1105             * (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value HybsSystem#TBL_MDL_KEY}])縲?
1106             *
1107             * @param       slaveTableId    繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮtableId
1108             * @see         org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY
1109             */
1110            public void setSlaveTableId( final String slaveTableId ) {
1111                    this.slaveTableId = nval( getRequestParameter( slaveTableId ),this.slaveTableId );
1112            }
1113    
1114            /**
1115             * 縲慎AG縲代せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮscope繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)縲?
1116             *
1117             * @og.tag
1118             * 髮?粋蜃ｦ逅??繧ｹ繝ｬ繝ｼ繝悶→縺ｪ繧?DBTableModel 繧偵Γ繝｢繝ｪ縺九ｉ蜿悶ｊ蜃ｺ縺吝?蜷医?繧ｹ繧ｳ繝ｼ繝励ｒ謖?ｮ壹＠縺ｾ縺吶?
1119             * 縺ｪ縺翫?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後げ繝ｫ繝ｼ繝?GROUP)縺ｮ蝣ｴ蜷医?縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ菴ｿ逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
1120             * 蛻晄悄蛟､縺ｯ縲《ession 縺ｧ縺吶?
1121             *
1122             * @param       slaveScope      繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｮscope
1123             */
1124            public void setSlaveScope( final String slaveScope ) {
1125                    this.slaveScope = nval( getRequestParameter( slaveScope ),this.slaveScope );
1126            }
1127    
1128            /**
1129             * 縲慎AG縲代せ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ霑ｽ蜉?☆繧九き繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
1130             *
1131             * @og.tag
1132             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟?蜷域?(UNION_CLM)縺ｾ縺溘?蛻苓ｿｽ蜉?ADD_CLM)縺ｮ蝣ｴ蜷医↓菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
1133             * 蛻怜粋謌?UNION_CLM)縺ｯ縲√?繧ｹ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶?荳ｻ繧ｭ繝ｼ縺ｫ蟇ｾ縺励※縲√％縺薙〒謖?ｮ壹?繧ｹ繝ｬ繝ｼ繝悶?
1134             * 繧ｫ繝ｩ繝??蜷阪ｒ縲√?繧ｹ繧ｿ縺ｮ蛻励↓霑ｽ蜉?＠縺ｾ縺吶?荳ｻ繧ｭ繝ｼ縺後?繝?メ縺励↑縺?｡後↓髢｢縺励※縺ｯ縲?
1135             * 繧ｫ繝ｩ繝??蛻晄悄蛟､縺碁←逕ｨ縺輔ｌ縺溘ョ繝ｼ繧ｿ繧剃ｽ懈?縺励∪縺吶?
1136             * 蛻苓ｿｽ蜉?ADD_CLM)縺ｯ縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｫ謖?ｮ壹?繧ｫ繝ｩ繝?ｒ霑ｽ蜉?☆繧九□縺代〒縺吶?繧ｹ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｯ
1137             * 蜿ら?縺励∪縺帙ｓ縲ゅｈ縺｣縺ｦ縲∽ｸｻ繧ｭ繝ｼ繧よ欠螳壻ｸ崎ｦ√〒縺吶?
1138             *
1139             * @param       unionClms       蛻怜粋謌舌☆繧九き繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ?
1140             */
1141            public void setUnionClms( final String unionClms ) {
1142                    this.unionClms = nval( getRequestParameter( unionClms ),this.unionClms );
1143            }
1144    
1145            /**
1146             * 縲慎AG縲代せ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
1147             *
1148             * @og.tag
1149             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟ｷｮ蛻??逅?DIFFERENCE)縺ｮ蝣ｴ蜷医↓縲∫ｵ先棡縺ｫ繝槭せ繧ｿ繝??繝悶Ν縺梧栢縺榊?縺輔ｌ縺ｾ縺吶′縲?
1150             * 譖ｴ譁ｰ縺吶ｋ蝣ｴ蜷医↓縲√せ繝ｬ繝ｼ繝也音譛峨?繝ｦ繝九?繧ｯ繧ｭ繝ｼ(萓具ｼ啅NIQ)繧堤畑縺?※譖ｴ譁ｰ縺吶ｋ蝣ｴ蜷医?
1151             * 謖?ｮ壹?繧ｫ繝ｩ繝??縺ｯ縲√せ繝ｬ繝ｼ繝悶?蛟､縺ｫ繧ｻ繝?ヨ縺励※縺翫″縺溘＞蝣ｴ蜷医′縺ゅｊ縺ｾ縺吶?
1152             * 縺薙％縺ｧ縺ｯ縲∵欠螳壹?繧ｫ繝ｩ繝?↓縺､縺?※縲∝?縺?￠繧ｹ繝ｬ繝ｼ繝悶°繧峨?繧ｹ繧ｿ縺ｸ繧ｻ繝?ヨ縺励∪縺吶?
1153             * 縺ｪ縺翫?蛟､縺ｮ譖ｴ譁ｰ縺ｫ縺､縺?※縺ｯ縲√?繧ｹ繧ｿ縺ｨ繧ｹ繝ｬ繝ｼ繝悶′蜷御ｸ?く繝ｼ縺ｨ縺?≧蛻ｶ邏?′縺ゅｊ縺ｾ縺吶?
1154             *
1155             * @param       modifyClms      蛟､繧呈峩譁ｰ縺吶ｋ繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ?
1156             */
1157            public void setModifyClms( final String modifyClms ) {
1158                    this.modifyClms = nval( getRequestParameter( modifyClms ),this.modifyClms );
1159            }
1160    
1161            /**
1162             * 縲慎AG縲鷹寔蜷亥?逅?☆繧九→縺阪↓縲∫嶌驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
1163             *
1164             * @og.tag
1165             * masterKeys縺ｧ髮?粋蜃ｦ逅?☆繧九→縺阪↓縲??蟶ｸ縲∵怙蛻昴↓隕九▽縺九▲縺溯｡後ョ繝ｼ繧ｿ縺ｮ縺ｿ谿九ｊ縺ｾ縺吶′縲?
1166             * 縺薙％縺ｫ謖?ｮ壹＠縺溘き繝ｩ繝?↓縺､縺?※縺ｯ縲∫匱逕滄?蠎ｦ縲∬?蛻??霄ｫ縺ｮ諠??縺ｫ縲，SV蠖｢蠑上〒騾｣邨舌＠縺ｦ
1167             * 縺?″縺ｾ縺吶?
1168             * 縺薙?謫堺ｽ懊↓繧医ｊ縲∵悽譚･蜑企勁縺輔ｌ縺滓ュ蝣ｱ縺後??題｡後?CSV蠖｢蠑上〒蜿門ｾ励〒縺阪ｋ蜉ｹ譫懊′蠕励ｉ繧後∪縺吶?
1169             * 縺薙ｌ縺ｯ縲」alue 繧ｿ繧ｰ縺ｮ action="APPEND" 繧偵?DBTableModel 縺ｫ蟇ｾ縺励※螳滓命縺吶ｋ繧医≧縺ｪ諢溘§縺ｧ縺吶?
1170             *
1171             * @og.rev 5.1.4.0 (2010/03/01) 譁ｰ隕剰ｿｽ蜉?
1172             *
1173             * @param       groupAddClms    逶ｸ驕輔ョ繝ｼ繧ｿ繧辰SV騾｣邨舌＠縺ｦ谿九☆繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ?
1174             */
1175            public void setGroupAddClms( final String groupAddClms ) {
1176                    this.groupAddClms = nval( getRequestParameter( groupAddClms ),this.groupAddClms );
1177            }
1178    
1179            /**
1180             * 縲慎AG縲代ユ繝ｼ繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑縺ｮ譛臥┌[true:縺ｪ縺?false:縺ゅｋ]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false:縺ゅｋ)縲?
1181             *
1182             * @og.tag
1183             * 縺吶∋縺ｦ縺ｮ蜃ｦ逅?〒縲．BTableModel 縺ｫ蟇ｾ縺励※縲√Θ繝九?繧ｯ蛹悶ｄ繧ｰ繝ｫ繝ｼ繝怜喧縺ｪ縺ｩ縺ｮ髮?粋蜃ｦ逅?ｒ
1184             * 陦後≧驕守ｨ九〒縲√?繧ｹ繧ｿ繝??繝悶Ν縺ｫ蟇ｾ縺励※逶ｴ謗･蜃ｦ逅?ｒ陦後≧縺ｨ縲∝憶菴懃畑縺檎匱逕溘＠縺ｾ縺吶?
1185             * 蜷梧ｧ倥↓縲√せ繝ｬ繝ｼ繝悶ユ繝ｼ繝悶Ν縺ｫ縺翫＞縺ｦ繧ゅ?荳?率繧ｭ繝ｼ蛻励〒繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ繧九◆繧√?蜑ｯ菴懃畑縺?
1186             * 逋ｺ逕溘＠縺ｾ縺吶?縺薙ｌ縺ｯ縲∫┌鬧?↑繝｡繝｢繝ｪ鬆伜沺縺ｮ遒ｺ菫昴→縲√ユ繝ｼ繝悶Ν(繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝悶→繧?縺ｮ
1187             * 繧ｳ繝斐?蜃ｦ逅?凾髢薙?遽?ｴ?↓縺ｪ繧翫∪縺吶?蛻晄悄蛟､縺ｮ險ｭ螳壹ｂ蜑ｯ菴懃畑縺後≠繧狗憾諷九↓縺ｪ縺｣縺ｦ縺?∪縺吶?
1188             * 縺ｨ縺薙ｍ縺後?驛ｽ蜷医↓繧医▲縺ｦ縺ｯ縲∬牡縲?↑ action 繧帝?邯壹＠縺ｦ陦後＞縺溘＞蝣ｴ蜷医↑縺ｩ縲∵ｯ主屓縲?
1189             * 繝??繧ｿ繝吶?繧ｹ繧呈､懃ｴ｢縺吶ｋ繧医ｊ繧ゅΓ繝｢繝ｪ荳翫〒繧ｳ繝斐?縺励◆縺ｻ縺?′驛ｽ蜷医′繧医＞繧ｱ繝ｼ繧ｹ縺ｧ縺ｯ縲?
1190             * 蜑ｯ菴懃畑縺悟?縺ｪ縺?ｈ縺?↓縲］oSideEffect="true" 縺ｫ險ｭ螳壹＠縺ｾ縺吶?
1191             * 縺溘□縺励?繝槭せ繧ｿ縲√せ繝ｬ繝ｼ繝悶→繧ゅユ繝ｼ繝悶Ν繧偵さ繝斐?繧定｡後＞縲∫ｵ先棡縺ｮ繝??繝悶Ν繧よｴｾ逕溘☆繧狗ぜ縲?
1192             * 騾壼ｸｸ縲?ｼ偵▽縺ｮ鬆伜沺(繝槭せ繧ｿ縺ｨ邨先棡縺ｯ蜷後§繝??繝悶Ν縺ｫ譖ｸ縺九ｌ繧?縺ｧ濶ｯ縺?園繧偵??輔▽縺ｮ鬆伜沺縺?
1193             * 菴懈?縺輔ｌ縺ｾ縺吶?
1194             * 蛻晄悄蛟､縺ｯ縲∝憶菴懃畑縺後≠繧?noSideEffect="false")縺ｧ縺吶?
1195             *
1196             * @param       noSideEffect    繝??繝悶Ν繝｢繝?Ν縺ｫ蟇ｾ縺吶ｋ蜑ｯ菴懃畑 [true:縺ｪ縺?false:縺ゅｋ]
1197             */
1198            public void setNoSideEffect( final String noSideEffect ) {
1199                    this.noSideEffect = nval( getRequestParameter( noSideEffect ),this.noSideEffect );
1200            }
1201    
1202            /**
1203             * 縲慎AG縲大ｷｮ蛻??繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧堤ｵ先棡繝??繝悶Ν縺ｫ霑ｽ蜉?☆繧九°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
1204             *
1205             * @og.tag
1206             * 繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺悟ｷｮ蛻??逅?DIFFERENCE)縺ｮ蝣ｴ蜷医↓縲∫ｵ先棡縺ｫ繝槭せ繧ｿ繝??繝悶Ν縺梧栢縺榊?縺輔ｌ縺ｾ縺吶′縲?
1207             * 蟾ｮ蛻?ｯｾ雎｡縺ｮ繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ縺ｨ豈碑ｼ?＠縺溘＞蝣ｴ蜷医′縺ゅｊ縺ｾ縺吶?
1208             * 縺薙?繝輔Λ繧ｰ繧?true 縺ｫ繧ｻ繝?ヨ縺吶ｋ縺ｨ縲∵嶌霎ｼ縺ｿ遖∵ｭ｢螻樊?縺御ｻ倥＞縺溽憾諷九〒縲√せ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ縺?
1209             * 邨先棡繝??繝悶Ν縺ｫ霑ｽ蜉?＆繧後∪縺吶?
1210             * 縺ｪ縺翫?縺薙?蜃ｦ逅?〒縺ｯ縲??蟶ｸ縺ｨ逡ｰ縺ｪ繧翫?繝槭せ繧ｿ繝??繝悶Ν縺ｫ縺ｯ繧ｰ繝ｫ繝ｼ繝怜喧縺ｮ蜑ｯ菴懃畑縺ｯ逋ｺ逕溘＠縺ｾ縺吶′縲?
1211             * 邨先棡繝??繝悶Ν縺ｯ譁ｰ隕上↓菴懈?縺輔ｌ縲∝?鬆ｭ陦後↓蠢?★ WRITABLE 繧ｫ繝ｩ繝?′莉伜刈縺輔ｌ縺ｾ縺吶?
1212             * 蛻晄悄蛟､縺ｯ縲》rue?夊ｿｽ蜉?☆繧?縺ｧ縺吶?
1213             *
1214             * @param       flag    繧ｹ繝ｬ繝ｼ繝悶ョ繝ｼ繧ｿ繧堤ｵ先棡繝??繝悶Ν縺ｫ霑ｽ蜉?☆繧九°縺ｩ縺?°(蛻晄悄蛟､:true)
1215             */
1216            public void setUseDiffData( final String flag ) {
1217                    useDiffData = nval( getRequestParameter( flag ),useDiffData );
1218            }
1219    
1220            /**
1221             * 縲慎AG縲代?繧ｹ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
1222             *
1223             * @og.tag
1224             * 蜃ｦ逅?ｯｾ雎｡縺ｮ繝槭せ繧ｿ繝??繝悶Ν縺ｫ縺､縺?※縲?∈謚櫁｡後′謖?ｮ壹＆繧後◆蝣ｴ蜷医↓縲?∈謚櫁｡後?縺ｿ繧貞?逅?ｯｾ雎｡縺ｫ
1225             * 縺吶ｋ縺九?蜈ｨ莉ｶ繧貞ｯｾ雎｡縺ｫ縺吶ｋ縺九ｒ謖?ｮ壹＠縺ｾ縺吶?
1226             * 遨埼寔蜷医ｄ蟾ｮ蛻?寔蜷医↑縺ｩ騾壼ｸｸ縺ｯ縲∝?莉ｶ繧貞ｯｾ雎｡縺ｫ縺吶ｋ縺薙→縺ｫ縺ｪ繧翫∪縺吶′縲∝?蜷域?繧??霑ｽ蜉?↑縺ｩ縲?
1227             * 繝槭せ繧ｿ繝??繝悶Ν縺ｫ蟇ｾ縺励※縺ｮ縺ｿ菴懃畑繧貞所縺ｼ縺吝?逅?〒縺ｯ縲?∈謚櫁｡後?縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧莠九′
1228             * 閠?∴繧峨ｌ縺ｾ縺吶?縺昴?蝣ｴ蜷医?蛻晄悄繧ｰ繝ｫ繝ｼ繝怜喧縺ｨ蜷後§縺ｧ縲∝ｯｾ雎｡縺ｨ縺吶ｋ陦後′驕ｸ謚櫁｡後?縺ｿ縺ｫ縺ｪ繧翫∪縺吶?
1229             * 蛻晄悄蛟､縺ｯ縲’alse?壼?莉ｶ蟇ｾ雎｡ 縺ｧ縺吶?
1230             *
1231             * @param       flag    繝槭せ繧ｿ繝??繝悶Ν縺ｮ驕ｸ謚櫁｡後?繝??繧ｿ縺ｮ縺ｿ繧貞ｯｾ雎｡縺ｫ蜃ｦ逅?ｒ陦後≧縺九←縺?°(蛻晄悄蛟､:false)
1232             */
1233            public void setUseCheckOnly( final String flag ) {
1234                    useCheckOnly = nval( getRequestParameter( flag ),useCheckOnly );
1235            }
1236    
1237            /**
1238             * 縲慎AG縲代?繝ｼ繧ｸ縺ｮ邨先棡繧定｡ｨ遉ｺ縺吶ｋ縺九←縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:true)縲?
1239             *
1240             * @og.tag
1241             * true 縺ｧ縲√?繝ｼ繧ｸ邨先棡繧定｡ｨ遉ｺ縺励∪縺吶? false 縺ｧ縺ｯ縲∽ｽ輔ｂ陦ｨ遉ｺ縺励∪縺帙ｓ(蛻晄悄蛟､:true)
1242             * 繝槭せ繧ｿ繝??繝悶Ν縺ｮ莉ｶ謨ｰ縺ｯ縲??蟶ｸ縲√く繝ｼ縺ｧ繧ｰ繝ｫ繝ｼ繝怜喧縺輔ｌ繧九◆繧√?蜈･蜉帑ｻｶ謨ｰ縺ｨ逡ｰ縺ｪ繧翫∪縺吶?
1243             * 蜷梧ｧ倥↓縲√せ繝ｬ繝ｼ繝紋ｻｶ謨ｰ繧ら焚縺ｪ繧翫∪縺吶?邨先棡縺ｮ莉ｶ謨ｰ縺ｯ縲∝?逅?ｵ先棡縺檎樟螳溽噪縺九←縺?°縺ｮ
1244             * 蛻､譁ｭ縺ｫ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
1245             * 蛻晄悄蛟､縺ｯ縲》rue?夊｡ｨ遉ｺ縺吶ｋ 縺ｧ縺吶?
1246             *
1247             * @param       flag    謗･邯壹?邨先棡繧定｡ｨ遉ｺ縺吶ｋ縺九←縺?°(蛻晄悄蛟､:false)
1248             */
1249            public void setDisplay( final String flag ) {
1250                    display = nval( getRequestParameter( flag ),display );
1251            }
1252    
1253            /**
1254             * 縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
1255             *
1256             * @og.tag
1257             * 縺薙?蛟､縺ｯ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅?↓蠖ｱ髻ｿ縺励∪縺吶?縺薙?蛟､縺荊rue縺ｫ謖?ｮ壹＆繧後◆譎ゅ↓commit縺輔ｌ縺櫂BTableModel縺?
1258             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨?蟇ｾ雎｡縺ｮ陦ｨ縺ｫ縺ｪ繧翫∪縺吶?
1259             *
1260             * 縺薙?繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｯ縲??蟶ｸ縲∝推繧ｿ繧ｰ縺ｫ繧医ｊ螳溯｣?＆繧後?繝ｦ繝ｼ繧ｶ繝ｼ縺梧欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲?
1261             * 菴?＠縲?縺､縺ｮJSP蜀?〒DBTableModel縺瑚､?焚逕滓?縺輔ｌ繧句?蜷医↓縲∝燕縺ｫ蜃ｦ逅?＠縺櫂BTableModel縺ｫ縺､縺?※繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨ｒ縺輔○縺溘＞
1262             * 蝣ｴ蜷医?縲∝ｾ後ｍ縺ｧDBTableModel繧堤函謌舌☆繧九ち繧ｰ縺ｧ縲∵?遉ｺ逧?↓縺薙?蛟､繧断alse縺ｫ謖?ｮ壹☆繧九％縺ｨ縺ｧ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅??蟇ｾ雎｡縺九ｉ
1263             * 髯､螟悶☆繧九％縺ｨ縺後〒縺阪∪縺吶?
1264             *
1265             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
1266             *
1267             * @param  flag 繝｡繧､繝ｳ繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ縺九←縺?°
1268             */
1269            public void setMainTrans( final String flag ) {
1270                    isMainTrans = nval( getRequestParameter( flag ),isMainTrans );
1271            }
1272    
1273            /**
1274             * 縲慎AG縲組roupAddClms縺ｧ譁?ｭ怜?繧帝?邨舌☆繧矩?逶ｮ蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:",")縲?
1275             *
1276             * @og.tag
1277             * groupAddClms縺ｧ譁?ｭ怜?繧帝?邨舌☆繧矩?逶ｮ蛹ｺ蛻?ｊ譁?ｭ励ｒ繧ｻ繝?ヨ縺励∪縺?蛻晄悄蛟､:",")縲?
1278             * 蛻晄悄蛟､縺ｯ縲?," 縺ｫ險ｭ螳壹＆繧後※縺?∪縺吶?
1279             *
1280             * @og.rev 5.3.1.0 (2011/01/01)
1281             *
1282             * @param   sepa        鬆?岼蛹ｺ蛻?ｊ譁?ｭ?蛻晄悄蛟､:",")
1283             */
1284            public void setSeparator( final String sepa ) {
1285                    separator = nval( getRequestParameter( sepa ),separator );
1286            }
1287    
1288            /**
1289             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
1290             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
1291             *
1292             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
1293             */
1294            @Override
1295            public String toString() {
1296                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
1297                                    .println( "VERSION"                     ,VERSION                )
1298                                    .println( "action"                      ,action                 )
1299                                    .println( "tableId"                     ,tableId                )
1300                                    .println( "scope"                       ,scope                  )
1301                                    .println( "masterTableId"       ,masterTableId  )
1302                                    .println( "masterScope"         ,masterScope    )
1303                                    .println( "slaveTableId"        ,slaveTableId   )
1304                                    .println( "slaveScope"          ,slaveScope             )
1305                                    .println( "masterKeys"          ,masterKeys             )
1306                                    .println( "diffKeys"            ,diffKeys               )
1307                                    .println( "unionClms"           ,unionClms              )
1308                                    .println( "modifyClms"          ,modifyClms             )
1309                                    .println( "noSideEffect"        ,noSideEffect   )
1310                                    .println( "useDiffData"         ,useDiffData    )
1311                                    .println( "useCheckOnly"        ,useCheckOnly   )
1312                                    .println( "display"                     ,display                )
1313                                    .println( "ACTION_LIST"         ,ACTION_LIST    )
1314                                    .println( "Other..."    ,getAttributes().getAttribute() )
1315                                    .fixForm().toString() ;
1316            }
1317    }