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.DBTableModel;
021    import org.opengion.fukurou.db.DBUtil;
022    
023    import org.opengion.fukurou.util.ErrorMessage;
024    import org.opengion.fukurou.util.StringUtil ;
025    import static org.opengion.fukurou.util.StringUtil.nval ;
026    import org.opengion.fukurou.model.Formatter;
027    
028    import java.util.Locale ;
029    import java.util.List ;
030    import java.util.ArrayList ;
031    
032    import java.io.ObjectOutputStream;
033    import java.io.ObjectInputStream;
034    import java.io.IOException;
035    
036    /**
037     * 縲仙ｻ?ｭ｢縲醍匳骭ｲ縺吶∋縺阪ョ繝ｼ繧ｿ縺ｮ繝槭せ繧ｿ蟄伜惠繝√ぉ繝?け繧定｡後≧縺溘ａ縺ｮ繧ｿ繧ｰ縺ｧ縺?騾壼ｸｸ縺ｯentry.jsp縺ｧupdate繧ｿ繧ｰ縺ｮ逶ｴ蜑阪〒菴ｿ逕ｨ縺励∪縺?縲?
038     *
039     * 縺薙?隕∫ｴ??蜀?ｮｹ縺ｫ縲ヾQL譁?ｒ險倩ｿｰ縺励∪縺吶?
040     * names 縺ｫ蟇ｾ蠢懊☆繧九き繝ｩ繝?錐繧偵?繧ｫ繝ｳ繝槫玄蛻?ｊ縺ｧ隍?焚荳弱∴縺ｾ縺吶?縺昴?蛟､繧偵?DBTableModel
041     * 繧医ｊ縲∝叙蠕励＠縲∝?縺ｮSQL譁?? ? 縺ｫ蛟､繧定ｨｭ螳壹＠縺ｾ縺吶?
042     * 縺ｾ縺溘?縲∝ｼ墓焚驛ｨ縺ｫ縲ー繧ｫ繝ｩ繝?錐]繧堤畑縺?◆Hybs諡｡蠑ｵSQL譁?ｒ謖?ｮ壹☆繧九％縺ｨ繧ょ庄閭ｽ縺ｧ縺吶?
043     *
044     * 蛟､縺ｮ蜿門ｾ励?縲∝?縺ｫ驕ｸ謚槭＆繧後◆陦後?縺ｿ縺ｫ縺､縺?※縲∝ｮ溯｡後＆繧後∪縺吶?
045     * exist 螻樊?縺ｫ謖?ｮ壹＆繧後◆ 縲?ｽ｢true:蟄伜惠縺吶ｋ?｣縲?ｽ｢false:蟄伜惠縺励↑縺?ｽ｣縲?ｽ｢one:縺ｲ縺ｨ縺､莉･荳具ｽ｣縲?
046     * 縺ｮ蛟､縺ｯ縲√メ繧ｧ繝?け譁ｹ豕輔ｒ險ｭ螳壹＠縺ｦ縺?∪縺吶?
047     * 縺?★繧後?蝣ｴ蜷医ｂ縲∵?遶区凾縺ｯ縲∵ｭ｣蟶ｸ縺ｨ縺ｿ縺ｪ縺励∪縺吶?
048     * (?｢true:蟄伜惠縺吶ｋ?｣ 縺ｫ縺ｯ縲√ョ繝ｼ繧ｿ縺悟ｭ伜惠縺励◆蝣ｴ蜷医↓縲?ｼｯ?ｫ縺ｧ縲√↑縺代ｌ縺ｰ繧ｨ繝ｩ繝ｼ縺ｧ縺吶?)
049     *
050     * @og.formSample
051     * 笳丞ｽ｢蠑擾ｼ?
052     *       繝ｻ&lt;og:tableExist
053     *                    command   = "{&#064;command}"
054     *                    names     = "[窶ｦ]"
055     *                    from      = "窶ｦ"                           蠢??
056     *                    where     = "窶ｦ"                           蠢??
057     *                    exist     = "[auto|true|false|one|notuse]" 蠢??
058     *                    errRemove = "[true|false]"
059     *         /&gt;
060     *
061     * 笳獣ody?壹↑縺?
062     *
063     * 笳週ag螳夂ｾｩ??
064     *   &lt;og:tableExist
065     *       command            縲仙ｻ?ｭ｢縲代さ繝槭Φ繝?ENTRY)繧偵そ繝?ヨ縺励∪縺?
066     *       scope              縲慎AG縲代く繝｣繝?す繝･縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝夕request/page/session/applicaton]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
067     *       names              縲仙ｻ?ｭ｢縲大ｼ墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ(繧ｫ繝ｩ繝?錐)繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺?
068     *       from             笳九?蟒?ｭ｢縲代メ繧ｧ繝?け縺吶ｋ繝??繧ｿ繝吶?繧ｹ蜷?from 蜿･)繧呈欠螳壹＠縺ｾ縺?蠢??)縲?
069     *       where            笳九?蟒?ｭ｢縲代メ繧ｧ繝?け縺吶ｋ讀懃ｴ｢譚｡莉ｶ(where蜿･)繧呈欠螳壹＠縺ｾ縺?蠢??)縲?
070     *       exist              縲仙ｻ?ｭ｢縲代ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｮ繝√ぉ繝?け譁ｹ豕?auto/true/false/one/notuse)繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:?｢auto:閾ｪ蜍包ｽ｣)
071     *       tableId            縲仙ｻ?ｭ｢縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡繧奪BTableModel縺ｫ譖ｸ縺崎ｾｼ繧薙〒縲《ession縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
072     *       dbid               縲仙ｻ?ｭ｢縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺?
073     *       errRemove          縲仙ｻ?ｭ｢縲代お繝ｩ繝ｼ譎ゅ?驕ｸ謚櫁｡後ｒ蜿悶ｊ髯､縺?※邯咏ｶ壼?逅?ｒ陦後≧縺九←縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
074     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
075     *   /&gt;
076     *
077     * 笳丈ｽｿ逕ｨ萓?
078     *       繝ｻ&lt;og:tableExist
079     *                    command = "{&#064;command}"
080     *                    names   = "USERID,SYSTEM_ID"
081     *                    from    = "GE10"
082     *                    where   = "USERID=? AND SYSTEM_ID=?"
083     *                    exist   = "true"         /&gt;
084     *
085     *          繝ｻwhere 譚｡莉ｶ縺ｮ ? 譁?ｭ励↓縲］ames 縺ｧ謖?ｮ壹＠縺溘き繝ｩ繝?錐縺ｮ蛟､縺後?DBTableModel繧医ｊ
086     *            蜿門ｾ励＆繧後∪縺吶?
087     *            蛟､縺ｮ蜿門ｾ励?縲∝?縺ｫ驕ｸ謚槭＆繧後◆陦後?縺ｿ縺ｫ縺､縺?※縲∝ｮ溯｡後＆繧後∪縺吶?
088     *          繝ｻexist 螻樊?縺ｮ蛟､縺ｫ蠢懊§縺ｦ縲√メ繧ｧ繝?け譁ｹ豕輔′逡ｰ縺ｪ繧翫∪縺吶?
089     *            auto , true , false , one , notuse 縺梧欠螳壹〒縺阪∪縺吶?
090     *          繝ｻ繝??繝悶Ν縺ｯ縲?ｼ代▽縺ｮ縺ｿ謖?ｮ壹〒縺阪∪縺吶?隍?焚謖?ｮ壹ｄ縲ゞNION縺ｧ邨仙粋縺吶ｋ蝣ｴ蜷医?縲?
091     *            繝薙Η繝ｼ遲峨ｒ菴懈?縺励※蟇ｾ蠢懊＠縺ｦ縺上□縺輔＞縲?
092     *
093     *       繝ｻ&lt;og:tableExist
094     *                    command = "{&#064;command}"
095     *                    from    = "GE10"
096     *                    where   = "USERID=[USERID] AND SYSTEM_ID=[SYSTEM_ID]"  /&gt;
097     *
098     *          繝ｻwhere 譚｡莉ｶ縺ｮ [繧ｫ繝ｩ繝?錐] 譁?ｭ励↓縲．BTableModel繧医ｊ蛟､縺後そ繝?ヨ縺輔ｌ縺ｾ縺吶?
099     *          繝ｻexist 縺ｯ縲∝?譛溷?(auto)縺ｫ縺ｪ繧翫∪縺吶?蜀?Κ縺ｮA,C,D縺ｫ蠢懊§縺ｦ閾ｪ蜍募愛蛻･縺励∪縺吶?
100     *
101     * @og.rev 3.5.0.0 (2003/09/17) 譁ｰ隕丈ｽ懈?
102     * @og.group (蟒?ｭ｢)?､?｢逋ｻ骭ｲ
103     *
104     * @version  4.0
105     * @author       Kazuhiko Hasegawa
106     * @since    JDK5.0,
107     * @deprecated 莉｣繧上ｊ縺ｫ dataCheck繧ｿ繧ｰ繧剃ｽｿ逕ｨ縺励※縺上□縺輔＞
108     */
109    @Deprecated public class TableExistTag extends CommonTagSupport {
110            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
111            private static final String VERSION = "4.0.0.0 (2007/11/28)" ;
112    
113            private static final long serialVersionUID = 400020071128L ;
114    
115            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 繧ｨ繝ｳ繝医Μ繝ｼ {@value} */
116            public static final String CMD_ENTRY   = "ENTRY" ;
117    
118            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
119            private static final String COMMAND_LIST = CMD_ENTRY;
120    
121            // 3.5.6.0 (2004/06/18) 縺吶∋縺ｦ繧?protected 縺九ｉ private 縺ｫ螟画峩縺励∪縺吶?
122            private transient DBTableModel  table           = null;
123            private transient ErrorMessage  errMessage      = null;
124            private String                  tableId         = HybsSystem.TBL_MDL_KEY;
125            // 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
126    //      private String                  dbid            = "DEFAULT";
127            private String                  dbid            = null;
128            private String                  command         = CMD_ENTRY;
129            private String                  sql                     = null;
130            private String                  names           = null;
131            private String                  from            = null;
132            private String                  where           = null;
133            private String                  exist           = "auto";
134            private boolean                 errRemove       = false;
135    
136            /**
137             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
138             *
139             * @og.rev 3.7.1.0 (2005/04/15) notuse 蛟､繧定ｿｽ蜉?
140             *
141             * @return      蠕檎ｶ壼?逅??謖?､ｺ(SKIP_BODY)
142             */
143            @Override
144            public int doStartTag() {
145                    if( !exist.equalsIgnoreCase( "notuse" ) ) {
146                            table = (DBTableModel)getObject( tableId );
147                            if( table != null && table.getRowCount() > 0 && check( command, COMMAND_LIST ) ) {
148                                    sql = makeSQLString();
149                                    execute( sql );
150                            }
151                    }
152    
153                    return(SKIP_BODY);                              // Body 繧定ｩ穂ｾ｡縺励↑縺?
154            }
155    
156            /**
157             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
158             *
159             * @og.rev 3.5.4.2 (2003/12/15) HTMLTableViewForm 繧ｯ繝ｩ繧ｹ蜷榊､画峩(竍?ViewForm_HTMLTable)
160             * @og.rev 3.5.4.4 (2004/01/16) 繧ｨ繝ｩ繝ｼ邨先棡繧定｡ｨ遉ｺ縺吶ｋ繝??繝悶Ν蠖｢蠑上?繝輔か繝ｼ繝?ｿｮ豁｣
161             * @og.rev 3.5.5.2 (2004/04/02) TaglibUtil.makeHTMLErrorTable 繝｡繧ｽ繝?ラ繧貞茜逕ｨ
162             *
163             * @return      蠕檎ｶ壼?逅??謖?､ｺ
164             */
165            @Override
166            public int doEndTag() {
167                    debugPrint();           // 4.0.0 (2005/02/28)
168    
169                    int rtnCode = EVAL_PAGE;
170    
171                    if( CMD_ENTRY.equals( command ) && errMessage != null && ! errMessage.isOK() ) {
172                    // 3.5.5.2 (2004/04/02) TaglibUtil.makeHTMLErrorTable 繝｡繧ｽ繝?ラ繧貞茜逕ｨ
173                            if( !errRemove ) {
174                                    rtnCode = SKIP_PAGE ;
175                                    jspPrint( TaglibUtil.makeHTMLErrorTable( errMessage,getResource() ) );
176                            }
177                    }
178    
179                    return( rtnCode );
180            }
181    
182            /**
183             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
184             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
185             *
186             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
187             */
188            @Override
189            protected void release2() {
190                    super.release2();
191                    tableId                 = HybsSystem.TBL_MDL_KEY;
192    //              dbid                    = "DEFAULT";
193                    dbid                    = null;
194                    command                 = CMD_ENTRY;
195                    table                   = null;
196                    sql                             = null;
197                    names                   = null;
198                    errMessage              = null;
199                    exist                   = "auto";
200                    errRemove               = false;
201            }
202    
203            /**
204             * SQL譁?ｒ讒狗ｯ峨＠縺ｾ縺吶?
205             *
206             * @return 讒狗ｯ峨＆繧後◆縲ヾQL譁?
207             */
208            private String makeSQLString() {
209                    StringBuilder rtn = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
210                    rtn.append( "select count(*) from " );
211                    rtn.append( from );
212                    rtn.append( " where " );
213                    rtn.append( where );
214    
215                    return rtn.toString();
216            }
217    
218            /**
219             * Query 繧貞ｮ溯｡後＠縺ｾ縺吶?
220             *
221             * @param   sql 讀懃ｴ｢譁?ｭ怜?
222             *
223             * @og.rev 3.8.6.0 (2006/09/29) exist 螻樊?縺ｮ one 繧??｢one:縺ｲ縺ｨ縺､縺ｮ縺ｿ?｣縺九ｉ?｢one:縺ｲ縺ｨ縺､莉･荳具ｽ｣縺ｫ螟画峩
224             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
225             * @og.rev 4.0.0.0 (2005/01/31) getParameterRows() 繧剃ｽｿ逕ｨ縺吶ｋ繧医≧縺ｫ螟画峩
226             * @og.rev 4.0.0.0 (2007/11/28) 隲也炊蜃ｦ逅??荳榊?蜷井ｿｮ豁｣(繧ｫ繝?さ縺ｮ莉倥￠繧倶ｽ咲ｽｮ髢馴＆縺?
227             */
228            private void execute( final String sql ) {
229                    errMessage = new ErrorMessage( "Database Exist Data Error!" );
230    
231                    final String query ;
232                    final int[]  clmNo ;
233    
234                    int[] rowNo = getParameterRows();               // 4.0.0 (2005/01/31)
235                    if( rowNo.length == 0 ) { return; }
236    
237                    // names 縺ｪ縺励?蝣ｴ蜷医?縲＿uery 繧医ｊ蜿門ｾ励☆繧九?  4.0.0 (2005/01/31)
238                    if( names == null ) {
239    //                      QueryForm form = new QueryForm( sql,table );
240    //                      clmNo = form.getColumnNos();
241    //                      query = form.getStatement();
242    //                      names = StringUtil.array2csv( form.getColumnNames() );
243    
244                            Formatter format = new Formatter( table );
245                            format.setFormat( sql );
246                            query = format.getQueryFormatString();
247                            clmNo = format.getClmNos();
248                            names = StringUtil.array2csv( table.getNames() );
249                    }
250                    else {
251                            clmNo = getTableColumnNo( StringUtil.csv2Array( names ) );
252                            query = sql;
253                    }
254    
255                    int row;
256                    boolean okFlag ;
257                    List<Integer> list = new ArrayList<Integer>();
258                    String[] values ;
259                    for( int j=0; j<rowNo.length; j++ ) {
260                            okFlag = true;
261                            row = rowNo[j];
262                            values = getTableModelData( clmNo,row );
263                            int cnt = DBUtil.dbExist( query,values,getApplicationInfo(),dbid );
264    
265                            String modifyType = table.getModifyType( row );
266                            if( ( exist.equalsIgnoreCase( "true" ) ||
267                                    ( exist.equalsIgnoreCase( "auto" ) && (
268                                                    DBTableModel.UPDATE_TYPE.equals( modifyType ) ||
269                                                    DBTableModel.DELETE_TYPE.equals( modifyType ) ) ) ) && cnt <= 0 ) {
270                                    // ERR0025=繝??繧ｿ譛ｪ逋ｻ骭ｲ繧ｨ繝ｩ繝ｼ縲ゅく繝ｼ={0}縲∝?={1} 縺ｮ繝??繧ｿ縺ｯ縲∝ｭ伜惠縺励※縺?∪縺帙ｓ縲?
271                                    String vals = StringUtil.array2csv( values );
272                                    errMessage.addMessage( row,ErrorMessage.NG,"ERR0025",names,vals );
273                                    okFlag = false;
274                            }
275                            // 4.0.0.0 (2007/11/28) 隲也炊蜃ｦ逅??荳榊?蜷井ｿｮ豁｣(繧ｫ繝?さ縺ｮ莉倥￠繧倶ｽ咲ｽｮ髢馴＆縺?
276                            else if( ( exist.equalsIgnoreCase( "false" ) ||
277                                             ( exist.equalsIgnoreCase( "auto" ) &&
278                                                            DBTableModel.INSERT_TYPE.equals( modifyType ) ) ) && cnt > 0 ) {
279                                    // ERR0026=繝??繧ｿ逋ｻ骭ｲ貂医∩繧ｨ繝ｩ繝ｼ縲ゅく繝ｼ={0}縲∝?={1} 縺ｮ繝??繧ｿ縺ｯ縲√☆縺ｧ縺ｫ蟄伜惠縺励※縺?∪縺吶?
280                                    String vals = StringUtil.array2csv( values );
281                                    errMessage.addMessage( row,ErrorMessage.NG,"ERR0026",names,vals );
282                                    okFlag = false;
283                            }
284                            else if( exist.equalsIgnoreCase( "one" ) && cnt > 1 ) {
285                                    // ERR0027=繝??繧ｿ?帝㍾逋ｻ骭ｲ繧ｨ繝ｩ繝ｼ縲ゅく繝ｼ={0}縲∝?={1} 縺ｮ繝??繧ｿ縺ｯ縲?㍾隍?＠縺ｦ蟄伜惠縺励※縺?∪縺吶?
286                                    String vals = StringUtil.array2csv( values );
287                                    errMessage.addMessage( row,ErrorMessage.NG,"ERR0027",names,vals );
288                                    okFlag = false;
289                            }
290                            if( errRemove && okFlag ) { list.add( row ); }
291                    }
292                    if( errRemove ) {
293                            Integer[] in = list.toArray( new Integer[list.size()] );
294                            int[] newRowNo = new int[in.length];
295                            for( int i=0; i<in.length; i++ ) {
296                                    newRowNo[i] = in[i].intValue();
297                            }
298                            setParameterRows( newRowNo );
299                    }
300            }
301    
302            /**
303             * 縲仙ｻ?ｭ｢縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡繧奪BTableModel縺ｫ譖ｸ縺崎ｾｼ繧薙〒縲《ession縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺吶?
304             *
305             * @og.tag
306             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
307             *
308             * @param       id session縺ｫ逋ｻ骭ｲ縺吶ｋ譎ゅ? ID
309             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
310             */
311            @Deprecated public void setTableId( final String id ) {
312                    tableId   = nval( getRequestParameter( id ),tableId );  // 3.8.0.9 (2005/10/17)
313            }
314    
315            /**
316             * 縲仙ｻ?ｭ｢縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
317             *
318             * @og.tag Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
319             *
320             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
321             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
322             */
323            @Deprecated public void setDbid( final String id ) {
324                    dbid = nval( getRequestParameter( id ),dbid );
325            }
326    
327            /**
328             * 縲仙ｻ?ｭ｢縲代さ繝槭Φ繝?ENTRY)繧偵そ繝?ヨ縺励∪縺吶?
329             *
330             * @og.tag
331             * 繧ｳ繝槭Φ繝峨?,HTML縺九ｉ(get/post)謖?ｮ壹＆繧後∪縺吶?縺ｧ,CMD_xxx 縺ｧ險ｭ螳壹＆繧後ｋ
332             * 繝輔ぅ繝ｼ繝ｫ繝牙ｮ壽焚蛟､縺ｮ縺?▼繧後°繧偵?謖?ｮ壹〒縺阪∪縺吶?
333             *
334             * @param       cmd 繧ｳ繝槭Φ繝?public static final 螳｣險?＆繧後※縺?ｋ譁?ｭ怜?)
335             * @see         <a href="../../../../constant-values.html#org.opengion.hayabusa.taglib.TableExistTag.CMD_NEW">繧ｳ繝槭Φ繝牙ｮ壽焚</a>
336             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
337             */
338            @Deprecated public void setCommand( final String cmd ) {
339                    String cmd2 = getRequestParameter( cmd );
340                    if( cmd2 != null && cmd2.length() > 0 ) { command = cmd2.toUpperCase(Locale.JAPAN); }
341            }
342    
343            /**
344             * 縲仙ｻ?ｭ｢縲大ｼ墓焚縺ｫ繧ｻ繝?ヨ縺吶∋縺?繝??繧ｿ縺ｮ蜷咲ｧｰ(繧ｫ繝ｩ繝?錐)繧辰SV蠖｢蠑上〒隍?焚謖?ｮ壹＠縺ｾ縺吶?
345             *
346             * @og.tag
347             * 隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ励〒貂｡縺励∪縺吶?
348             * 蠑墓焚繧地ames 縺ｧ縺ｯ縺ｪ縺上?[繧ｫ繝ｩ繝?錐]蠖｢蠑上〒逶ｴ謗･謖?ｮ壹☆繧九⊇縺?′縲ヾQL譁?′蛻､繧翫ｄ縺吶￥縺ｪ繧翫∪縺吶?
349             *
350             * @param       nm 蠑墓焚縺ｮ蜷咲ｧｰ(隍?焚縺ゅｋ蝣ｴ蜷医?縲√き繝ｳ繝槫玄蛻?ｊ譁?ｭ?
351             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
352             */
353            @Deprecated public void setNames( final String nm ) {
354                    names = nval( getRequestParameter( nm ),names );
355            }
356    
357            /**
358             * 縲仙ｻ?ｭ｢縲代メ繧ｧ繝?け縺吶ｋ繝??繧ｿ繝吶?繧ｹ蜷?from 蜿･)繧呈欠螳壹＠縺ｾ縺吶?
359             *
360             * @og.tag
361             * from 蜿･ 縺ｫ謖?ｮ壹☆繧九ョ繝ｼ繧ｿ繝吶?繧ｹ蜷阪〒縺吶?
362             *
363             * @param       fm 繝??繧ｿ繝吶?繧ｹID
364             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
365             */
366            @Deprecated public void setFrom( final String fm ) {
367                    from = nval( getRequestParameter( fm ),from );
368            }
369    
370            /**
371             * 縲仙ｻ?ｭ｢縲代メ繧ｧ繝?け縺吶ｋ讀懃ｴ｢譚｡莉ｶ(where蜿･)繧呈欠螳壹＠縺ｾ縺吶?
372             *
373             * @og.tag
374             * where 蛹ｺ 縺ｫ謖?ｮ壹☆繧区､懃ｴ｢譚｡莉ｶ縺ｧ縺吶?? 縺ｮ驛ｨ蛻?↓縲］ames 螻樊?縺ｧ謖?ｮ壹＠縺?
375             * 繧ｫ繝ｩ繝??繝??繧ｿ縺後?DBTableModel繧医ｊ蜿悶ｊ蜃ｺ縺輔ｌ縺ｦ驕ｩ逕ｨ縺輔ｌ縺ｾ縺吶?
376             * 縺ｾ縺溘?縲ー繧ｫ繝ｩ繝?錐]蠖｢蠑上〒縲∫峩謗･謖?ｮ壹☆繧九％縺ｨ繧ゅ〒縺阪∪縺吶?縺昴?蝣ｴ蜷医?縲?
377             * name 螻樊?縺ｯ謖?ｮ壹☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺帙ｓ縲?
378             * [繧ｫ繝ｩ繝?錐]縺ｮ蜑榊ｾ後↓縲?')繧ｷ繝ｳ繧ｰ繝ｫ繧ｳ繝ｼ繝??繧ｷ繝ｧ繝ｳ縺ｯ縲∽ｸ崎ｦ√〒縺吶?
379             *
380             * @param       wr 讀懃ｴ｢譚｡莉ｶ(where蜿･)
381             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
382             */
383            @Deprecated public void setWhere( final String wr ) {
384                    where = nval( getRequestParameter( wr ),where );
385            }
386    
387            /**
388             * 縲仙ｻ?ｭ｢縲代ョ繝ｼ繧ｿ繝吶?繧ｹ縺ｮ繝√ぉ繝?け譁ｹ豕?auto/true/false/one/notuse)繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:?｢auto:閾ｪ蜍包ｽ｣)縲?
389             *
390             * @og.tag
391             * exist 螻樊?縺ｫ謖?ｮ壹＆繧後◆ 縲?ｽ｢true:蟄伜惠縺吶ｋ?｣縲?ｽ｢false:蟄伜惠縺励↑縺?ｽ｣縲?ｽ｢one:縺ｲ縺ｨ縺､莉･荳具ｽ｣縲?
392             * 縺ｮ蛟､縺ｯ縲√＞縺壹ｌ縺ｮ蝣ｴ蜷医ｂ縲∵?遶区凾縺ｯ縲∵ｭ｣蟶ｸ縺ｨ縺ｿ縺ｪ縺励∪縺吶?
393             * ?｢auto:閾ｪ蜍包ｽ｣縺ｯ縲．BTableModele縺ｮmodifyType(A,C,D)縺ｫ蠢懊§縺ｦ縲√メ繧ｧ繝?け縺励∪縺吶?
394             * A,C,D 縺ｯ縲‘ntry繧ｿ繧ｰ縺ｫ繧ｳ繝槭Φ繝峨ｒ貂｡縺励※繝??繧ｿ繧剃ｽ懈?縺励◆縺ｨ縺阪↓縲∝?驛ｨ縺ｧ菴懈?縺輔ｌ縺ｾ縺吶?
395             * notuse 縺ｯ縲√メ繧ｧ繝?け繧定｡後＞縺ｾ縺帙ｓ縲ゅ％繧後?縲√％縺ｮ繧ｿ繧ｰ繧貞?譛我ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医↓縲∝､夜Κ縺ｧ
396             * 繝√ぉ繝?け繧定｡後≧縺九←縺?°繧呈欠螳壹〒縺阪ｋ繧医≧縺ｫ縺吶ｋ縺溘ａ縺ｫ菴ｿ逕ｨ縺励∪縺吶?
397             * (?｢true:蟄伜惠縺吶ｋ?｣ 縺ｫ縺ｯ縲√ョ繝ｼ繧ｿ縺悟ｭ伜惠縺励◆蝣ｴ蜷医↓縲?ｼｯ?ｫ縺ｧ縲√↑縺代ｌ縺ｰ繧ｨ繝ｩ繝ｼ縺ｧ縺吶?)
398             * 蛻晄悄蛟､縺ｯ縲?ｽ｢auto:閾ｪ蜍包ｽ｣縺ｧ縺吶?
399             *
400             * @param       ext 繝√ぉ繝?け譁ｹ豕??｢auto:閾ｪ蜍包ｽ｣縲?ｽ｢true:蟄伜惠縺吶ｋ?｣縲?ｽ｢false:蟄伜惠縺励↑縺?ｽ｣縲?ｽ｢one:縺ｲ縺ｨ縺､莉･荳具ｽ｣縲?ｽ｢notuse:繝√ぉ繝?け縺励↑縺?ｽ｣)
401             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
402             */
403            @Deprecated public void setExist( final String ext ) {
404                    exist = nval( getRequestParameter( ext ),exist );
405                    if( !"auto".equalsIgnoreCase( exist ) &&
406                            !"true".equalsIgnoreCase( exist ) &&
407                            !"false".equalsIgnoreCase( exist ) &&
408                            !"one".equalsIgnoreCase( exist ) &&
409                            !"notuse".equalsIgnoreCase( exist ) ) {
410                                    String errMsg = "exist 螻樊?縺ｯ縲?auto,true,false,one,notuse)繧呈欠螳壹＠縺ｦ縺上□縺輔＞縲?[" + exist + "]" + HybsSystem.CR ;
411                                    throw new HybsSystemException( errMsg );
412                    }
413            }
414    
415            /**
416             * 縲仙ｻ?ｭ｢縲代お繝ｩ繝ｼ譎ゅ?驕ｸ謚櫁｡後ｒ蜿悶ｊ髯､縺?※邯咏ｶ壼?逅?ｒ陦後≧縺九←縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
417             *
418             * @og.tag
419             * exist 螻樊?縺ｫ謖?ｮ壹＆繧後◆ 縲?ｽ｢true:蟄伜惠縺吶ｋ?｣縲?ｽ｢false:蟄伜惠縺励↑縺?ｽ｣縲?ｽ｢one:縺ｲ縺ｨ縺､莉･荳具ｽ｣縲?
420             * 縺ｫ蟇ｾ縺励※縲√お繝ｩ繝ｼ縺檎匱逕溘＠縺滄∈謚櫁｡檎分蜿ｷ繧偵?蜿悶ｊ髯､縺?※莉･荳九?蜃ｦ逅?ｒ邯咏ｶ壹☆繧九°縺ｩ縺?°繧?
421             * 謖?ｮ壹＠縺ｾ縺吶?
422             * true 縺ｫ險ｭ螳壹＠縺溷?蜷医?縲√お繝ｩ繝ｼ繝??繧ｿ繧貞炎髯､縺励?邯咏ｶ壼?逅?ｒ陦後≧縺薙→縺後〒縺阪∪縺吶?
423             * flase 縺ｮ蝣ｴ蜷医?縲√お繝ｩ繝ｼ繝??繧ｿ繧定｡ｨ遉ｺ縺励※縲∫ｶ咏ｶ壼?逅?ｒ蛛懈ｭ｢縺励∪縺吶?
424             * 蛻晄悄蛟､縺ｯ縲?ｽ｢false:繧ｨ繝ｩ繝ｼ譎ょ●豁｢?｣縺ｧ縺吶?
425             *
426             * @param       flag 繧ｨ繝ｩ繝ｼ譎ゅ?邯咏ｶ壼?逅?[true:繧ｨ繝ｩ繝ｼ陦檎分蜿ｷ繧貞叙繧企勁縺咲ｶ咏ｶ壼?逅?false:繧ｨ繝ｩ繝ｼ譎ょ●豁｢]
427             * @deprecated 繧ｯ繝ｩ繧ｹ縺悟ｻ?ｭ｢縺輔ｌ縺ｾ縺励◆縲?
428             */
429            @Deprecated public void setErrRemove( final String flag ) {
430                    errRemove = nval( getRequestParameter( flag ),errRemove );
431            }
432    
433            /**
434             *  繧ｫ繝ｩ繝?錐驟榊?(String[])繧医ｊ縲∝ｯｾ蠢懊☆繧九き繝ｩ繝?o驟榊?(int[])繧剃ｽ懈?縺励∪縺吶?
435             *
436             * @param       nameArray 繧ｫ繝ｩ繝?錐驟榊?
437             *
438             * @return      繧ｫ繝ｩ繝?o驟榊?
439             */
440            private int[] getTableColumnNo( final String[] nameArray ) {
441                    int[] clmNo = new int[ nameArray.length ];
442                    for( int i=0; i<clmNo.length; i++ ) {
443                            clmNo[i] = table.getColumnNo( nameArray[i] );
444                    }
445                    return clmNo;
446            }
447    
448            /**
449             *  謖?ｮ壹?陦檎分蜿ｷ縺ｮ縲√き繝ｩ繝?o驟榊?(int[])縺ｫ蟇ｾ蠢懊＠縺溷?縺ｮ驟榊?繧定ｿ斐＠縺ｾ縺吶?
450             *
451             * 陦ｨ遉ｺ繝??繧ｿ縺ｮ HybsSystem.ROW_SEL_KEY 繧貞?縺ｫ縲?∈縺ｰ繧後◆ 陦後ｒ
452             * 蜃ｦ逅??蟇ｾ雎｡縺ｨ縺励∪縺吶?
453             *
454             * @param       clmNo   繧ｫ繝ｩ繝?o驟榊?
455             * @param       row             陦檎分蜿ｷ
456             *
457             * @return      陦檎分蜿ｷ縺ｨ繧ｫ繝ｩ繝?o驟榊?縺ｫ蟇ｾ蠢懊＠縺溘?蛟､縺ｮ驟榊?
458             */
459            private String[] getTableModelData( final int[] clmNo,final int row ) {
460                    String[] values = new String[ clmNo.length ];
461                    for( int i=0; i<values.length; i++ ) {
462                            values[i] = table.getValue( row,clmNo[i] ) ;
463                    }
464                    return values;
465            }
466    
467            /**
468             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ譖ｸ縺崎ｾｼ縺ｿ繝｡繧ｽ繝?ラ
469             *
470             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
471             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
472             *
473             * @param       strm    ObjectOutputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
474             * @throws IOException  蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
475             */
476            private void writeObject( final ObjectOutputStream strm ) throws IOException {
477                    strm.defaultWriteObject();
478            }
479    
480            /**
481             * 繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ逕ｨ縺ｮ繧ｫ繧ｹ繧ｿ繝?す繝ｪ繧｢繝ｩ繧､繧ｺ隱ｭ縺ｿ霎ｼ縺ｿ繝｡繧ｽ繝?ラ
482             *
483             * 縺薙％縺ｧ縺ｯ縲》ransient 螳｣險?＆繧後◆蜀?Κ螟画焚縺ｮ蜀??蛻晄悄蛹悶′蠢?ｦ√↑繝輔ぅ繝ｼ繝ｫ繝峨?縺ｿ險ｭ螳壹＠縺ｾ縺吶?
484             *
485             * @og.rev 4.0.0.0 (2006/09/31) 譁ｰ隕剰ｿｽ蜉?
486             * @serialData 荳?Κ縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?縲√す繝ｪ繧｢繝ｩ繧､繧ｺ縺輔ｌ縺ｾ縺帙ｓ縲?
487             *
488             * @param       strm    ObjectInputStream繧ｪ繝悶ず繧ｧ繧ｯ繝?
489             * @see #release2()
490             * @throws IOException  繧ｷ繝ｪ繧｢繝ｩ繧､繧ｺ縺ｫ髢｢縺吶ｋ蜈･蜃ｺ蜉帙お繝ｩ繝ｼ縺檎匱逕溘＠縺溷?蜷?
491             * @throws ClassNotFoundException       繧ｯ繝ｩ繧ｹ繧定ｦ九▽縺代ｋ縺薙→縺後〒縺阪↑縺九▲縺溷?蜷?
492             */
493            private void readObject( final ObjectInputStream strm ) throws IOException , ClassNotFoundException {
494                    strm.defaultReadObject();
495            }
496    
497            /**
498             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
499             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
500             *
501             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
502             */
503            @Override
504            public String toString() {
505                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
506                                    .println( "VERSION"             ,VERSION        )
507                                    .println( "tableId"             ,tableId        )
508                                    .println( "dbid"                ,dbid           )
509                                    .println( "command"             ,command        )
510                                    .println( "sql"                 ,sql            )
511                                    .println( "names"               ,names          )
512                                    .println( "from"                ,from           )
513                                    .println( "where"               ,where          )
514                                    .println( "exist"               ,exist          )
515                                    .println( "CMD_ENTRY"   ,CMD_ENTRY      )
516                                    .println( "Other..."    ,getAttributes().getAttribute() )
517                                    .fixForm().toString() ;
518            }
519    }