Java SQL Type getSqlTypeName(int sqlType)

Description

get Sql Type Name

License

Apache License

Declaration

private static String getSqlTypeName(int sqlType) 

Method Source Code

//package com.java2s;
/**// w  w w.  jav  a  2 s  .  co m
 * Copyright 2016 Hortonworks.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 **/

import java.lang.reflect.Field;

import java.sql.Types;

public class Main {
    private static String getSqlTypeName(int sqlType) {
        try {
            Integer val = sqlType;
            for (Field field : Types.class.getFields()) {
                if (val.equals(field.get(null))) {
                    return field.getName();
                }
            }
        } catch (IllegalAccessException e) {
            throw new RuntimeException("Could not get sqlTypeName ", e);
        }
        throw new RuntimeException("Unknown sqlType " + sqlType);
    }
}

Related

1. getSqlTypeAsString(int jdbcType)
2. getSQLTypeByName(String type)
3. getSqlTypeByValue(Object value)
4. getSQLTypeName(int sqlType)
5. getSQLTypeName(int sqlType)
6. getSqlTypeName(int type)
7. getSQLTypeName(Integer sqltypecode)
8. getSQLTypePrecision(int sqlType)
9. getSQLTypeRadix(int sqlType)