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.fukurou.util.Attributes;
020    
021    import java.util.List;
022    import java.util.ArrayList;
023    
024    /**
025     * and 繧ｿ繧ｰ縺ｧ謖?ｮ壹＆繧後◆譚｡莉ｶ繧貞?縺ｫ縲仝HERE蜿･繧剃ｽ懈?縺励∪縺吶?
026     *
027     * 蜷?ｱ樊?縺ｯ縲＋&#064;XXXX} 螟画焚縺御ｽｿ逕ｨ縺ｧ縺阪∪縺吶?
028     * 縺薙ｌ縺ｯ縲ヾervletRequest 縺九ｉ縲々XXX 繧偵く繝ｼ縺ｫ蛟､繧貞叙繧雁?縺?縺薙?螟画焚縺ｫ
029     * 蜑ｲ繧雁ｽ薙※縺ｾ縺吶?縺､縺ｾ繧翫?縺薙?XXXX繧偵く繝ｼ縺ｫ繝ｪ繧ｯ繧ｨ繧ｹ繝医☆繧後?縲?
030     * 縺薙?螟画焚縺ｫ蛟､繧偵そ繝?ヨ縺吶ｋ縺薙→縺後〒縺阪∪縺吶?
031     *
032     * @og.formSample
033     * 笳丞ｽ｢蠑擾ｼ?lt;og:where startKey="窶ｦ" &gt; &lt;og:and startKey="窶ｦ" ... /&gt; &lt;/og:where&gt;
034     * 笳獣ody?壹≠繧?EVAL_BODY_INCLUDE:BODY繧偵う繝ｳ繧ｯ繝ｫ繝ｼ繝峨＠縲＋&#064;XXXX} 縺ｯ隗｣譫舌＠縺ｾ縺帙ｓ)
035     *
036     * 笳週ag螳夂ｾｩ??
037     *   &lt;og:where
038     *       startKey           縲慎AG縲全QL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:where)
039     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
040     *   &gt;   ... Body ...
041     *   &lt;/og:where&gt;
042     *
043     * 笳丈ｽｿ逕ｨ萓?
044     *     &lt;og:query command="NEW"&gt;
045     *             select PN,YOBI,NMEN,HINM from XX01 where PN = '{&#064;PN}' order by PN
046     *     &lt;/og:query&gt;
047     *
048     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;PN}縺君OT NULL縺ｮ縺ｨ縺?
049     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = 'AAA' order by PN
050     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;PN}縺君ULL縺ｮ縺ｨ縺?
051     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 where PN = '' order by PN
052     *
053     *     &lt;og:query command="NEW"&gt;
054     *             select PN,YOBI,NMEN,HINM from XX01
055     *         &lt;og:where&gt;
056     *             &lt;og:and value="PN = '{&#064;PN}%'" /&gt;
057     *             &lt;og:and value="YOBI like '{&#064;YOBI}%'" /&gt;
058     *         &lt;/og:where&gt;
059     *             order by PN
060     *     &lt;/og:query&gt;
061     *
062     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;PN}縺君OT NULL縺ｮ縺ｨ縺?
063     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = 'AAA%' and YOBI like 'BBB%' order by PN
064     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;PN}縺君ULL縺ｮ縺ｨ縺? WHERE蜿･縺後↑縺上↑繧九?
065     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 order by PN
066     *
067     *        豕ｨ諢?WhereTag繧剃ｽｿ縺｣縺溷?蜷医?荳九?繧医≧縺ｫ縺ｯ縺ｪ繧翫∪縺帙ｓ縲?
068     *            select PN,YOBI,NMEN,HINM from XX01 PN = '' and YOBI like '%' order by PN
069     *
070     *     &lt;og:query command="NEW"&gt;
071     *             select PN,YOBI,NMEN,HINM from XX01 where PN="11111"
072     *         &lt;og:where startKey="and"&gt;
073     *             &lt;og:and value="YOBI like '{&#064;PN}%'" /&gt;
074     *         &lt;/og:where&gt;
075     *             order by PN
076     *     &lt;/og:query&gt;
077     *
078     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後◆譎?{&#064;YOBI}縺君OT NULL縺ｮ縺ｨ縺?
079     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = '11111' and YOBI like 'BBB%' order by PN
080     *          繝ｻ讀懃ｴ｢譚｡莉ｶ縺悟?蜉帙＆繧後↑縺九▲縺滓凾({&#064;YOBI}縺君ULL縺ｮ縺ｨ縺? WHERE蜿･縺後↑縺上↑繧九?
081     *            菴懈?縺輔ｌ繧鬼QL譁?∫select PN,YOBI,NMEN,HINM from XX01 PN = '11111' order by PN
082     *
083     * @og.group 逕ｻ髱｢驛ｨ蜩?
084     *
085     * @version  4.0
086     * @author       Kazuhiko Hasegawa
087     * @since    JDK5.0,
088     */
089    public class SqlWhereTag extends CommonTagSupport {
090            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
091            private static final String VERSION = "4.0.0.0 (2005/01/31)" ;
092    
093            private static final long serialVersionUID = 400020050131L ;
094    
095            private transient List<Attributes>        values          = null;
096    
097            private String  startKey        = "where";
098            private String  whereWord       = "";
099    
100            /**
101             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
102             *
103             * @return      蠕檎ｶ壼?逅??謖?､ｺ( EVAL_BODY_INCLUDE )
104             */
105            @Override
106            public int doStartTag() {
107                    return( EVAL_BODY_INCLUDE );    // Body 繧､繝ｳ繧ｯ繝ｫ繝ｼ繝? extends TagSupport 譎?
108            }
109    
110            /**
111             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
112             *
113             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
114             *
115             * @return      蠕檎ｶ壼?逅??謖?､ｺ
116             */
117            @Override
118            public int doEndTag() {
119                    debugPrint();           // 4.0.0 (2005/02/28)
120                    jspPrint( makeSqlWhere() );
121    
122                    return(EVAL_PAGE);
123            }
124    
125            /**
126             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
127             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
128             *
129             * @og.rev 2.0.0.4 (2002/09/27) 繧ｫ繧ｹ繧ｿ繝?ち繧ｰ縺ｮ release() 繝｡繧ｽ繝?ラ繧偵?霑ｽ蜉?
130             * @og.rev 3.1.1.2 (2003/04/04) Tomcat4.1 蟇ｾ蠢懊?release2() 繧?doEndTag()縺ｧ蜻ｼ縺ｶ縲?
131             *
132             */
133            @Override
134            protected void release2() {
135                    super.release2();
136                    values          = null;
137                    startKey        = "where";
138                    whereWord       = "";
139            }
140    
141            /**
142             * 蜀?Κ繧ｿ繧ｰ縺ｮ SqlAndTag / SqlAndTag 繧医ｊ縲∝?縲??繧ｫ繝ｩ繝??蛟､繧呈嶌縺肴鋤縺医ｋ
143             * 轤ｺ縺ｮ繧｢繝医Μ繝薙Η繝ｼ繝医ｒ蜿励￠蜿悶ｋ縲?
144             *
145             * 隍?焚縺ｮ蛟､繧貞女縺大叙縺｣縺ｦ縲∝ｾ後⊇縺ｩ縲√☆縺ｹ縺ｦ縺ｮ繧ｫ繝ｩ繝?↓蟇ｾ縺励※蜃ｦ逅?ｒ陦後＞縺ｾ縺吶?
146             *
147             * @og.rev 3.1.0.0 (2003/03/20) Vector 繧剃ｽｿ逕ｨ縺励※縺?ｋ邂?園縺ｧ縲?撼蜷梧悄縺ｧ繧よｧ九ｏ縺ｪ縺?ｮ?園繧偵?ArrayList 縺ｫ鄂ｮ謠帙∴縲?
148             * @og.rev 3.1.2.0 (2003/04/07) taglib 繝代ャ繧ｱ繝ｼ繧ｸ蜀?Κ縺ｧ菴ｿ逕ｨ縺励※縺?ｋ邂?園繧?protected 蛹悶☆繧九?
149             *
150             * @param   attri       螻樊?繝ｪ繧ｹ繝?
151             */
152            protected void setAttributes( final Attributes attri ) {
153                    if( values == null ) { values = new ArrayList<Attributes>(); }
154                    values.add( attri );
155            }
156    
157            /**
158             * 縲慎AG縲全QL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺?蛻晄悄蛟､:where)縲?
159             *
160             * @og.tag SQL譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ舌ｒ謖?ｮ壹＠縺ｾ縺吶?
161             *
162             * @param       skey 譚｡莉ｶ蜿･縺ｮ譛??縺ｮ貍皮ｮ怜ｭ?
163             */
164            public void setStartKey( final String skey ) {
165                    String key = getRequestParameter( skey );
166                    if( key != null && key.length() > 0 ) { startKey = key; }
167            }
168    
169            /**
170             * SqlAndTag / SqlOrTag 縺ｧ謖?ｮ壹＆繧後◆譚｡莉ｶ繧貞?縺ｫ縲仝HERE蜿･繧剃ｽ懈?縺励∪縺吶?
171             *
172             * @return      WHERE蜿･縺ｮ譁?ｭ怜?
173             */
174            private String makeSqlWhere() {
175                    StringBuilder rtn = new StringBuilder( HybsSystem.BUFFER_MIDDLE );
176                    if( values != null ) {
177                            for( int i=0; i<values.size(); i++ ) {
178                                    Attributes attri = values.get( i );
179                                    String keyWord = attri.get( "keyWord" );
180                                    String value   = attri.get( "value" );
181                                    if( rtn.length() == 0 ) { keyWord = this.startKey; }
182                                    rtn.append( " " );
183                                    rtn.append( keyWord );
184                                    rtn.append( " " );
185                                    rtn.append( value );
186                            }
187                    }
188                    rtn.append( " " );
189                    whereWord = rtn.toString();
190                    return whereWord;
191            }
192    
193            /**
194             * 繧ｿ繧ｰ縺ｮ蜷咲ｧｰ繧偵?霑斐＠縺ｾ縺吶?
195             * 閾ｪ蛻??霄ｫ縺ｮ繧ｯ繝ｩ繧ｹ蜷阪ｈ繧翫?閾ｪ蜍慕噪縺ｫ蜿悶ｊ蜃ｺ縺帙↑縺?◆繧√?縺薙?繝｡繧ｽ繝?ラ繧偵が繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
196             *
197             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕剰ｿｽ蜉?
198             *
199             * @return  繧ｿ繧ｰ縺ｮ蜷咲ｧｰ
200             */
201            @Override
202            protected String getTagName() {
203                    return "where" ;
204            }
205    
206            /**
207             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
208             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
209             *
210             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
211             */
212            @Override
213            public String toString() {
214                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
215                                    .println( "VERSION"                     ,VERSION        )
216                                    .println( "startKey"            ,startKey       )
217                                    .println( "whereWord"           ,whereWord      )
218                                    .println( "Other..."    ,getAttributes().getAttribute() )
219                                    .fixForm().toString() ;
220            }
221    }