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    /**
019     * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨い繧､繧ｳ繝ｳ蜃ｦ逅?↓蠢?ｦ√↑諠??繧呈?邏阪＠縺ｦ縺翫￥
020     * 繝??繧ｿ邂｡逅?け繝ｩ繧ｹ縺ｧ縺吶?
021     * fileUD 繧ｿ繧ｰ縺九ｉ縲…ommon/fileDownload.jsp 縺ｫ蜃ｦ逅?′驕ｷ遘ｻ縺励∪縺吶′縲?
022     * 縺昴?髢薙?DBTableModel 縺梧欠螳壹?逕ｻ髱｢縺ｧ菴懈?縺輔ｌ縺溘°縲√∪縺溘?view 縺ｧ
023     * 謖?ｮ壹＆繧後◆繧ｫ繝ｩ繝??縺ｿ繧呈栢縺榊?縺励※縺?ｋ縺九?繧ｹ繧ｳ繝ｼ繝励?縲√↑縺ｩ縺ｮ
024     * 繝√ぉ繝?け繧定｡後＞縺ｾ縺吶?
025     *
026     * @og.rev 4.3.0.0 (2008/07/04) 譁ｰ隕剰ｿｽ蜉?
027     *
028     * @version  4.0
029     * @author   Kazuhiko Hasegawa
030     * @since    JDK5.0,
031     */
032    public class DBLastSql  {
033            private String  scope   = null;
034            private final String  guikey ;          // 4.3.1.1 (2008/08/23) final蛹?
035            private final boolean overflow ;        // 4.3.1.1 (2008/08/23) final蛹?
036            private String  tableId = null;
037            private String  clmNames= null;
038            private String  viewClmNames= null;     // 5.1.6.0 (2010/05/01) 逕ｻ髱｢鬆?岼荳ｦ縺ｹ譖ｿ縺亥ｯｾ蠢?
039    
040    //      private boolean isViewEditable  =       true;   // 5.1.6.0 (2010/05/01) 逕ｻ髱｢鬆?岼荳ｦ縺ｹ譖ｿ縺亥ｯｾ蠢?
041            private boolean useViewEditable =       true;   // 5.1.6.0 (2010/05/01) 逕ｻ髱｢鬆?岼荳ｦ縺ｹ譖ｿ縺亥ｯｾ蠢?(螟画焚蜷榊､画峩)
042    
043            /**
044             * 蛻晄悄諠??繧貞性繧薙□譁ｰ隕上が繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
045             *
046             * @param    scope     繧ｹ繧ｳ繝ｼ繝?[session/request]
047             * @param    guikey    逕ｻ髱｢ID
048             * @param    overflow  讀懃ｴ｢譎ゅ↓繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ縺励◆縺九←縺?°
049             * @param    tableId   繝??繝悶ΝID(DBTableModel縺ｮ譬ｼ邏阪く繝ｼ)
050             */
051            public DBLastSql( final String scope,
052                                                    final String guikey,
053                                                    final boolean overflow,
054                                                    final String tableId ) {
055                    this.scope              = scope;
056                    this.guikey             = guikey;
057                    this.overflow   = overflow;
058                    this.tableId    = tableId;
059            }
060    
061            /**
062             * DBTableModel 繧貞?蜉帙☆繧九→縺阪?繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?繧偵そ繝?ヨ縺励∪縺吶?
063             *
064             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝画凾縺ｫ縲」iew 縺ｧ陦ｨ遉ｺ縺励◆蛻?□縺第栢縺榊?縺吝?蜷医?縲?
065             * 縺薙?繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｾ縺吶?
066             *
067             * @param    clmNames 繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?
068             */
069            public void setClmNames( final String clmNames ) {
070                    this.clmNames = clmNames;
071            }
072    
073            /**
074             *  DBTableModel 繧貞?蜉帙☆繧九→縺阪?繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?繧定ｿ斐＠縺ｾ縺吶?
075             *
076             * 繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝画凾縺ｫ縲」iew 縺ｧ陦ｨ遉ｺ縺励◆蛻?□縺第栢縺榊?縺吝?蜷医?縲?
077             * 縺薙?繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｾ縺吶?
078             *
079             * @return      繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?
080             */
081            public String getClmNames() { return clmNames; }
082    
083            /**
084             * 繧ｹ繧ｳ繝ｼ繝?session/request)繧偵そ繝?ヨ縺励∪縺吶?
085             *
086             * @param scope 繧ｹ繧ｳ繝ｼ繝?[session/request]
087             */
088            public void setScope( final String scope ) { this.scope = scope; }
089    
090            /**
091             * 繧ｹ繧ｳ繝ｼ繝?session/request)繧定ｿ斐＠縺ｾ縺吶?
092             *
093             * @og.rev 5.3.6.0 (2011/06/01) 譁ｰ隕丈ｽ懈?
094             *
095             * @return      繧ｹ繧ｳ繝ｼ繝?session/request)
096             */
097            public String getScope() { return scope; }
098    
099            /**
100             * 繧ｹ繧ｳ繝ｼ繝?session/request)縺後?request縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
101             *
102             * scope=="request" 縺ｮ蝣ｴ蜷医?縲．BTableModel 縺ｯ
103             * 繝｡繝｢繝ｪ縺ｫ谿九▲縺ｦ縺?∪縺帙ｓ縺ｮ縺ｧ縲?
104             * ?托ｼ取栢蜃ｺ繧｢繧､繧ｳ繝ｳ繧定｡ｨ遉ｺ縺励↑縺??
105             * ?抵ｼ四astSql 繧貞茜逕ｨ縺励※繝輔Ν縺ｮDBTableModel繧剃ｽ懈?縺励↑縺翫☆縲?
106             * 譁ｹ豕輔′閠?∴繧峨ｌ縺ｾ縺吶?
107             *
108             * @return      繧ｹ繧ｳ繝ｼ繝励′縲〉equest縺ｪ繧峨?true
109             */
110            public boolean isRequest() { return "request".equals( scope ); }
111    
112            /**
113             * 逕ｻ髱｢ID繧定ｿ斐＠縺ｾ縺吶?
114             *
115             * 縺薙?逕ｻ髱｢ID縺ｯ縲√ヵ繧｡繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨い繧､繧ｳ繝ｳ縺ｮ蟄伜惠縺励※縺?ｋ
116             * 逕ｻ髱｢縺ｨ蜷後§邂?園縺ｧ縲∽ｽ懈?縺輔ｌ縺溘°繧偵メ繧ｧ繝?け縺吶ｋ轤ｺ縺ｫ菴ｿ逕ｨ縺輔ｌ縺ｾ縺吶?
117             *
118             * @return      逕ｻ髱｢ID
119             */
120            public String getGuiKey() { return guikey; }
121    
122            /**
123             * 蜀?Κ逕ｻ髱｢ID縺ｨ遲峨＠縺?°蛻､螳壹＠縺ｾ縺吶?
124             *
125             * gamenId != null &amp;&amp; gamenId.equals( lastSql.getGuikey() )
126             * 蜃ｦ逅?→蜷檎ｭ峨〒縺吶?
127             *
128             * @param  gamenId 逕ｻ髱｢ID
129             *
130             * @return      蠑墓焚縺?null 縺ｧ縺ｪ縺上?荳斐▽蜀?Κ逕ｻ髱｢繧ｭ繝ｼ縺ｨ蜷後§蝣ｴ蜷医?縲》rue
131             */
132            public boolean isGuiMatch( final String gamenId ) {
133                    return ( gamenId != null && gamenId.equals( guikey ) );
134            }
135    
136            /**
137             * 讀懃ｴ｢譎ゅ↓繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ縺励◆縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
138             *
139             * 讀懃ｴ｢譎ゅ↓繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ縺励◆蝣ｴ蜷医?繝輔ぃ繧､繝ｫ繝?え繝ｳ繝ｭ繝ｼ繝峨→縺励※縲?
140             * ?托ｼ弱◎縺ｮ縺ｾ縺ｾ縲．BTableModel 縺ｮ蛻?□縺代ｒ謚懊″蜃ｺ縺吶?
141             * ?抵ｼ四astSql 繧貞茜逕ｨ縺励※繝輔Ν縺ｮDBTableModel繧剃ｽ懈?縺励↑縺翫☆縲?
142             * 譁ｹ豕輔′閠?∴繧峨ｌ縺ｾ縺吶?
143             *
144             * @return  繧ｪ繝ｼ繝舌?繝輔Ο繝ｼ縺励◆縺九←縺?°
145             */
146            public boolean isOverflow() { return overflow; }
147    
148            /**
149             *  繝??繝悶ΝID(DBTableModel縺ｮ譬ｼ邏阪く繝ｼ)繧偵そ繝?ヨ縺励∪縺吶?
150             *
151             * DBTableModel 繧貞叙繧雁?縺吶→縺阪↓菴ｿ逕ｨ縺励∪縺吶?
152             *
153             * @param       tableId 繝??繝悶ΝID(DBTableModel縺ｮ譬ｼ邏阪く繝ｼ)
154             */
155            public void setTableId( final String tableId ) { this.tableId = tableId; }
156    
157            /**
158             *  繝??繝悶ΝID(DBTableModel縺ｮ譬ｼ邏阪く繝ｼ)繧定ｿ斐＠縺ｾ縺吶?
159             *
160             * DBTableModel 繧貞叙繧雁?縺吶→縺阪↓菴ｿ逕ｨ縺励∪縺吶?
161             *
162             * @return      繝??繝悶ΝID(DBTableModel縺ｮ譬ｼ邏阪く繝ｼ)
163             */
164            public String getTableId() { return tableId; }
165    
166            /**
167             * 蜀?Κ繝??繝悶ΝID縲√せ繧ｳ繝ｼ繝励→遲峨＠縺?°蛻､螳壹＠縺ｾ縺吶?
168             *
169             * tableId != null &amp;&amp; tableId.equals( lastSql.getTableId() ) &amp;&amp;
170             * scope   != null &amp;&amp; scope.equals( lastSql.scope )
171             * 蜃ｦ逅?→蜷檎ｭ峨〒縺吶?
172             *
173             * @param  tableId 逕ｻ髱｢ID
174             * @param  scope   繧ｹ繧ｳ繝ｼ繝?
175             *
176             * @return      蠑墓焚縺?null 縺ｧ縺ｪ縺上?荳斐▽蜀?Κ繝??繝悶ΝID縲√せ繧ｳ繝ｼ繝励→蜷後§蝣ｴ蜷医?縲》rue
177             */
178            public boolean isTableMatch( final String tableId, final String scope ) {
179                    return ( tableId != null && tableId.equals( this.tableId ) ) &&
180                                    ( scope != null && scope.equals( this.scope ) );
181            }
182    
183            /**
184             * DBTableModel 繧貞?蜉帙☆繧九→縺阪?繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?繧偵そ繝?ヨ縺励∪縺吶?
185             *
186             * 逕ｻ髱｢鬆?岼荳ｦ縺ｳ譖ｿ縺域凾縺ｫ縲」iew 縺ｧ陦ｨ遉ｺ縺励◆蛻?□縺第栢縺榊?縺吝?蜷医?縲?
187             * 縺薙?繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｾ縺吶?
188             *
189             * 蟾ｦ蜿ｳ蛻?牡縺ｪ縺ｩ縺ｧView縺瑚､?焚蟄伜惠縺吶ｋ蝣ｴ蜷医?縲?|'繧貞玄蛻?ｊ譁?ｭ励→縺励※縺昴ｌ縺槭ｌ縺ｮView縺ｮ
190             * 繧ｫ繝ｩ繝?ｸ?ｦｧ縺後そ繝?ヨ縺励∪縺吶?
191             *  萓? AAA,BBB,CCC|DDD,EEE
192             *
193             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
194             *
195             * @param    clmNames 繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?|)
196             */
197            public void setViewClmNames( final String clmNames ) {
198                    this.viewClmNames = clmNames;
199            }
200    
201            /**
202             *  DBTableModel 繧貞?蜉帙☆繧九→縺阪?繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?繧定ｿ斐＠縺ｾ縺吶?
203             *
204             * 逕ｻ髱｢鬆?岼荳ｦ縺ｳ譖ｿ縺域凾縺ｫ縲」iew 縺ｧ陦ｨ遉ｺ縺励◆蛻?□縺第栢縺榊?縺吝?蜷医?縲?
205             * 縺薙?繧ｫ繝ｩ繝?錐繧呈欠螳壹＠縺ｾ縺吶?
206             *
207             * 蟾ｦ蜿ｳ蛻?牡縺ｪ縺ｩ縺ｧView縺瑚､?焚蟄伜惠縺吶ｋ蝣ｴ蜷医?縲?|'繧貞玄蛻?ｊ譁?ｭ励→縺励※縺昴ｌ縺槭ｌ縺ｮView縺ｮ
208             * 繧ｫ繝ｩ繝?ｸ?ｦｧ縺後そ繝?ヨ縺輔ｌ縺ｦ縺?∪縺吶?
209             *  萓? AAA,BBB,CCC|DDD,EEE
210             *
211             * @og.rev 5.1.6.0 (2010/05/01) 譁ｰ隕丈ｽ懈?
212             *
213             * @return      繧ｫ繝ｩ繝?錐(CSV蠖｢蠑?|)
214             */
215            public String getViewClmNames() { return viewClmNames; }
216    
217            /**
218             * 繝ｦ繝ｼ繧ｶ繝ｼ縺ｫ繧医ｋ逕ｻ髱｢鬆?岼縺ｮ荳ｦ縺ｳ譖ｿ縺医ｒ遖∵ｭ｢縺励∪縺吶?
219             */
220            public void setViewNotEditable() { this.useViewEditable = false; }
221    
222            /**
223             * 繝ｦ繝ｼ繧ｶ繝ｼ縺ｫ繧医ｋ逕ｻ髱｢鬆?岼縺ｮ荳ｦ縺ｳ譖ｿ縺医ｒ縺檎ｦ∵ｭ｢縺輔ｌ縺ｦ縺?ｋ縺九←縺?°繧定ｿ斐＠縺ｾ縺吶?
224             *
225             * @return      繝ｦ繝ｼ繧ｶ繝ｼ縺ｫ繧医ｋ逕ｻ髱｢鬆?岼縺ｮ荳ｦ縺ｳ譖ｿ縺医ｒ縺檎ｦ∵ｭ｢縺輔ｌ縺ｦ縺?ｋ縺九←縺?°
226             */
227            public boolean isViewEditable() { return useViewEditable; }
228    }