Java tutorial
/* * Copyright (c) 1996, 2014, Oracle and/or its affiliates. All rights reserved. * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * This code is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License version 2 only, as * published by the Free Software Foundation. Oracle designates this * particular file as subject to the "Classpath" exception as provided * by Oracle in the LICENSE file that accompanied this code. * * This code is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License * version 2 for more details (a copy is included in the LICENSE file that * accompanied this code). * * You should have received a copy of the GNU General Public License version * 2 along with this work; if not, write to the Free Software Foundation, * Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA. * * Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA * or visit www.oracle.com if you need additional information or have any * questions. */ package java.sql; /** * <P>The class that defines the constants that are used to identify generic * SQL types, called JDBC types. * <p> * This class is never instantiated. * * @since 1.1 */ public class Types { /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>BIT</code>. */ public final static int BIT = -7; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>TINYINT</code>. */ public final static int TINYINT = -6; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>SMALLINT</code>. */ public final static int SMALLINT = 5; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>INTEGER</code>. */ public final static int INTEGER = 4; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>BIGINT</code>. */ public final static int BIGINT = -5; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>FLOAT</code>. */ public final static int FLOAT = 6; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>REAL</code>. */ public final static int REAL = 7; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>DOUBLE</code>. */ public final static int DOUBLE = 8; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>NUMERIC</code>. */ public final static int NUMERIC = 2; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>DECIMAL</code>. */ public final static int DECIMAL = 3; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>CHAR</code>. */ public final static int CHAR = 1; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>VARCHAR</code>. */ public final static int VARCHAR = 12; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>LONGVARCHAR</code>. */ public final static int LONGVARCHAR = -1; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>DATE</code>. */ public final static int DATE = 91; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>TIME</code>. */ public final static int TIME = 92; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>TIMESTAMP</code>. */ public final static int TIMESTAMP = 93; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>BINARY</code>. */ public final static int BINARY = -2; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>VARBINARY</code>. */ public final static int VARBINARY = -3; /** * <P>The constant in the Java programming language, sometimes referred * to as a type code, that identifies the generic SQL type * <code>LONGVARBINARY</code>. */ public final static int LONGVARBINARY = -4; /** * <P>The constant in the Java programming language * that identifies the generic SQL value * <code>NULL</code>. */ public final static int NULL = 0; /** * The constant in the Java programming language that indicates * that the SQL type is database-specific and * gets mapped to a Java object that can be accessed via * the methods <code>getObject</code> and <code>setObject</code>. */ public final static int OTHER = 1111; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>JAVA_OBJECT</code>. * @since 1.2 */ public final static int JAVA_OBJECT = 2000; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>DISTINCT</code>. * @since 1.2 */ public final static int DISTINCT = 2001; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>STRUCT</code>. * @since 1.2 */ public final static int STRUCT = 2002; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>ARRAY</code>. * @since 1.2 */ public final static int ARRAY = 2003; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>BLOB</code>. * @since 1.2 */ public final static int BLOB = 2004; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>CLOB</code>. * @since 1.2 */ public final static int CLOB = 2005; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * <code>REF</code>. * @since 1.2 */ public final static int REF = 2006; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>DATALINK</code>. * * @since 1.4 */ public final static int DATALINK = 70; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>BOOLEAN</code>. * * @since 1.4 */ public final static int BOOLEAN = 16; //------------------------- JDBC 4.0 ----------------------------------- /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>ROWID</code> * * @since 1.6 * */ public final static int ROWID = -8; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>NCHAR</code> * * @since 1.6 */ public static final int NCHAR = -15; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>NVARCHAR</code>. * * @since 1.6 */ public static final int NVARCHAR = -9; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>LONGNVARCHAR</code>. * * @since 1.6 */ public static final int LONGNVARCHAR = -16; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>NCLOB</code>. * * @since 1.6 */ public static final int NCLOB = 2011; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type <code>XML</code>. * * @since 1.6 */ public static final int SQLXML = 2009; //--------------------------JDBC 4.2 ----------------------------- /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type {@code REF CURSOR}. * * @since 1.8 */ public static final int REF_CURSOR = 2012; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * {@code TIME WITH TIMEZONE}. * * @since 1.8 */ public static final int TIME_WITH_TIMEZONE = 2013; /** * The constant in the Java programming language, sometimes referred to * as a type code, that identifies the generic SQL type * {@code TIMESTAMP WITH TIMEZONE}. * * @since 1.8 */ public static final int TIMESTAMP_WITH_TIMEZONE = 2014; // Prevent instantiation private Types() { } }