author | František Kučera <franta-hg@frantovo.cz> |
Wed, 24 Sep 2014 22:53:30 +0200 | |
branch | v_0 |
changeset 178 | 5a5fc66f11b1 |
parent 155 | eb3676c6929b |
permissions | -rw-r--r-- |
68
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
1 |
/** |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
2 |
* SQL-DK |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
3 |
* Copyright © 2013 František Kučera (frantovo.cz) |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
4 |
* |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
5 |
* This program is free software: you can redistribute it and/or modify |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
6 |
* it under the terms of the GNU General Public License as published by |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
7 |
* the Free Software Foundation, either version 3 of the License, or |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
8 |
* (at your option) any later version. |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
9 |
* |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
10 |
* This program is distributed in the hope that it will be useful, |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
13 |
* GNU General Public License for more details. |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
14 |
* |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
15 |
* You should have received a copy of the GNU General Public License |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
16 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
17 |
*/ |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
18 |
package info.globalcode.sql.dk; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
19 |
|
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
20 |
import java.sql.Types; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
21 |
|
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
22 |
/** |
155 | 23 |
* Data types of SQL parameters. |
68
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
24 |
* |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
25 |
* @author Ing. František Kučera (frantovo.cz) |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
26 |
*/ |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
27 |
public enum SQLType { |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
28 |
|
93
5a4dbe6f962c
Type names in --types option are case insensitive
František Kučera <franta-hg@frantovo.cz>
parents:
92
diff
changeset
|
29 |
/** |
5a4dbe6f962c
Type names in --types option are case insensitive
František Kučera <franta-hg@frantovo.cz>
parents:
92
diff
changeset
|
30 |
* Names must be upper case – user input is also converted to upper case → case insensitive |
5a4dbe6f962c
Type names in --types option are case insensitive
František Kučera <franta-hg@frantovo.cz>
parents:
92
diff
changeset
|
31 |
*/ |
92
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
32 |
BIT(Types.BIT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
33 |
TINYINT(Types.TINYINT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
34 |
SMALLINT(Types.SMALLINT), |
68
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
35 |
INTEGER(Types.INTEGER), |
92
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
36 |
BIGINT(Types.BIGINT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
37 |
FLOAT(Types.FLOAT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
38 |
REAL(Types.REAL), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
39 |
DOUBLE(Types.DOUBLE), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
40 |
NUMERIC(Types.NUMERIC), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
41 |
DECIMAL(Types.DECIMAL), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
42 |
CHAR(Types.CHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
43 |
VARCHAR(Types.VARCHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
44 |
LONGVARCHAR(Types.LONGVARCHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
45 |
DATE(Types.DATE), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
46 |
TIME(Types.TIME), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
47 |
TIMESTAMP(Types.TIMESTAMP), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
48 |
BINARY(Types.BINARY), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
49 |
VARBINARY(Types.VARBINARY), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
50 |
LONGVARBINARY(Types.LONGVARBINARY), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
51 |
NULL(Types.NULL), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
52 |
OTHER(Types.OTHER), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
53 |
JAVA_OBJECT(Types.JAVA_OBJECT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
54 |
DISTINCT(Types.DISTINCT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
55 |
STRUCT(Types.STRUCT), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
56 |
ARRAY(Types.ARRAY), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
57 |
BLOB(Types.BLOB), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
58 |
CLOB(Types.CLOB), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
59 |
REF(Types.REF), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
60 |
DATALINK(Types.DATALINK), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
61 |
BOOLEAN(Types.BOOLEAN), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
62 |
ROWID(Types.ROWID), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
63 |
NCHAR(Types.NCHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
64 |
NVARCHAR(Types.NVARCHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
65 |
LONGNVARCHAR(Types.LONGNVARCHAR), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
66 |
NCLOB(Types.NCLOB), |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
67 |
SQLXML(Types.SQLXML); |
1399ac70a5bd
support all types from java.sql.Types.Types
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
68 |
/** value from java.sql.Types */ |
68
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
69 |
private int code; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
70 |
|
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
71 |
private SQLType(int code) { |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
72 |
this.code = code; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
73 |
} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
74 |
|
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
75 |
/** |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
76 |
* @see java.sql.Types.Types |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
77 |
*/ |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
78 |
public int getCode() { |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
79 |
return code; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
80 |
} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
81 |
|
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
82 |
/** |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
83 |
* @param code see {@linkplain java.sql.Types.Types} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
84 |
* @return found SQLType |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
85 |
* @throws IllegalArgumentException if no data type has given code |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
86 |
*/ |
146
4f4f515df807
BatchDecoder: basic decoder
František Kučera <franta-hg@frantovo.cz>
parents:
93
diff
changeset
|
87 |
public static SQLType valueOf(int code) { |
68
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
88 |
for (SQLType t : values()) { |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
89 |
if (t.code == code) { |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
90 |
return t; |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
91 |
} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
92 |
} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
93 |
throw new IllegalArgumentException("No data type has code: " + code); |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
94 |
} |
574cd7fbb5b2
SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
95 |
} |