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 java.sql.ResultSet;
019    import java.sql.ResultSetMetaData;
020    import java.sql.SQLException;
021    import java.sql.Types;
022    import java.util.Locale;
023    
024    import org.opengion.fukurou.db.DBUtil;
025    import org.opengion.fukurou.db.Transaction;
026    import org.opengion.fukurou.db.TransactionReal;
027    import org.opengion.fukurou.util.ApplicationInfo;
028    import org.opengion.fukurou.util.ErrorMessage;
029    import org.opengion.fukurou.util.StringUtil;
030    import org.opengion.hayabusa.common.HybsSystem;
031    import org.opengion.hayabusa.common.HybsSystemException;
032    import org.opengion.hayabusa.resource.LabelData;
033    import org.opengion.hayabusa.resource.ResourceManager;
034    
035    /**
036     * 繝??繧ｿ繝吶?繧ｹ髢｢騾｣縺ｮ萓ｿ蛻ｩ縺ｪ繝｡繧ｽ繝?ラ繧帝寔繧√◆邁｡譏薙Θ繝ｼ繝?ぅ繝ｪ繝?ぅ繝ｼ繧ｯ繝ｩ繧ｹ縺ｧ縺吶?
037     * 蜈ｨ縺ｦ縺ｮ繝｡繧ｽ繝?ラ縺ｯ縲《tatic 繝｡繧ｽ繝?ラ縺ｫ縺ｪ縺｣縺ｦ縺?∪縺吶?
038     *
039     * @og.rev 2.1.1.1 (2002/11/15) Serializable 繧､繝ｳ繧ｿ繝ｼ繝輔ぉ繝ｼ繧ｹ繧貞炎髯､縺吶ｋ縲?
040     * @og.rev 4.0.0.0 (2007/10/16) 蜷咲ｧｰ螟画峩(DBUtil 竍?DBTableModelUtil) DB繧｢繧ｯ繧ｻ繧ｹ髢｢菫ゅ?繝｡繧ｽ繝?ラ縺ｯfukurou/db/DBUtil縺ｫ遘ｻ蜍?
041     * @og.group ?､?｢/Shell蛻ｶ蠕｡
042     *
043     * @version  4.0
044     * @author   Kazuhiko Hasegawa
045     * @since    JDK5.0,
046     */
047    public final class DBTableModelUtil {
048            /**
049             * 繧､繝ｳ繧ｹ繧ｿ繝ｳ繧ｹ繧剃ｽ懊ｉ縺ｪ縺??縺ｧ縲√さ繝ｳ繧ｹ繝医Λ繧ｯ繧ｿ縺ｯ縲｝rivate 縺ｫ險ｭ螳壹＠縺ｾ縺吶?
050             */
051            private DBTableModelUtil() {}
052    
053            /**
054             * 蛻晄悄繝??繧ｿ繝吶?繧ｹ縺ｫ謗･邯壹＠縺ｦ縲＿uery繧貞ｮ溯｡後＠縺ｾ縺吶?
055             * 繧ｹ繝??繝医Γ繝ｳ繝医→蠑墓焚縺ｫ繧医ｊ縲￣repared 繧ｯ繧ｨ繝ｪ繝ｼ縺ｮ讀懃ｴ｢縺ｮ縺ｿ螳溯｡後＠縺ｾ縺吶?
056             * 邨先棡縺ｯ,DBTableModel 縺ｨ縺励※霑斐＆繧後∪縺吶?
057             *
058             * @og.rev 3.0.0.0 (2002/12/25) 譁ｰ隕剰ｿｽ蜉?
059             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
060             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
061             * @og.rev 4.0.0.0 (2007/10/10) dbid 縺ｮ蛻晄悄蛟､繧偵?"DEFAULT" 縺九ｉ null 縺ｫ螟画峩
062             *
063             * @param   stmt 繧ｹ繝??繝医Γ繝ｳ繝域枚蟄怜?
064             * @param   args 繧ｪ繝悶ず繧ｧ繧ｯ繝医?蠑墓焚驟榊?
065             * @param   resource 繝ｪ繧ｽ繝ｼ繧ｹ繝槭ロ繝ｼ繧ｸ繝｣繝ｼ
066             * @param   appInfo 繧｢繝励Μ諠??繧ｪ繝悶ず繧ｧ繧ｯ繝?
067             *
068             * @return  讀懃ｴ｢邨先棡縺ｮ驟榊?
069             */
070            public static DBTableModel makeDBTable( final String stmt ,final String[] args, final ResourceManager resource, final ApplicationInfo appInfo ) {
071    //              return makeDBTable( stmt ,args,resource,appInfo,"DEFAULT" );            // 4.0.0 (2005/01/31)
072                    return makeDBTable( stmt ,args,resource,appInfo,null );
073            }
074    
075            /**
076             * 讀懃ｴ｢縺吶ｋ繝??繧ｿ繝吶?繧ｹ繧呈欠螳壹＠縺ｦ縲＿uery繧貞ｮ溯｡後＠縺ｾ縺吶?
077             * 繧ｹ繝??繝医Γ繝ｳ繝医→蠑墓焚縺ｫ繧医ｊ縲￣repared 繧ｯ繧ｨ繝ｪ繝ｼ縺ｮ讀懃ｴ｢縺ｮ縺ｿ螳溯｡後＠縺ｾ縺吶?
078             * 邨先棡縺ｯ,DBTableModel 縺ｨ縺励※霑斐＆繧後∪縺吶?
079             * 讀懃ｴ｢莉･螟悶?SQL繧ょｮ溯｡後〒縺阪∪縺吶?邨先棡縺ｯ縲］ull 繧定ｿ斐＠縺ｾ縺吶?
080             *
081             * @og.rev 3.0.0.0 (2002/12/25) 譁ｰ隕剰ｿｽ蜉?
082             * @og.rev 3.0.0.1 (2003/02/14) 繝倥ャ繝??縲√ヵ繝?ち繝ｼ諠??縺?null 縺ｮ縺ｨ縺阪?蜃ｦ逅?ｿｽ蜉??
083             * @og.rev 3.5.6.0 (2004/06/18) null縺ｫ蟇ｾ縺吶ｋ辟｡鬧?↑豈碑ｼ?ｒ蜑企勁縺励∪縺吶?
084             * @og.rev 3.8.7.0 (2006/12/15) 繧｢繧ｯ繧ｻ繧ｹ繝ｭ繧ｰ蜿門ｾ励?轤ｺ,ApplicationInfo繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ險ｭ螳?
085             * @og.rev 4.0.0.0 (2005/01/31) lang 竍?ResourceManager 縺ｸ螟画峩
086             * @og.rev 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
087             * @og.rev 5.3.7.0 (2011/07/01) TransactionReal 縺ｮ蠑墓焚螟画峩
088             * @og.rev 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
089             *
090             * @param   stmt        繧ｹ繝??繝医Γ繝ｳ繝域枚蟄怜?
091             * @param   args        繧ｪ繝悶ず繧ｧ繧ｯ繝医?蠑墓焚驟榊?
092             * @param   resource 繝ｪ繧ｽ繝ｼ繧ｹ繝槭ロ繝ｼ繧ｸ繝｣繝ｼ
093             * @param   appInfo 繧｢繝励Μ諠??繧ｪ繝悶ず繧ｧ繧ｯ繝?
094             * @param   dbid        謗･邯壼?ID
095             *
096             * @return  讀懃ｴ｢邨先棡縺ｮ驟榊?
097             */
098            public static DBTableModel makeDBTable( final String stmt ,final String[] args ,
099                                                                                            final ResourceManager resource, final ApplicationInfo appInfo, final String dbid ) {
100                    if( stmt == null || stmt.length() == 0 ) { return null; }
101    
102                    DBTableModel table = null;
103    
104                    Query query = QueryFactory.newInstance( "JDBCPrepared" );
105    
106                    ErrorMessage errMessage = null;
107                    Transaction tran = null;
108                    try {
109    //                      Transaction tran = new TransactionReal( dbid,appInfo );         // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
110    //                      Transaction tran = new TransactionReal( appInfo );                      // 5.3.7.0 (2011/07/01) 蠑墓焚螟画峩
111                            tran = new TransactionReal( appInfo );                                          // 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
112                            query.setTransaction( dbid,tran );                                                      // 5.1.9.0 (2010/08/01) Transaction 蟇ｾ蠢?
113    //                      query.setConnectionID( dbid );
114                            query.setResourceManager( resource );   // 4.0.0 (2005/01/31)
115                            query.setStatement( stmt );
116                            query.execute( args );
117                            int errCode = query.getErrorCode();
118                            int executeCount = query.getExecuteCount();
119                            if( errCode < ErrorMessage.NG && executeCount >= 0 ) {            // 逡ｰ蟶ｸ莉･螟悶?蝣ｴ蜷?
120                                    table = query.getDBTableModel();
121    //                              if( query.getUpdateFlag() ) { query.commit(); }
122                                    if( query.isUpdate() ) { query.commit(); }
123                            }
124                            else {
125                                    errMessage = query.getErrorMessage();
126                            }
127                    }
128                    catch( HybsSystemException ex ) {
129                            if( query != null ) { query.rollback(); }
130                            throw ex;
131                    }
132                    finally {
133    //                      if( query != null ) { query.close(); }
134                            QueryFactory.close( query );
135                            if( tran != null ) { tran.close(); }            // 5.3.8.0 (2011/08/01) Transaction逋ｺ逕溽ｮ?園縺ｧclose()
136                    }
137    
138                    if( errMessage != null ) {
139                            throw new HybsSystemException( errMessage.toString() );
140                    }
141    
142                    return table;
143            }
144    
145            /**
146             * 遨ｺ縺ｮ DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
147             * 縺薙ｌ縺ｯ縲∵悽譚･縲√ヵ繧｡繧ｯ繝医Μ繧ｯ繝ｩ繧ｹ縺ｧ菴懈?縺吶∋縺阪〒縺吶′縲∫ｰ｡譏謎ｽ懈?繝｡繧ｽ繝?ラ縺ｨ縺励※
148             * DBUtil 縺ｮ static 繝｡繧ｽ繝?ラ縺ｨ縺励※螳溯｣?＠縺ｾ縺吶?
149             *
150             * @og.rev 4.0.0.0 (2005/01/31) 譁ｰ隕剰ｿｽ蜉?
151             *
152             * @return  DBTableModel繧ｪ繝悶ず繧ｧ繧ｯ繝?
153             */
154            public static DBTableModel newDBTable() {
155                    return new DBTableModelImpl();
156            }
157    
158            /**
159             * 繧ｫ繝ｩ繝?錐縺ｮ驟榊?蜿翫?繝??繧ｿ縺ｮ2谺｡蜈??蛻励°繧吋B繝??繝悶Ν繝｢繝?Ν繧剃ｽ懈?縺励∪縺吶?
160             * 繧ｫ繝ｩ繝?錐縺後そ繝?ヨ縺輔ｌ縺ｦ縺?↑縺?凶縺励￥縺ｯ繝??繧ｿ縺後そ繝?ヨ縺輔ｌ縺ｦ縺?↑縺??蜷医?縲］ull繧定ｿ斐＠縺ｾ縺吶?
161             *
162             * @og.rev 4.2.1.0 (2008/04/26) 譁ｰ隕剰ｿｽ蜉?
163             *
164             * @param   clms 繧ｫ繝ｩ繝?錐縺ｮ驟榊?
165             * @param   vals 蛟､縺ｮ驟榊?
166             * @param   resource 繝ｪ繧ｽ繝ｼ繧ｹ繝槭ロ繝ｼ繧ｸ繝｣繝ｼ
167             *
168             * @return  DB繝??繝悶Ν繝｢繝?Ν
169             */
170            public static DBTableModel makeDBTable( final String[] clms, final String[][] vals, final ResourceManager resource ) {
171                    if( clms == null || clms.length == 0
172                                    || vals == null || vals.length == 0 || vals[0] == null || vals[0].length == 0 ) {
173                            return null;
174                    }
175    
176                    if( clms.length != vals[0].length ) {
177    //                      throw new HybsSystemException( "繧ｭ繝ｼ縺ｮ繧ｫ繝ｩ繝?焚縺ｨ繝??繧ｿ縺ｮ繧ｫ繝ｩ繝?焚縺御ｸ??縺励※縺?∪縺帙ｓ" );
178                            String errMsg = "繧ｭ繝ｼ縺ｮ繧ｫ繝ｩ繝?焚縺ｨ繝??繧ｿ縺ｮ繧ｫ繝ｩ繝?焚縺御ｸ??縺励※縺?∪縺帙ｓ縲?
179                                                    + HybsSystem.CR
180                                                    + " clms.length=[" + clms.length + "]  vals.length=[" + vals[0].length + "]"
181                                                    + " clms=" + StringUtil.array2csv( clms ) + HybsSystem.CR
182                                                    + " vals=" + StringUtil.array2csv( vals[0] )  ; // 5.1.8.0 (2010/07/01) errMsg 菫ｮ豁｣
183                            throw new HybsSystemException( errMsg );
184                    }
185    
186                    int numberOfColumns = clms.length;
187                    DBTableModel table = newDBTable() ;
188                    table.init( numberOfColumns );
189    
190                    DBColumn[] dbColumn = new DBColumn[numberOfColumns];
191                    for( int column=0; column<numberOfColumns; column++ ) {
192                            dbColumn[column] = resource.makeDBColumn( clms[column] );
193                            table.setDBColumn( column,dbColumn[column] );
194                    }
195    
196                    int numberOfRows = vals.length;
197                    for( int row=0; row<numberOfRows; row++ ) {
198                            table.addColumnValues( vals[row] );
199                    }
200    
201                    return table;
202            }
203    
204            /**
205             * 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝医°繧吋B繝??繝悶Ν繝｢繝?Ν繧剃ｽ懈?縺励∪縺吶?
206             * 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝医∪縺溘?繝ｪ繧ｽ繝ｼ繧ｹ繧ｪ繝悶ず繧ｧ繧ｯ繝医′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?↑縺??蜷医?縲］ull繧定ｿ斐＠縺ｾ縺吶?
207             *
208             * @og.rev 5.3.6.0 (2011/06/01) 譁ｰ隕剰ｿｽ蜉?
209             * @og.rev 5.5.5.4 (2012/08/18) TIMESTAMP 蝙九ｂCLOB縺ｨ蜷梧ｧ倥↓蜃ｦ逅?ｒ蛻?￠繧九?
210             *
211             * @param   result 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝?
212             * @param   skipRowCount 隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ
213             * @param       maxRowCount 譛?､ｧ讀懃ｴ｢莉ｶ謨ｰ
214             * @param   resource 繝ｪ繧ｽ繝ｼ繧ｹ繝槭ロ繝ｼ繧ｸ繝｣繝ｼ
215             *
216             * @return  DB繝??繝悶Ν繝｢繝?Ν
217             * @throws      SQLException 繝??繧ｿ繝吶?繧ｹ繧｢繧ｯ繧ｻ繧ｹ繧ｨ繝ｩ繝ｼ
218             */
219            public static DBTableModel makeDBTable( final ResultSet result, final int skipRowCount, final int maxRowCount, final ResourceManager resource ) throws SQLException {
220                    if( result == null || resource == null ) { return null; }
221    
222                    ResultSetMetaData metaData      = result.getMetaData();
223    
224                    int numberOfColumns =  metaData.getColumnCount();
225    
226                    DBTableModel table = DBTableModelUtil.newDBTable() ;
227                    table.init( numberOfColumns );
228    
229                    // 鬆?岼蜷搾ｼ碁?逶ｮ繧ｿ繧､繝暦ｼ碁?逶ｮ繧ｵ繧､繧ｺ?梧嶌霎ｼ縺ｿ繝輔Λ繧ｰ繧定ｨｭ螳壹☆繧九?
230                    DBColumn[] dbColumn = new DBColumn[numberOfColumns];
231    
232                    // 3.8.5.0 (2006/03/02) CLOB/ROWID 縺ｪ縺ｩ縺ｮ繧ｫ繝ｩ繝?°縺ｩ縺?°繧貞愛螳壹＠縺ｾ縺吶?
233                    boolean   isOther = false;
234                    int[] types  = new int[numberOfColumns];
235    
236                    for( int column=0; column<numberOfColumns; column++ ) {
237                            String  name     = (metaData.getColumnLabel(column+1)).toUpperCase(Locale.JAPAN) ;
238                            dbColumn[column] = resource.getDBColumn( name );
239                            if( dbColumn[column] == null ) {
240                                    LabelData labelData  = resource.getLabelData( name );
241                                    dbColumn[column] = makeDBColumn( name,labelData,metaData,column,resource.getLang() );
242                            }
243                            table.setDBColumn( column,dbColumn[column] );
244    
245                            // 3.8.5.0 (2006/03/02) CLOB 繧ｫ繝ｩ繝?°縺ｩ縺?°繧貞愛螳壹＠縺ｾ縺吶?
246                            // 5.5.5.4 (2012/08/18) TIMESTAMP 蝙九ｂCLOB縺ｨ蜷梧ｧ倥↓蜃ｦ逅?ｒ蛻?￠繧九?
247    //                      types[column] = metaData.getColumnType(column+1);
248                            int clmType = metaData.getColumnType(column+1);
249                            types[column] = clmType;
250    //                      if( types[column] == Types.CLOB || types[column] == Types.ROWID ) {     // JDK 6.0莉･髯?ROWID
251                            if( clmType == Types.CLOB || clmType == Types.ROWID || clmType == Types.TIMESTAMP ) {   // JDK 6.0莉･髯?ROWID
252                                    isOther = true;
253                            }
254                    }
255    
256                    // 繝??繧ｿ驛ｨ縺ｮ險ｭ螳?
257                    int numberOfRows = 0;
258                    while( numberOfRows < skipRowCount && result.next() ) {
259                            // 豕ｨ諢?resultSet.next() 繧貞?縺ｫ蛻､螳壹☆繧九→蠢?★?台ｻｶ隱ｭ縺ｿ鬟帙?縺励※縺励∪縺??
260                            numberOfRows ++ ;
261                    }
262    //              resultSet.absolute( getSkipRowCount() );
263                    numberOfRows = 0;
264    
265                    // 3.8.5.1 (2006/05/08) 陦悟?縺ｮ繝ｫ繝ｼ繝励↑縺ｮ縺ｧ縲?CLOB 菴ｿ逕ｨ蜿ｯ蜷ｦ縺ｧ繝ｫ繝ｼ繝励ｒ蛻?￠繧九?
266                    if( isOther ) {
267                            while( numberOfRows < maxRowCount && result.next() ) {
268                                    numberOfRows ++ ;
269                                    String[] columnValues = new String[numberOfColumns];
270                                    for( int column=0; column<numberOfColumns; column++ ) {
271                                            // 5.3.6.0 (2011/06/01) 繝｡繧ｽ繝?ラ蛹?
272                                            columnValues[column] = DBUtil.getValue( result, column, types[column] );
273                                    }
274                                    table.addColumnValues( columnValues );
275                            }
276                    }
277                    else {
278                            while( numberOfRows < maxRowCount && result.next() ) {
279                                    numberOfRows ++ ;
280                                    String[] columnValues = new String[numberOfColumns];
281                                    for( int column=0; column<numberOfColumns; column++ ) {
282                                            Object obj = result.getObject(column+1);
283                                            columnValues[column] = ( obj == null ? "" : String.valueOf( obj ) );
284                                    }
285                                    table.addColumnValues( columnValues );
286                            }
287                    }
288    
289                    // 譛?､ｧ莉ｶ謨ｰ縺後?雜?∴縺溷?蜷医〒縺九▽谺｡縺ｮ繝??繧ｿ縺後≠繧句?蜷医?縲√が繝ｼ繝舌?繝輔Ο繝ｼ
290                    if( numberOfRows >= maxRowCount && result.next() ) {
291                            table.setOverflow( true );
292                    }
293    
294                    return table;
295            }
296    
297            /**
298             * 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝医°繧峨お繝?ぅ繝?ヨ險ｭ螳壹↓蝓ｺ縺･縺?※螟画鋤縺輔ｌ縺櫂B繝??繝悶Ν繝｢繝?Ν繧剃ｽ懈?縺励∪縺吶?
299             * 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝医∪縺溘?繝ｪ繧ｽ繝ｼ繧ｹ繧ｪ繝悶ず繧ｧ繧ｯ繝医∪縺溘?繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝医′繧ｻ繝?ヨ縺輔ｌ縺ｦ縺?↑縺??蜷医?縲］ull繧定ｿ斐＠縺ｾ縺吶?
300             *
301             * @og.rev 5.3.6.0 (2011/06/01) 譁ｰ隕剰ｿｽ蜉?
302             *
303             * @param   result 讀懃ｴ｢邨先棡繧ｪ繝悶ず繧ｧ繧ｯ繝?
304             * @param   skipRowCount 隱ｭ縺ｿ鬟帙?縺嶺ｻｶ謨ｰ
305             * @param       maxRowCount 譛?､ｧ讀懃ｴ｢莉ｶ謨ｰ
306             * @param   resource 繝ｪ繧ｽ繝ｼ繧ｹ繝槭ロ繝ｼ繧ｸ繝｣繝ｼ
307             * @param       config 繧ｨ繝?ぅ繝?ヨ險ｭ螳壹が繝悶ず繧ｧ繧ｯ繝?
308             *
309             * @return  DB繝??繝悶Ν繝｢繝?Ν
310             * @throws      SQLException 繝??繧ｿ繝吶?繧ｹ繧｢繧ｯ繧ｻ繧ｹ繧ｨ繝ｩ繝ｼ
311             */
312            public static DBTableModel makeEditDBTable( final ResultSet result, final int skipRowCount, final int maxRowCount, final ResourceManager resource, final DBEditConfig config ) throws SQLException {
313                    if( result == null || resource == null ) { return null; }
314                    DBTableModel table = new DBTableModelEditor();
315                    ((DBTableModelEditor)table).create( result, skipRowCount, maxRowCount, resource, config );
316                    return table;
317            }
318    
319            /**
320             * ResultSetMetaData 縺九ｉ縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺励∪縺吶?
321             *
322             * DBColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝?縺後Μ繧ｽ繝ｼ繧ｹ繝輔ぃ繧､繝ｫ縺ｫ螳夂ｾｩ縺輔ｌ縺ｦ縺?↑縺??蜷医↓縲?
323             * 繝??繧ｿ繝吶?繧ｹ縺ｮ讀懃ｴ｢邨先棡縺ｮ繝｡繧ｿ繝??繧ｿ繧貞茜逕ｨ縺励※縲．BColumn 繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ
324             * 菴懈?縺励∪縺吶?
325             *
326             * @og.rev 3.4.0.0 (2003/09/01) 陦ｨ遉ｺ繝代Λ繝｡繝ｼ繧ｿ縲∫ｷｨ髮?ヱ繝ｩ繝｡繝ｼ繧ｿ縲∵枚蟄励ヱ繝ｩ繝｡繝ｼ繧ｿ縺ｮ霑ｽ蜉??
327             * @og.rev 3.4.0.2 (2003/09/05) DBType 縺ｮ繝?ヵ繧ｩ繝ｫ繝亥?繧偵?'X' 縺九ｉ 'XK' 縺ｫ螟画峩縺励∪縺吶?
328             * @og.rev 3.6.0.7 (2004/11/06) DBColumn 縺ｮ official螻樊?霑ｽ蜉?
329             * @og.rev 4.0.0.0 (2005/01/31) lang 螟画焚繧貞叙蠕?
330             * @og.rev 5.3.6.0 (2011/06/01) AbstractQuery縺九ｉ遘ｻ蜍?
331             *
332             * @param       name            繧ｫ繝ｩ繝?錐
333             * @param       labelData       LabelData繧ｪ繝悶ず繧ｧ繧ｯ繝?
334             * @param       metaData        ResultSetMetaData繧ｪ繝悶ず繧ｧ繧ｯ繝?
335             * @param       column          繧ｫ繝ｩ繝?分蜿ｷ
336             * @param       lang            險?ｪ?
337             *
338             * @return      DBColumn繧ｪ繝悶ず繧ｧ繧ｯ繝?
339             */
340            public static DBColumn makeDBColumn( final String name,final LabelData labelData,
341                                                            final ResultSetMetaData metaData,final int column,final String lang ) {
342                    final DBColumn dbColumn ;
343    
344                    try {
345                            String  clsName  = type2ClassName( metaData.getColumnType(column+1) );
346                            int     size     = metaData.getColumnDisplaySize(column+1);
347                            if( size == 0 ) { size = 60; }
348                            boolean writable = metaData.isWritable(column+1);
349                            String  dbType   = ( "NUMBER".equals( clsName )) ? "S9" : "XK" ;
350                            String  defValue = ( "NUMBER".equals( clsName )) ? "0"  : ""  ;
351                            DBColumnConfig config = new DBColumnConfig(
352                                    lang,                                                   // 險?ｪ?
353                                    name,                                                   // 繧ｫ繝ｩ繝?錐
354                                    labelData,                                              // 繧ｫ繝ｩ繝??繝ｩ繝吶Ν繝??繧ｿ繧ｪ繝悶ず繧ｧ繧ｯ繝?
355                                    clsName ,                                               // 繧ｫ繝ｩ繝??繧ｯ繝ｩ繧ｹ繧呈枚蟄怜?縺ｫ縺励◆蜷咲ｧｰ
356                                    String.valueOf( size ) ,                // 繧ｫ繝ｩ繝??譁?ｭ玲｡∵焚
357                                    String.valueOf( writable ) ,    // 繧ｫ繝ｩ繝?′譖ｸ縺崎ｾｼ縺ｿ蜿ｯ閭ｽ縺九←縺?°
358                                    null ,                                                  // 繝??繧ｿ縺ｮ陦ｨ遉ｺ逕ｨ繝ｬ繝ｳ繝?Λ繝ｼ
359                                    null ,                                                  // 繝??繧ｿ縺ｮ邱ｨ髮?畑繧ｨ繝?ぅ繧ｿ繝ｼ
360                                    null ,                                                  // 繝｡繝九Η繝ｼ縺ｮ鬆?岼繧ｳ繝ｼ繝峨ョ繝ｼ繧ｿ繧ｪ繝悶ず繧ｧ繧ｯ繝?
361                                    dbType ,                                                // 繝??繧ｿ縺ｮ繧ｿ繧､繝?
362                                    defValue,                                               // 繝??繧ｿ縺ｮ繝?ヵ繧ｩ繝ｫ繝亥?
363                                    null ,                                                  // 陦ｨ遉ｺ逕ｨ繝ｬ繝ｳ繝?Λ繝ｼ縺ｮ繝代Λ繝｡繝ｼ繧ｿ
364                                    null ,                                                  // 邱ｨ髮?畑繧ｨ繝?ぅ繧ｿ繝ｼ縺ｮ繝代Λ繝｡繝ｼ繧ｿ
365                                    null ,                                                  // 繝??繧ｿ縺ｮ繧ｿ繧､繝励?繝代Λ繝｡繝ｼ繧ｿ
366                                    null ,                                                  // 繧ｫ繝ｩ繝?Ο繝ｼ繝ｫ
367                                    false,                                                  // 豁｣蠑上↑繧ｫ繝ｩ繝?が繝悶ず繧ｧ繧ｯ繝医°縺ｩ縺?°
368                                    null                                                    // 繝??繧ｿ繝吶?繧ｹ謗･邯壼?ID
369                            );
370    
371                            dbColumn = new DBColumn( config );              // 4.0.0 (2005/01/31)
372    
373                    }
374                    catch( SQLException ex ) {
375                            String errMsg = "DBColumn 繧剃ｽ懈?縺ｧ縺阪∪縺帙ｓ縺ｧ縺励◆縲Ｏame=[" + name + " , label=[" + labelData + "]";
376                            throw new HybsSystemException( errMsg,ex );             // 3.5.5.4 (2004/04/15) 蠑墓焚縺ｮ荳ｦ縺ｳ鬆?､画峩
377                    }
378                    catch( RuntimeException ex2 ) {
379                            String errMsg = "莠域悄縺帙〓繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺ｾ縺励◆縲Ｏame=[" + name + " , label=[" + labelData + "]";
380                            throw new HybsSystemException( errMsg,ex2 );            // 3.6.0.0 (2004/09/17)
381                    }
382    
383                    return dbColumn;
384            }
385    
386            /**
387             * 繧ｫ繝ｩ繝??繧ｿ繧､繝励ｒ陦ｨ迴ｾ縺吶ｋ譁?ｭ怜?蛟､繧定ｿ斐＠縺ｾ縺吶?
388             *
389             * 縺薙?譁?ｭ怜?繧堤畑縺?※縲，CS繝輔ぃ繧､繝ｫ縺ｧ繧ｿ繧､繝励＃縺ｨ縺ｮ陦ｨ遉ｺ譁ｹ豕輔ｒ
390             * 謖?ｮ壹☆繧九％縺ｨ縺後〒縺阪∪縺吶?
391             *
392             * @og.rev 2.1.1.1 (2002/11/15) 縺昴?莉悶?繧ｱ繝ｼ繧ｹ繧偵?VARCHAR2 繧定ｿ斐☆繧医≧縺ｫ菫ｮ豁｣縲?
393             * @og.rev 4.0.0.0 (2006/01/31) CLOB 繧定ｿｽ蜉?
394             * @og.rev 5.3.6.0 (2011/06/01) AbstractQuery縺九ｉ遘ｻ蜍?
395             * @og.rev 5.5.5.4 (2012/08/18) DECIMAL,TIMESTAMP 繧定ｿｽ蜉?
396             *
397             * @param       type 繧ｿ繧､繝礼分蜿ｷ
398             *
399             * @return      繧ｫ繝ｩ繝??繧ｿ繧､繝励ｒ陦ｨ迴ｾ縺吶ｋ譁?ｭ怜?蛟､
400             * @see         java.sql.Types
401             */
402            private static String type2ClassName( final int type ) {
403                    final String rtn ;
404    
405                    switch( type ) {
406                            case Types.CHAR:
407                            case Types.VARCHAR:
408                            case Types.BIT:
409                                    rtn = "VARCHAR2"; break;
410                            case Types.LONGVARCHAR:                 // 4.0.0 (2006/01/31)
411                                    rtn = "LONG"; break;
412                            case Types.TINYINT:
413                            case Types.SMALLINT:
414                            case Types.INTEGER:
415                            case Types.NUMERIC:
416                            case Types.BIGINT:
417                            case Types.FLOAT:
418                            case Types.DOUBLE:
419                            case Types.REAL:
420                            case Types.DECIMAL:                             // 5.5.5.4 (2012/08/18)
421                                    rtn = "NUMBER"; break;
422                            case Types.DATE:
423                            case Types.TIMESTAMP:                   // 5.5.5.4 (2012/08/18)
424                                    rtn = "DATE"; break;
425                            case Types.CLOB:                                // 4.0.0 (2006/01/31)
426                                    rtn = "CLOB"; break;
427                            default:
428                                    rtn = "NONE"; break;
429                    }
430    
431                    return rtn;
432            }
433    }