View Javadoc
1   /*
2    * Copyright 2004-2025 the original author or authors.
3    *
4    * Licensed under the Apache License, Version 2.0 (the "License");
5    * you may not use this file except in compliance with the License.
6    * You may obtain a copy of the License at
7    *
8    *    https://www.apache.org/licenses/LICENSE-2.0
9    *
10   * Unless required by applicable law or agreed to in writing, software
11   * distributed under the License is distributed on an "AS IS" BASIS,
12   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   * See the License for the specific language governing permissions and
14   * limitations under the License.
15   */
16  package com.ibatis.sqlmap.engine.type;
17  
18  import java.sql.Types;
19  import java.util.HashMap;
20  import java.util.Map;
21  
22  /**
23   * Singleton.
24   */
25  public class JdbcTypeRegistry {
26  
27    /** Value for the unknown type. */
28    public static final int UNKNOWN_TYPE = -99999999;
29  
30    /** The Constant TYPE_MAP. */
31    private static final Map<String, Integer> TYPE_MAP = new HashMap<>();
32  
33    /**
34     * Value for a JDBC 3.o datalink type
35     */
36    public static final int JDBC_30_DATALINK = 70;
37  
38    /**
39     * Value for a JDBC 3.o boolean type
40     */
41    public static final int JDBC_30_BOOLEAN = 16;
42  
43    static {
44      initializeTypes();
45    }
46  
47    /**
48     * Instantiates a new jdbc type registry.
49     */
50    private JdbcTypeRegistry() {
51    }
52  
53    /**
54     * Sets the type.
55     *
56     * @param name
57     *          the name
58     * @param value
59     *          the value
60     */
61    public static void setType(String name, int value) {
62      TYPE_MAP.put(name, Integer.valueOf(value));
63    }
64  
65    /**
66     * Looks up a type by name, and returns it's int value (from java.sql.Types)
67     *
68     * @param name
69     *          - the type name
70     *
71     * @return - the int value (from java.sql.Types)
72     */
73    public static int getType(String name) {
74      if (name == null) {
75        return UNKNOWN_TYPE;
76      }
77      Integer i = TYPE_MAP.get(name);
78      if (i != null) {
79        return i.intValue();
80      }
81      return UNKNOWN_TYPE;
82    }
83  
84    /**
85     * Initialize types.
86     */
87    private static void initializeTypes() {
88      setType("ARRAY", Types.ARRAY);
89      setType("BIGINT", Types.BIGINT);
90      setType("BINARY", Types.BINARY);
91      setType("BIT", Types.BIT);
92      setType("BLOB", Types.BLOB);
93      setType("BOOLEAN", JDBC_30_BOOLEAN);
94      setType("CHAR", Types.CHAR);
95      setType("CLOB", Types.CLOB);
96      setType("DATALINK", JDBC_30_DATALINK);
97      setType("DATE", Types.DATE);
98      setType("DECIMAL", Types.DECIMAL);
99      setType("DISTINCT", Types.DISTINCT);
100     setType("DOUBLE", Types.DOUBLE);
101     setType("FLOAT", Types.FLOAT);
102     setType("INTEGER", Types.INTEGER);
103     setType("JAVA_OBJECT", Types.JAVA_OBJECT);
104     setType("LONGVARBINARY", Types.LONGVARBINARY);
105     setType("LONGVARCHAR", Types.LONGVARCHAR);
106     setType("NULL", Types.NULL);
107     setType("NUMERIC", Types.NUMERIC);
108     setType("OTHER", Types.OTHER);
109     setType("REAL", Types.REAL);
110     setType("REF", Types.REF);
111     setType("SMALLINT", Types.SMALLINT);
112     setType("STRUCT", Types.STRUCT);
113     setType("TIME", Types.TIME);
114     setType("TIMESTAMP", Types.TIMESTAMP);
115     setType("TINYINT", Types.TINYINT);
116     setType("VARBINARY", Types.VARBINARY);
117     setType("VARCHAR", Types.VARCHAR);
118 
119     setType("CH", Types.CHAR);
120     setType("VC", Types.VARCHAR);
121 
122     setType("DT", Types.DATE);
123     setType("TM", Types.TIME);
124     setType("TS", Types.TIMESTAMP);
125 
126     setType("NM", Types.NUMERIC);
127     setType("II", Types.INTEGER);
128     setType("BI", Types.BIGINT);
129     setType("SI", Types.SMALLINT);
130     setType("TI", Types.TINYINT);
131 
132     setType("DC", Types.DECIMAL);
133     setType("DB", Types.DOUBLE);
134     setType("FL", Types.FLOAT);
135 
136     setType("ORACLECURSOR", -10);
137 
138   }
139 
140 }