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.hayabusa.db.DBColumn;
022    import org.opengion.hayabusa.db.DBTableModelUtil;
023    import org.opengion.hayabusa.resource.LDAPSearch;
024    
025    import org.opengion.fukurou.util.ErrorMessage;
026    import org.opengion.fukurou.util.StringUtil ;
027    import static org.opengion.fukurou.util.StringUtil.nval ;
028    
029    import java.util.List;
030    import java.util.Locale;
031    
032    /**
033     * LDAP縺ｮ蜀?ｮｹ繧呈､懃ｴ｢縺吶ｋ縺溘ａ縺ｮ縲〕dapQuery繧ｿ繧ｰ縺ｧ縺吶?
034     *
035     * 讀懃ｴ｢縺励◆邨先棡縺ｯ縲．BTableModel 縺ｫ繧ｻ繝?ヨ縺輔ｌ繧九◆繧√?
036     * JDBCQuery 縺ｨ蜷梧ｧ倥↓縲」iew繧ｿ繧ｰ縺ｧ陦ｨ遉ｺ縺輔○繧九％縺ｨ縺悟庄閭ｽ縺ｧ縺吶?
037     *
038     * 荳玖ｨ倥?鬆?岼縺ｫ縺､縺?※縺ｯ縲《rc/resource/繧ｷ繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ 縺ｫ縲∽ｺ医ａ
039     * 險ｭ螳壹＠縺ｦ縺翫￥縺薙→縺ｧ縲√ち繧ｰ縺斐→縺ｫ謖?ｮ壹☆繧句ｿ?ｦ√′縺ｪ縺上↑繧翫∪縺吶?
040     * 繝ｻLDAP_INITIAL_CONTEXT_FACTORY
041     * 繝ｻLDAP_PROVIDER_URL
042     * 繝ｻLDAP_ENTRYDN
043     * 繝ｻLDAP_SEARCH_BASE
044     * 繝ｻLDAP_SEARCH_SCOPE
045     *
046     * 縺薙?繧ｿ繧ｰ繝ｪ繝悶〒縺ｯ縲∵､懃ｴ｢縺ｮ縺ｿ繧ｵ繝昴?繝医＠縺ｦ縺?∪縺吶?
047     *
048     * @og.formSample
049     * 笳丞ｽ｢蠑擾ｼ?
050     *     &lt;og:ldapQuery  debug=&quot;false&quot;
051     *         command     = &quot;NEW&quot;                                       NEW,RENEW 縺御ｽｿ逕ｨ蜿ｯ閭ｽ縺ｧ縺吶?
052     *         initctx     = &quot;com.sun.jndi.ldap.LdapCtxFactory&quot;          蛻晄悄繧ｳ繝ｳ繝?く繧ｹ繝医ヵ繧｡繧ｯ繝医Μ
053     *         providerURL = &quot;ldap://ldap.opengion.org:389&quot;              繧ｵ繝ｼ繝薙せ繝励Ο繝舌う繝??讒区?諠??
054     *         entrydn     = &quot;cn=inquiry-sys,o=opengion,c=JP&quot;            螻樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕
055     *         password    = &quot;xxxxxx&quot;                                    螻樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝代せ繝ｯ繝ｼ繝?
056     *         searchbase  = &quot;soouid=employeeuser,o=opengion,c=JP&quot;       讀懃ｴ｢縺吶ｋ繧ｳ繝ｳ繝?く繧ｹ繝医∪縺溘?繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝吶?繧ｹ蜷?
057     *         filter      = &quot;(objectClass=person)&quot;                      讀懃ｴ｢縺ｫ菴ｿ逕ｨ縺吶ｋ繝輔ぅ繝ｫ繧ｿ蠑上?null 縺ｯ荳榊庄
058     *         attributes  = &quot;uid,cn,officeName,ou,mail,belongOUID&quot;      螻樊?繧定ｭ伜挨縺吶ｋ螻樊? ID繧偵き繝ｳ繝槫玄蛻?ｊ縺ｧ謖?ｮ?
059     *         searchScope = &quot;SUBTREE&quot;                                   讀懃ｴ｢遽?峇繧定ｨｭ螳?縲三BJECT縲上?ONELEVEL縲上?SUBTREE縲上?縺ｩ繧後°)
060     *         maxRowCount = &quot;0&quot;                                         讀懃ｴ｢譎ゅ?譛?､ｧ讀懃ｴ｢謨ｰ(0縺ｯ縲∫┌蛻ｶ髯撰ｼ壹ョ繝輔か繝ｫ繝?
061     *     /&gt;
062     * 笳獣ody?壹↑縺?
063     *
064     * 笳週ag螳夂ｾｩ??
065     *   &lt;og:ldapQuery
066     *       initctx            縲慎AG縲大?譛溘さ繝ｳ繝?く繧ｹ繝医ヵ繧｡繧ｯ繝医Μ繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_INITIAL_CONTEXT_FACTORY[=com.sun.jndi.ldap.LdapCtxFactory])
067     *       providerURL        縲慎AG縲代し繝ｼ繝薙せ繝励Ο繝舌う繝??讒区?諠??繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_PROVIDER_URL[=ldap://ldap.opengion.org:389])
068     *       entrydn            縲慎AG縲大ｱ樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_ENTRYDN[=cn=inquiry-sys,o=opengion,c=JP])
069     *       password           縲慎AG縲大ｱ樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝代せ繝ｯ繝ｼ繝峨ｒ險ｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_PASSWORD[=password])
070     *       searchbase         縲慎AG縲第､懃ｴ｢縺吶ｋ繧ｳ繝ｳ繝?く繧ｹ繝医∪縺溘?繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_SEARCH_BASE[=soouid=employeeuser,o=opengion,c=JP])
071     *       filter           笳九?TAG縲第､懃ｴ｢縺ｫ菴ｿ逕ｨ縺吶ｋ繝輔ぅ繝ｫ繧ｿ蠑?萓具ｼ喘elongOUID=61200)(蠢??)縲?
072     *       searchScope        縲慎AG縲第､懃ｴ｢遽?峇(OBJECT/ONELEVEL/SUBTREE)繧定ｨｭ螳壹＠縺ｾ縺?(蛻晄悄蛟､:LDAP_SEARCH_SCOPE[=SUBTREE])
073     *       timeLimit          縲慎AG縲代％繧後ｉ縺ｮ SearchControls 縺ｮ譎る俣蛻ｶ髯舌ｒ繝溘Μ遘貞腰菴阪〒險ｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:0[辟｡蛻ｶ髯疹)
074     *       derefLinkFlag      縲慎AG縲第､懃ｴ｢荳ｭ縺ｮ繝ｪ繝ｳ繧ｯ縺ｸ縺ｮ髢捺磁蜿ら?繧呈怏蜉ｹ縺ｾ縺溘?辟｡蜉ｹ[true/false]縺ｫ縺励∪縺?蛻晄悄蛟､:false)
075     *       maxRowCount        縲慎AG縲代Ξ繧ｸ繧ｹ繝医Μ縺ｮ譛?､ｧ讀懃ｴ｢莉ｶ謨ｰ繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:0[辟｡蛻ｶ髯疹)
076     *       returningObjFlag   縲慎AG縲醍ｵ先棡縺ｮ荳?Κ縺ｨ縺励※繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐☆縺薙→繧呈怏蜉ｹ縺ｾ縺溘?辟｡蜉ｹ[true/false]縺ｫ縺励∪縺?蛻晄悄蛟､:false)
077     *       attributes         縲慎AG縲第､懃ｴ｢縺ｮ荳?Κ縺ｨ縺励※霑斐＆繧後ｋ螻樊?繧辰SV縺ｧ隍?焚謖?ｮ壹＠縺ｾ縺?
078     *       columns            縲慎AG縲台ｽ懈?縺吶ｋ DBTableModel 縺ｮ繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺?
079     *       orderBy            縲慎AG縲第､懃ｴ｢縺励◆邨先棡繧定｡ｨ遉ｺ縺吶ｋ陦ｨ遉ｺ鬆?ｒ繝輔ぃ繧､繝ｫ螻樊?蜷阪〒謖?ｮ壹＠縺ｾ縺?
080     *       tableId            縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡繧奪BTableModel縺ｫ譖ｸ縺崎ｾｼ繧薙〒縲《ession縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
081     *       command            縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)
082     *       displayMsg         縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､縺ｯ讀懃ｴ｢莉ｶ謨ｰ)
083     *       notfoundMsg        縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])
084     *       overflowMsg        縲慎AG縲代が繝ｼ繝舌?繝輔Ο繝ｼ譎ゅ↓逕ｻ髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0007)
085     *       scope              縲慎AG縲代く繝｣繝?す繝･縺吶ｋ蝣ｴ蜷医?繧ｹ繧ｳ繝ｼ繝夕request/page/session/applicaton]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:session)
086     *       mainTrans          縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
087     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
088     *   /&gt;
089     *
090     * 笳丈ｽｿ逕ｨ萓?
091     *     繧ｷ繧ｹ繝?Β繝代Λ繝｡繝ｼ繧ｿ 縺ｫ縲∝ｿ?ｦ√↑LDAP螳壽焚繧貞ｮ夂ｾｩ縺励※縺翫＞縺溷?蜷医?縲∽ｸ玖ｨ倥?繧ｿ繧ｰ縺ｧ讀懃ｴ｢縺ｧ縺阪∪縺吶?
092     *     萓九〒縺ｯ縲’ilter 縺ｫ縺ゅ＞縺ｾ縺?､懃ｴ｢(*)縺ｨAND譚｡莉ｶ(&amp;(譚｡莉ｶA)(譚｡莉ｶB)) 繧呈欠螳壹＠縺滉ｾ九ｒ謖吶￡縺ｦ縺翫″縺ｾ縺吶?
093     *     filter 縺ｮ蠖｢蠑上→隗｣驥医?縲ヽFC 2254 縺ｫ貅匁侠縺励※縺?∪縺吶?
094     *     (RFC 2254 縺ｧ螳夂ｾｩ縺輔ｌ縺ｦ縺?ｋ貍皮ｮ怜ｭ舌?縺吶∋縺ｦ繧偵☆縺ｹ縺ｦ縺ｮ螻樊?縺ｫ驕ｩ逕ｨ縺ｧ縺阪ｋ繧上￠縺ｧ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縲?
095     *
096     *      &lt;og:ldapQuery  debug=&quot;false&quot;
097     *          command     = &quot;NEW&quot;
098     *          filter      = &quot;(&amp;(cnphoneticlangjp=OPENGION*)(businessName=*COMMON*))&quot;
099     *          attributes  = &quot;uid,cn,officeName,ou,mail,belongOUID&quot;
100     *      /&gt;
101     *
102     *    繝ｻqueryOption 繧ｿ繧ｰ縺ｮ蜀?Κ縺ｫ險倩ｿｰ縺吶ｌ縺ｰ縲√?繝ｫ繝?え繝ｳ繝｡繝九Η繝ｼ繧剃ｽ懈?縺吶ｋ縺薙→縺悟庄閭ｽ縺ｧ縺吶?
103     *    &lt;og:select name="UID"&gt;
104     *        &lt;og:queryOption&gt;
105     *            &lt;og:ldapQuery
106     *                filter      = "(&amp;amp;(|(belongOUID=60000)(belongOUID=70000))(uid=C*))"
107     *                attributes  = "uid,uid,sn"
108     *                orderBy     = "uid"
109     *            /&gt;
110     *        &lt;/og:queryOption&gt;
111     *    &lt;/og:select&gt;
112     *
113     * @og.rev 3.1.0.0 (2003/03/20) ?ｬ?､?｡?ｰ縺ｫ繧｢繧ｯ繧ｻ繧ｹ縺ｧ縺阪ｋ縲´DAPQueryTag.java 繧呈眠隕上↓菴懈?縲?
114     * @og.group 縺昴?莉門?蜉?
115     *
116     * @version  4.0
117     * @author       Kazuhiko Hasegawa
118     * @since    JDK5.0,
119     */
120    public class LDAPQueryTag extends CommonTagSupport {
121            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
122            private static final String VERSION = "5.1.6.0 (2010/05/01)" ;
123    
124            private static final long serialVersionUID = 516020100501L ;
125    
126            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 譁ｰ隕?{@value} */
127            public static final String CMD_NEW       = "NEW" ;
128            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝? 蜀肴､懃ｴ｢ {@value} */
129            public static final String CMD_RENEW = "RENEW" ;
130            /** command 蠑墓焚縺ｫ貂｡縺吩ｺ九?蜃ｺ譚･繧?繧ｳ繝槭Φ繝?繝ｪ繧ｹ繝? */
131            private static final String[] COMMAND_LIST = new String[] { CMD_NEW , CMD_RENEW };
132    
133            private String                  initctx                         = HybsSystem.sys( "LDAP_INITIAL_CONTEXT_FACTORY" );
134            private String                  providerURL             = HybsSystem.sys( "LDAP_PROVIDER_URL" );
135            private String                  entrydn                         = HybsSystem.sys( "LDAP_ENTRYDN" );
136            private String                  password                        = HybsSystem.sys( "LDAP_PASSWORD" );            // 4.2.2.0 (2008/05/10)
137            private String                  searchbase                      = HybsSystem.sys( "LDAP_SEARCH_BASE" );
138            private String                  filter                          = null;         // "employeeNumber=87019";
139    
140            // 讀懃ｴ｢遽?峇縲０BJECT_SCOPE縲＾NELEVEL_SCOPE縲ヾUBTREE_SCOPE 縺ｮ縺ｩ繧後° 1 縺､
141            private String                  searchScope                     = HybsSystem.sys( "LDAP_SEARCH_SCOPE" );
142            private static final long       COUNTLIMIT              = 0;                    // 霑斐☆繧ｨ繝ｳ繝医Μ縺ｮ譛?､ｧ謨ｰ縲? 縺ｮ蝣ｴ蜷医?繝輔ぅ繝ｫ繧ｿ繧呈ｺ?◆縺吶お繝ｳ繝医Μ繧偵☆縺ｹ縺ｦ霑斐☆
143            private int                             timeLimit                       = 0;                    // 邨先棡縺瑚ｿ斐＆繧後ｋ縺ｾ縺ｧ縺ｮ繝溘Μ遘呈焚縲? 縺ｮ蝣ｴ蜷医?辟｡蛻ｶ髯?
144            private String[]                attrs                           = null;                 // 繧ｨ繝ｳ繝医Μ縺ｨ荳?ｷ偵↓霑斐＆繧後ｋ螻樊?縺ｮ隴伜挨蟄舌?null 縺ｮ蝣ｴ蜷医?縺吶∋縺ｦ縺ｮ螻樊?繧定ｿ斐☆縲らｩｺ縺ｮ蝣ｴ蜷医?螻樊?繧定ｿ斐＆縺ｪ縺?
145            private String[]                columns                         = null;                 // DBTableModel 繧剃ｽ懈?縺吶ｋ蝣ｴ蜷医?繧ｫ繝ｩ繝?錐縺ｫ縺ｪ繧翫∪縺吶?null 縺ｮ蝣ｴ蜷医?縲∥ttributes 螻樊?
146            private boolean                 returningObjFlag        = false;                // true 縺ｮ蝣ｴ蜷医?繧ｨ繝ｳ繝医Μ縺ｮ蜷榊燕縺ｫ繝舌う繝ｳ繝峨＆繧後◆繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐☆縲Ｇalse 蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐＆縺ｪ縺?
147            private boolean                 derefLinkFlag           = false;                // true 縺ｮ蝣ｴ蜷医?讀懃ｴ｢荳ｭ縺ｫ繝ｪ繝ｳ繧ｯ繧帝俣謗･蜿ら?縺吶ｋ
148    
149            private String                  tableId                         = HybsSystem.TBL_MDL_KEY;       // session?ｷ?ｰ
150            private String                  orderBy                         = null;                                         // ?ｿ?ｰ???逶ｮ(csv)
151            private String                  command                         = CMD_NEW;                                      // ?ｺ?擾ｾ晢ｾ?ｾ?
152            private int                             executeCount            = 0;                                            // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
153            private int                             errCode                         = ErrorMessage.OK;                      // Ver4.3.1.1 (2008/09/05) 讀懃ｴ｢繧ｨ繝ｩ繝ｼ繧ｳ繝ｼ繝?
154            private int                     maxRowCount                     = 0;                    // 譛?､ｧ讀懃ｴ｢謨ｰ(0縺ｯ辟｡蛻ｶ髯?
155    //      private String                  displayMsg              = "MSG0033";    // 莉ｶ讀懃ｴ｢縺励∪縺励◆縲?
156            private String                  displayMsg                      = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
157            private String                  overflowMsg             = "MSG0007";    // 讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆縲?
158            private String                  notfoundMsg                     = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
159            private boolean                 isMainTrans                     = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
160    
161            /**
162             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
163             *
164             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
165             * @og.rev 3.6.0.8 (2004/11/19) DBTableModel 繧偵そ繝ｼ繝悶☆繧区凾縺ｫ縲√ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
166             * @og.rev 4.0.0.0 (2007/10/18) 繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹ邨ｱ蜷? getResource().getMessage 竍?getResource().getLabel )
167             * @og.rev 4.3.1.1 (2008/09/03) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ縲∫憾豕√さ繝ｼ繝峨ｒ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚 "DB.COUNT"縲?DB.ERR_CODE" 縺ｫ繧ｻ繝?ヨ縺吶ｋ縲?
168             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
169             *
170             * @return      蠕檎ｶ壼?逅??謖?､ｺ
171             */
172            @Override
173            public int doEndTag() {
174                    debugPrint();           // 4.0.0 (2005/02/28)
175    
176                    // QueryOptionTag 縺ｮ蜀?Κ縺ｧ險倩ｿｰ縺輔ｌ縺溷?蜷医?蜃ｦ逅??
177                    QueryOptionTag queryOption = (QueryOptionTag)findAncestorWithClass( this,QueryOptionTag.class );
178                    if( queryOption != null ) {
179                            queryOption.setTableModel( makeDBTable() );
180                            return(EVAL_PAGE);
181                    }
182    
183                    // 騾壼ｸｸ縺ｮ LDAPQuery 蜃ｦ逅?
184                    if( check( command, COMMAND_LIST ) ) {
185                            useMainTrans( isMainTrans );                    // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
186                            startQueryTransaction( tableId );               // 3.6.0.8 (2004/11/19)
187    
188                            DBTableModel table = makeDBTable();
189    
190                            // 3.6.0.8 (2004/11/19) 繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
191                            if( ! commitTableObject( tableId, table ) ) {
192                                    jspPrint( "LDAPQueryTag Query蜃ｦ逅?′蜑ｲ繧願ｾｼ縺ｾ繧後∪縺励◆縲?BTableModel 縺ｯ逋ｻ骭ｲ縺励∪縺帙ｓ縲? );
193                                    return (SKIP_PAGE);
194                            }
195                            StringBuilder buf = new StringBuilder( HybsSystem.BUFFER_SMALL );
196    
197                            // 螳溯｡御ｻｶ謨ｰ縺ｮ陦ｨ遉ｺ command="NEW" 縺ｮ縺ｨ縺阪?縺ｿ縲‥isplayMsg 繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
198                            // 4.0.0 (2005/11/30) 蜃ｺ蜉幃?縺ｮ螟画峩縲ゆｸ?分譛??縺ｫ蜃ｺ蜉帙＠縺ｾ縺吶?
199                            if( CMD_NEW.equals( command ) ) {
200                                    if( executeCount > 0 && displayMsg != null && displayMsg.length() > 0 ) {
201                                            buf.append( executeCount );
202                                            buf.append( getResource().getLabel( displayMsg ) );
203                                            buf.append( HybsSystem.BR );
204                                    }
205                                    else if( executeCount == 0 && notfoundMsg != null && notfoundMsg.length() > 0 ) {
206                                            buf.append( getResource().getLabel( notfoundMsg ) );
207                                            buf.append( HybsSystem.BR );
208                                    }
209                            }
210    
211                            if( maxRowCount > 0 && maxRowCount <= executeCount ) {
212                                    buf.append( getResource().getLabel( overflowMsg ) );
213                                    buf.append( HybsSystem.BR ).append( HybsSystem.CR );
214                            }
215                            // 4.3.1.1 (2008/09/03) 讀懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ縲√お繝ｩ繝ｼ繧ｳ繝ｼ繝峨ｒ繧ｻ繝?ヨ縺吶ｋ縲?
216                            setRequestAttribute( "DB.COUNT" , String.valueOf( executeCount ) );
217                            setRequestAttribute( "DB.ERR_CODE", String.valueOf( errCode ) );
218    
219                            jspPrint( buf.toString() );
220                    }
221    
222                    return(EVAL_PAGE);
223            }
224    
225            /**
226             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
227             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
228             *
229             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
230             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
231             * @og.rev 4.2.2.0 (2008/05/10) password 霑ｽ蜉?
232             * @og.rev 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??縲．BTableModel縺梧眠隕丈ｽ懈?縺輔ｌ縺溷?逅?〒縺ｮ縺ｿ陦後≧縲?
233             *
234             */
235            @Override
236            protected void release2() {
237                    super.release2();
238    
239                    searchScope                     = HybsSystem.sys( "LDAP_SEARCH_SCOPE" );        // 讀懃ｴ｢遽?峇縲０BJECT_SCOPE縲＾NELEVEL_SCOPE縲ヾUBTREE_SCOPE 縺ｮ縺ｩ繧後° 1 縺､
240                    timeLimit                       = 0;                    // 邨先棡縺瑚ｿ斐＆繧後ｋ縺ｾ縺ｧ縺ｮ繝溘Μ遘呈焚縲? 縺ｮ蝣ｴ蜷医?辟｡蛻ｶ髯?
241                    derefLinkFlag           = false;                // true 縺ｮ蝣ｴ蜷医?讀懃ｴ｢荳ｭ縺ｫ繝ｪ繝ｳ繧ｯ繧帝俣謗･蜿ら?縺吶ｋ
242                    returningObjFlag        = false;                // true 縺ｮ蝣ｴ蜷医?繧ｨ繝ｳ繝医Μ縺ｮ蜷榊燕縺ｫ繝舌う繝ｳ繝峨＆繧後◆繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐☆縲Ｇalse 蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐＆縺ｪ縺?
243                    attrs                           = null;                 // 繧ｨ繝ｳ繝医Μ縺ｨ荳?ｷ偵↓霑斐＆繧後ｋ螻樊?縺ｮ隴伜挨蟄舌?null 縺ｮ蝣ｴ蜷医?縺吶∋縺ｦ縺ｮ螻樊?繧定ｿ斐☆縲らｩｺ縺ｮ蝣ｴ蜷医?螻樊?繧定ｿ斐＆縺ｪ縺?
244                    columns                         = null;                 // DBTableModel 繧剃ｽ懈?縺吶ｋ蝣ｴ蜷医?繧ｫ繝ｩ繝?錐縺ｫ縺ｪ繧翫∪縺吶?null 縺ｮ蝣ｴ蜷医?縲∥ttributes 螻樊?
245    
246                    initctx                         = HybsSystem.sys( "LDAP_INITIAL_CONTEXT_FACTORY" );
247                    providerURL             = HybsSystem.sys( "LDAP_PROVIDER_URL" );
248                    entrydn                         = HybsSystem.sys( "LDAP_ENTRYDN" );
249                    password                        = HybsSystem.sys( "LDAP_PASSWORD" );            // 4.2.2.0 (2008/05/10)
250                    searchbase                      = HybsSystem.sys( "LDAP_SEARCH_BASE" );
251                    filter                          = null;         // "employeeNumber=87019";
252    
253                    tableId                         = HybsSystem.TBL_MDL_KEY;       // session?ｷ?ｰ
254                    orderBy                         = null;                 // ?ｿ?ｰ???逶ｮ(csv)
255                    command                         = CMD_NEW;              // ?ｺ?擾ｾ晢ｾ?ｾ?
256                    executeCount            = 0;                    // 讀懃ｴ｢/螳溯｡御ｻｶ謨ｰ
257                    errCode                         = ErrorMessage.OK; // Ver4.3.1.1 (2008/09/05) 讀懃ｴ｢繧ｨ繝ｩ繝ｼ繧ｳ繝ｼ繝?
258                    maxRowCount                     = 0;                    // 譛?､ｧ讀懃ｴ｢謨ｰ(0縺ｯ辟｡蛻ｶ髯?
259    //              displayMsg              = "MSG0033";    // 莉ｶ讀懃ｴ｢縺励∪縺励◆縲?
260                    displayMsg                      = HybsSystem.sys( "VIEW_DISPLAY_MSG" );
261                    overflowMsg             = "MSG0007";    // 讀懃ｴ｢邨先棡縺後?蛻ｶ髯占｡梧焚繧定ｶ?∴縺ｾ縺励◆縺ｮ縺ｧ縲∵ｮ九ｊ縺ｯ繧ｫ繝?ヨ縺輔ｌ縺ｾ縺励◆縲?        */
262                    notfoundMsg                     = "MSG0077";    // 蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆縲?
263                    isMainTrans                     = true;                 // 5.1.6.0 (2010/05/01) DBLastSql縺ｮ蜃ｦ逅??隕狗峩縺?
264            }
265    
266            /**
267             * LDPA 縺九ｉ縲∝?繧貞叙繧雁?縺励?DBTableModel 繧剃ｽ懈?縺励∪縺吶?
268             *
269             * @og.rev 4.2.2.0 (2008/05/10) entrydn 縺ｨ縲｝assword 蜃ｦ逅??霑ｽ蜉?
270             *
271             * @return      繝??繝悶Ν繝｢繝?Ν
272             */
273            private DBTableModel makeDBTable() {
274                    if( filter == null ) {
275                            String errMsg = "S讀懃ｴ｢繝輔ぅ繝ｫ繧ｿ繝ｼ縺ｫ null 縺梧欠螳壹＆繧後∪縺励◆縲? ;
276                            throw new HybsSystemException( errMsg );
277                    }
278    
279                    LDAPSearch serch = new LDAPSearch();
280                    serch.setSearchScope( searchScope ) ;
281                    serch.setTimeLimit( timeLimit ) ;
282                    serch.setDerefLinkFlag( derefLinkFlag ) ;
283                    serch.setReturningObjFlag( returningObjFlag ) ;
284                    serch.setMaxRowCount( maxRowCount ) ;
285                    serch.setAttributes( attrs ) ;
286                    serch.setInitctx( initctx ) ;
287                    serch.setProviderURL( providerURL ) ;
288                    serch.setSearchbase( searchbase ) ;
289                    if( entrydn != null  ) { serch.setEntrydn( entrydn ) ; }        //4 .2.2.0 (2008/05/10)
290                    if( password != null ) { serch.setPassword( password ) ; }      //4 .2.2.0 (2008/05/10)
291                    serch.setOrderBy( orderBy ) ;
292                    serch.init();
293    
294                    List<String[]> list = serch.search( filter );
295                    executeCount = list.size();
296    
297    //              DBTableModel table = DBTableModelUtil.newDBTable();
298                    String[] ids = serch.getAttributes();   // attrs 縺?null 縺ｮ蝣ｴ蜷医?蜈ｨ莉ｶ縲ゅ◎繧御ｻ･螟悶?縲∥ttrs
299    
300                    // DBTableModel 縺ｫ菴ｿ逕ｨ縺吶ｋ繧ｫ繝ｩ繝?錐縺ｮ逋ｻ骭ｲ
301                    if( columns != null && columns.length > 0 ) {
302                            if( ids.length != columns.length ) {
303                                    String errMsg = "attributes 螻樊?縺ｨcolumns螻樊?縺ｮ蛟区焚縺檎焚縺ｪ繧翫∪縺吶?"
304                                                            + "attrs=[" + attrs.length + "]:" + StringUtil.array2csv( attrs )
305                                                            + HybsSystem.CR
306                                                            + " columns=[" + columns.length + "]:" + StringUtil.array2csv( columns )
307                                                            + HybsSystem.CR ;
308                                    throw new HybsSystemException( errMsg );
309                            }
310                            for( int i=0; i<columns.length; i++ ) {
311                                    // columns 縺ｫ繧ｫ繝ｩ繝?錐縺瑚ｨｭ螳壹＆繧後※縺?ｋ蝣ｴ蜷医?縺ｿ縲∽ｽｿ逕ｨ縺吶ｋ縲?
312                                    if( columns[i] != null && columns[i].length() > 0 ) {
313                                            ids[i] = columns[i];
314                                    }
315                            }
316                    }
317    
318                    DBTableModel table = null;
319                    if( ids.length > 0 ) {
320                            table = DBTableModelUtil.newDBTable();
321                            table.init( ids.length );
322                            for( int clm=0; clm<ids.length; clm++ ) {
323                                    DBColumn dbColumn = getResource().makeDBColumn( ids[clm] );
324                                    table.setDBColumn( clm,dbColumn );
325                            }
326    
327                            for( int row=0; row<executeCount; row++ ) {
328                                    table.addColumnValues( list.get( row ) );
329                            }
330                    }
331                    return table ;
332            }
333    
334            /**
335             * 縲慎AG縲第､懃ｴ｢遽?峇(OBJECT/ONELEVEL/SUBTREE)繧定ｨｭ螳壹＠縺ｾ縺?
336             *              (蛻晄悄蛟､:LDAP_SEARCH_SCOPE[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_SCOPE}])縲?
337             *
338             * @og.tag
339             * 讀懃ｴ｢遽?峇繧?OBJECT_SCOPE縲＾NELEVEL_SCOPE縲ヾUBTREE_SCOPE 縺ｮ縺ｩ繧後° 1 縺､縺ｧ縺吶?
340             * 謖?ｮ壽枚蟄怜?縺ｯ縲√◎繧後◇繧後?OBJECT縲上?ONELEVEL縲上?SUBTREE縲上〒縺吶?
341             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_SEARCH_SCOPE[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_SCOPE}])縲?
342             *
343             * @param       scope SearchControls 縺ｮ讀懃ｴ｢遽?峇
344             * @see         org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_SCOPE
345             */
346            public void setSearchScope( final String scope ) {
347                    searchScope = nval( getRequestParameter( scope ), searchScope );
348            }
349    
350            /**
351             * 縲慎AG縲代％繧後ｉ縺ｮ SearchControls 縺ｮ譎る俣蛻ｶ髯舌ｒ繝溘Μ遘貞腰菴阪〒險ｭ螳壹＠縺ｾ縺?蛻晄悄蛟､:0[辟｡蛻ｶ髯疹)縲?
352             *
353             * @og.tag
354             * 蛟､縺?0 縺ｮ蝣ｴ蜷医?辟｡蛻ｶ髯舌↓蠕?▽縺薙→繧呈э蜻ｳ縺励∪縺吶?
355             *
356             * @param       limit 繝溘Μ遘貞腰菴阪?譎る俣蛻ｶ髯?蛻晄悄蛟､:辟｡蛻ｶ髯?
357             */
358            public void setTimeLimit( final String limit ) {
359                    timeLimit = nval( getRequestParameter( limit ), timeLimit );
360            }
361    
362            /**
363             * 縲慎AG縲第､懃ｴ｢荳ｭ縺ｮ繝ｪ繝ｳ繧ｯ縺ｸ縺ｮ髢捺磁蜿ら?繧呈怏蜉ｹ縺ｾ縺溘?辟｡蜉ｹ[true/false]縺ｫ縺励∪縺?蛻晄悄蛟､:false)縲?
364             *
365             * @og.tag 讀懃ｴ｢荳ｭ縺ｮ繝ｪ繝ｳ繧ｯ縺ｸ縺ｮ髢捺磁蜿ら?繧呈怏蜉ｹ縺ｾ縺溘?辟｡蜉ｹ縺ｫ縺励∪縺吶?
366             *
367             * @param       deref 繝ｪ繝ｳ繧ｯ繧帝?蜿ら?縺吶ｋ蝣ｴ蜷医? true縲√◎縺?〒縺ｪ縺??蜷医? false(蛻晄悄蛟､:false)
368             */
369            public void setDerefLinkFlag( final String deref ) {
370                    derefLinkFlag = nval( getRequestParameter( deref ), derefLinkFlag );
371            }
372    
373            /**
374             * 縲慎AG縲醍ｵ先棡縺ｮ荳?Κ縺ｨ縺励※繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ霑斐☆縺薙→繧呈怏蜉ｹ縺ｾ縺溘?辟｡蜉ｹ[true/false]縺ｫ縺励∪縺?蛻晄悄蛟､:false)縲?
375             *
376             * @og.tag
377             * 辟｡蜉ｹ縺ｫ縺励◆蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕縺翫ｈ縺ｳ繧ｯ繝ｩ繧ｹ縺?￠縺瑚ｿ斐＆繧後∪縺吶?
378             * 譛牙柑縺ｫ縺励◆蝣ｴ蜷医?繧ｪ繝悶ず繧ｧ繧ｯ繝医′霑斐＆繧後∪縺吶?
379             *
380             * @param       pbjflag 繧ｪ繝悶ず繧ｧ繧ｯ繝医′霑斐＆繧後ｋ蝣ｴ蜷医? true縲√◎縺?〒縺ｪ縺??蜷医? false(蛻晄悄蛟､:false)
381             */
382            public void setReturningObjFlag( final String pbjflag ) {
383                    returningObjFlag = nval( getRequestParameter( pbjflag ), returningObjFlag );
384            }
385    
386            /**
387             * 縲慎AG縲代Ξ繧ｸ繧ｹ繝医Μ縺ｮ譛?､ｧ讀懃ｴ｢莉ｶ謨ｰ繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:0[辟｡蛻ｶ髯疹)縲?
388             *
389             * @og.tag
390             * DBTableModel縺ｮ繝??繧ｿ縺ｨ縺励※逋ｻ骭ｲ縺吶ｋ譛?､ｧ莉ｶ謨ｰ繧偵％縺ｮ蛟､縺ｫ險ｭ螳壹＠縺ｾ縺吶?
391             * 繧ｵ繝ｼ繝舌?縺ｮ繝｡繝｢繝ｪ雉?ｺ舌→蠢懃ｭ疲凾髢薙?遒ｺ菫昴?轤ｺ縺ｧ縺吶?
392             * 蛻晄悄蛟､縺ｯ縲? 縺ｯ縲∫┌蛻ｶ髯舌〒縺吶?
393             *
394             * @param       count 繝ｬ繧ｸ繧ｹ繝医Μ縺ｮ譛?､ｧ讀懃ｴ｢莉ｶ謨ｰ
395             */
396            public void setMaxRowCount( final String count ) {
397                    maxRowCount = nval( getRequestParameter( count ),maxRowCount );
398            }
399    
400            /**
401             * 縲慎AG縲第､懃ｴ｢縺ｮ荳?Κ縺ｨ縺励※霑斐＆繧後ｋ螻樊?繧辰SV縺ｧ隍?焚謖?ｮ壹＠縺ｾ縺吶?
402             *
403             * @og.tag
404             * null 縺ｯ螻樊?縺御ｽ輔ｂ霑斐＆繧後↑縺?％縺ｨ繧堤､ｺ縺励∪縺吶?
405             * 縺薙?繝｡繧ｽ繝?ラ縺九ｉ縺ｯ縲∫ｩｺ縺ｮ驟榊?繧偵そ繝?ヨ縺吶ｋ縺薙→縺ｯ蜃ｺ譚･縺ｾ縺帙ｓ縲?
406             *
407             * @og.rev 3.5.6.2 (2004/07/05) 蜈医↓驟榊?縺ｫ蛻?ｧ｣縺励※縺九ｉ繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ蛟､繧貞叙蠕?
408             * @og.rev 3.7.0.4 (2005/03/18) 繝ｪ繧ｯ繧ｨ繧ｹ繝亥､画焚縺ｮ蛟､繧貞叙蠕怜ｾ後?蛻?ｧ｣縺励∪縺吶?
409             *
410             * @param       val 霑斐＆繧後ｋ螻樊?繧定ｭ伜挨縺吶ｋ螻樊? ID 縺ｮ鄒??(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
411             */
412            public void setAttributes( final String val ) {
413                    String att = nval( getRequestParameter( val ),null );
414                    if( att != null ) {
415                            attrs = StringUtil.csv2Array( att );
416                    }
417            }
418    
419            /**
420             * 縲慎AG縲台ｽ懈?縺吶ｋ DBTableModel 縺ｮ繧ｫ繝ｩ繝?錐繧辰SV蠖｢蠑上〒謖?ｮ壹＠縺ｾ縺吶?
421             *
422             * @og.tag
423             * 縺ｪ縺ｫ繧よ欠螳壹＠縺ｪ縺??蜷医?縲∥ttributes 螻樊?縺御ｽｿ逕ｨ縺輔ｌ縺ｾ縺吶?
424             * LDAP讀懃ｴ｢邨先棡縺ｫ縲∝挨蜷阪ｒ縺､縺代ｋ繧､繝｡繝ｼ繧ｸ縺ｧ菴ｿ逕ｨ縺励∪縺吶?
425             *
426             * @og.rev 3.7.1.0 (2005/04/26) 譁ｰ隕剰ｿｽ蜉?
427             *
428             * @param       clm 菴懈?縺吶ｋ DBTableModel 縺ｮ繧ｫ繝ｩ繝?錐(繧ｫ繝ｳ繝槫玄蛻?ｊ譁?ｭ?
429             */
430            public void setColumns( final String clm ) {
431                    String cl = nval( getRequestParameter( clm ),null );
432                    if( cl != null ) {
433                            columns = StringUtil.csv2Array( cl );
434                    }
435            }
436    
437            /**
438             * 縲慎AG縲大?譛溘さ繝ｳ繝?く繧ｹ繝医ヵ繧｡繧ｯ繝医Μ繧呈欠螳壹＠縺ｾ縺?
439             *              (蛻晄悄蛟､:LDAP_INITIAL_CONTEXT_FACTORY[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_INITIAL_CONTEXT_FACTORY}])縲?
440             *
441             * @og.tag
442             * 萓?com.sun.jndi.ldap.LdapCtxFactory
443             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_INITIAL_CONTEXT_FACTORY[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_INITIAL_CONTEXT_FACTORY}])縲?
444             *
445             * @param       ctx 蛻晄悄繧ｳ繝ｳ繝?く繧ｹ繝医ヵ繧｡繧ｯ繝医Μ
446             * @see         org.opengion.hayabusa.common.SystemData#LDAP_INITIAL_CONTEXT_FACTORY
447             */
448            public void setInitctx( final String ctx ) {
449                    initctx = nval( getRequestParameter( ctx ), initctx );
450            }
451    
452            /**
453             * 縲慎AG縲代し繝ｼ繝薙せ繝励Ο繝舌う繝??讒区?諠??繧呈欠螳壹＠縺ｾ縺?
454             *              (蛻晄悄蛟､:LDAP_PROVIDER_URL[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_PROVIDER_URL}])縲?
455             *
456             * @og.tag
457             * 繝励Ο繝医さ繝ｫ縺ｨ繧ｵ繝ｼ繝舌?縺ｨ繝昴?繝医ｒ謖?ｮ壹＠縺ｾ縺吶?
458             * 萓?縲四dap://ldap.opengion.org:389縲?
459             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_PROVIDER_URL[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_PROVIDER_URL}])縲?
460             *
461             * @param       url 繧ｵ繝ｼ繝薙せ繝励Ο繝舌う繝??讒区?諠??
462             * @see         org.opengion.hayabusa.common.SystemData#LDAP_PROVIDER_URL
463             */
464            public void setProviderURL( final String url ) {
465                    providerURL = nval( getRequestParameter( url ), providerURL );
466            }
467    
468            /**
469             * 縲慎AG縲第､懃ｴ｢縺吶ｋ繧ｳ繝ｳ繝?く繧ｹ繝医∪縺溘?繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕繧定ｨｭ螳壹＠縺ｾ縺?
470             *              (蛻晄悄蛟､:LDAP_SEARCH_BASE[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_BASE}])縲?
471             *
472             * @og.tag
473             * 萓?縲市oOUID=employeeuser,o=opengion,c=JP縲?
474             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_SEARCH_BASE[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_BASE}])縲?
475             *
476             * @param       base 讀懃ｴ｢繝吶?繧ｹ
477             * @see         org.opengion.hayabusa.common.SystemData#LDAP_SEARCH_BASE
478             */
479            public void setSearchbase( final String base ) {
480                    searchbase = nval( getRequestParameter( base ), searchbase );
481            }
482    
483            /**
484             * 縲慎AG縲第､懃ｴ｢縺ｫ菴ｿ逕ｨ縺吶ｋ繝輔ぅ繝ｫ繧ｿ蠑?萓具ｼ喘elongOUID=61200)縲?
485             *
486             * @og.tag
487             * 萓?縲暫elongOUID=61200縲?
488             *
489             * @param       siki 繝輔ぅ繝ｫ繧ｿ蠑?
490             */
491            public void setFilter( final String siki ) {
492                    filter = nval( getRequestParameter( siki ), filter );
493            }
494    
495            /**
496             * 縲慎AG縲大ｱ樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕繧定ｨｭ螳壹＠縺ｾ縺?
497             *              (蛻晄悄蛟､:LDAP_ENTRYDN[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_ENTRYDN}])縲?
498             *
499             * @og.tag
500             * 萓?縲市oOUID=opengion-sys,o=opengion,c=JP縲?
501             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_ENTRYDN[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_ENTRYDN}])縲?
502             *
503             * @og.rev 4.2.2.0 (2008/05/10) 蛻晄悄蛟､螟画峩
504             *
505             * @param       dn 蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?蜷榊燕
506             * @see         org.opengion.hayabusa.common.SystemData#LDAP_ENTRYDN
507             */
508            public void setEntrydn( final String dn ) {
509                    entrydn = nval( getRequestParameter( dn ), entrydn );
510            }
511    
512            /**
513             * 縲慎AG縲大ｱ樊?縺ｮ蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝代せ繝ｯ繝ｼ繝峨ｒ險ｭ螳壹＠縺ｾ縺?
514             *              (蛻晄悄蛟､:LDAP_PASSWORD[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_PASSWORD}])縲?
515             *
516             * @og.tag
517             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮLDAP_PASSWORD[={@og.value org.opengion.hayabusa.common.SystemData#LDAP_PASSWORD}])縲?
518             *
519             * @og.rev 4.2.2.0 (2008/05/10) 譁ｰ隕剰ｿｽ蜉?
520             *
521             * @param       pwd 蜿門ｾ怜?縺ｮ繧ｪ繝悶ず繧ｧ繧ｯ繝医?繝代せ繝ｯ繝ｼ繝?
522             * @see         org.opengion.hayabusa.common.SystemData#LDAP_PASSWORD
523             */
524            public void setPassword( final String pwd ) {
525                    password = nval( getRequestParameter( pwd ), password );
526            }
527    
528            /**
529             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)邨先棡縺ｮDBTableModel繧偵?session縺ｫ逋ｻ骭ｲ縺吶ｋ縺ｨ縺阪?繧ｭ繝ｼ繧呈欠螳壹＠縺ｾ縺?
530             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
531             *
532             * @og.tag
533             * 讀懃ｴ｢邨先棡繧医ｊ縲．BTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?縺薙ｌ繧偵?荳区ｵ√?view繧ｿ繧ｰ遲峨↓
534             * 貂｡縺吝?蜷医↓縲??蟶ｸ縺ｯ縲《ession 繧貞茜逕ｨ縺励∪縺吶?縺昴?蝣ｴ蜷医?逋ｻ骭ｲ繧ｭ繝ｼ縺ｧ縺吶?
535             * query 繧ｿ繧ｰ繧貞酔譎ゅ↓螳溯｡後＠縺ｦ縲∫ｵ先棡繧呈ｱゅａ繧句?蜷医?蜷御ｸ?Γ繝｢繝ｪ縺ｫ驟咲ｽｮ縺輔ｌ繧狗ぜ縲?
536             * 縺薙? tableId 螻樊?繧貞茜逕ｨ縺励※縲√Γ繝｢繝ｪ遨ｺ髢薙ｒ蛻?￠縺ｾ縺吶?
537             *              (蛻晄悄蛟､:HybsSystem#TBL_MDL_KEY[={@og.value org.opengion.hayabusa.common.HybsSystem#TBL_MDL_KEY}])縲?
538             *
539             * @param       id session縺ｫ逋ｻ骭ｲ縺吶ｋ譎ゅ? ID
540             */
541            public void setTableId( final String id ) {
542                    tableId = nval( getRequestParameter( id ), tableId );
543            }
544    
545            /**
546             * 縲慎AG縲第､懃ｴ｢縺励◆邨先棡繧定｡ｨ遉ｺ縺吶ｋ陦ｨ遉ｺ鬆?ｒ繝輔ぃ繧､繝ｫ螻樊?蜷阪〒謖?ｮ壹＠縺ｾ縺吶?
547             *
548             * @og.tag
549             * attributes 螻樊?縺ｧ謖?ｮ壹☆繧九く繝ｼ縲√∪縺溘?縲´DAP縺九ｉ霑斐＆繧後◆繧ｭ繝ｼ縺ｫ縺､縺?※
550             * 縺昴?螻樊?縺ｧ繧ｽ繝ｼ繝医＠縺ｾ縺吶?騾??繧定｡後≧蝣ｴ蜷医?縲．ESC 繧呈欠螳壹?繧ｫ繝ｩ繝?錐縺ｮ蠕後ｍ縺ｫ
551             * 莉倥￠縺ｦ荳九＆縺??
552             *
553             * @param       ordr    繧ｽ繝ｼ繝医く繝ｼ繧呈欠螳壹?
554             */
555            public void setOrderBy( final String ordr ) {
556                    orderBy = nval( getRequestParameter( ordr ), orderBy );
557                    if( orderBy != null ) { orderBy = orderBy.toUpperCase(Locale.JAPAN) ; }
558            }
559    
560            /**
561             * 縲慎AG縲代さ繝槭Φ繝?NEW,RENEW)繧偵そ繝?ヨ縺励∪縺?蛻晄悄蛟､:NEW)縲?
562             *
563             * @og.tag
564             * 繧ｳ繝槭Φ繝峨?,HTML縺九ｉ(get/post)謖?ｮ壹＆繧後∪縺吶?縺ｧ,CMD_xxx 縺ｧ險ｭ螳壹＆繧後ｋ
565             * 繝輔ぅ繝ｼ繝ｫ繝牙ｮ壽焚蛟､縺ｮ縺?▼繧後°繧偵?謖?ｮ壹〒縺阪∪縺吶?
566             * 菴輔ｂ險ｭ螳壹＆繧後↑縺??縺ｾ縺溘?縲］ull 縺ｮ蝣ｴ蜷医?縲?NEW" 縺悟?譛溷?縺ｫ繧ｻ繝?ヨ縺輔ｌ縺ｾ縺吶?
567             *
568             * @param       cmd 繧ｳ繝槭Φ繝?public static final 螳｣險?＆繧後※縺?ｋ譁?ｭ怜?)
569             * @see         <a href="../../../../constant-values.html#org.opengion.hayabusa.taglib.LDAPQueryTag.CMD_NEW">繧ｳ繝槭Φ繝牙ｮ壽焚</a>
570             */
571            public void setCommand( final String cmd ) {
572                    String cmd2 = getRequestParameter( cmd );
573                    if( cmd2 != null && cmd2.length() > 0 ) { command = cmd2.toUpperCase(Locale.JAPAN); }
574            }
575    
576            /**
577             * 縲慎AG縲第､懃ｴ｢邨先棡繧堤判髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､縺ｯ讀懃ｴ｢莉ｶ謨ｰ)縲?
578             *
579             * @og.tag
580             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺ｮ莉ｶ謨ｰ繧?匳骭ｲ縺輔ｌ縺滉ｻｶ謨ｰ繧偵∪縺壼?蜉帙＠縲?
581             * 縺昴?谺｡縺ｫ縲√％縺薙〒謖?ｮ壹＠縺溘Γ繝?そ繝ｼ繧ｸ繧偵Μ繧ｽ繝ｼ繧ｹ縺九ｉ蜿門ｾ励＠縺ｦ
582             * 陦ｨ遉ｺ縺励∪縺吶?
583             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, displayMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
584             * 蛻晄悄蛟､縺ｯ縲∵､懃ｴ｢莉ｶ謨ｰ繧定｡ｨ遉ｺ縺励∪縺吶?
585             *
586             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
587             */
588            public void setDisplayMsg( final String id ) {
589                    displayMsg = getRequestParameter( id );
590            }
591    
592            /**
593             * 縲慎AG縲第､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸ繝ｪ繧ｽ繝ｼ繧ｹID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆])縲?
594             *
595             * @og.tag
596             * 縺薙％縺ｧ縺ｯ縲∵､懃ｴ｢邨先棡縺後ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ縲∫音蛻･縺ｪ繝｡繝?そ繝ｼ繧ｸ繧定｡ｨ遉ｺ縺輔○縺ｾ縺吶?
597             * 蠕捺擂縺ｯ縲‥isplayMsg 縺ｨ蜈ｼ逕ｨ縺ｧ縲√?0縲?ｻｶ讀懃ｴ｢縺励∪縺励◆縲上→縺?≧陦ｨ遉ｺ縺ｧ縺励◆縺後?
598             * displayMsg 縺ｮ蛻晄悄陦ｨ遉ｺ縺ｯ縲＾FF 縺ｫ縺ｪ繧翫∪縺励◆縺ｮ縺ｧ縲√ぞ繝ｭ莉ｶ縺ｮ蝣ｴ蜷医?縺ｿ蛻･縺ｫ陦ｨ遉ｺ縺輔○縺ｾ縺吶?
599             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, notfoundMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
600             * 蛻晄悄蛟､縺ｯ縲｀SG0077[蟇ｾ雎｡繝??繧ｿ縺ｯ縺ゅｊ縺ｾ縺帙ｓ縺ｧ縺励◆]縺ｧ縺吶?
601             *
602             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
603             */
604            public void setNotfoundMsg( final String id ) {
605                    String ids = getRequestParameter( id );
606                    if( ids != null ) { notfoundMsg = ids; }
607            }
608    
609            /**
610             * 縲慎AG縲代が繝ｼ繝舌?繝輔Ο繝ｼ譎ゅ↓逕ｻ髱｢荳翫↓陦ｨ遉ｺ縺吶ｋ繝｡繝?そ繝ｼ繧ｸID繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:MSG0007)縲?
611             *
612             * @og.tag
613             * 陦ｨ遉ｺ縺輔○縺溘￥縺ｪ縺??蜷医?, overflowMsg = "" 繧偵そ繝?ヨ縺励※縺上□縺輔＞縲?
614             *
615             * @param       id 繝?ぅ繧ｹ繝励Ξ繧､縺ｫ陦ｨ遉ｺ縺輔○繧九Γ繝?そ繝ｼ繧ｸ ID
616             */
617            public void setOverflowMsg( final String id ) {
618                    overflowMsg = getRequestParameter( id );
619            }
620    
621            /**
622             * 縲慎AG縲?騾壼ｸｸ菴ｿ縺?∪縺帙ｓ)繧ｿ繧ｰ縺ｧ蜃ｦ逅?＆繧後ｋ蜃ｦ逅?′繝｡繧､繝ｳ縺ｨ縺ｪ繧九ヨ繝ｩ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ蜃ｦ逅?°縺ｩ縺?°繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)縲?
623             *
624             * @og.tag
625             * 縺薙?蛟､縺ｯ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅?↓蠖ｱ髻ｿ縺励∪縺吶?縺薙?蛟､縺荊rue縺ｫ謖?ｮ壹＆繧後◆譎ゅ↓commit縺輔ｌ縺櫂BTableModel縺?
626             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨?蟇ｾ雎｡縺ｮ陦ｨ縺ｫ縺ｪ繧翫∪縺吶?
627             *
628             * 縺薙?繝代Λ繝｡繝ｼ繧ｿ繝ｼ縺ｯ縲??蟶ｸ縲∝推繧ｿ繧ｰ縺ｫ繧医ｊ螳溯｣?＆繧後?繝ｦ繝ｼ繧ｶ繝ｼ縺梧欠螳壹☆繧句ｿ?ｦ√?縺ゅｊ縺ｾ縺帙ｓ縲?
629             * 菴?＠縲?縺､縺ｮJSP蜀?〒DBTableModel縺瑚､?焚逕滓?縺輔ｌ繧句?蜷医↓縲∝燕縺ｫ蜃ｦ逅?＠縺櫂BTableModel縺ｫ縺､縺?※繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨ｒ縺輔○縺溘＞
630             * 蝣ｴ蜷医?縲∝ｾ後ｍ縺ｧDBTableModel繧堤函謌舌☆繧九ち繧ｰ縺ｧ縲∵?遉ｺ逧?↓縺薙?蛟､繧断alse縺ｫ謖?ｮ壹☆繧九％縺ｨ縺ｧ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝牙?逅??蟇ｾ雎｡縺九ｉ
631             * 髯､螟悶☆繧九％縺ｨ縺後〒縺阪∪縺吶?
632             *
633             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
634             *
635             * @param  flag 繝｡繧､繝ｳ繝医Λ繝ｳ繧ｶ繧ｯ繧ｷ繝ｧ繝ｳ縺九←縺?°
636             */
637            public void setMainTrans( final String flag ) {
638                    isMainTrans = nval( getRequestParameter( flag ),isMainTrans );
639            }
640    
641            /**
642             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
643             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
644             *
645             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
646             */
647            @Override
648            public String toString() {
649                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
650                                    .println( "VERSION"                             ,VERSION                )
651                                    .println( "initctx"                     ,initctx                )
652                                    .println( "providerURL"                 ,providerURL    )
653                                    .println( "entrydn"                     ,entrydn                )
654                                    .println( "searchbase"                  ,searchbase             )
655                                    .println( "filter"                              ,filter                 )
656                                    .println( "searchScope"                 ,searchScope    )
657                                    .println( "COUNTLIMIT"                  ,COUNTLIMIT             )
658                                    .println( "timeLimit"                   ,timeLimit              )
659                                    .println( "attrs"                               ,attrs                  )
660                                    .println( "columns"                             ,columns                )
661                                    .println( "returningObjFlag"    ,returningObjFlag)
662                                    .println( "derefLinkFlag"               ,derefLinkFlag  )
663                                    .println( "tableId"                     ,tableId                )
664                                    .println( "orderBy"                             ,orderBy                )
665                                    .println( "command"                             ,command                )
666                                    .println( "executeCount"                ,executeCount   )
667                                    .println( "errCode"                             ,errCode                )
668                                    .println( "maxRowCount"                 ,maxRowCount    )
669                                    .println( "displayMsg"                  ,displayMsg     )
670                                    .println( "overflowMsg"                 ,overflowMsg    )
671                                    .println( "Other..."                    ,getAttributes().getAttribute() )
672                                    .fixForm().toString() ;
673            }
674    }