javatools.database

Class SQLType

java.lang.Object

javatools.database.SQLType

Direct Known Subclasses:

MySQLDatabase.ANSIvarcharBin, PostgresDatabase.Postgretext, SQLType.ANSIBigint, SQLType.ANSIblob, SQLType.ANSIboolean, SQLType.ANSIchar, SQLType.ANSIfloat, SQLType.ANSIinteger, SQLType.ANSIsmallint, SQLType.ANSItext, SQLType.ANSItimestamp, SQLType.ANSIvarchar

public abstract class SQLType
extends java.lang.Object

This class is part of the Java Tools (see http://mpii.de/yago-naga/javatools). It is licensed under the Creative Commons Attribution License (see http://creativecommons.org/licenses/by/3.0) by the YAGO-NAGA team (see http://mpii.de/yago-naga). This abstract class provides a Wrapper for SQL datatypes. A datatype has a type code (from java.sql.Types) and a scale. For example, INTEGER(17) is a datatype. A datatype can convert a datum to a suitable string. E.g. a TIMESTAMP datatype will convert the datum "2006-09-18" to TIMESTAMP '2006-09-18 00:00:00.00'. Of course, the same SQL datatype is different for different database systems, so that different databases have to implement different classes for the same datatype.
Example:

     Database d=new OracleDatabase("user","password");     
     d.getSQLType(java.sql.Types.VARCHAR).format("Bobby's")
     -> 'Bobby"s'
     d=new MySQLDatabase("user","password","database");     
     d.getSQLType(java.sql.Types.VARCHAR).format("Bobby's")
     -> 'Bobby\'s'

See here for a comparison of database systems. This class provides the ANSI implementations with generous conversion capabilities.
Example:

    SQLType.ANSItimestamp.format("13th of May 1980")
    --> TIMESTAMP '1980-05-13 00:00:00.00'

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLType.ANSIBigint
static class	SQLType.ANSIblob
static class	SQLType.ANSIboolean
static class	SQLType.ANSIchar
static class	SQLType.ANSIfloat
static class	SQLType.ANSIinteger
static class	SQLType.ANSIsmallint
static class	SQLType.ANSItext
static class	SQLType.ANSItimestamp
static class	SQLType.ANSIvarchar

Field Summary

Fields

Modifier and Type	Field and Description
static SQLType.ANSIBigint	ansibigint
static SQLType.ANSIblob	ansiblob
static SQLType.ANSIboolean	ansiboolean
static SQLType.ANSIchar	ansichar
static SQLType.ANSIfloat	ansifloat
static SQLType.ANSIinteger	ansiinteger
static SQLType.ANSIsmallint	ansismallint
static SQLType.ANSItext	ansitext
static SQLType.ANSItimestamp	ansitimestamp
static SQLType.ANSIvarchar	ansivarchar
protected int	scale Holds the scale as defined in java.sql.Types
protected int	typeCode Holds the type code as defined in java.sql.Types

Constructor Summary

Constructors

Constructor and Description
SQLType()

Method Summary

Modifier and Type	Method and Description
abstract java.lang.String	format(java.lang.Object s) Formats an object to a valid SQL literal of the given type
int	getScale() Returns the scale java.sql.Types type
int	getTypeCode() Returns the java.sql.Types type
static void	main(java.lang.String[] args)

Methods inherited from class java.lang.Object

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

Field Detail

typeCode

protected int typeCode

Holds the type code as defined in java.sql.Types

scale

protected int scale

Holds the scale as defined in java.sql.Types

ansivarchar

public static SQLType.ANSIvarchar ansivarchar

ansiblob

public static SQLType.ANSIblob ansiblob

ansitext

public static SQLType.ANSItext ansitext

ansichar

public static SQLType.ANSIchar ansichar

ansitimestamp

public static SQLType.ANSItimestamp ansitimestamp

ansiinteger

public static SQLType.ANSIinteger ansiinteger

ansismallint

public static SQLType.ANSIsmallint ansismallint

ansifloat

public static SQLType.ANSIfloat ansifloat

ansiboolean

public static SQLType.ANSIboolean ansiboolean

ansibigint

public static SQLType.ANSIBigint ansibigint

Constructor Detail

SQLType

public SQLType()

Method Detail

format

public abstract java.lang.String format(java.lang.Object s)

Formats an object to a valid SQL literal of the given type

getTypeCode

public int getTypeCode()

Returns the java.sql.Types type

getScale

public int getScale()

Returns the scale java.sql.Types type

main

public static void main(java.lang.String[] args)