1
2
3
4
5
6
7
8
9
10
11
12
13
14
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
24
25 public class JdbcTypeRegistry {
26
27
28 public static final int UNKNOWN_TYPE = -99999999;
29
30
31 private static final Map<String, Integer> TYPE_MAP = new HashMap<>();
32
33
34
35
36 public static final int JDBC_30_DATALINK = 70;
37
38
39
40
41 public static final int JDBC_30_BOOLEAN = 16;
42
43 static {
44 initializeTypes();
45 }
46
47
48
49
50 private JdbcTypeRegistry() {
51 }
52
53
54
55
56
57
58
59
60
61 public static void setType(String name, int value) {
62 TYPE_MAP.put(name, Integer.valueOf(value));
63 }
64
65
66
67
68
69
70
71
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
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 }