Java SQL Type isNumberType(int aSqlType)

Description

Returns true if the passed datatype (from java.sql.Types) can hold a numeric value (either with or without decimals)

License

Apache License

Declaration

public static boolean isNumberType(int aSqlType) 

Method Source Code

//package com.java2s;
/*/*from w w  w . ja  v  a 2  s . co  m*/
 * SqlUtil.java
 *
 * This file is part of SQL Workbench/J, http://www.sql-workbench.net
 *
 * Copyright 2002-2017, Thomas Kellerer
 *
 * Licensed under a modified Apache License, Version 2.0
 * that restricts the use for certain governments.
 * You may not use this file except in compliance with the License.
 * You may obtain a copy of the License at.
 *
 *     http://sql-workbench.net/manual/license.html
 *
 * 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.
 *
 * To contact the author please send an email to: support@sql-workbench.net
 *
 */

import java.sql.Types;

public class Main {
    /**
     *    Returns true if the passed datatype (from java.sql.Types)
     *  can hold a numeric value (either with or without decimals)
     */
    public static boolean isNumberType(int aSqlType) {
        return (aSqlType == Types.BIGINT || aSqlType == Types.INTEGER || aSqlType == Types.DECIMAL
                || aSqlType == Types.DOUBLE || aSqlType == Types.FLOAT || aSqlType == Types.NUMERIC
                || aSqlType == Types.REAL || aSqlType == Types.SMALLINT || aSqlType == Types.TINYINT);
    }
}

Related

1. isDigitalType(int sqlType)
2. isJDBCType(final int type)
3. isLobColumn(int dataType)
4. isNativeType(final Class type)
5. isNumberic(int type)
6. isNumberType(int sqlType)
7. isNumeric(int dataType)
8. isNumeric(int dataType)
9. isNumeric(int pColumnType)