Java SQL Type getSQLAttributeType(int sqlType)

Description

Convert database type to connector supported set of attribute types Can be redefined for different databases

License

Open Source License

Parameter

Parameter	Description
sqlType	# Types

Return

a connector supported class

Declaration

public static Class<?> getSQLAttributeType(int sqlType) 

Method Source Code

//package com.java2s;
/*//w  w  w .java  2 s . co m
 * ====================
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2008-2009 Sun Microsystems, Inc. All rights reserved.     
 * 
 * The contents of this file are subject to the terms of the Common Development 
 * and Distribution License("CDDL") (the "License").  You may not use this file 
 * except in compliance with the License.
 * 
 * You can obtain a copy of the License at 
 * http://IdentityConnectors.dev.java.net/legal/license.txt
 * See the License for the specific language governing permissions and limitations 
 * under the License. 
 * 
 * When distributing the Covered Code, include this CDDL Header Notice in each file
 * and include the License file at identityconnectors/legal/license.txt.
 * If applicable, add the following below this CDDL Header, with the fields 
 * enclosed by brackets [] replaced by your own identifying information: 
 * "Portions Copyrighted [year] [name of copyright owner]"
 * ====================
 */

import java.math.BigDecimal;

import java.sql.Types;

public class Main {
    /**
     * Convert database type to connector supported set of attribute types
     * Can be redefined for different databases
     * @param sqlType
     *            #{@link Types}
     * @return a connector supported class
     */
    public static Class<?> getSQLAttributeType(int sqlType) {
        Class<?> ret;
        switch (sqlType) {
        //Known conversions
        case Types.DECIMAL:
        case Types.NUMERIC:
            ret = BigDecimal.class;
            break;
        case Types.DOUBLE:
            ret = Double.class;
            break;
        case Types.FLOAT:
        case Types.REAL:
            ret = Float.class;
            break;
        case Types.INTEGER:
            ret = Integer.class;
            break;
        case Types.BIGINT:
            ret = Long.class;
            break;
        case Types.TINYINT:
            ret = Byte.class;
            break;
        case Types.BLOB:
        case Types.BINARY:
        case Types.VARBINARY:
        case Types.LONGVARBINARY:
            ret = byte[].class;
            break;
        case Types.BIT:
        case Types.BOOLEAN:
            ret = Boolean.class;
            break;
        default:
            ret = String.class;
        }
        return ret;
    }
}

Related

1. getPrimitiveInstance(Type type, String valueString)
2. getReturnClass(String typeName)
3. getSemestre(Integer actionformation_id, Connection connection, String actionformation_libellecourt)
4. getSerialPrimaryKeyTypeString(Connection conn)
5. getSimpleTypeString(String dbType)
6. getSQLException(String message, String sqlState, Exception exception)
7. getSQLParameterSubstring(String value, int type)
8. getSqlType(int type)
9. getSqlType(Object param)