KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > mckoi > database > global > SQLTypes


1 /**
2  * com.mckoi.database.global.SQLTypes 01 Mar 2001
3  *
4  * Mckoi SQL Database ( http://www.mckoi.com/database )
5  * Copyright (C) 2000, 2001, 2002 Diehl and Associates, Inc.
6  *
7  * This program is free software; you can redistribute it and/or
8  * modify it under the terms of the GNU General Public License
9  * Version 2 as published by the Free Software Foundation.
10  *
11  * This program is distributed in the hope that it will be useful,
12  * but WITHOUT ANY WARRANTY; without even the implied warranty of
13  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14  * GNU General Public License Version 2 for more details.
15  *
16  * You should have received a copy of the GNU General Public License
17  * Version 2 along with this program; if not, write to the Free Software
18  * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
19  *
20  * Change Log:
21  *
22  *
23  */
24
25 package com.mckoi.database.global;
26
27 /**
28  * A JDBC independant type definition list. This allows the specification of
29  * all JDBC 1.0 and 2.0 types without requiring the JDBC 2.0
30  * 'java.sql.Types' interface.
31  * <p>
32  * The values are compatible with the JDBC 1.0 and 2.0 spec.
33  *
34  * @author Tobias Downer
35  */
36
37 public interface SQLTypes {
38
39   public final static int BIT = -7;
40
41   public final static int TINYINT = -6;
42
43   public final static int SMALLINT = 5;
44
45   public final static int INTEGER = 4;
46
47   public final static int BIGINT = -5;
48
49   public final static int FLOAT = 6;
50
51   public final static int REAL = 7;
52
53   public final static int DOUBLE = 8;
54
55   public final static int NUMERIC = 2;
56
57   public final static int DECIMAL = 3;
58
59   public final static int CHAR = 1;
60
61   public final static int VARCHAR = 12;
62
63   public final static int LONGVARCHAR = -1;
64
65   public final static int DATE = 91;
66
67   public final static int TIME = 92;
68
69   public final static int TIMESTAMP = 93;
70
71   public final static int BINARY = -2;
72
73   public final static int VARBINARY = -3;
74
75   public final static int LONGVARBINARY = -4;
76
77   public final static int NULL = 0;
78
79   public final static int OTHER = 1111;
80
81   public final static int JAVA_OBJECT = 2000;
82
83   public final static int DISTINCT = 2001;
84         
85   public final static int STRUCT = 2002;
86
87   public final static int ARRAY = 2003;
88
89   public final static int BLOB = 2004;
90
91   public final static int CLOB = 2005;
92
93   public final static int REF = 2006;
94
95   public final static int BOOLEAN = 16;
96   
97 }
98
Popular Tags