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.db;
017    
018    import org.opengion.hayabusa.common.HybsSystem;
019    import org.opengion.fukurou.util.LogWriter;
020    import org.opengion.hayabusa.resource.ResourceFactory;
021    import org.opengion.hayabusa.resource.ResourceManager;
022    import org.opengion.fukurou.db.DBUtil;
023    import org.opengion.fukurou.util.ApplicationInfo;
024    
025    import java.util.Map;
026    import java.util.HashSet;
027    import java.util.HashMap;
028    
029    /**
030     * 繝??繧ｿ縺ｮ繧ｳ繝ｼ繝画ュ蝣ｱ繧貞叙繧頑桶縺?け繝ｩ繧ｹ縺ｧ縺吶?
031     *
032     * 繧ｳ繝ｼ繝峨?繧ｭ繝ｼ縺ｨ繝ｩ繝吶Ν縺ｮ諠??縺九ｉ縲？TML縺ｮ繝｡繝九Η繝ｼ繧?Μ繧ｹ繝医ｒ菴懈?縺吶ｋ縺溘ａ縺ｮ 繧ｪ繝励す繝ｧ繝ｳ
033     * 繧ｿ繧ｰ繧剃ｽ懈?縺励◆繧翫?荳弱∴繧峨ｌ縺溘く繝ｼ繧偵ｂ縺ｨ縺ｫ縲√メ繧ｧ繝?け貂医∩縺ｮ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧剃ｽ懈?縺励◆繧?
034     * 縺励∪縺吶?
035     * QUERY縺ｮ隨ｬ?代き繝ｩ繝??縲?∈謚槭く繝ｼ縺ｫ縺ｪ繧翫∪縺吶?隨ｬ?偵き繝ｩ繝??繝ｩ繝吶Ν縺ｧ縺吶?縺薙％縺ｾ縺ｧ縺ｯ蠢??縺ｧ縺吶?
036     * 隨ｬ?薙き繝ｩ繝?′蟄伜惠縺吶ｋ蝣ｴ蜷医?縲∫洒邵ｮ繧ｫ繝ｩ繝?→縺励※隱崎ｭ倥＆繧後∪縺吶?蟄伜惠縺励↑縺??蜷医?縲?
037     * 遏ｭ邵ｮ繝ｩ繝吶Ν縺ｯ菴ｿ逕ｨ縺励∪縺帙ｓ縲?
038     *
039     * 繝｡繝九Η繝ｼ菴懈?逕ｨ縺ｫ縲ヾELECT譁?ｒ荳弱∴縺ｾ縺吶?
040     * SELECT 蛟､,繝ｩ繝吶Ν[,繧ｰ繝ｫ繝ｼ繝余[,繧ｯ繝ｩ繧ｹ] FROM XXXX 縺ｧ謖?ｮ壹＆繧後?蛟､縲√Λ繝吶Ν縺ｾ縺ｧ縺ｯ蠢??縲?
041     * 繧ｰ繝ｫ繝ｼ繝励?縲｛ptgroup 縺ｫ蟇ｾ縺励※謖?ｮ壹☆繧九Λ繝吶Ν縺ｧ縺吶?繧ｯ繝ｩ繧ｹ縺ｯ縲√◎縺ｮ繧ｪ繝励す繝ｧ繝ｳ縺ｫ
042     * 濶ｲ縺･縺代↑縺ｩ繧定｡後≧轤ｺ縺ｮ謖?ｮ壹〒縺吶?
043     * 縺ｪ縺翫?繧ｰ繝ｫ繝ｼ繝励?繧ｯ繝ｩ繧ｹ 縺ｯ縲¨ULL(縺ｾ縺溘?縲√ぞ繝ｭ譁?ｭ怜?)縺ｮ蝣ｴ蜷医?縲?←逕ｨ縺輔ｌ縺ｾ縺帙ｓ縲?
044     *
045     * @og.group 驕ｸ謚槭ョ繝ｼ繧ｿ蛻ｶ蠕｡
046     *
047     * @version  4.0
048     * @author   Kazuhiko Hasegawa
049     * @since    JDK5.0,
050     */
051    public class Selection_DB implements Selection {
052            // 3.5.4.8 (2004/02/23) USE_MULTI_KEY_SELECT 繧貞ｮ夂ｾｩ縺励※縺翫″縺ｾ縺吶?
053            private final boolean USE_MULTI_KEY_SELECT      = HybsSystem.sysBool( "USE_MULTI_KEY_SELECT" ) ;
054            private final long        DB_CACHE_TIME                 = (long)HybsSystem.sysInt( "DB_CACHE_TIME" ) ;
055    
056            private final boolean   isMultiSelect ;
057            private final boolean   isShortLavel ;          // 遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺ｧ縺阪ｋ縺九←縺?°
058            private final long              createTime ;            // 繧ｭ繝｣繝?す繝･縺ｮ遐ｴ譽?ち繧､繝溘Φ繧ｰ繧定ｨ医ｋ縺溘ａ縺ｮ菴懈?譎る俣
059    
060            private final int[]             ADRS  ;
061            private final String    CACHE ;
062            private final int               LEN      ;
063            private final int[]             LADRS  ; // 5.1.3.0 (2010/02/01)
064            private final String    LCACHE ; // 5.1.3.0 (2010/02/01)
065            private final int               LLEN   ; // 5.1.3.0 (2010/02/01)
066            private final Map<String,Integer> map  ;
067    
068            private final String[]  value ;         // 蛟､
069            private final String[]  label ;         // 繝ｩ繝吶Ν
070            private final String[]  slabel ;        // 遏ｭ邵ｮ繝ｩ繝吶Ν
071    
072            private static final int VAL  = 0;
073            private static final int LBL  = 1;
074            private static final int SLBL = 2;
075            private static final int GRP  = 3;
076            private static final int CLS  = 4;
077    
078            // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
079            private static final ApplicationInfo appInfo;
080            static {
081                    /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
082                    boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
083    
084                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
085                    if( USE_DB_APPLICATION_INFO ) {
086                            String SYSTEM_ID = HybsSystem.sys( "SYSTEM_ID" );
087                            appInfo = new ApplicationInfo();
088                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
089                            appInfo.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
090                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
091                            appInfo.setModuleInfo( "Selection_DB",null,null );
092                    }
093                    else {
094                            appInfo = null;
095                    }
096            }
097    
098            /**
099             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
100             *
101             * ?､?｢讀懃ｴ｢逕ｨ縺ｮ?ｳ?ｱ?ｬ譁?ｒ荳弱∴縺ｦ縲∝?譛溷喧縺励∪縺吶?
102             * SQL譁??縲゜EY,LNAME [,SNAME] 縺ｧ縲∫ｬｬ?馴?縺後↑縺代ｌ縺ｰ縲´NAME 繧剃ｽｿ逕ｨ縺励∪縺吶?
103             * LNAME 縺ｯ縲??蟶ｸ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓縲ヾNAME 縺ｯ縲∽ｸ?ｦｧ陦ｨ遉ｺ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓菴ｿ逕ｨ縺励∪縺吶?
104             * 迚ｹ蛻･縺ｫ縲゜EY 縺ｮ縺ｿ縺ｮ蝣ｴ蜷医?縲〕ang 縺ｫ蝓ｺ縺･縺?ResourceManager 縺九ｉ?暦ｾ搾ｾ橸ｾ吶ｒ蜿門ｾ励＠縺ｾ縺吶?
105             * 縺溘□縺励?縺昴?蝣ｴ蜷医?縲√が繝ｼ繝翫?(SYSTEM_ID)縺ｯ驕ｸ縺ｹ縺ｾ縺帙ｓ縲?
106             *
107             * @og.rev 3.5.4.2 (2003/12/15) 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ 譁ｰ隕剰ｿｽ蜉?
108             * @og.rev 3.6.0.9 (2004/12/03) isMultiSelect 縺ｮ蛻､螳壹ｒ繝ｩ繝吶Ν驛ｨ縺ｮ繝ｦ繝九?繧ｯ蠎ｦ縺ｧ蛻､螳壹＠縺ｾ縺吶?
109             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
110             * @og.rev 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ繧定ｿｽ蜉??Select譁??隨ｬ?薙?隨ｬ?泌ｼ墓焚縺ｨ縺励※謖?ｮ壹?
111             * @og.rev 4.0.0.0 (2006/11/15) lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
112             * @og.rev 4.3.8.0 (2009/08/01) 繝??繝ｫ繝√ャ繝苓｡ｨ遉ｺ讖溯?霑ｽ蜉?
113             * @og.rev 5.1.3.0 (2010/02/01) 繝ｩ繝吶Ν(遏ｭ)縺系ull縺ｮ蝣ｴ蜷医〒繧ゅ?繝ｩ繝吶Ν(遏ｭ)縺ｧ陦ｨ遉ｺ縺輔ｌ縺ｦ縺励∪縺?ヰ繧ｰ繧剃ｿｮ豁｣
114             * @og.rev 5.1.3.0 (2010/02/01) 荳?ｦｧ陦ｨ遉ｺ莉･螟悶?縲√ヤ繝ｼ繝ｫ繝√ャ繝苓｡ｨ遉ｺ縺励↑縺?
115             *
116             * @param newQuery      DB讀懃ｴ｢(SQL)譁?ｭ怜?
117             * @param dbid          繝??繧ｿ繝吶?繧ｹ謗･邯壼?ID
118             * @param lang          繝ｪ繧ｽ繝ｼ繧ｹ繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?險?ｪ?
119             */
120            public Selection_DB( final String newQuery,final String dbid,final String lang ) {
121    
122                    String[][] cols = DBUtil.dbExecute( newQuery,null,appInfo,dbid );       // 3.8.7.0 (2006/12/15)
123                    int count = cols.length;
124    
125                    value   = new String[count];
126                    label   = new String[count];
127                    slabel  = new String[count];
128                    ADRS    = new int[count];
129                    map             = new HashMap<String,Integer>(count);
130    
131                    int len = ( count > 0 ) ? cols[0].length : 0 ;
132    //              isShortLavel = ( len >= 3 ) ? true : false ;
133                    isShortLavel  = ( len > SLBL );      // >= 3 縺ｨ蜷梧э;
134                    boolean isGrp = ( len > GRP );       // >= 4 縺ｨ蜷梧э;
135                    boolean isCls = ( len > CLS );       // >= 5 縺ｨ蜷梧э;
136    
137                    boolean useLabelData = false ;
138                    ResourceManager resource = null;
139                    if( len == 1 ) {
140                            useLabelData = true;
141                            resource = ResourceFactory.newInstance( lang );
142                    }
143    
144                    // 3.6.0.9 (2004/12/03)
145                    HashSet<String> set = new HashSet<String>();
146                    boolean flag = USE_MULTI_KEY_SELECT;    // 蛻､螳壼?逅?ｒ陦後≧縲Ｇalse 縺ｪ繧牙愛螳壼?逅?ｂ陦後ｏ縺ｪ縺??
147    
148                    StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_LARGE );
149                    String bkGroupKey = "";
150                    for( int i=0; i<count; i++ ) {
151                            value[i] = cols[i][VAL];
152                            if( useLabelData ) {
153                                    label[i] = resource.getLabel( value[i] );
154                            }
155                            else {
156                                    label[i] = cols[i][LBL];
157                                    if( isShortLavel ) { slabel[i] = cols[i][SLBL]; }
158                            }
159                            map.put( value[i], Integer.valueOf( i ) );
160    
161                            // 3.8.9.2 (2007/07/28)
162                            if( isGrp ) {
163                                    String groupKey = cols[i][GRP];
164                                    if( !groupKey.equals( bkGroupKey ) ) {  // 繧ｭ繝ｼ繝悶Ξ繧､繧ｯ
165                                            if( ! "".equals( bkGroupKey ) ) {
166                                                    buf.append( "</optgroup>" );
167                                            }
168                                            if( ! "".equals( groupKey ) ) {
169                                                    buf.append( "<optgroup label=\"" + groupKey + "\">" );
170                                            }
171                                            bkGroupKey = groupKey;
172                                    }
173                            }
174    
175                            buf.append( "<option value=\"" ).append( value[i] ).append( "\"" );
176                            ADRS[i] = buf.length() ;
177                            if( isCls ) {
178                                    String classKey = cols[i][CLS];
179                                    if( ! "".equals( classKey ) ) {
180                                            buf.append( " class=\"" ).append( classKey ).append( "\"" );
181                                    }
182                            }
183                            // 4.3.8.0 (2009/08/01) slabel蛻ｩ逕ｨ縺ｮ蝣ｴ蜷医?label繧稚itle螻樊?縺ｫ繧ｻ繝?ヨ
184                            //buf.append( ">" ).append( label[i] ).append( "</option>" );
185    //                      if( isShortLavel ){
186                            if( isShortLavel && slabel[i] != null && slabel[i].length() > 0 ){ // 5.1.3.0 (2010/02/01)
187                                    if( !label[i].equals( slabel[i] ) ){ // slabel縺ｨlabel縺檎焚縺ｪ繧句?蜷医?縺ｿ
188                                            buf.append( " title=\"" ).append( label[i] ).append( "\"" );
189                                    }
190                                    buf.append( ">" ).append( slabel[i] );
191                            }
192                            else{
193                                    buf.append( ">" ).append( label[i] );
194                            }
195                            buf.append( "</option>" );
196    
197                            // 3.6.0.9 (2004/12/03)
198                            if( flag && label[i].length() > 0 ) {
199                                    flag = set.add( label[i].substring(0,1) );      // 驥崎､?凾縺ｯ false
200                            }
201                    }
202                    if( isGrp && ! "".equals( bkGroupKey ) ) {
203                            buf.append( "</optgroup>" );
204                    }
205    
206                    CACHE = buf.toString();
207                    LEN   = CACHE.length() + 30;
208    
209                    // 5.1.3.0 (2010/02/01) 繝??繝ｫ繝√ャ繝苓｡ｨ遉ｺ縺碁←逕ｨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医?縺ｿ縲√ヤ繝ｼ繝ｫ繝√ャ繝励↑縺励?迥ｶ諷九?option繧偵く繝｣繝?す繝･縺吶ｋ縲?
210                    if( CACHE.indexOf( "title=\"" ) < 0 ) {
211                            LADRS  = null;
212                            LCACHE = null;
213                            LLEN   = 0;
214                    }
215                    else {
216                            LADRS  = new int[count];
217                            StringBuilder lbuf = new StringBuilder( HybsSystem.BUFFER_LARGE );
218    
219                            bkGroupKey = "";
220                            for( int i=0; i<count; i++ ) {
221                                    if( isGrp ) {
222                                            String groupKey = cols[i][GRP];
223                                            if( !groupKey.equals( bkGroupKey ) ) {
224                                                    if( ! "".equals( bkGroupKey ) ) { lbuf.append( "</optgroup>" ); }
225                                                    if( ! "".equals( groupKey ) )   { lbuf.append( "<optgroup label=\"" + groupKey + "\">" ); }
226                                                    bkGroupKey = groupKey;
227                                            }
228                                    }
229                                    lbuf.append( "<option value=\"" ).append( value[i] ).append( "\"" );
230                                    LADRS[i] = lbuf.length() ;
231                                    if( isCls && ! "".equals( cols[i][CLS] ) ) {
232                                            lbuf.append( " class=\"" ).append( cols[i][CLS] ).append( "\"" );
233                                    }
234                                    lbuf.append( ">" ).append( label[i] ).append( "</option>" );
235                            }
236                            if( isGrp && ! "".equals( bkGroupKey ) ) {
237                                    lbuf.append( "</optgroup>" );
238                            }
239                            LCACHE = lbuf.toString();
240                            LLEN   = LCACHE.length() + 30;
241                    }
242    
243                    isMultiSelect = ( USE_MULTI_KEY_SELECT && ! flag ) ;    // flag 縺ｮ蜿崎ｻ｢縺ｫ豕ｨ諢?
244                    createTime = System.currentTimeMillis() ;
245            }
246    
247            /**
248             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
249             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
250             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲√Λ繝吶Ν(遏ｭ)縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医〒繧ゅ?縺薙ｌ繧剃ｽｿ逕ｨ縺帙★縺ｫ蠢?★繝ｩ繝吶Ν(髟ｷ)繧剃ｽｿ逕ｨ縺励∪縺吶?
251             *
252             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?繧呈欠螳壹☆繧?seqFlag 繧貞ｰ主?
253             * @og.rev 4.0.0.0 (2005/01/31) selectValue 縺後?null/繧ｼ繝ｭ譁?ｭ怜?縺ｧ縺ｪ縺??蜷医↓縲?∈謚櫁い縺ｫ縺ｪ縺??蜷医?縲√お繝ｩ繝ｼ
254             *
255             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
256             * @param   seqFlag  繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯? [true:ON/false:OFF]
257             *
258             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
259             * @see     #getOption( String, boolean, boolean )
260             */
261            public String getOption( final String selectValue,final boolean seqFlag ) {
262                    return getOption( selectValue, seqFlag, false );
263            }
264    
265            /**
266             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
267             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
268             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∝ｼ墓焚縺ｮuseShortLabel縺荊rue縺ｫ謖?ｮ壹＆繧後◆蝣ｴ蜷医↓縲√Λ繝吶Ν(遏ｭ)繧偵?繝ｼ繧ｹ縺ｨ縺励◆
269             * 繝??繝ｫ繝√ャ繝苓｡ｨ遉ｺ繧定｡後＞縺ｾ縺吶?
270             *
271             * @og.rev 5.1.3.0 (2010/02/01) 霑ｽ蜉?
272             *
273             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
274             * @param   seqFlag  繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯? [true:ON/false:OFF]
275             * @param   useShortLabel 繝ｩ繝吶Ν(遏ｭ)繧偵?繝ｼ繧ｹ縺ｨ縺励◆繧ｪ繝励す繝ｧ繝ｳ陦ｨ遉ｺ繧定｡後≧縺九←縺?°縲?
276             *
277             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
278             * @see     #getOption( String, boolean )
279             */
280            public String getOption( final String selectValue,final boolean seqFlag, final boolean useShortLabel ) {
281                    int[] adrs = null;
282                    String cache = null;
283                    int len = 0;
284                    if( !useShortLabel && LCACHE != null && LCACHE.length() > 0 ) {
285                            adrs = LADRS;
286                            cache = LCACHE;
287                            len = LLEN;
288                    }
289                    else {
290                            adrs = ADRS;
291                            cache = CACHE;
292                            len = LEN;
293                    }
294    
295                    // 繝槭ャ繝√☆繧九い繝峨Ξ繧ｹ繧呈爾縺吶?
296                    Integer sel = map.get( selectValue );
297    
298                    if( sel == null ) {
299                            // 4.0.0 (2005/01/31)
300                            if( selectValue != null && selectValue.length() > 0 ) {
301                                    String errMsg = "DB繧ｳ繝ｼ繝峨↓蟄伜惠縺励↑縺??縺梧欠螳壹＆繧後∪縺励◆縲?
302                                                            + " value=[" + selectValue + "]"
303                                                            + HybsSystem.CR ;
304                                    LogWriter.log( errMsg );
305                            }
306                            return cache;
307                    }
308                    else {
309                            int selected = sel.intValue();
310                            StringBuilder buf = new StringBuilder( len );
311                            // 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?繧呈欠螳壹☆繧?seqFlag 繧貞ｰ主?
312                            if( seqFlag ) {
313                                    buf.append( "<option value=\"" ).append( value[selected] ).append( "\"" );
314                            }
315                            else {
316                                    buf.append( cache.substring( 0,adrs[selected] ) );
317                            }
318                            buf.append( " selected=\"selected\"" );
319                            buf.append( cache.substring( adrs[selected] ) );
320                            return buf.toString() ;
321                    }
322            }
323    
324            /**
325             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
326             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
327             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
328             *
329             * @og.rev 2.1.0.1 (2002/10/17) 驕ｸ謚槭Μ繧ｹ繝医ｒ縲∵ｭ｣譁ｹ蜷代↓縺励°驕ｸ縺ｹ縺ｪ縺?ｈ縺?↓縺吶ｋ sequenceFlag 繧貞ｰ主?縺吶ｋ
330             * @og.rev 3.8.6.0 (2006/09/29) useLabel 螻樊? 霑ｽ蜉?
331             *
332             * @param   name         繝ｩ繧ｸ繧ｪ縺ｮ name
333             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
334             * @param   useLabel     繝ｩ繝吶Ν陦ｨ遉ｺ縺ｮ譛臥┌ [true:譛?false:辟｡]
335             *
336             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
337             */
338            public String getRadio( final String name,final String selectValue,final boolean useLabel ) {
339                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
340                    throw new UnsupportedOperationException( errMsg );
341            }
342    
343            /**
344             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
345             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
346             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
347             *
348             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
349             *
350             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
351             */
352            public String getRadioLabel( final String selectValue ) {
353                    String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
354                    throw new UnsupportedOperationException( errMsg );
355            }
356    
357            /**
358             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
359             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
360             * getValueLabel( XX ) 縺ｯ縲“etValueLabel( XX,false ) 縺ｨ蜷後§縺ｧ縺吶?
361             *
362             * @param   selectValue 驕ｸ謚櫁い縺ｮ蛟､
363             *
364             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
365             * @see     #getValueLabel( String,boolean )
366             */
367            public String getValueLabel( final String selectValue ) {
368                    return getValueLabel( selectValue,false );
369            }
370    
371            /**
372             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
373             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
374             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∫洒邵ｮ繝ｩ繝吶Ν繧定ｿ斐☆縺九←縺?°繧呈欠螳壹☆繧九ヵ繝ｩ繧ｰ繧呈欠螳壹＠縺ｾ縺吶?
375             * getValueLabel( XX,false ) 縺ｯ縲“etValueLabel( XX ) 縺ｨ蜷後§縺ｧ縺吶?
376             *
377             * @og.rev 4.0.0.0 (2005/11/30) 繧定ｿｽ蜉?
378             * @og.rev 5.3.5.0 (2011/05/01) 蜷咲ｧｰ(遏ｭ)陦ｨ遉ｺ譎ゅ↓蜷咲ｧｰ(髟ｷ)繧偵ヤ繝ｼ繝ｫ繝√ャ繝励〒陦ｨ遉ｺ縺吶ｋ縲?
379             *
380             * @param       selectValue     驕ｸ謚櫁い縺ｮ蛟､
381             * @param       flag    遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺吶ｋ [true:菴ｿ逕ｨ縺吶ｋ/false:縺励↑縺Ь
382             *
383             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
384             * @see     #getValueLabel( String )
385             */
386            public String getValueLabel( final String selectValue,final boolean flag ) {
387                    // 繝槭ャ繝√☆繧九い繝峨Ξ繧ｹ繧呈爾縺吶?
388                    Integer sel = map.get( selectValue );
389    
390                    if( sel == null ) {
391                            return selectValue;
392                    }
393                    else {
394                            if( isShortLavel && flag ) {
395    //                              return slabel[sel.intValue()];
396                                    return "<span title=\""+label[sel.intValue()]+"\">"+slabel[sel.intValue()]+"</span>";
397                            }
398                            else {
399                                    return label[sel.intValue()] ;
400                            }
401                    }
402            }
403    
404            /**
405             * 繝槭Ν繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
406             * true?壻ｽｿ逕ｨ縺吶ｋ縲Ｇalse:菴ｿ逕ｨ縺励↑縺?縺ｧ縺吶?
407             * 縺溘□縺励?螳滄圀縺ｫ菴ｿ逕ｨ縺吶ｋ縺九←縺?°縺ｯ縲？TML蜃ｺ蜉帶凾縺ｫ豎ｺ繧√ｋ縺薙→縺悟?譚･縺ｾ縺吶?
408             * 縺薙％縺ｧ縺ｯ縲ゞSE_MULTI_KEY_SELECT 縺?true 縺ｧ縲ゞSE_SIZE(=20)莉･荳翫?蝣ｴ蜷医↓
409             * true 繧定ｿ斐＠縺ｾ縺吶?
410             *
411             * @og.rev 3.5.5.7 (2004/05/10) 譁ｰ隕丈ｽ懈?
412             *
413             * @return  驕ｸ謚槭Μ繧ｹ繝医〒縲√?繝ｫ繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°(true:菴ｿ逕ｨ縺吶ｋ)
414             */
415            public boolean useMultiSelect() {
416                    return isMultiSelect;
417            }
418    
419            /**
420             * 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
421             * 繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧?辟｡蜉ｹ)縺ｧ縺ゅｌ縺ｰ縲》rue 繧偵?譛牙柑縺ｧ縺ゅｌ縺ｰ縲?
422             * false 繧定ｿ斐＠縺ｾ縺吶?
423             *
424             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕丈ｽ懈?
425             *
426             * @return  繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後↑繧?true
427             */
428            public boolean isTimeOver() {
429                    return ( System.currentTimeMillis() - createTime > DB_CACHE_TIME ) ;
430            }
431    }