us.daveread.basicquery

Class SQLTypes

java.lang.Object

us.daveread.basicquery.SQLTypes

public class SQLTypes
extends java.lang.Object

Title: SQL Types

Description: Associates string representation of SQL data types to the java.sql.Types value

Copyright: Copyright (c) 2004-2014, David Read

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program 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 for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

Author:

David Read TODO Convert to Enumeration

Field Summary

Fields

Modifier and Type	Field and Description
private static SQLTypes[]	knownTypes The set of known types
private int	typeId The type id
private java.lang.String	typeName The type name

Constructor Summary

Constructors

Modifier	Constructor and Description
private	SQLTypes(java.lang.String pTypeName, int pTypeId) Create a SQLTypes instance

Method Summary

Methods

Modifier and Type	Method and Description
static java.lang.String[]	getKnownTypeNames() Return a String array of the known java.sql.Types that are defined
static int	getSQLTypeId(java.lang.String pTypeName) Get the java.sql.Types value for the supplied type string representation

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

typeName

private java.lang.String typeName

The type name

typeId

private int typeId

The type id

knownTypes

private static SQLTypes[] knownTypes

The set of known types

Constructor Detail

SQLTypes

private SQLTypes(java.lang.String pTypeName,
        int pTypeId)

Create a SQLTypes instance

Parameters:

pTypeName - The string representation of the type

pTypeId - The java.sql.Types value for the type

Method Detail

getSQLTypeId

public static int getSQLTypeId(java.lang.String pTypeName)

Get the java.sql.Types value for the supplied type string representation

Parameters:

pTypeName - The string representation of the type

Returns:

The java.sql.Types value associated with the supplied string representation

getKnownTypeNames

public static java.lang.String[] getKnownTypeNames()

Return a String array of the known java.sql.Types that are defined

Returns:

The String array of known SQL data types