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    public class Selection_DB extends Selection_NULL {
053            // 3.5.4.8 (2004/02/23) USE_MULTI_KEY_SELECT 繧貞ｮ夂ｾｩ縺励※縺翫″縺ｾ縺吶?
054            private final boolean USE_MULTI_KEY_SELECT      = HybsSystem.sysBool( "USE_MULTI_KEY_SELECT" ) ;
055            private final long        DB_CACHE_TIME                 = (long)HybsSystem.sysInt( "DB_CACHE_TIME" ) ;
056    
057            private final boolean   isMultiSelect ;
058            private final boolean   isShortLavel ;          // 遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺ｧ縺阪ｋ縺九←縺?°
059            private final long              createTime ;            // 繧ｭ繝｣繝?す繝･縺ｮ遐ｴ譽?ち繧､繝溘Φ繧ｰ繧定ｨ医ｋ縺溘ａ縺ｮ菴懈?譎る俣
060    
061            private final int[]             ADRS  ;
062            private final String    CACHE ;
063            private final int               LEN      ;
064            private final int[]             LADRS  ; // 5.1.3.0 (2010/02/01)
065            private final String    LCACHE ; // 5.1.3.0 (2010/02/01)
066            private final int               LLEN   ; // 5.1.3.0 (2010/02/01)
067            private final Map<String,Integer> map  ;
068    
069            private final String[]  value ;         // 蛟､
070            private final String[]  label ;         // 繝ｩ繝吶Ν
071            private final String[]  slabel ;        // 遏ｭ邵ｮ繝ｩ繝吶Ν
072    
073            private static final int VAL  = 0;
074            private static final int LBL  = 1;
075            private static final int SLBL = 2;
076            private static final int GRP  = 3;
077            private static final int CLS  = 4;
078    
079            // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
080            private static final ApplicationInfo appInfo;
081            static {
082                    /** 繧ｳ繝阪け繧ｷ繝ｧ繝ｳ縺ｫ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ諠??繧定ｿｽ險倥☆繧九°縺ｩ縺?°謖?ｮ?*/
083                    boolean USE_DB_APPLICATION_INFO  = HybsSystem.sysBool( "USE_DB_APPLICATION_INFO" ) ;
084    
085                    // 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
086                    if( USE_DB_APPLICATION_INFO ) {
087                            String SYSTEM_ID = HybsSystem.sys( "SYSTEM_ID" );
088                            appInfo = new ApplicationInfo();
089                            // 繝ｦ繝ｼ繧ｶ繝ｼID,IP繧｢繝峨Ξ繧ｹ,繝帙せ繝亥錐
090                            appInfo.setClientInfo( SYSTEM_ID,HybsSystem.HOST_ADRS,HybsSystem.HOST_NAME );
091                            // 逕ｻ髱｢ID,謫堺ｽ?繝励Ο繧ｰ繝ｩ繝?D
092                            appInfo.setModuleInfo( "Selection_DB",null,null );
093                    }
094                    else {
095                            appInfo = null;
096                    }
097            }
098    
099            /**
100             * 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ
101             *
102             * ?､?｢讀懃ｴ｢逕ｨ縺ｮ?ｳ?ｱ?ｬ譁?ｒ荳弱∴縺ｦ縲∝?譛溷喧縺励∪縺吶?
103             * SQL譁??縲゜EY,LNAME [,SNAME] 縺ｧ縲∫ｬｬ?馴?縺後↑縺代ｌ縺ｰ縲´NAME 繧剃ｽｿ逕ｨ縺励∪縺吶?
104             * LNAME 縺ｯ縲??蟶ｸ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓縲ヾNAME 縺ｯ縲∽ｸ?ｦｧ陦ｨ遉ｺ縺ｮ蛟､繧定ｿ斐☆蝣ｴ蜷医↓菴ｿ逕ｨ縺励∪縺吶?
105             * 迚ｹ蛻･縺ｫ縲゜EY 縺ｮ縺ｿ縺ｮ蝣ｴ蜷医?縲〕ang 縺ｫ蝓ｺ縺･縺?ResourceManager 縺九ｉ?暦ｾ搾ｾ橸ｾ吶ｒ蜿門ｾ励＠縺ｾ縺吶?
106             * 縺溘□縺励?縺昴?蝣ｴ蜷医?縲√が繝ｼ繝翫?(SYSTEM_ID)縺ｯ驕ｸ縺ｹ縺ｾ縺帙ｓ縲?
107             *
108             * @og.rev 3.5.4.2 (2003/12/15) 繧ｳ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ繝ｼ 譁ｰ隕剰ｿｽ蜉?
109             * @og.rev 3.6.0.9 (2004/12/03) isMultiSelect 縺ｮ蛻､螳壹ｒ繝ｩ繝吶Ν驛ｨ縺ｮ繝ｦ繝九?繧ｯ蠎ｦ縺ｧ蛻､螳壹＠縺ｾ縺吶?
110             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
111             * @og.rev 3.8.9.2 (2007/07/28) 繧ｰ繝ｫ繝ｼ繝励→縲√け繝ｩ繧ｹ繧定ｿｽ蜉??Select譁??隨ｬ?薙?隨ｬ?泌ｼ墓焚縺ｨ縺励※謖?ｮ壹?
112             * @og.rev 4.0.0.0 (2006/11/15) lang 螻樊?繧定ｿｽ蜉?＠縺ｾ縺吶?
113             * @og.rev 4.3.8.0 (2009/08/01) 繝??繝ｫ繝√ャ繝苓｡ｨ遉ｺ讖溯?霑ｽ蜉?
114             * @og.rev 5.1.3.0 (2010/02/01) 繝ｩ繝吶Ν(遏ｭ)縺系ull縺ｮ蝣ｴ蜷医〒繧ゅ?繝ｩ繝吶Ν(遏ｭ)縺ｧ陦ｨ遉ｺ縺輔ｌ縺ｦ縺励∪縺?ヰ繧ｰ繧剃ｿｮ豁｣
115             * @og.rev 5.1.3.0 (2010/02/01) 荳?ｦｧ陦ｨ遉ｺ莉･螟悶?縲√ヤ繝ｼ繝ｫ繝√ャ繝苓｡ｨ遉ｺ縺励↑縺?
116             *
117             * @param newQuery      DB讀懃ｴ｢(SQL)譁?ｭ怜?
118             * @param dbid          繝??繧ｿ繝吶?繧ｹ謗･邯壼?ID
119             * @param lang          繝ｪ繧ｽ繝ｼ繧ｹ繧剃ｽｿ逕ｨ縺吶ｋ蝣ｴ蜷医?險?ｪ?
120             */
121            public Selection_DB( final String newQuery,final String dbid,final String lang ) {
122    
123                    String[][] cols = DBUtil.dbExecute( newQuery,null,appInfo,dbid );       // 3.8.7.0 (2006/12/15)
124                    int count = cols.length;
125    
126                    value   = new String[count];
127                    label   = new String[count];
128                    slabel  = new String[count];
129                    ADRS    = new int[count];
130                    map             = new HashMap<String,Integer>(count);
131    
132                    int len = ( count > 0 ) ? cols[0].length : 0 ;
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 && slabel[i] != null && slabel[i].length() > 0 ){ // 5.1.3.0 (2010/02/01)
186                                    if( !label[i].equals( slabel[i] ) ){ // slabel縺ｨlabel縺檎焚縺ｪ繧句?蜷医?縺ｿ
187                                            buf.append( " title=\"" ).append( label[i] ).append( "\"" );
188                                    }
189                                    buf.append( ">" ).append( slabel[i] );
190                            }
191                            else{
192                                    buf.append( ">" ).append( label[i] );
193                            }
194                            buf.append( "</option>" );
195    
196                            // 3.6.0.9 (2004/12/03)
197                            if( flag && label[i].length() > 0 ) {
198                                    flag = set.add( label[i].substring(0,1) );      // 驥崎､?凾縺ｯ false
199                            }
200                    }
201                    if( isGrp && ! "".equals( bkGroupKey ) ) {
202                            buf.append( "</optgroup>" );
203                    }
204    
205                    CACHE = buf.toString();
206                    LEN   = CACHE.length() + 30;
207    
208                    // 5.1.3.0 (2010/02/01) 繝??繝ｫ繝√ャ繝苓｡ｨ遉ｺ縺碁←逕ｨ縺輔ｌ縺ｦ縺?ｋ蝣ｴ蜷医?縺ｿ縲√ヤ繝ｼ繝ｫ繝√ャ繝励↑縺励?迥ｶ諷九?option繧偵く繝｣繝?す繝･縺吶ｋ縲?
209                    if( CACHE.indexOf( "title=\"" ) < 0 ) {
210                            LADRS  = null;
211                            LCACHE = null;
212                            LLEN   = 0;
213                    }
214                    else {
215                            LADRS  = new int[count];
216                            StringBuilder lbuf = new StringBuilder( HybsSystem.BUFFER_LARGE );
217    
218                            bkGroupKey = "";
219                            for( int i=0; i<count; i++ ) {
220                                    if( isGrp ) {
221                                            String groupKey = cols[i][GRP];
222                                            if( !groupKey.equals( bkGroupKey ) ) {
223                                                    if( ! "".equals( bkGroupKey ) ) { lbuf.append( "</optgroup>" ); }
224                                                    if( ! "".equals( groupKey ) )   { lbuf.append( "<optgroup label=\"" + groupKey + "\">" ); }
225                                                    bkGroupKey = groupKey;
226                                            }
227                                    }
228                                    lbuf.append( "<option value=\"" ).append( value[i] ).append( "\"" );
229                                    LADRS[i] = lbuf.length() ;
230                                    if( isCls && ! "".equals( cols[i][CLS] ) ) {
231                                            lbuf.append( " class=\"" ).append( cols[i][CLS] ).append( "\"" );
232                                    }
233                                    lbuf.append( ">" ).append( label[i] ).append( "</option>" );
234                            }
235                            if( isGrp && ! "".equals( bkGroupKey ) ) {
236                                    lbuf.append( "</optgroup>" );
237                            }
238                            LCACHE = lbuf.toString();
239                            LLEN   = LCACHE.length() + 30;
240                    }
241    
242                    isMultiSelect = USE_MULTI_KEY_SELECT && ! flag ;        // flag 縺ｮ蜿崎ｻ｢縺ｫ豕ｨ諢?
243                    createTime = System.currentTimeMillis() ;
244            }
245    
246            /**
247             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
248             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
249             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲√Λ繝吶Ν(遏ｭ)縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医〒繧ゅ?縺薙ｌ繧剃ｽｿ逕ｨ縺帙★縺ｫ蠢?★繝ｩ繝吶Ν(髟ｷ)繧剃ｽｿ逕ｨ縺励∪縺吶?
250             *
251             * @og.rev 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?繧呈欠螳壹☆繧?seqFlag 繧貞ｰ主?
252             * @og.rev 4.0.0.0 (2005/01/31) selectValue 縺後?null/繧ｼ繝ｭ譁?ｭ怜?縺ｧ縺ｪ縺??蜷医↓縲?∈謚櫁い縺ｫ縺ｪ縺??蜷医?縲√お繝ｩ繝ｼ
253             * @og.rev 5.7.7.1 (2014/06/13) Selection_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            @Override
281            public String getOption( final String selectValue,final boolean seqFlag, final boolean useShortLabel ) {
282                    int[] adrs = null;
283                    String cache = null;
284                    int len = 0;
285                    if( !useShortLabel && LCACHE != null && LCACHE.length() > 0 ) {
286                            adrs = LADRS;
287                            cache = LCACHE;
288                            len = LLEN;
289                    }
290                    else {
291                            adrs = ADRS;
292                            cache = CACHE;
293                            len = LEN;
294                    }
295    
296                    // 繝槭ャ繝√☆繧九い繝峨Ξ繧ｹ繧呈爾縺吶?
297                    Integer sel = map.get( selectValue );
298    
299                    if( sel == null ) {
300                            // 4.0.0 (2005/01/31)
301                            if( selectValue != null && selectValue.length() > 0 ) {
302                                    String errMsg = "DB繧ｳ繝ｼ繝峨↓蟄伜惠縺励↑縺??縺梧欠螳壹＆繧後∪縺励◆縲?
303                                                            + " value=[" + selectValue + "]"
304                                                            + HybsSystem.CR ;
305                                    LogWriter.log( errMsg );
306                            }
307                            return cache;
308                    }
309                    else {
310                            int selected = sel.intValue();
311                            StringBuilder buf = new StringBuilder( len );
312                            // 3.6.0.6 (2004/10/22) 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ繧｢繧ｯ繧ｻ繧ｹ讖溯?繧呈欠螳壹☆繧?seqFlag 繧貞ｰ主?
313                            if( seqFlag ) {
314                                    buf.append( "<option value=\"" ).append( value[selected] ).append( "\"" );
315                            }
316                            else {
317                                    buf.append( cache.substring( 0,adrs[selected] ) );
318                            }
319                            buf.append( " selected=\"selected\"" );
320                            buf.append( cache.substring( adrs[selected] ) );
321                            return buf.toString() ;
322                    }
323            }
324    
325            /**
326             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
327             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
328             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
329             *
330             * @og.rev 2.1.0.1 (2002/10/17) 驕ｸ謚槭Μ繧ｹ繝医ｒ縲∵ｭ｣譁ｹ蜷代↓縺励°驕ｸ縺ｹ縺ｪ縺?ｈ縺?↓縺吶ｋ sequenceFlag 繧貞ｰ主?縺吶ｋ
331             * @og.rev 3.8.6.0 (2006/09/29) useLabel 螻樊? 霑ｽ蜉?
332             * @og.rev 5.7.7.1 (2014/06/13) Selection_NULL 繧?邯呎価縺吶ｋ縺溘ａ縲∝炎髯､
333             *
334             * @param   name         繝ｩ繧ｸ繧ｪ縺ｮ name
335             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
336             * @param   useLabel     繝ｩ繝吶Ν陦ｨ遉ｺ縺ｮ譛臥┌ [true:譛?false:辟｡]
337             *
338             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
339             */
340    //      public String getRadio( final String name,final String selectValue,final boolean useLabel ) {
341    //              String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
342    //              throw new UnsupportedOperationException( errMsg );
343    //      }
344    
345            /**
346             * 蛻晄悄蛟､縺碁∈謚樊ｸ医∩縺ｮ 驕ｸ謚櫁い(繧ｪ繝励す繝ｧ繝ｳ)繧定ｿ斐＠縺ｾ縺吶?
347             * 縺薙?繧ｪ繝励す繝ｧ繝ｳ縺ｯ縲∝ｼ墓焚縺ｮ蛟､繧貞?譛溷?縺ｨ縺吶ｋ繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ繧定ｿ斐＠縺ｾ縺吶?
348             * 窶ｻ 縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?
349             *
350             * @og.rev 5.7.7.1 (2014/06/13) Selection_NULL 繧?邯呎価縺吶ｋ縺溘ａ縲∝炎髯､
351             *
352             * @param   selectValue  驕ｸ謚槭＆繧後※縺?ｋ蛟､
353             *
354             * @return  繧ｪ繝励す繝ｧ繝ｳ繧ｿ繧ｰ
355             */
356    //      public String getRadioLabel( final String selectValue ) {
357    //              String errMsg = "縺薙?繧ｯ繝ｩ繧ｹ縺ｧ縺ｯ螳溯｣?＆繧後※縺?∪縺帙ｓ縲?;
358    //              throw new UnsupportedOperationException( errMsg );
359    //      }
360    
361            /**
362             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
363             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
364             * getValueLabel( XX ) 縺ｯ縲“etValueLabel( XX,false ) 縺ｨ蜷後§縺ｧ縺吶?
365             *
366             * @og.rev 5.7.7.1 (2014/06/13) Selection_NULL 繧?邯呎価縺吶ｋ縺溘ａ縲∝炎髯､
367             *
368             * @param   selectValue 驕ｸ謚櫁い縺ｮ蛟､
369             *
370             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
371             * @see     #getValueLabel( String,boolean )
372             */
373    //      public String getValueLabel( final String selectValue ) {
374    //              return getValueLabel( selectValue,false );
375    //      }
376    
377            /**
378             * 驕ｸ謚櫁い(value)縺ｫ蟇ｾ縺吶ｋ繝ｩ繝吶Ν繧定ｿ斐＠縺ｾ縺吶?
379             * 驕ｸ謚櫁い(value)縺後?蟄伜惠縺励↑縺九▲縺溷?蜷医?縲?∈謚櫁い縺昴?繧ゅ?繧定ｿ斐＠縺ｾ縺吶?
380             * 縺薙?繝｡繧ｽ繝?ラ縺ｧ縺ｯ縲∫洒邵ｮ繝ｩ繝吶Ν繧定ｿ斐☆縺九←縺?°繧呈欠螳壹☆繧九ヵ繝ｩ繧ｰ繧呈欠螳壹＠縺ｾ縺吶?
381             * getValueLabel( XX,false ) 縺ｯ縲“etValueLabel( XX ) 縺ｨ蜷後§縺ｧ縺吶?
382             *
383             * @og.rev 4.0.0.0 (2005/11/30) 繧定ｿｽ蜉?
384             * @og.rev 5.3.5.0 (2011/05/01) 蜷咲ｧｰ(遏ｭ)陦ｨ遉ｺ譎ゅ↓蜷咲ｧｰ(髟ｷ)繧偵ヤ繝ｼ繝ｫ繝√ャ繝励〒陦ｨ遉ｺ縺吶ｋ縲?
385             *
386             * @param       selectValue     驕ｸ謚櫁い縺ｮ蛟､
387             * @param       flag    遏ｭ邵ｮ繝ｩ繝吶Ν繧剃ｽｿ逕ｨ縺吶ｋ [true:菴ｿ逕ｨ縺吶ｋ/false:縺励↑縺Ь
388             *
389             * @return  驕ｸ謚櫁い縺ｮ繝ｩ繝吶Ν
390             * @see     #getValueLabel( String )
391             */
392            @Override
393            public String getValueLabel( final String selectValue,final boolean flag ) {
394                    // 繝槭ャ繝√☆繧九い繝峨Ξ繧ｹ繧呈爾縺吶?
395                    Integer sel = map.get( selectValue );
396    
397                    if( sel == null ) {
398                            return selectValue;
399                    }
400                    else {
401                            if( isShortLavel && flag ) {
402                                    return "<span title=\""+label[sel.intValue()]+"\">"+slabel[sel.intValue()]+"</span>";
403                            }
404                            else {
405                                    return label[sel.intValue()] ;
406                            }
407                    }
408            }
409    
410            /**
411             * 繝槭Ν繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
412             * true?壻ｽｿ逕ｨ縺吶ｋ縲Ｇalse:菴ｿ逕ｨ縺励↑縺?縺ｧ縺吶?
413             * 縺溘□縺励?螳滄圀縺ｫ菴ｿ逕ｨ縺吶ｋ縺九←縺?°縺ｯ縲？TML蜃ｺ蜉帶凾縺ｫ豎ｺ繧√ｋ縺薙→縺悟?譚･縺ｾ縺吶?
414             * 縺薙％縺ｧ縺ｯ縲ゞSE_MULTI_KEY_SELECT 縺?true 縺ｧ縲ゞSE_SIZE(=20)莉･荳翫?蝣ｴ蜷医↓
415             * true 繧定ｿ斐＠縺ｾ縺吶?
416             *
417             * @og.rev 3.5.5.7 (2004/05/10) 譁ｰ隕丈ｽ懈?
418             *
419             * @return  驕ｸ謚槭Μ繧ｹ繝医〒縲√?繝ｫ繝√?繧ｭ繝ｼ繧ｻ繝ｬ繧ｯ繝医ｒ菴ｿ逕ｨ縺吶ｋ縺九←縺?°(true:菴ｿ逕ｨ縺吶ｋ)
420             */
421            @Override
422            public boolean useMultiSelect() {
423                    return isMultiSelect;
424            }
425    
426            /**
427             * 繧ｪ繝悶ず繧ｧ繧ｯ繝医?繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後°縺ｩ縺?°繧定ｿ斐＠縺ｾ縺吶?
428             * 繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧?辟｡蜉ｹ)縺ｧ縺ゅｌ縺ｰ縲》rue 繧偵?譛牙柑縺ｧ縺ゅｌ縺ｰ縲?
429             * false 繧定ｿ斐＠縺ｾ縺吶?
430             *
431             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕丈ｽ懈?
432             *
433             * @return  繧ｭ繝｣繝?す繝･縺梧凾髢灘?繧後↑繧?true
434             */
435            @Override
436            public boolean isTimeOver() {
437                    return ( System.currentTimeMillis() - createTime ) > DB_CACHE_TIME ;
438            }
439    }