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